enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2017 · 11,958 ✖
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
1293035 1293035 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2017   grade_2                         33.0 40.0                       73.0                         33 40                 73
1293036 1293036 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2017   grade_3                         30.0 38.0                       68.0                         30 38                 68
1293037 1293037 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2017   grade_4                         34.0 32.0                       66.0                         34 32                 66
1293038 1293038 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2017   grade_5                         40.0 42.0                       82.0                         40 42                 82
1293039 1293039 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         36.0 37.0                       73.0                         36 37                 73
1293041 1293041 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         10.0 1.0                       11.0                         10 1                 11
1293042 1293042 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2017   grade_1                         53.0 38.0                       91.0                         53 38                 91
1293043 1293043 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2017   grade_2                         56.0 52.0                       108.0                         56 52                 108
1293044 1293044 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2017   grade_3                         52.0 51.0                       103.0                         52 51                 103
1293045 1293045 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2017   grade_4                         66.0 45.0                       111.0                         66 45                 111
1293046 1293046 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2017   grade_5                         50.0 44.0                       94.0                         50 44                 94
1293047 1293047 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         57.0 59.0                       116.0                         57 59                 116
1293049 1293049 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2017   grade_6                         135.0 143.0                       278.0                         135 143                 278
1293050 1293050 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2017   grade_7                         173.0 127.0                       300.0                         173 127                 300
1293051 1293051 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2017   grade_8                         185.0 170.0                       355.0                         185 170                 355
1293053 1293053 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   grade_10                         269.0 323.0                       592.0                         269 323                 592
1293054 1293054 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   grade_11                         299.0 281.0                       580.0                         299 281                 580
1293055 1293055 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   grade_12                         248.0 258.0                       506.0                         248 258                 506
1293056 1293056 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   grade_9                         285.0 317.0                       602.0                         285 317                 602
1293058 1293058 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2017   grade_1                         47.0 38.0                       85.0                         47 38                 85
1293059 1293059 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2017   grade_2                         42.0 43.0                       85.0                         42 43                 85
1293060 1293060 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2017   grade_3                         34.0 40.0                       74.0                         34 40                 74
1293061 1293061 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2017   grade_4                         45.0 40.0                       85.0                         45 40                 85
1293062 1293062 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2017   grade_5                         48.0 42.0                       90.0                         48 42                 90
1293063 1293063 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         51.0 30.0                       81.0                         51 30                 81
1293065 1293065 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   grade_1                         44.0 33.0                       77.0                         44 33                 77
1293066 1293066 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   grade_2                         41.0 36.0                       77.0                         41 36                 77
1293067 1293067 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   grade_3                         37.0 35.0                       72.0                         37 35                 72
1293068 1293068 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   grade_4                         44.0 37.0                       81.0                         44 37                 81
1293069 1293069 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   grade_5                         47.0 29.0                       76.0                         47 29                 76
1293070 1293070 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         42.0 45.0                       87.0                         42 45                 87
1293072 1293072 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   grade_1                         37.0 35.0                       72.0                         37 35                 72
1293073 1293073 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   grade_2                         41.0 41.0                       82.0                         41 41                 82
1293074 1293074 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   grade_3                         51.0 48.0                       99.0                         51 48                 99
1293075 1293075 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   grade_4                         53.0 52.0                       105.0                         53 52                 105
1293076 1293076 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   grade_5                         60.0 48.0                       108.0                         60 48                 108
1293077 1293077 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         31.0 49.0                       80.0                         31 49                 80
1293079 1293079 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         16.0 5.0                       21.0                         16 5                 21
1293080 1293080 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2017   grade_1                         37.0 35.0                       72.0                         37 35                 72
1293081 1293081 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2017   grade_2                         43.0 34.0                       77.0                         43 34                 77
1293082 1293082 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2017   grade_3                         49.0 53.0                       102.0                         49 53                 102
1293083 1293083 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2017   grade_4                         45.0 45.0                       90.0                         45 45                 90
1293084 1293084 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2017   grade_5                         39.0 50.0                       89.0                         39 50                 89
1293085 1293085 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         56.0 44.0                       100.0                         56 44                 100
1293087 1293087 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_10                         1.0 3.0                       4.0                         1 3                 4
1293088 1293088 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_11                         2.0 0.0                       2.0                         2 0                 2
1293089 1293089 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_5                         1.0 0.0                       1.0                         1 0                 1
1293090 1293090 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_6                         0.0 1.0                       1.0                         0 1                 1
1293091 1293091 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_8                         1.0 1.0                       2.0                         1 1                 2
1293092 1293092 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_9                         0.0 2.0                       2.0                         0 2                 2
1293094 1293094 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   grade_10                         3.0 2.0                       5.0                         3 2                 5
1293095 1293095 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   grade_11                         8.0 4.0                       12.0                         8 4                 12
1293096 1293096 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   grade_12                         3.0 1.0                       4.0                         3 1                 4
1293097 1293097 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   grade_8                         2.0 1.0                       3.0                         2 1                 3
1293098 1293098 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   grade_9                         1.0 0.0                       1.0                         1 0                 1
1293100 1293100 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2017   grade_10                         230.0 205.0                       435.0                         230 205                 435
1293101 1293101 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2017   grade_11                         234.0 201.0                       435.0                         234 201                 435
1293102 1293102 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2017   grade_12                         205.0 196.0                       401.0                         205 196                 401
1293103 1293103 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2017   grade_9                         193.0 208.0                       401.0                         193 208                 401
1293105 1293105 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2017   grade_10                         240.0 234.0                       474.0                         240 234                 474
1293106 1293106 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2017   grade_11                         223.0 232.0                       455.0                         223 232                 455
1293107 1293107 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2017   grade_12                         227.0 224.0                       451.0                         227 224                 451
1293108 1293108 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2017   grade_9                         219.0 251.0                       470.0                         219 251                 470
1293110 1293110 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2017   grade_10                         203.0 171.0                       374.0                         203 171                 374
1293111 1293111 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2017   grade_11                         150.0 167.0                       317.0                         150 167                 317
1293112 1293112 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2017   grade_12                         167.0 161.0                       328.0                         167 161                 328
1293113 1293113 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2017   grade_9                         197.0 193.0                       390.0                         197 193                 390
1293115 1293115 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2017   grade_6                         111.0 132.0                       243.0                         111 132                 243
1293116 1293116 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2017   grade_7                         139.0 132.0                       271.0                         139 132                 271
1293117 1293117 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2017   grade_8                         136.0 126.0                       262.0                         136 126                 262
1293119 1293119 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_1                         41.0 29.0                       70.0                         41 29                 70
1293120 1293120 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_2                         36.0 39.0                       75.0                         36 39                 75
1293121 1293121 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_3                         33.0 37.0                       70.0                         33 37                 70
1293122 1293122 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_4                         31.0 37.0                       68.0                         31 37                 68
1293123 1293123 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_5                         37.0 40.0                       77.0                         37 40                 77
1293124 1293124 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_6                         38.0 38.0                       76.0                         38 38                 76
1293125 1293125 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_7                         44.0 34.0                       78.0                         44 34                 78
1293126 1293126 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_8                         37.0 45.0                       82.0                         37 45                 82
1293128 1293128 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2017   grade_6                         144.0 111.0                       255.0                         144 111                 255
1293129 1293129 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2017   grade_7                         102.0 125.0                       227.0                         102 125                 227
1293130 1293130 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2017   grade_8                         121.0 115.0                       236.0                         121 115                 236
1293132 1293132 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2017   grade_6                         103.0 84.0                       187.0                         103 84                 187
1293133 1293133 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2017   grade_7                         87.0 73.0                       160.0                         87 73                 160
1293134 1293134 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2017   grade_8                         93.0 76.0                       169.0                         93 76                 169
1293136 1293136 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2017   grade_6                         82.0 95.0                       177.0                         82 95                 177
1293137 1293137 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2017   grade_7                         85.0 68.0                       153.0                         85 68                 153
1293138 1293138 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2017   grade_8                         93.0 74.0                       167.0                         93 74                 167
1293140 1293140 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2017   grade_6                         124.0 120.0                       244.0                         124 120                 244
1293141 1293141 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2017   grade_7                         99.0 114.0                       213.0                         99 114                 213
1293142 1293142 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2017   grade_8                         108.0 114.0                       222.0                         108 114                 222
1293144 1293144 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2017   grade_6                         95.0 123.0                       218.0                         95 123                 218
1293145 1293145 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2017   grade_7                         80.0 111.0                       191.0                         80 111                 191
1293146 1293146 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2017   grade_8                         83.0 109.0                       192.0                         83 109                 192
1293148 1293148 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2017   grade_6                         85.0 104.0                       189.0                         85 104                 189
1293149 1293149 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2017   grade_7                         95.0 87.0                       182.0                         95 87                 182
1293150 1293150 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2017   grade_8                         102.0 78.0                       180.0                         102 78                 180
1293152 1293152 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No Middle 06 08 2017   grade_6                         107.0 90.0                       197.0                         107 90                 197
1293153 1293153 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No Middle 06 08 2017   grade_7                         110.0 100.0                       210.0                         110 100                 210
1293154 1293154 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No Middle 06 08 2017   grade_8                         108.0 89.0                       197.0                         108 89                 197
1293156 1293156 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No Middle 06 08 2017   grade_6                         79.0 73.0                       152.0                         79 73                 152

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