enrollments

Data source: Big Local News · About: Big Local

7,378 rows where grade = "grade_3" and state = "IN" sorted by district_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_3 · 7,378 ✖
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
1166235 1166235 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_3                         4.0 0.0                       4.0                         4 0                 4
1287637 1287637 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_3                         4.0 1.0                       5.0                         4 1                 5
1299674 1299674 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_3                         6.0 1.0                       7.0                         6 1                 7
1758212 1758212 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_3                         5.0 0.0                       5.0                         5 0                 5
1794002 1794002 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_3                         3.0 0.0                       3.0                         3 0                 3
1908017 1908017 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   grade_3                         53.0 58.0                       111.0                         53 58                 111
1908035 1908035 IN     school   940   West Clark Community Schools   789 Silver Creek Elementary School             2020   grade_3                         121.0 92.0                       213.0                         121 92                 213
1908049 1908049 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   grade_3                         12.0 14.0                       26.0                         12 14                 26
1913640 1913640 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_3                         6.0 0.0                       6.0                         6 0                 6
1925546 1925546 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_3                         8.0 1.0                       9.0                         8 1                 9
1927085 1927085 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   grade_3                         2.0 2.0                       4.0                         2 2                 4
1927244 1927244 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_3                         3.0 0.0                       3.0                         3 0                 3
1927327 1927327 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_3                         2.0 1.0                       3.0                         2 1                 3
1164251 1164251 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         28.0 25.0                       53.0                         28 25                 53
1164263 1164263 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         27.0 23.0                       50.0                         27 23                 50
1285658 1285658 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   grade_3                         29.0 38.0                       67.0                         29 38                 67
1285670 1285670 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         23.0 30.0                       53.0                         23 30                 53
1297704 1297704 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   grade_3                         30.0 20.0                       50.0                         30 20                 50
1297716 1297716 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   grade_3                         27.0 35.0                       62.0                         27 35                 62
1756301 1756301 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2019   grade_3                         28.0 22.0                       50.0                         28 22                 50
1756310 1756310 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2019   grade_3                         26.0 15.0                       41.0                         26 15                 41
1792062 1792062 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2018   grade_3                         16.0 35.0                       51.0                         16 35                 51
1792074 1792074 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2018   grade_3                         21.0 17.0                       38.0                         21 17                 38
1911758 1911758 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2020   grade_3                         24.0 25.0                       49.0                         24 25                 49
1911767 1911767 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2020   grade_3                         17.0 26.0                       43.0                         17 26                 43
1923726 1923726 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2021   grade_3                         18.0 30.0                       48.0                         18 30                 48
1923735 1923735 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2021   grade_3                         15.0 26.0                       41.0                         15 26                 41
1165113 1165113 IN     school 1813200 4760   Whiting School City 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         42.0 34.0                       76.0                         42 34                 76
1286508 1286508 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2016   grade_3                         23.0 45.0                       68.0                         23 45                 68
1298547 1298547 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2017   grade_3                         27.0 48.0                       75.0                         27 48                 75
1757075 1757075 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2019   grade_3                         40.0 33.0                       73.0                         40 33                 73
1792866 1792866 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2018   grade_3                         25.0 45.0                       70.0                         25 45                 70
1912511 1912511 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2020   grade_3                         40.0 34.0                       74.0                         40 34                 74
1924461 1924461 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2021   grade_3                         31.0 28.0                       59.0                         31 28                 59
1164301 1164301 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         31.0 47.0                       78.0                         31 47                 78
1164310 1164310 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         40.0 21.0                       61.0                         40 21                 61
1164317 1164317 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elem School   Regular School No 1.0 KG 04 2015   grade_3                         40.0 38.0                       78.0                         40 38                 78
1285707 1285707 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2016   grade_3                         23.0 29.0                       52.0                         23 29                 52
1285716 1285716 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   grade_3                         39.0 31.0                       70.0                         39 31                 70
1285724 1285724 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No 1.0 KG 04 2016   grade_3                         43.0 37.0                       80.0                         43 37                 80
1297754 1297754 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2017   grade_3                         29.0 29.0                       58.0                         29 29                 58
1297763 1297763 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 05 2017   grade_3                         34.0 35.0                       69.0                         34 35                 69
1297771 1297771 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2017   grade_3                         32.0 31.0                       63.0                         32 31                 63
1756351 1756351 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2019   grade_3                         32.0 25.0                       57.0                         32 25                 57
1756360 1756360 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2019   grade_3                         38.0 23.0                       61.0                         38 23                 61
1756369 1756369 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2019   grade_3                         33.0 33.0                       66.0                         33 33                 66
1792113 1792113 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2018   grade_3                         27.0 30.0                       57.0                         27 30                 57
1792122 1792122 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2018   grade_3                         52.0 42.0                       94.0                         52 42                 94
1792131 1792131 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2018   grade_3                         29.0 38.0                       67.0                         29 38                 67
1911808 1911808 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2020   grade_3                         39.0 34.0                       73.0                         39 34                 73
1911817 1911817 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2020   grade_3                         45.0 36.0                       81.0                         45 36                 81
1911826 1911826 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2020   grade_3                         31.0 33.0                       64.0                         31 33                 64
1923776 1923776 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2021   grade_3                         18.0 25.0                       43.0                         18 25                 43
1923785 1923785 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2021   grade_3                         39.0 27.0                       66.0                         39 27                 66
1923794 1923794 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2021   grade_3                         28.0 37.0                       65.0                         28 37                 65
1162509 1162509 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   grade_3                         59.0 59.0                       118.0                         59 59                 118
1162521 1162521 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   grade_3                         41.0 49.0                       90.0                         41 49                 90
1162528 1162528 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         41.0 44.0                       85.0                         41 44                 85
1162534 1162534 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   grade_3                         56.0 48.0                       104.0                         56 48                 104
1162541 1162541 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   grade_3                         20.0 22.0                       42.0                         20 22                 42
1162551 1162551 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   grade_3                         73.0 33.0                       106.0                         73 33                 106
1283924 1283924 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No 1.0 KG 04 2016   grade_3                         37.0 49.0                       86.0                         37 49                 86
1283936 1283936 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No 1.0 PK 04 2016   grade_3                         55.0 43.0                       98.0                         55 43                 98
1283943 1283943 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2016   grade_3                         41.0 45.0                       86.0                         41 45                 86
1283949 1283949 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No 1.0 PK 04 2016   grade_3                         63.0 58.0                       121.0                         63 58                 121
1283956 1283956 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2016   grade_3                         23.0 27.0                       50.0                         23 27                 50
1283966 1283966 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2016   grade_3                         73.0 61.0                       134.0                         73 61                 134
1295959 1295959 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2017   grade_3                         40.0 52.0                       92.0                         40 52                 92
1295972 1295972 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2017   grade_3                         76.0 68.0                       144.0                         76 68                 144
1295979 1295979 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary KG 04 2017   grade_3                         43.0 46.0                       89.0                         43 46                 89
1295985 1295985 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2017   grade_3                         53.0 65.0                       118.0                         53 65                 118
1295992 1295992 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2017   grade_3                         49.0 36.0                       85.0                         49 36                 85
1296001 1296001 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2017   grade_3                         51.0 36.0                       87.0                         51 36                 87
1754569 1754569 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2019   grade_3                         49.0 40.0                       89.0                         49 40                 89
1754582 1754582 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2019   grade_3                         53.0 63.0                       116.0                         53 63                 116
1754589 1754589 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2019   grade_3                         46.0 37.0                       83.0                         46 37                 83
1754596 1754596 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2019   grade_3                         71.0 46.0                       117.0                         71 46                 117
1754603 1754603 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2019   grade_3                         64.0 56.0                       120.0                         64 56                 120
1754612 1754612 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2019   grade_3                         72.0 45.0                       117.0                         72 45                 117
1790309 1790309 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2018   grade_3                         53.0 39.0                       92.0                         53 39                 92
1790322 1790322 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2018   grade_3                         64.0 50.0                       114.0                         64 50                 114
1790329 1790329 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2018   grade_3                         42.0 48.0                       90.0                         42 48                 90
1790336 1790336 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2018   grade_3                         62.0 57.0                       119.0                         62 57                 119
1790343 1790343 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2018   grade_3                         47.0 48.0                       95.0                         47 48                 95
1790352 1790352 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2018   grade_3                         60.0 56.0                       116.0                         60 56                 116
1910010 1910010 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2020   grade_3                         55.0 44.0                       99.0                         55 44                 99
1910023 1910023 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2020   grade_3                         61.0 51.0                       112.0                         61 51                 112
1910030 1910030 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2020   grade_3                         53.0 52.0                       105.0                         53 52                 105
1910037 1910037 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2020   grade_3                         66.0 66.0                       132.0                         66 66                 132
1910044 1910044 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2020   grade_3                         57.0 49.0                       106.0                         57 49                 106
1910053 1910053 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2020   grade_3                         64.0 52.0                       116.0                         64 52                 116
1921965 1921965 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2021   grade_3                         59.0 63.0                       122.0                         59 63                 122
1921978 1921978 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2021   grade_3                         63.0 60.0                       123.0                         63 60                 123
1921985 1921985 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2021   grade_3                         58.0 50.0                       108.0                         58 50                 108
1921992 1921992 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2021   grade_3                         49.0 47.0                       96.0                         49 47                 96
1921999 1921999 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2021   grade_3                         57.0 45.0                       102.0                         57 45                 102
1922008 1922008 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2021   grade_3                         51.0 61.0                       112.0                         51 61                 112
1170408 1170408 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elem Sch   Regular School No 1.0 PK 05 2015   grade_3                         36.0 33.0                       69.0                         36 33                 69
1291795 1291795 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elementary School   Regular School No 1.0 PK 05 2016   grade_3                         45.0 33.0                       78.0                         45 33                 78
1303820 1303820 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elementary School   Regular School No Elementary PK 05 2017   grade_3                         35.0 38.0                       73.0                         35 38                 73

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