enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2015 · 12,044 ✖
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
1160035 1160035 IN     school   255   East Allen County Schools   318 Park Hill Learning Center             2015   pk_12_total 34.0 11.0 5.0     1.0         2.0   37.0 16.0     0.0             47.0   53.0 34 11 5     1         2   37 16     0       47   53
1160036 1160036 IN     school   255   East Allen County Schools   318 Park Hill Learning Center             2015   pre_kindergarten                         37.0 16.0                       53.0                         37 16                 53
1166230 1166230 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_1                         2.0 1.0                       3.0                         2 1                 3
1166231 1166231 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_10                         8.0 2.0                       10.0                         8 2                 10
1166232 1166232 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_11                         4.0 2.0                       6.0                         4 2                 6
1166233 1166233 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_12                         7.0 1.0                       8.0                         7 1                 8
1166234 1166234 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_2                         2.0 1.0                       3.0                         2 1                 3
1166235 1166235 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_3                         4.0 0.0                       4.0                         4 0                 4
1166236 1166236 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_4                         5.0 1.0                       6.0                         5 1                 6
1166237 1166237 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_5                         9.0 1.0                       10.0                         9 1                 10
1166238 1166238 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_6                         7.0 0.0                       7.0                         7 0                 7
1166239 1166239 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_7                         11.0 1.0                       12.0                         11 1                 12
1166240 1166240 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_8                         6.0 0.0                       6.0                         6 0                 6
1166241 1166241 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_9                         8.0 0.0                       8.0                         8 0                 8
1166242 1166242 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   kindergarten                         2.0 0.0                       2.0                         2 0                 2
1166243 1166243 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   pk_12_total 43.0 25.0 8.0               9.0   75.0 10.0     7.0             83.0   85.0 43 25 8               9   75 10     7       83   85
1167334 1167334 IN     school   5855   Crawfordsville Com Schools   6305 Anna Willson School             2015   pk_12_total 95.0 4.0 36.0     1.0         1.0   86.0 51.0     0.0             70.0   137.0 95 4 36     1         1   86 51     0       70   137
1167335 1167335 IN     school   5855   Crawfordsville Com Schools   6305 Anna Willson School             2015   pre_kindergarten                         86.0 51.0                       137.0                         86 51                 137
1168294 1168294 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   adult                         4.0 3.0                       7.0                         4 3                 7
1168295 1168295 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   grade_10                         3.0 4.0                       7.0                         3 4                 7
1168296 1168296 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   grade_11                         1.0 4.0                       5.0                         1 4                 5
1168297 1168297 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   grade_12                         3.0 1.0                       4.0                         3 1                 4
1168298 1168298 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   grade_9                         4.0 1.0                       5.0                         4 1                 5
1168299 1168299 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   pk_12_total 28.0                       15.0 13.0                       28.0 28                       15 13                 28
1168929 1168929 IN     school   7205   South Bend Community Sch Corp   7605 South Bend SNAP             2015   pk_12_total 94.0 34.0 11.0 1.0             13.0   114.0 39.0     0.0             97.0   153.0 94 34 11 1             13   114 39     0       97   153
1168930 1168930 IN     school   7205   South Bend Community Sch Corp   7605 South Bend SNAP             2015   pre_kindergarten                         114.0 39.0                       153.0                         114 39                 153
1159666 1159666 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_1                         37.0 39.0                       76.0                         37 39                 76
1159667 1159667 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_2                         35.0 36.0                       71.0                         35 36                 71
1159668 1159668 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_3                         37.0 34.0                       71.0                         37 34                 71
1159669 1159669 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_4                         38.0 30.0                       68.0                         38 30                 68
1159670 1159670 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_5                         25.0 34.0                       59.0                         25 34                 59
1159671 1159671 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_6                         40.0 43.0                       83.0                         40 43                 83
1159672 1159672 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_7                         32.0 39.0                       71.0                         32 39                 71
1159673 1159673 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_8                         35.0 41.0                       76.0                         35 41                 76
1159674 1159674 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   pk_12_total 277.0 143.0 91.0 2.0   12.0         50.0   279.0 296.0     40.0             87.0   575.0 277 143 91 2   12         50   279 296     40       87   575
1159707 1159707 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_1                         57.0 62.0                       119.0                         57 62                 119
1159708 1159708 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_2                         69.0 49.0                       118.0                         69 49                 118
1159709 1159709 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_3                         61.0 49.0                       110.0                         61 49                 110
1159710 1159710 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_4                         50.0 57.0                       107.0                         50 57                 107
1159711 1159711 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_5                         43.0 63.0                       106.0                         43 63                 106
1159712 1159712 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   pk_12_total 245.0 150.0 115.0 4.0   11.0     3.0   32.0   280.0 280.0     59.0             61.0   560.0 245 150 115 4   11     3   32   280 280     59       61   560
1162134 1162134 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   grade_1                         1.0 0.0                       1.0                         1 0                 1
1162135 1162135 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   grade_2                         4.0 0.0                       4.0                         4 0                 4
1162136 1162136 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   grade_3                         78.0 71.0                       149.0                         78 71                 149
1162137 1162137 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   grade_4                         90.0 76.0                       166.0                         90 76                 166
1162138 1162138 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   grade_5                         88.0 72.0                       160.0                         88 72                 160
1162139 1162139 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   pk_12_total 391.0 20.0 12.0     6.0     1.0   50.0   261.0 219.0     5.0             154.0   480.0 391 20 12     6     1   50   261 219     5       154   480
1163264 1163264 IN     school 1807440 3445   New Castle Community Sch Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No 1.0 01 06 2015   grade_1                         17.0 18.0                       35.0                         17 18                 35
1163265 1163265 IN     school 1807440 3445   New Castle Community Sch Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No 1.0 01 06 2015   grade_2                         22.0 24.0                       46.0                         22 24                 46
1163266 1163266 IN     school 1807440 3445   New Castle Community Sch Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No 1.0 01 06 2015   grade_3                         24.0 18.0                       42.0                         24 18                 42
1163267 1163267 IN     school 1807440 3445   New Castle Community Sch Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No 1.0 01 06 2015   grade_4                         19.0 22.0                       41.0                         19 22                 41
1163268 1163268 IN     school 1807440 3445   New Castle Community Sch Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No 1.0 01 06 2015   grade_5                         27.0 17.0                       44.0                         27 17                 44
1163269 1163269 IN     school 1807440 3445   New Castle Community Sch Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No 1.0 01 06 2015   grade_6                         22.0 31.0                       53.0                         22 31                 53
1163270 1163270 IN     school 1807440 3445   New Castle Community Sch Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No 1.0 01 06 2015   pk_12_total 240.0 3.0 10.0     4.0         4.0   131.0 130.0     1.0             27.0   261.0 240 3 10     4         4   131 130     1       27   261
1163280 1163280 IN     school 1807440 3445   New Castle Community Sch Corp 180744001291 2861 Westwood Elementary School   Regular School No 1.0 01 06 2015   grade_1                         15.0 12.0                       27.0                         15 12                 27
1163281 1163281 IN     school 1807440 3445   New Castle Community Sch Corp 180744001291 2861 Westwood Elementary School   Regular School No 1.0 01 06 2015   grade_2                         18.0 25.0                       43.0                         18 25                 43
1163282 1163282 IN     school 1807440 3445   New Castle Community Sch Corp 180744001291 2861 Westwood Elementary School   Regular School No 1.0 01 06 2015   grade_3                         22.0 29.0                       51.0                         22 29                 51
1163283 1163283 IN     school 1807440 3445   New Castle Community Sch Corp 180744001291 2861 Westwood Elementary School   Regular School No 1.0 01 06 2015   grade_4                         21.0 19.0                       40.0                         21 19                 40
1163284 1163284 IN     school 1807440 3445   New Castle Community Sch Corp 180744001291 2861 Westwood Elementary School   Regular School No 1.0 01 06 2015   grade_5                         28.0 21.0                       49.0                         28 21                 49
1163285 1163285 IN     school 1807440 3445   New Castle Community Sch Corp 180744001291 2861 Westwood Elementary School   Regular School No 1.0 01 06 2015   grade_6                         28.0 18.0                       46.0                         28 18                 46
1163286 1163286 IN     school 1807440 3445   New Castle Community Sch Corp 180744001291 2861 Westwood Elementary School   Regular School No 1.0 01 06 2015   pk_12_total 234.0 2.0 9.0     5.0         6.0   132.0 124.0     1.0             31.0   256.0 234 2 9     5         6   132 124     1       31   256
1164698 1164698 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2015   grade_1                         22.0 14.0                       36.0                         22 14                 36
1164699 1164699 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2015   grade_2                         15.0 33.0                       48.0                         15 33                 48
1164700 1164700 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2015   grade_3                         22.0 22.0                       44.0                         22 22                 44
1164701 1164701 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2015   grade_4                         24.0 20.0                       44.0                         24 20                 44
1164702 1164702 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2015   grade_5                         25.0 16.0                       41.0                         25 16                 41
1164703 1164703 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2015   grade_6                         21.0 13.0                       34.0                         21 13                 34
1164704 1164704 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2015   pk_12_total 103.0 18.0 120.0               6.0   129.0 118.0     19.0             37.0   247.0 103 18 120               6   129 118     19       37   247
1164713 1164713 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No 1.0 01 06 2015   grade_1                         17.0 20.0                       37.0                         17 20                 37
1164714 1164714 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No 1.0 01 06 2015   grade_2                         24.0 17.0                       41.0                         24 17                 41
1164715 1164715 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No 1.0 01 06 2015   grade_3                         16.0 10.0                       26.0                         16 10                 26
1164716 1164716 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No 1.0 01 06 2015   grade_4                         15.0 13.0                       28.0                         15 13                 28
1164717 1164717 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No 1.0 01 06 2015   grade_5                         23.0 17.0                       40.0                         23 17                 40
1164718 1164718 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No 1.0 01 06 2015   grade_6                         10.0 14.0                       24.0                         10 14                 24
1164719 1164719 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No 1.0 01 06 2015   pk_12_total 118.0 6.0 67.0 1.0             4.0   105.0 91.0     19.0             26.0   196.0 118 6 67 1             4   105 91     19       26   196
1165056 1165056 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No 1.0 01 05 2015   grade_1                         36.0 30.0                       66.0                         36 30                 66
1165057 1165057 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No 1.0 01 05 2015   grade_2                         40.0 37.0                       77.0                         40 37                 77
1165058 1165058 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No 1.0 01 05 2015   grade_3                         29.0 29.0                       58.0                         29 29                 58
1165059 1165059 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No 1.0 01 05 2015   grade_4                         28.0 30.0                       58.0                         28 30                 58
1165060 1165060 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No 1.0 01 05 2015   grade_5                         25.0 31.0                       56.0                         25 31                 56
1165061 1165061 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No 1.0 01 05 2015   pk_12_total 214.0 13.0 74.0 3.0             11.0   158.0 157.0     10.0             54.0   315.0 214 13 74 3             11   158 157     10       54   315
1165614 1165614 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No 1.0 01 06 2015   grade_1                         56.0 46.0                       102.0                         56 46                 102
1165615 1165615 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No 1.0 01 06 2015   grade_2                         44.0 44.0                       88.0                         44 44                 88
1165616 1165616 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No 1.0 01 06 2015   grade_3                         47.0 57.0                       104.0                         47 57                 104
1165617 1165617 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No 1.0 01 06 2015   grade_4                         50.0 35.0                       85.0                         50 35                 85
1165618 1165618 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No 1.0 01 06 2015   grade_5                         50.0 59.0                       109.0                         50 59                 109
1165619 1165619 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No 1.0 01 06 2015   grade_6                         44.0 59.0                       103.0                         44 59                 103
1165620 1165620 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No 1.0 01 06 2015   pk_12_total 438.0 70.0 44.0 1.0         1.0   37.0   291.0 300.0     34.0             67.0   591.0 438 70 44 1         1   37   291 300     34       67   591
1165621 1165621 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No 1.0 01 06 2015   grade_1                         46.0 43.0                       89.0                         46 43                 89
1165622 1165622 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No 1.0 01 06 2015   grade_2                         47.0 55.0                       102.0                         47 55                 102
1165623 1165623 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No 1.0 01 06 2015   grade_3                         61.0 54.0                       115.0                         61 54                 115
1165624 1165624 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No 1.0 01 06 2015   grade_4                         51.0 43.0                       94.0                         51 43                 94
1165625 1165625 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No 1.0 01 06 2015   grade_5                         51.0 37.0                       88.0                         51 37                 88
1165626 1165626 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No 1.0 01 06 2015   grade_6                         51.0 43.0                       94.0                         51 43                 94
1165627 1165627 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No 1.0 01 06 2015   pk_12_total 390.0 78.0 78.0 2.0   3.0         31.0   307.0 275.0     55.0             48.0   582.0 390 78 78 2   3         31   307 275     55       48   582
1165631 1165631 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elem Sch   Regular School No 1.0 01 06 2015   grade_1                         40.0 40.0                       80.0                         40 40                 80
1165632 1165632 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elem Sch   Regular School No 1.0 01 06 2015   grade_2                         39.0 42.0                       81.0                         39 42                 81
1165633 1165633 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elem Sch   Regular School No 1.0 01 06 2015   grade_3                         51.0 37.0                       88.0                         51 37                 88
1165634 1165634 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elem Sch   Regular School No 1.0 01 06 2015   grade_4                         54.0 47.0                       101.0                         54 47                 101
1165635 1165635 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elem Sch   Regular School No 1.0 01 06 2015   grade_5                         45.0 36.0                       81.0                         45 36                 81

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