enrollments

Data source: Big Local News · About: Big Local

12,002 rows where state = "IN" and year = 2021 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 11,902 ✖
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
1919073 1919073 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   grade_1                         31.0 26.0                       57.0                         31 26                 57
1919074 1919074 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   grade_2                         27.0 24.0                       51.0                         27 24                 51
1919075 1919075 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   grade_3                         29.0 27.0                       56.0                         29 27                 56
1919076 1919076 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   grade_4                         37.0 31.0                       68.0                         37 31                 68
1919077 1919077 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   grade_5                         42.0 43.0                       85.0                         42 43                 85
1919078 1919078 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         25.0 23.0                       48.0                         25 23                 48
1919080 1919080 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         5.0 2.0                       7.0                         5 2                 7
1919081 1919081 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   grade_1                         51.0 41.0                       92.0                         51 41                 92
1919082 1919082 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   grade_2                         60.0 42.0                       102.0                         60 42                 102
1919083 1919083 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   grade_3                         65.0 52.0                       117.0                         65 52                 117
1919084 1919084 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   grade_4                         55.0 70.0                       125.0                         55 70                 125
1919085 1919085 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   grade_5                         51.0 49.0                       100.0                         51 49                 100
1919086 1919086 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         47.0 57.0                       104.0                         47 57                 104
1919088 1919088 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2021   grade_6                         167.0 147.0                       314.0                         167 147                 314
1919089 1919089 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2021   grade_7                         160.0 174.0                       334.0                         160 174                 334
1919090 1919090 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2021   grade_8                         165.0 160.0                       325.0                         165 160                 325
1919092 1919092 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2021   grade_10                         301.0 326.0                       627.0                         301 326                 627
1919093 1919093 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2021   grade_11                         314.0 280.0                       594.0                         314 280                 594
1919094 1919094 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2021   grade_12                         326.0 287.0                       613.0                         326 287                 613
1919095 1919095 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2021   grade_9                         331.0 310.0                       641.0                         331 310                 641
1919097 1919097 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_1                         58.0 46.0                       104.0                         58 46                 104
1919098 1919098 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_2                         44.0 60.0                       104.0                         44 60                 104
1919099 1919099 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_3                         50.0 58.0                       108.0                         50 58                 108
1919100 1919100 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_4                         53.0 44.0                       97.0                         53 44                 97
1919101 1919101 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_5                         50.0 52.0                       102.0                         50 52                 102
1919102 1919102 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         55.0 41.0                       96.0                         55 41                 96
1919104 1919104 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   grade_1                         48.0 33.0                       81.0                         48 33                 81
1919105 1919105 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   grade_2                         31.0 41.0                       72.0                         31 41                 72
1919106 1919106 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   grade_3                         54.0 41.0                       95.0                         54 41                 95
1919107 1919107 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   grade_4                         52.0 49.0                       101.0                         52 49                 101
1919108 1919108 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   grade_5                         40.0 42.0                       82.0                         40 42                 82
1919109 1919109 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         40.0 30.0                       70.0                         40 30                 70
1919111 1919111 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   grade_1                         60.0 58.0                       118.0                         60 58                 118
1919112 1919112 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   grade_2                         57.0 37.0                       94.0                         57 37                 94
1919113 1919113 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   grade_3                         51.0 57.0                       108.0                         51 57                 108
1919114 1919114 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   grade_4                         43.0 51.0                       94.0                         43 51                 94
1919115 1919115 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   grade_5                         48.0 45.0                       93.0                         48 45                 93
1919116 1919116 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         48.0 38.0                       86.0                         48 38                 86
1919118 1919118 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         13.0 11.0                       24.0                         13 11                 24
1919119 1919119 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   grade_1                         50.0 40.0                       90.0                         50 40                 90
1919120 1919120 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   grade_2                         50.0 59.0                       109.0                         50 59                 109
1919121 1919121 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   grade_3                         57.0 40.0                       97.0                         57 40                 97
1919122 1919122 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   grade_4                         52.0 46.0                       98.0                         52 46                 98
1919123 1919123 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   grade_5                         42.0 38.0                       80.0                         42 38                 80
1919124 1919124 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         49.0 43.0                       92.0                         49 43                 92
1919126 1919126 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1919127 1919127 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_11                         3.0 0.0                       3.0                         3 0                 3
1919128 1919128 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1919129 1919129 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_8                         1.0 0.0                       1.0                         1 0                 1
1919131 1919131 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2021   grade_10                         216.0 202.0                       418.0                         216 202                 418
1919132 1919132 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2021   grade_11                         167.0 182.0                       349.0                         167 182                 349
1919133 1919133 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2021   grade_12                         189.0 174.0                       363.0                         189 174                 363
1919134 1919134 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2021   grade_9                         216.0 201.0                       417.0                         216 201                 417
1919136 1919136 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2021   grade_10                         213.0 250.0                       463.0                         213 250                 463
1919137 1919137 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2021   grade_11                         224.0 221.0                       445.0                         224 221                 445
1919138 1919138 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2021   grade_12                         216.0 217.0                       433.0                         216 217                 433
1919139 1919139 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2021   grade_9                         235.0 254.0                       489.0                         235 254                 489
1919141 1919141 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2021   grade_10                         204.0 201.0                       405.0                         204 201                 405
1919142 1919142 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2021   grade_11                         155.0 170.0                       325.0                         155 170                 325
1919143 1919143 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2021   grade_12                         157.0 149.0                       306.0                         157 149                 306
1919144 1919144 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2021   grade_9                         181.0 198.0                       379.0                         181 198                 379
1919146 1919146 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2021   grade_6                         129.0 136.0                       265.0                         129 136                 265
1919147 1919147 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2021   grade_7                         145.0 144.0                       289.0                         145 144                 289
1919148 1919148 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2021   grade_8                         138.0 134.0                       272.0                         138 134                 272
1919150 1919150 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_1                         31.0 35.0                       66.0                         31 35                 66
1919151 1919151 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_2                         31.0 35.0                       66.0                         31 35                 66
1919152 1919152 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_3                         39.0 34.0                       73.0                         39 34                 73
1919153 1919153 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_4                         29.0 37.0                       66.0                         29 37                 66
1919154 1919154 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_5                         36.0 34.0                       70.0                         36 34                 70
1919155 1919155 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_6                         41.0 34.0                       75.0                         41 34                 75
1919156 1919156 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_7                         30.0 38.0                       68.0                         30 38                 68
1919157 1919157 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_8                         41.0 32.0                       73.0                         41 32                 73
1919159 1919159 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2021   grade_6                         125.0 98.0                       223.0                         125 98                 223
1919160 1919160 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2021   grade_7                         122.0 141.0                       263.0                         122 141                 263
1919161 1919161 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2021   grade_8                         124.0 109.0                       233.0                         124 109                 233
1919163 1919163 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2021   grade_6                         107.0 108.0                       215.0                         107 108                 215
1919164 1919164 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2021   grade_7                         94.0 86.0                       180.0                         94 86                 180
1919165 1919165 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2021   grade_8                         87.0 91.0                       178.0                         87 91                 178
1919167 1919167 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2021   grade_6                         93.0 70.0                       163.0                         93 70                 163
1919168 1919168 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2021   grade_7                         85.0 93.0                       178.0                         85 93                 178
1919169 1919169 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2021   grade_8                         89.0 82.0                       171.0                         89 82                 171
1919171 1919171 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2021   grade_6                         115.0 116.0                       231.0                         115 116                 231
1919172 1919172 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2021   grade_7                         132.0 120.0                       252.0                         132 120                 252
1919173 1919173 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2021   grade_8                         133.0 121.0                       254.0                         133 121                 254
1919175 1919175 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2021   grade_6                         92.0 115.0                       207.0                         92 115                 207
1919176 1919176 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2021   grade_7                         87.0 109.0                       196.0                         87 109                 196
1919177 1919177 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2021   grade_8                         102.0 90.0                       192.0                         102 90                 192
1919179 1919179 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2021   grade_6                         100.0 88.0                       188.0                         100 88                 188
1919180 1919180 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2021   grade_7                         92.0 85.0                       177.0                         92 85                 177
1919181 1919181 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2021   grade_8                         100.0 93.0                       193.0                         100 93                 193
1919183 1919183 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No Middle 06 08 2021   grade_6                         97.0 84.0                       181.0                         97 84                 181
1919184 1919184 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No Middle 06 08 2021   grade_7                         121.0 108.0                       229.0                         121 108                 229
1919185 1919185 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No Middle 06 08 2021   grade_8                         94.0 81.0                       175.0                         94 81                 175
1919187 1919187 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No Middle 06 08 2021   grade_6                         80.0 74.0                       154.0                         80 74                 154
1919188 1919188 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No Middle 06 08 2021   grade_7                         90.0 67.0                       157.0                         90 67                 157
1919189 1919189 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No Middle 06 08 2021   grade_8                         76.0 75.0                       151.0                         76 75                 151
1919191 1919191 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2021   grade_1                         51.0 64.0                       115.0                         51 64                 115
1919192 1919192 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2021   grade_2                         60.0 55.0                       115.0                         60 55                 115
1919193 1919193 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2021   grade_3                         59.0 57.0                       116.0                         59 57                 116
1919194 1919194 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2021   grade_4                         63.0 54.0                       117.0                         63 54                 117

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