enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten · 7,228 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id ▲ school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1166242 1166242 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   kindergarten                         2.0 0.0                       2.0                         2 0                 2
1299681 1299681 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   kindergarten                         1.0 2.0                       3.0                         1 2                 3
1758219 1758219 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1794009 1794009 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1908021 1908021 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   kindergarten                         44.0 53.0                       97.0                         44 53                 97
1908053 1908053 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   kindergarten                         25.0 17.0                       42.0                         25 17                 42
1908056 1908056 IN     school   940   West Clark Community Schools   818 Silver Creek Primary School             2020   kindergarten                         91.0 97.0                       188.0                         91 97                 188
1927090 1927090 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1927190 1927190 IN     school   6520   Porter Township School Corp   6811 Porter County Education Services             2021   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1927250 1927250 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   kindergarten                         1.0 1.0                       2.0                         1 1                 2
1164266 1164266 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         14.0 21.0                       35.0                         14 21                 35
1285673 1285673 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         21.0 17.0                       38.0                         21 17                 38
1297719 1297719 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         15.0 26.0                       41.0                         15 26                 41
1756314 1756314 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         18.0 15.0                       33.0                         18 15                 33
1792077 1792077 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         15.0 26.0                       41.0                         15 26                 41
1911771 1911771 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2020   kindergarten                         20.0 27.0                       47.0                         20 27                 47
1923739 1923739 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         23.0 23.0                       46.0                         23 23                 46
1164254 1164254 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         20.0 37.0                       57.0                         20 37                 57
1285661 1285661 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         27.0 20.0                       47.0                         27 20                 47
1297707 1297707 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         21.0 25.0                       46.0                         21 25                 46
1756305 1756305 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2019   kindergarten                         28.0 23.0                       51.0                         28 23                 51
1792065 1792065 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         26.0 37.0                       63.0                         26 37                 63
1911762 1911762 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2020   kindergarten                         34.0 23.0                       57.0                         34 23                 57
1923730 1923730 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         32.0 31.0                       63.0                         32 31                 63
1165116 1165116 IN     school 1813200 4760   Whiting School City 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         20.0 40.0                       60.0                         20 40                 60
1286511 1286511 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         35.0 34.0                       69.0                         35 34                 69
1298550 1298550 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         36.0 23.0                       59.0                         36 23                 59
1757078 1757078 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         36.0 48.0                       84.0                         36 48                 84
1792869 1792869 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         34.0 29.0                       63.0                         34 29                 63
1912514 1912514 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         27.0 31.0                       58.0                         27 31                 58
1924464 1924464 IN     school 1813200 4760   School City of Whiting 181320002081 4361 Nathan Hale Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         27.0 27.0                       54.0                         27 27                 54
1164303 1164303 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         38.0 42.0                       80.0                         38 42                 80
1285709 1285709 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         38.0 37.0                       75.0                         38 37                 75
1297756 1297756 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2017   kindergarten                         46.0 43.0                       89.0                         46 43                 89
1756353 1756353 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         39.0 40.0                       79.0                         39 40                 79
1792115 1792115 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         33.0 29.0                       62.0                         33 29                 62
1911810 1911810 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2020   kindergarten                         42.0 36.0                       78.0                         42 36                 78
1923778 1923778 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2021   kindergarten                         39.0 26.0                       65.0                         39 26                 65
1164319 1164319 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elem School   Regular School No 1.0 KG 04 2015   kindergarten                         33.0 44.0                       77.0                         33 44                 77
1285726 1285726 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No 1.0 KG 04 2016   kindergarten                         36.0 40.0                       76.0                         36 40                 76
1297773 1297773 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2017   kindergarten                         34.0 36.0                       70.0                         34 36                 70
1756371 1756371 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2019   kindergarten                         43.0 47.0                       90.0                         43 47                 90
1792133 1792133 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2018   kindergarten                         36.0 39.0                       75.0                         36 39                 75
1911828 1911828 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2020   kindergarten                         49.0 44.0                       93.0                         49 44                 93
1923796 1923796 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2021   kindergarten                         45.0 36.0                       81.0                         45 36                 81
1164313 1164313 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary Sch   Regular School No 1.0 KG 05 2015   kindergarten                         56.0 52.0                       108.0                         56 52                 108
1285720 1285720 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         52.0 28.0                       80.0                         52 28                 80
1297766 1297766 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         52.0 42.0                       94.0                         52 42                 94
1756364 1756364 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2019   kindergarten                         42.0 41.0                       83.0                         42 41                 83
1792126 1792126 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2018   kindergarten                         49.0 37.0                       86.0                         49 37                 86
1911821 1911821 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2020   kindergarten                         59.0 40.0                       99.0                         59 40                 99
1923789 1923789 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         43.0 27.0                       70.0                         43 27                 70
1162543 1162543 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   kindergarten                         49.0 29.0                       78.0                         49 29                 78
1283958 1283958 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2016   kindergarten                         59.0 31.0                       90.0                         59 31                 90
1295994 1295994 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2017   kindergarten                         45.0 38.0                       83.0                         45 38                 83
1754605 1754605 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         48.0 45.0                       93.0                         48 45                 93
1790345 1790345 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         55.0 41.0                       96.0                         55 41                 96
1910046 1910046 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2020   kindergarten                         58.0 62.0                       120.0                         58 62                 120
1922001 1922001 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2021   kindergarten                         48.0 50.0                       98.0                         48 50                 98
1162553 1162553 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   kindergarten                         53.0 55.0                       108.0                         53 55                 108
1283968 1283968 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2016   kindergarten                         73.0 40.0                       113.0                         73 40                 113
1296003 1296003 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2017   kindergarten                         63.0 45.0                       108.0                         63 45                 108
1754614 1754614 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2019   kindergarten                         59.0 51.0                       110.0                         59 51                 110
1790354 1790354 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2018   kindergarten                         54.0 73.0                       127.0                         54 73                 127
1910055 1910055 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2020   kindergarten                         64.0 67.0                       131.0                         64 67                 131
1922010 1922010 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2021   kindergarten                         50.0 64.0                       114.0                         50 64                 114
1162530 1162530 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         38.0 28.0                       66.0                         38 28                 66
1283945 1283945 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         48.0 37.0                       85.0                         48 37                 85
1295981 1295981 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary KG 04 2017   kindergarten                         53.0 52.0                       105.0                         53 52                 105
1754591 1754591 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2019   kindergarten                         51.0 42.0                       93.0                         51 42                 93
1790331 1790331 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         59.0 48.0                       107.0                         59 48                 107
1910032 1910032 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2020   kindergarten                         68.0 42.0                       110.0                         68 42                 110
1921987 1921987 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         53.0 59.0                       112.0                         53 59                 112
1162536 1162536 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   kindergarten                         60.0 57.0                       117.0                         60 57                 117
1283951 1283951 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No 1.0 PK 04 2016   kindergarten                         65.0 48.0                       113.0                         65 48                 113
1295987 1295987 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2017   kindergarten                         70.0 61.0                       131.0                         70 61                 131
1754598 1754598 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2019   kindergarten                         52.0 45.0                       97.0                         52 45                 97
1790338 1790338 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         60.0 39.0                       99.0                         60 39                 99
1910039 1910039 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2020   kindergarten                         58.0 56.0                       114.0                         58 56                 114
1921994 1921994 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         48.0 42.0                       90.0                         48 42                 90
1162523 1162523 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   kindergarten                         55.0 46.0                       101.0                         55 46                 101
1283938 1283938 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No 1.0 PK 04 2016   kindergarten                         57.0 50.0                       107.0                         57 50                 107
1295974 1295974 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2017   kindergarten                         58.0 45.0                       103.0                         58 45                 103
1754584 1754584 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2019   kindergarten                         59.0 67.0                       126.0                         59 67                 126
1790324 1790324 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         65.0 58.0                       123.0                         65 58                 123
1910025 1910025 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2020   kindergarten                         58.0 58.0                       116.0                         58 58                 116
1921980 1921980 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         68.0 38.0                       106.0                         68 38                 106
1162511 1162511 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   kindergarten                         44.0 43.0                       87.0                         44 43                 87
1283926 1283926 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         34.0 37.0                       71.0                         34 37                 71
1295961 1295961 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2017   kindergarten                         48.0 33.0                       81.0                         48 33                 81
1754571 1754571 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2019   kindergarten                         51.0 37.0                       88.0                         51 37                 88
1790311 1790311 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         46.0 45.0                       91.0                         46 45                 91
1910012 1910012 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2020   kindergarten                         58.0 47.0                       105.0                         58 47                 105
1921967 1921967 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         63.0 56.0                       119.0                         63 56                 119
1170411 1170411 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elem Sch   Regular School No 1.0 PK 05 2015   kindergarten                         31.0 31.0                       62.0                         31 31                 62
1291798 1291798 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         37.0 36.0                       73.0                         37 36                 73
1303823 1303823 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         33.0 35.0                       68.0                         33 35                 68
1762362 1762362 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         25.0 24.0                       49.0                         25 24                 49
1798145 1798145 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         36.0 33.0                       69.0                         36 33                 69
1917781 1917781 IN     school 1813050 8355   Western Wayne Schools 181305000807 8971 Western Wayne Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         27.0 23.0                       50.0                         27 23                 50

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