enrollments

Data source: Big Local News · About: Big Local

12,058 rows where state = "IN" and year = 2017 sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2017 · 12,058 ✖
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
1304144 1304144 IN     school 1800006 9100   Indiana Department of Corrections 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2017   adult                         11.0 0.0                       11.0                         11 0                 11
1304145 1304145 IN     school 1800006 9100   Indiana Department of Corrections 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2017   grade_10                         32.0 0.0                       32.0                         32 0                 32
1304146 1304146 IN     school 1800006 9100   Indiana Department of Corrections 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2017   grade_11                         14.0 0.0                       14.0                         14 0                 14
1304147 1304147 IN     school 1800006 9100   Indiana Department of Corrections 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2017   grade_12                         5.0 0.0                       5.0                         5 0                 5
1304148 1304148 IN     school 1800006 9100   Indiana Department of Corrections 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2017   grade_7                         1.0 0.0                       1.0                         1 0                 1
1304149 1304149 IN     school 1800006 9100   Indiana Department of Corrections 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2017   grade_8                         7.0 0.0                       7.0                         7 0                 7
1304150 1304150 IN     school 1800006 9100   Indiana Department of Corrections 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2017   grade_9                         47.0 0.0                       47.0                         47 0                 47
1304151 1304151 IN     school 1800006 9100   Indiana Department of Corrections 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2017   pk_12_total 64.0 30.0 12.0               11.0   117.0 0.0     1.0             42.0   117.0 64 30 12               11   117 0     1       42   117
1304152 1304152 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   grade_10                         19.0 0.0                       19.0                         19 0                 19
1304153 1304153 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   grade_11                         19.0 0.0                       19.0                         19 0                 19
1304154 1304154 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   grade_12                         10.0 0.0                       10.0                         10 0                 10
1304155 1304155 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1304156 1304156 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   grade_9                         8.0 0.0                       8.0                         8 0                 8
1304157 1304157 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   pk_12_total 34.0 18.0 3.0               2.0   57.0 0.0     1.0             12.0   57.0 34 18 3               2   57 0     1       12   57
1304158 1304158 IN     school 1800006 9100   Indiana Department of Corrections 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2017   adult                         12.0 0.0                       12.0                         12 0                 12
1304159 1304159 IN     school 1800006 9100   Indiana Department of Corrections 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2017   grade_10                         47.0 0.0                       47.0                         47 0                 47
1304160 1304160 IN     school 1800006 9100   Indiana Department of Corrections 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2017   grade_11                         9.0 0.0                       9.0                         9 0                 9
1304161 1304161 IN     school 1800006 9100   Indiana Department of Corrections 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2017   grade_12                         5.0 0.0                       5.0                         5 0                 5
1304162 1304162 IN     school 1800006 9100   Indiana Department of Corrections 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2017   grade_8                         10.0 0.0                       10.0                         10 0                 10
1304163 1304163 IN     school 1800006 9100   Indiana Department of Corrections 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2017   grade_9                         87.0 0.0                       87.0                         87 0                 87
1304164 1304164 IN     school 1800006 9100   Indiana Department of Corrections 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2017   pk_12_total 66.0 75.0 14.0 2.0             13.0   170.0 0.0     5.0             87.0   170.0 66 75 14 2             13   170 0     5       87   170
1304165 1304165 IN     school 1800006 9100   Indiana Department of Corrections 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2017   adult                         0.0 1.0                       1.0                         0 1                 1
1304166 1304166 IN     school 1800006 9100   Indiana Department of Corrections 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2017   grade_10                         0.0 9.0                       9.0                         0 9                 9
1304167 1304167 IN     school 1800006 9100   Indiana Department of Corrections 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2017   grade_11                         0.0 20.0                       20.0                         0 20                 20
1304168 1304168 IN     school 1800006 9100   Indiana Department of Corrections 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2017   grade_12                         0.0 8.0                       8.0                         0 8                 8
1304169 1304169 IN     school 1800006 9100   Indiana Department of Corrections 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2017   grade_8                         0.0 1.0                       1.0                         0 1                 1
1304170 1304170 IN     school 1800006 9100   Indiana Department of Corrections 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2017   grade_9                         0.0 8.0                       8.0                         0 8                 8
1304171 1304171 IN     school 1800006 9100   Indiana Department of Corrections 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2017   pk_12_total 28.0 8.0 6.0               5.0   0.0 47.0     2.0             13.0   47.0 28 8 6               5   0 47     2       13   47
1295812 1295812 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 08 12 2017   grade_10                         31.0 44.0                       75.0                         31 44                 75
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
1304203 1304203 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_1                         20.0 24.0                       44.0                         20 24                 44
1304204 1304204 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_10                         23.0 19.0                       42.0                         23 19                 42
1304205 1304205 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_11                         17.0 20.0                       37.0                         17 20                 37
1304206 1304206 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_12                         25.0 15.0                       40.0                         25 15                 40
1304207 1304207 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_2                         30.0 17.0                       47.0                         30 17                 47
1304208 1304208 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_3                         20.0 21.0                       41.0                         20 21                 41
1304209 1304209 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_4                         18.0 21.0                       39.0                         18 21                 39
1304210 1304210 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_5                         19.0 25.0                       44.0                         19 25                 44
1304211 1304211 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_6                         21.0 20.0                       41.0                         21 20                 41
1304212 1304212 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_7                         21.0 22.0                       43.0                         21 22                 43
1304213 1304213 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_8                         19.0 18.0                       37.0                         19 18                 37
1304214 1304214 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_9                         22.0 17.0                       39.0                         22 17                 39
1304215 1304215 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   kindergarten                         25.0 23.0                       48.0                         25 23                 48
1304216 1304216 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   pk_12_total 479.0 7.0 13.0     10.0     2.0   31.0   280.0 262.0     0.0             115.0   542.0 479 7 13     10     2   31   280 262     0       115   542
1304240 1304240 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes Elementary KG 08 2017   grade_1                         17.0 11.0                       28.0                         17 11                 28
1304241 1304241 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes Elementary KG 08 2017   grade_2                         6.0 10.0                       16.0                         6 10                 16
1304242 1304242 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes Elementary KG 08 2017   grade_3                         11.0 8.0                       19.0                         11 8                 19
1304243 1304243 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes Elementary KG 08 2017   grade_4                         9.0 7.0                       16.0                         9 7                 16
1304244 1304244 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes Elementary KG 08 2017   grade_5                         6.0 3.0                       9.0                         6 3                 9
1304245 1304245 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes Elementary KG 08 2017   grade_6                         10.0 6.0                       16.0                         10 6                 16
1304246 1304246 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes Elementary KG 08 2017   grade_7                         11.0 4.0                       15.0                         11 4                 15
1304247 1304247 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes Elementary KG 08 2017   grade_8                         4.0 3.0                       7.0                         4 3                 7
1304248 1304248 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes Elementary KG 08 2017   kindergarten                         12.0 11.0                       23.0                         12 11                 23
1304249 1304249 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes Elementary KG 08 2017   pk_12_total 113.0 10.0 13.0               13.0   86.0 63.0     0.0             27.0   149.0 113 10 13               13   86 63     0       27   149
1304254 1304254 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2017   grade_1                         27.0 23.0                       50.0                         27 23                 50
1304255 1304255 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2017   grade_2                         22.0 26.0                       48.0                         22 26                 48
1304256 1304256 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2017   grade_3                         34.0 29.0                       63.0                         34 29                 63
1304257 1304257 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2017   grade_4                         2.0 11.0                       13.0                         2 11                 13
1304258 1304258 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2017   grade_5                         22.0 22.0                       44.0                         22 22                 44
1304259 1304259 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2017   grade_6                         14.0 12.0                       26.0                         14 12                 26
1304260 1304260 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2017   kindergarten                         38.0 34.0                       72.0                         38 34                 72
1304261 1304261 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2017   pk_12_total 6.0 220.0 27.0     54.0     1.0   8.0   159.0 157.0     57.0             34.0   316.0 6 220 27     54     1   8   159 157     57       34   316
1304222 1304222 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_1                         41.0 34.0                       75.0                         41 34                 75
1304223 1304223 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_10                         43.0 61.0                       104.0                         43 61                 104
1304224 1304224 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_11                         43.0 38.0                       81.0                         43 38                 81
1304225 1304225 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_12                         51.0 33.0                       84.0                         51 33                 84
1304226 1304226 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_2                         35.0 40.0                       75.0                         35 40                 75
1304227 1304227 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_3                         33.0 43.0                       76.0                         33 43                 76
1304228 1304228 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_4                         34.0 39.0                       73.0                         34 39                 73
1304229 1304229 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_5                         42.0 33.0                       75.0                         42 33                 75
1304230 1304230 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_6                         37.0 39.0                       76.0                         37 39                 76
1304231 1304231 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_7                         35.0 40.0                       75.0                         35 40                 75
1304232 1304232 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_8                         42.0 35.0                       77.0                         42 35                 77
1304233 1304233 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_9                         40.0 39.0                       79.0                         40 39                 79
1304234 1304234 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   kindergarten                         34.0 41.0                       75.0                         34 41                 75
1304235 1304235 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   pk_12_total 697.0 131.0 94.0 1.0   5.0         97.0   510.0 515.0     13.0             157.0   1025.0 697 131 94 1   5         97   510 515     13       157   1025
1304266 1304266 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   grade_1                         9.0 5.0                       14.0                         9 5                 14
1304267 1304267 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   grade_2                         1.0 1.0                       2.0                         1 1                 2
1304268 1304268 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   grade_3                         2.0 7.0                       9.0                         2 7                 9
1304269 1304269 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   grade_4                         10.0 3.0                       13.0                         10 3                 13
1304270 1304270 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   grade_5                         8.0 3.0                       11.0                         8 3                 11
1304271 1304271 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   grade_6                         6.0 4.0                       10.0                         6 4                 10
1304272 1304272 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   grade_7                         9.0 4.0                       13.0                         9 4                 13
1304273 1304273 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   grade_8                         5.0 2.0                       7.0                         5 2                 7
1304274 1304274 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   kindergarten                         6.0 5.0                       11.0                         6 5                 11

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