enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 7,371 ✖
Link rowid state county county_state_id admin_level district_nces_id ▲ district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1166234 1166234 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_2                         2.0 1.0                       3.0                         2 1                 3
1287636 1287636 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_2                         6.0 1.0                       7.0                         6 1                 7
1299673 1299673 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_2                         6.0 0.0                       6.0                         6 0                 6
1758211 1758211 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_2                         7.0 1.0                       8.0                         7 1                 8
1794001 1794001 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_2                         7.0 0.0                       7.0                         7 0                 7
1908016 1908016 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   grade_2                         53.0 40.0                       93.0                         53 40                 93
1908034 1908034 IN     school   940   West Clark Community Schools   789 Silver Creek Elementary School             2020   grade_2                         97.0 101.0                       198.0                         97 101                 198
1908048 1908048 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   grade_2                         24.0 17.0                       41.0                         24 17                 41
1913639 1913639 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_2                         7.0 1.0                       8.0                         7 1                 8
1925545 1925545 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_2                         6.0 0.0                       6.0                         6 0                 6
1927084 1927084 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   grade_2                         2.0 0.0                       2.0                         2 0                 2
1927137 1927137 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_2                         0.0 1.0                       1.0                         0 1                 1
1927211 1927211 IN     school   6530   Union Township School Corp   6811 Porter County Education Services             2021   grade_2                         0.0 1.0                       1.0                         0 1                 1
1927243 1927243 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_2                         6.0 1.0                       7.0                         6 1                 7
1927326 1927326 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_2                         4.0 0.0                       4.0                         4 0                 4
1164250 1164250 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         30.0 32.0                       62.0                         30 32                 62
1164262 1164262 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         21.0 32.0                       53.0                         21 32                 53
1285657 1285657 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         31.0 17.0                       48.0                         31 17                 48
1285669 1285669 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         27.0 29.0                       56.0                         27 29                 56
1297703 1297703 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   grade_2                         15.0 31.0                       46.0                         15 31                 46
1297715 1297715 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   grade_2                         19.0 21.0                       40.0                         19 21                 40
1756300 1756300 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2019   grade_2                         23.0 27.0                       50.0                         23 27                 50
1756309 1756309 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2019   grade_2                         16.0 27.0                       43.0                         16 27                 43
1792061 1792061 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2018   grade_2                         28.0 17.0                       45.0                         28 17                 45
1792073 1792073 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2018   grade_2                         25.0 17.0                       42.0                         25 17                 42
1911757 1911757 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2020   grade_2                         21.0 34.0                       55.0                         21 34                 55
1911766 1911766 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2020   grade_2                         16.0 23.0                       39.0                         16 23                 39
1923725 1923725 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2021   grade_2                         29.0 26.0                       55.0                         29 26                 55
1923734 1923734 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2021   grade_2                         19.0 17.0                       36.0                         19 17                 36
1165112 1165112 IN     school 1813200 4760   Whiting School City 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         29.0 46.0                       75.0                         29 46                 75
1286507 1286507 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         23.0 42.0                       65.0                         23 42                 65
1298546 1298546 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2017   grade_2                         24.0 45.0                       69.0                         24 45                 69
1757074 1757074 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2019   grade_2                         38.0 31.0                       69.0                         38 31                 69
1792865 1792865 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2018   grade_2                         38.0 34.0                       72.0                         38 34                 72
1912510 1912510 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2020   grade_2                         32.0 30.0                       62.0                         32 30                 62
1924460 1924460 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2021   grade_2                         35.0 41.0                       76.0                         35 41                 76
1164300 1164300 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2015   grade_2                         26.0 33.0                       59.0                         26 33                 59
1164309 1164309 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         40.0 30.0                       70.0                         40 30                 70
1164316 1164316 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elem School   Regular School No 1.0 KG 04 2015   grade_2                         45.0 41.0                       86.0                         45 41                 86
1285706 1285706 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2016   grade_2                         32.0 32.0                       64.0                         32 32                 64
1285715 1285715 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   grade_2                         38.0 40.0                       78.0                         38 40                 78
1285723 1285723 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No 1.0 KG 04 2016   grade_2                         32.0 28.0                       60.0                         32 28                 60
1297753 1297753 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2017   grade_2                         26.0 35.0                       61.0                         26 35                 61
1297762 1297762 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 05 2017   grade_2                         57.0 45.0                       102.0                         57 45                 102
1297770 1297770 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2017   grade_2                         28.0 37.0                       65.0                         28 37                 65
1756350 1756350 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2019   grade_2                         37.0 34.0                       71.0                         37 34                 71
1756359 1756359 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2019   grade_2                         47.0 37.0                       84.0                         47 37                 84
1756368 1756368 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2019   grade_2                         26.0 36.0                       62.0                         26 36                 62
1792112 1792112 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2018   grade_2                         35.0 24.0                       59.0                         35 24                 59
1792121 1792121 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2018   grade_2                         37.0 23.0                       60.0                         37 23                 60
1792130 1792130 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2018   grade_2                         31.0 33.0                       64.0                         31 33                 64
1911807 1911807 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2020   grade_2                         22.0 28.0                       50.0                         22 28                 50
1911816 1911816 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2020   grade_2                         34.0 29.0                       63.0                         34 29                 63
1911825 1911825 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2020   grade_2                         30.0 39.0                       69.0                         30 39                 69
1923775 1923775 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2021   grade_2                         30.0 23.0                       53.0                         30 23                 53
1923784 1923784 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2021   grade_2                         32.0 41.0                       73.0                         32 41                 73
1923793 1923793 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2021   grade_2                         39.0 37.0                       76.0                         39 37                 76
1162508 1162508 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   grade_2                         40.0 44.0                       84.0                         40 44                 84
1162520 1162520 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   grade_2                         61.0 42.0                       103.0                         61 42                 103
1162527 1162527 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   grade_2                         37.0 42.0                       79.0                         37 42                 79
1162533 1162533 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   grade_2                         62.0 59.0                       121.0                         62 59                 121
1162540 1162540 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   grade_2                         28.0 24.0                       52.0                         28 24                 52
1162550 1162550 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   grade_2                         66.0 53.0                       119.0                         66 53                 119
1283923 1283923 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No 1.0 KG 04 2016   grade_2                         41.0 55.0                       96.0                         41 55                 96
1283935 1283935 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No 1.0 PK 04 2016   grade_2                         71.0 65.0                       136.0                         71 65                 136
1283942 1283942 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2016   grade_2                         39.0 44.0                       83.0                         39 44                 83
1283948 1283948 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No 1.0 PK 04 2016   grade_2                         50.0 63.0                       113.0                         50 63                 113
1283955 1283955 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2016   grade_2                         35.0 32.0                       67.0                         35 32                 67
1283965 1283965 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2016   grade_2                         50.0 32.0                       82.0                         50 32                 82
1295958 1295958 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2017   grade_2                         56.0 43.0                       99.0                         56 43                 99
1295971 1295971 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2017   grade_2                         56.0 49.0                       105.0                         56 49                 105
1295978 1295978 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary KG 04 2017   grade_2                         38.0 45.0                       83.0                         38 45                 83
1295984 1295984 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2017   grade_2                         63.0 55.0                       118.0                         63 55                 118
1295991 1295991 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2017   grade_2                         48.0 43.0                       91.0                         48 43                 91
1296000 1296000 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2017   grade_2                         61.0 55.0                       116.0                         61 55                 116
1754568 1754568 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2019   grade_2                         51.0 36.0                       87.0                         51 36                 87
1754581 1754581 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2019   grade_2                         63.0 46.0                       109.0                         63 46                 109
1754588 1754588 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2019   grade_2                         52.0 46.0                       98.0                         52 46                 98
1754595 1754595 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2019   grade_2                         69.0 65.0                       134.0                         69 65                 134
1754602 1754602 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2019   grade_2                         53.0 50.0                       103.0                         53 50                 103
1754611 1754611 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2019   grade_2                         62.0 49.0                       111.0                         62 49                 111
1790308 1790308 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2018   grade_2                         47.0 36.0                       83.0                         47 36                 83
1790321 1790321 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2018   grade_2                         48.0 63.0                       111.0                         48 63                 111
1790328 1790328 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2018   grade_2                         50.0 35.0                       85.0                         50 35                 85
1790335 1790335 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2018   grade_2                         71.0 45.0                       116.0                         71 45                 116
1790342 1790342 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2018   grade_2                         66.0 43.0                       109.0                         66 43                 109
1790351 1790351 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2018   grade_2                         75.0 46.0                       121.0                         75 46                 121
1910009 1910009 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2020   grade_2                         54.0 57.0                       111.0                         54 57                 111
1910022 1910022 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2020   grade_2                         69.0 65.0                       134.0                         69 65                 134
1910029 1910029 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2020   grade_2                         62.0 55.0                       117.0                         62 55                 117
1910036 1910036 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2020   grade_2                         61.0 43.0                       104.0                         61 43                 104
1910043 1910043 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2020   grade_2                         62.0 48.0                       110.0                         62 48                 110
1910052 1910052 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2020   grade_2                         53.0 64.0                       117.0                         53 64                 117
1921964 1921964 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2021   grade_2                         65.0 40.0                       105.0                         65 40                 105
1921977 1921977 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2021   grade_2                         56.0 61.0                       117.0                         56 61                 117
1921984 1921984 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2021   grade_2                         52.0 45.0                       97.0                         52 45                 97
1921991 1921991 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2021   grade_2                         45.0 47.0                       92.0                         45 47                 92
1921998 1921998 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2021   grade_2                         51.0 42.0                       93.0                         51 42                 93
1922007 1922007 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2021   grade_2                         53.0 48.0                       101.0                         53 48                 101
1170407 1170407 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elem Sch   Regular School No 1.0 PK 05 2015   grade_2                         39.0 32.0                       71.0                         39 32                 71

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