enrollments

Data source: Big Local News · About: Big Local

12,044 rows where state = "IN" and year = 2015 sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2015 · 12,017 ✖
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
1162359 1162359 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   adult                         0.0 2.0                       2.0                         0 2                 2
1162360 1162360 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_10                         18.0 28.0                       46.0                         18 28                 46
1162361 1162361 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_11                         35.0 35.0                       70.0                         35 35                 70
1162362 1162362 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_12                         29.0 26.0                       55.0                         29 26                 55
1162363 1162363 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         35.0 31.0                       66.0                         35 31                 66
1162364 1162364 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_8                         27.0 39.0                       66.0                         27 39                 66
1162365 1162365 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_9                         39.0 30.0                       69.0                         39 30                 69
1162366 1162366 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   pk_12_total 363.0 1.0 5.0     3.0         2.0   183.0 191.0     0.0             34.0   374.0 363 1 5     3         2   183 191     0       34   374
1162367 1162367 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         14.0 13.0                       27.0                         14 13                 27
1162368 1162368 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         10.0 17.0                       27.0                         10 17                 27
1162369 1162369 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         12.0 9.0                       21.0                         12 9                 21
1162370 1162370 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_4                         11.0 11.0                       22.0                         11 11                 22
1162371 1162371 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         13.0 9.0                       22.0                         13 9                 22
1162372 1162372 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_6                         8.0 15.0                       23.0                         8 15                 23
1162373 1162373 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         17.0 10.0                       27.0                         17 10                 27
1162374 1162374 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   pk_12_total 154.0   8.0     2.0         5.0   85.0 84.0     0.0             24.0   169.0 154   8     2         5   85 84     0       24   169
1162375 1162375 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         23.0 8.0                       31.0                         23 8                 31
1162376 1162376 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         8.0 16.0                       24.0                         8 16                 24
1162377 1162377 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         19.0 12.0                       31.0                         19 12                 31
1162378 1162378 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_4                         14.0 11.0                       25.0                         14 11                 25
1162379 1162379 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         21.0 14.0                       35.0                         21 14                 35
1162380 1162380 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_6                         25.0 17.0                       42.0                         25 17                 42
1162381 1162381 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         20.0 17.0                       37.0                         20 17                 37
1162382 1162382 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   pk_12_total 241.0 1.0 5.0               4.0   148.0 103.0     0.0             51.0   251.0 241 1 5               4   148 103     0       51   251
1162383 1162383 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         18.0 8.0                       26.0                         18 8                 26
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
1170831 1170831 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_1                         22.0 16.0                       38.0                         22 16                 38
1170832 1170832 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_2                         21.0 14.0                       35.0                         21 14                 35
1170833 1170833 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_3                         17.0 7.0                       24.0                         17 7                 24
1170834 1170834 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_4                         16.0 16.0                       32.0                         16 16                 32
1170835 1170835 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_5                         13.0 13.0                       26.0                         13 13                 26
1170836 1170836 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_6                         12.0 7.0                       19.0                         12 7                 19
1170837 1170837 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_7                         14.0 6.0                       20.0                         14 6                 20
1170838 1170838 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_8                         6.0 3.0                       9.0                         6 3                 9
1170839 1170839 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   kindergarten                         26.0 16.0                       42.0                         26 16                 42
1170840 1170840 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   pk_12_total 195.0 10.0 22.0 1.0         1.0   16.0   147.0 98.0                       245.0 195 10 22 1         1   16   147 98                 245
1170847 1170847 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_1                         19.0 21.0                       40.0                         19 21                 40
1170848 1170848 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_2                         26.0 22.0                       48.0                         26 22                 48
1170849 1170849 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_3                         16.0 21.0                       37.0                         16 21                 37
1170850 1170850 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_4                         18.0 8.0                       26.0                         18 8                 26
1170851 1170851 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_5                         11.0 12.0                       23.0                         11 12                 23
1170852 1170852 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_6                         12.0 7.0                       19.0                         12 7                 19
1170853 1170853 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   kindergarten                         30.0 18.0                       48.0                         30 18                 48
1170854 1170854 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   pk_12_total 2.0 211.0 15.0     1.0     1.0   11.0   132.0 109.0                       241.0 2 211 15     1     1   11   132 109                 241
1170811 1170811 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_1                         37.0 35.0                       72.0                         37 35                 72
1170812 1170812 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_10                         44.0 53.0                       97.0                         44 53                 97
1170813 1170813 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_11                         36.0 26.0                       62.0                         36 26                 62
1170814 1170814 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_12                         40.0 47.0                       87.0                         40 47                 87
1170815 1170815 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_2                         32.0 41.0                       73.0                         32 41                 73
1170816 1170816 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_3                         45.0 32.0                       77.0                         45 32                 77
1170817 1170817 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_4                         33.0 40.0                       73.0                         33 40                 73
1170818 1170818 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_5                         41.0 34.0                       75.0                         41 34                 75
1170819 1170819 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_6                         44.0 32.0                       76.0                         44 32                 76
1170820 1170820 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_7                         42.0 38.0                       80.0                         42 38                 80
1170821 1170821 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_8                         39.0 39.0                       78.0                         39 39                 78
1170822 1170822 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_9                         50.0 52.0                       102.0                         50 52                 102
1170823 1170823 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   kindergarten                         33.0 37.0                       70.0                         33 37                 70
1170824 1170824 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   pk_12_total 734.0 113.0 81.0 1.0   4.0         89.0   516.0 506.0                       1022.0 734 113 81 1   4         89   516 506                 1022
1170861 1170861 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   grade_1                         6.0 8.0                       14.0                         6 8                 14
1170862 1170862 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   grade_2                         8.0 4.0                       12.0                         8 4                 12
1170863 1170863 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   grade_3                         13.0 7.0                       20.0                         13 7                 20
1170864 1170864 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   grade_4                         6.0 7.0                       13.0                         6 7                 13
1170865 1170865 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   grade_5                         7.0 5.0                       12.0                         7 5                 12
1170866 1170866 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   grade_6                         6.0 7.0                       13.0                         6 7                 13
1170867 1170867 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   grade_7                         9.0 9.0                       18.0                         9 9                 18
1170868 1170868 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   grade_8                         2.0 5.0                       7.0                         2 5                 7
1170869 1170869 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   kindergarten                         9.0 8.0                       17.0                         9 8                 17
1170870 1170870 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   pk_12_total 26.0 77.0 11.0               12.0   66.0 60.0                       126.0 26 77 11               12   66 60                 126
1170806 1170806 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes 3.0 09 12 2015   grade_10                         10.0 6.0                       16.0                         10 6                 16
1170807 1170807 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes 3.0 09 12 2015   grade_11                         17.0 9.0                       26.0                         17 9                 26
1170808 1170808 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes 3.0 09 12 2015   grade_12                         66.0 67.0                       133.0                         66 67                 133
1170809 1170809 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes 3.0 09 12 2015   grade_9                         6.0 5.0                       11.0                         6 5                 11
1170810 1170810 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes 3.0 09 12 2015   pk_12_total 138.0 20.0 6.0 1.0   2.0         19.0   99.0 87.0                       186.0 138 20 6 1   2         19   99 87                 186
1170877 1170877 IN     school 1800017 9370   Fall Creek Academy 180001701788 5870 Fall Creek Academy   Regular School Yes 4.0 06 12 2015   grade_10                         16.0 17.0                       33.0                         16 17                 33
1170878 1170878 IN     school 1800017 9370   Fall Creek Academy 180001701788 5870 Fall Creek Academy   Regular School Yes 4.0 06 12 2015   grade_11                         15.0 16.0                       31.0                         15 16                 31
1170879 1170879 IN     school 1800017 9370   Fall Creek Academy 180001701788 5870 Fall Creek Academy   Regular School Yes 4.0 06 12 2015   grade_12                         14.0 8.0                       22.0                         14 8                 22
1170880 1170880 IN     school 1800017 9370   Fall Creek Academy 180001701788 5870 Fall Creek Academy   Regular School Yes 4.0 06 12 2015   grade_6                         6.0 7.0                       13.0                         6 7                 13
1170881 1170881 IN     school 1800017 9370   Fall Creek Academy 180001701788 5870 Fall Creek Academy   Regular School Yes 4.0 06 12 2015   grade_7                         11.0 12.0                       23.0                         11 12                 23
1170882 1170882 IN     school 1800017 9370   Fall Creek Academy 180001701788 5870 Fall Creek Academy   Regular School Yes 4.0 06 12 2015   grade_8                         17.0 16.0                       33.0                         17 16                 33
1170883 1170883 IN     school 1800017 9370   Fall Creek Academy 180001701788 5870 Fall Creek Academy   Regular School Yes 4.0 06 12 2015   grade_9                         13.0 18.0                       31.0                         13 18                 31
1170884 1170884 IN     school 1800017 9370   Fall Creek Academy 180001701788 5870 Fall Creek Academy   Regular School Yes 4.0 06 12 2015   pk_12_total 5.0 171.0 2.0               8.0   92.0 94.0                       186.0 5 171 2               8   92 94                 186
1170895 1170895 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2015   grade_1                         34.0 19.0                       53.0                         34 19                 53
1170896 1170896 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2015   grade_10                         27.0 23.0                       50.0                         27 23                 50
1170897 1170897 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2015   grade_11                         17.0 17.0                       34.0                         17 17                 34
1170898 1170898 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2015   grade_12                         15.0 15.0                       30.0                         15 15                 30
1170899 1170899 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2015   grade_2                         14.0 39.0                       53.0                         14 39                 53
1170900 1170900 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2015   grade_3                         27.0 27.0                       54.0                         27 27                 54

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