enrollments

Data source: Big Local News · About: Big Local

84,143 rows where state = "IN" sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1295813 1295813 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 08 12 2017   grade_11                         38.0 30.0                       68.0                         38 30                 68
1295814 1295814 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 08 12 2017   grade_12                         19.0 28.0                       47.0                         19 28                 47
1295815 1295815 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 08 12 2017   grade_8                         31.0 31.0                       62.0                         31 31                 62
1295816 1295816 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 08 12 2017   grade_9                         39.0 39.0                       78.0                         39 39                 78
1295817 1295817 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 08 12 2017   pk_12_total 317.0 1.0 6.0     1.0         5.0   158.0 172.0     0.0             35.0   330.0 317 1 6     1         5   158 172     0       35   330
1295818 1295818 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 07 2017   grade_5                         31.0 22.0                       53.0                         31 22                 53
1295819 1295819 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 07 2017   grade_6                         29.0 25.0                       54.0                         29 25                 54
1295820 1295820 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 07 2017   grade_7                         36.0 30.0                       66.0                         36 30                 66
1295821 1295821 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 07 2017   pk_12_total 150.0 5.0 8.0 1.0   2.0     1.0   6.0   96.0 77.0     0.0             24.0   173.0 150 5 8 1   2     1   6   96 77     0       24   173
1295822 1295822 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2017   grade_1                         24.0 28.0                       52.0                         24 28                 52
1295823 1295823 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2017   grade_2                         35.0 24.0                       59.0                         35 24                 59
1295824 1295824 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2017   grade_3                         31.0 24.0                       55.0                         31 24                 55
1295825 1295825 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2017   grade_4                         15.0 30.0                       45.0                         15 30                 45
1295826 1295826 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2017   kindergarten                         25.0 24.0                       49.0                         25 24                 49
1295827 1295827 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2017   pk_12_total 278.0 1.0 14.0     1.0         3.0   148.0 149.0     0.0             59.0   297.0 278 1 14     1         3   148 149     0       59   297
1295828 1295828 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2017   pre_kindergarten                         18.0 19.0                       37.0                         18 19                 37
1754421 1754421 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2019   grade_10                         25.0 34.0                       59.0                         25 34                 59
1754422 1754422 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2019   grade_11                         37.0 35.0                       72.0                         37 35                 72
1754423 1754423 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2019   grade_12                         33.0 35.0                       68.0                         33 35                 68
1754424 1754424 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2019   grade_9                         39.0 37.0                       76.0                         39 37                 76
1754425 1754425 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2019   pk_12_total 254.0 2.0 11.0     2.0         6.0   134.0 141.0     1.0         114.0   34.0   275.0 254 2 11     2         6   134 141     1     114 34   275
1754426 1754426 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2019   grade_5                         30.0 23.0                       53.0                         30 23                 53
1754427 1754427 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2019   grade_6                         16.0 33.0                       49.0                         16 33                 49
1754428 1754428 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2019   grade_7                         33.0 25.0                       58.0                         33 25                 58
1754429 1754429 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2019   grade_8                         29.0 24.0                       53.0                         29 24                 53
1754430 1754430 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2019   pk_12_total 191.0 3.0 14.0     2.0         3.0   108.0 105.0     2.0         127.0   28.0   213.0 191 3 14     2         3   108 105     2     127 28   213
1754431 1754431 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2019   grade_1                         18.0 21.0                       39.0                         18 21                 39
1754432 1754432 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2019   grade_2                         27.0 28.0                       55.0                         27 28                 55
1754433 1754433 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2019   grade_3                         30.0 29.0                       59.0                         30 29                 59
1754434 1754434 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2019   grade_4                         33.0 27.0                       60.0                         33 27                 60
1754435 1754435 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2019   kindergarten                         31.0 26.0                       57.0                         31 26                 57
1754436 1754436 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2019   pk_12_total 290.0 2.0 21.0               3.0   170.0 146.0     6.0         173.0   78.0   316.0 290 2 21               3   170 146     6     173 78   316
1754437 1754437 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2019   pre_kindergarten                         31.0 15.0                       46.0                         31 15                 46
1790158 1790158 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2018   grade_10                         42.0 35.0                       77.0                         42 35                 77
1790159 1790159 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2018   grade_11                         32.0 40.0                       72.0                         32 40                 72
1790160 1790160 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2018   grade_12                         40.0 26.0                       66.0                         40 26                 66
1790161 1790161 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2018   grade_9                         27.0 32.0                       59.0                         27 32                 59
1790162 1790162 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2018   pk_12_total 259.0   10.0     1.0         4.0   141.0 133.0     2.0         123.0   32.0   274.0 259   10     1         4   141 133     2     123 32   274
1790163 1790163 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2018   grade_5                         15.0 32.0                       47.0                         15 32                 47
1790164 1790164 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2018   grade_6                         28.0 21.0                       49.0                         28 21                 49
1790165 1790165 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2018   grade_7                         30.0 24.0                       54.0                         30 24                 54
1790166 1790166 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2018   grade_8                         40.0 32.0                       72.0                         40 32                 72
1790167 1790167 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2018   pk_12_total 195.0 5.0 13.0     2.0     1.0   6.0   113.0 109.0     0.0         126.0   35.0   222.0 195 5 13     2     1   6   113 109     0     126 35   222
1790168 1790168 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   grade_1                         25.0 26.0                       51.0                         25 26                 51
1790169 1790169 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   grade_2                         23.0 29.0                       52.0                         23 29                 52
1790170 1790170 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   grade_3                         36.0 27.0                       63.0                         36 27                 63
1790171 1790171 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   grade_4                         30.0 27.0                       57.0                         30 27                 57
1790172 1790172 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   kindergarten                         20.0 21.0                       41.0                         20 21                 41
1790173 1790173 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   pk_12_total 283.0 2.0 13.0     1.0         4.0   161.0 142.0     2.0         176.0   69.0   303.0 283 2 13     1         4   161 142     2     176 69   303
1790174 1790174 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   pre_kindergarten                         27.0 12.0                       39.0                         27 12                 39
1909854 1909854 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2020   grade_10                         38.0 38.0                       76.0                         38 38                 76
1909855 1909855 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2020   grade_11                         23.0 32.0                       55.0                         23 32                 55
1909856 1909856 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2020   grade_12                         33.0 32.0                       65.0                         33 32                 65
1909857 1909857 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2020   grade_9                         26.0 24.0                       50.0                         26 24                 50
1909858 1909858 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2020   pk_12_total 218.0 3.0 15.0     2.0     1.0   7.0   120.0 126.0     4.0         105.0   32.0   246.0 218 3 15     2     1   7   120 126     4     105 32   246
1909859 1909859 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2020   grade_5                         33.0 29.0                       62.0                         33 29                 62
1909860 1909860 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2020   grade_6                         32.0 25.0                       57.0                         32 25                 57
1909861 1909861 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2020   grade_7                         19.0 35.0                       54.0                         19 35                 54
1909862 1909862 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2020   grade_8                         29.0 29.0                       58.0                         29 29                 58
1909863 1909863 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2020   pk_12_total 214.0 2.0 10.0     1.0         4.0   113.0 118.0     3.0         143.0   35.0   231.0 214 2 10     1         4   113 118     3     143 35   231
1909864 1909864 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2020   grade_1                         33.0 24.0                       57.0                         33 24                 57
1909865 1909865 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2020   grade_2                         19.0 22.0                       41.0                         19 22                 41
1909866 1909866 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2020   grade_3                         28.0 27.0                       55.0                         28 27                 55
1909867 1909867 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2020   grade_4                         32.0 30.0                       62.0                         32 30                 62
1909868 1909868 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2020   kindergarten                         34.0 21.0                       55.0                         34 21                 55
1909869 1909869 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2020   pk_12_total 289.0 1.0 19.0               1.0   170.0 140.0     3.0         168.0   71.0   310.0 289 1 19               1   170 140     3     168 71   310
1909870 1909870 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2020   pre_kindergarten                         24.0 16.0                       40.0                         24 16                 40
1921807 1921807 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2021   grade_10                         27.0 23.0                       50.0                         27 23                 50
1921808 1921808 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2021   grade_11                         35.0 35.0                       70.0                         35 35                 70
1921809 1921809 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2021   grade_12                         22.0 34.0                       56.0                         22 34                 56
1921810 1921810 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2021   grade_9                         34.0 29.0                       63.0                         34 29                 63
1921811 1921811 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2021   pk_12_total 206.0 5.0 16.0     2.0     2.0   8.0   118.0 121.0     4.0         113.0   33.0   239.0 206 5 16     2     2   8   118 121     4     113 33   239
1921812 1921812 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2021   grade_5                         27.0 26.0                       53.0                         27 26                 53
1921813 1921813 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2021   grade_6                         33.0 28.0                       61.0                         33 28                 61
1921814 1921814 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2021   grade_7                         37.0 29.0                       66.0                         37 29                 66
1921815 1921815 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2021   grade_8                         23.0 37.0                       60.0                         23 37                 60
1921816 1921816 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2021   pk_12_total 225.0 2.0 11.0     1.0         1.0   120.0 120.0     2.0         144.0   34.0   240.0 225 2 11     1         1   120 120     2     144 34   240
1921817 1921817 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   grade_1                         30.0 23.0                       53.0                         30 23                 53
1921818 1921818 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   grade_2                         32.0 19.0                       51.0                         32 19                 51
1921819 1921819 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   grade_3                         22.0 24.0                       46.0                         22 24                 46
1921820 1921820 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   grade_4                         28.0 28.0                       56.0                         28 28                 56
1921821 1921821 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   kindergarten                         42.0 28.0                       70.0                         42 28                 70
1921822 1921822 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   pk_12_total 285.0   22.0               4.0   173.0 138.0     3.0         186.0   75.0   311.0 285   22               4   173 138     3     186 75   311
1921823 1921823 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   pre_kindergarten                         19.0 16.0                       35.0                         19 16                 35
1170792 1170792 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_1                         19.0 19.0                       38.0                         19 19                 38
1170793 1170793 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_10                         28.0 20.0                       48.0                         28 20                 48
1170794 1170794 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_11                         23.0 15.0                       38.0                         23 15                 38
1170795 1170795 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_12                         16.0 16.0                       32.0                         16 16                 32
1170796 1170796 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_2                         19.0 23.0                       42.0                         19 23                 42
1170797 1170797 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_3                         23.0 28.0                       51.0                         23 28                 51
1170798 1170798 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_4                         18.0 20.0                       38.0                         18 20                 38
1170799 1170799 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_5                         21.0 25.0                       46.0                         21 25                 46
1170800 1170800 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_6                         20.0 19.0                       39.0                         20 19                 39
1170801 1170801 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_7                         21.0 20.0                       41.0                         21 20                 41
1170802 1170802 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_8                         23.0 16.0                       39.0                         23 16                 39
1170803 1170803 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_9                         20.0 19.0                       39.0                         20 19                 39
1170804 1170804 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   kindergarten                         35.0 19.0                       54.0                         35 19                 54
1170805 1170805 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   pk_12_total 475.0 7.0 19.0     9.0     1.0   34.0   286.0 259.0                       545.0 475 7 19     9     1   34   286 259                 545
1292169 1292169 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2016   grade_1                         31.0 18.0                       49.0                         31 18                 49
1292170 1292170 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2016   grade_10                         18.0 22.0                       40.0                         18 22                 40

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