enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1926542 1926542 IN     school 1802460 5855   Crawfordsville Community Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No High 09 12 2021   adult                         0.0 1.0                       1.0                         0 1                 1
1926602 1926602 IN     school 1806510 5925   MSD Martinsville Schools 180651001135 6329 Martinsville High School   Regular School No High 09 12 2021   adult                         2.0 2.0                       4.0                         2 2                 4
1926731 1926731 IN     school 1807920 5945   North Newton School Corp 180792001363 6411 North Newton Jr-Sr High School   Regular School No High 07 12 2021   adult                         5.0 0.0                       5.0                         5 0                 5
1926760 1926760 IN     school 1801710 6055   Central Noble Com School Corp 180171000230 6453 Central Noble Junior Senior HS   Regular School No High 06 12 2021   adult                         0.0 1.0                       1.0                         0 1                 1
1926781 1926781 IN     school 1802970 6060   East Noble School Corporation 180297000389 6458 East Noble High School   Regular School No High 09 12 2021   adult                         1.0 3.0                       4.0                         1 3                 4
1926819 1926819 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2021   adult                         8.0 2.0                       10.0                         8 2                 10
1926976 1926976 IN     school 1801740 6325   Perry Central Com Schools Corp 180174000234 6708 Perry Central Jr-Sr High School   Regular School No High 07 12 2021   adult                         0.0 2.0                       2.0                         0 2                 2
1926999 1926999 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001819 6741 Tell City Jr-Sr High School   Regular School No High 07 12 2021   adult                         2.0 0.0                       2.0                         2 0                 2
1927036 1927036 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011802644 6654 Parke Heritage High School   Regular School No High 09 12 2021   adult                         1.0 0.0                       1.0                         1 0                 1
1927083 1927083 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   adult                         1.0 0.0                       1.0                         1 0                 1
1927113 1927113 IN     school 1802800 6470   Duneland School Corporation 180280000333 6925 Chesterton Senior High School   Regular School No High 09 12 2021   adult                         3.0 0.0                       3.0                         3 0                 3
1927195 1927195 IN     school 1809180 6520   Porter Township School Corp 180918001521 6838 Boone Grove High School   Regular School No High 09 12 2021   adult                         2.0 4.0                       6.0                         2 4                 6
1927238 1927238 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   adult                         2.0 1.0                       3.0                         2 1                 3
1927252 1927252 IN     school 1809150 6550   Portage Township Schools 180915001514 6853 Portage High School   Regular School No High 09 12 2021   adult                         10.0 3.0                       13.0                         10 3                 13
1927322 1927322 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   adult                         0.0 1.0                       1.0                         0 1                 1
1927333 1927333 IN     school 1811970 6560   Valparaiso Community Schools 181197001891 6881 Valparaiso High School   Regular School No High 09 12 2021   adult                         8.0 4.0                       12.0                         8 4                 12
1927403 1927403 IN     school 1807290 6590   MSD Mount Vernon 180729001226 6949 Mount Vernon High School   Regular School No High 09 12 2021   adult                         2.0 1.0                       3.0                         2 1                 3
1927478 1927478 IN     school 1809360 6630   West Central School Corp 180936001529 7025 West Central Senior High School   Regular School No High 09 12 2021   adult                         2.0 2.0                       4.0                         2 2                 4
1927543 1927543 IN     school 1802220 6750   Cloverdale Community Schools 180222000265 7077 Cloverdale High School   Regular School No High 09 12 2021   adult                         1.0 0.0                       1.0                         1 0                 1
1927606 1927606 IN     school 1811730 6795   Union School Corporation 181173002666 7131 Indiana Digital JR and High School   Regular School No High 07 12 2021   adult                         1.0 0.0                       1.0                         1 0                 1
1927703 1927703 IN     school 1810530 6865   South Ripley Com Sch Corp 181053001729 7182 South Ripley High School   Regular School No High 09 12 2021   adult                         2.0 0.0                       2.0                         2 0                 2
1927709 1927709 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2021   adult                         1.0 1.0                       2.0                         1 1                 2
1927794 1927794 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High School   Regular School No High 09 12 2021   adult                         1.0 4.0                       5.0                         1 4                 5
1927806 1927806 IN     school 1809120 7150   John Glenn School Corporation 180912001505 7453 John Glenn High School   Regular School No High 09 12 2021   adult                         2.0 0.0                       2.0                         2 0                 2
1927866 1927866 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001451 7353 Penn High School   Regular School No High 09 12 2021   adult                         159.0 288.0                       447.0                         159 288                 447
1927937 1927937 IN     school 1806840 7200   School City of Mishawaka 180684001183 7461 Mishawaka High School   Regular School No High 09 12 2021   adult                         12.0 7.0                       19.0                         12 7                 19
1927946 1927946 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No High 07 12 2021   adult                         1.0 0.0                       1.0                         1 0                 1
1928193 1928193 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No Prekindergarten PK PK 2021   adult                         27.0 28.0                       55.0                         27 28                 55
1928255 1928255 IN     school 1810020 7255   Scott County School District 2 181002001612 7641 Scottsburg Senior High School   Regular School No High 09 12 2021   adult                         13.0 4.0                       17.0                         13 4                 17
1928417 1928417 IN     school 1808010 7385   North Spencer County Sch Corp 180801001376 7759 Heritage Hills High School   Regular School No High 09 12 2021   adult                         1.0 0.0                       1.0                         1 0                 1
1928489 1928489 IN     school 1805340 7525   Knox Community School Corp 180534000938 7833 Knox Community High School   Regular School No High 09 12 2021   adult                         3.0 3.0                       6.0                         3 3                 6
1928523 1928523 IN     school 1804230 7610   Hamilton Community Schools 180423000724 7885 Hamilton Community High School   Regular School No High 06 12 2021   adult                         0.0 1.0                       1.0                         0 1                 1
1928539 1928539 IN     school 1811100 7615   MSD Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2021   adult                         5.0 3.0                       8.0                         5 3                 8
1928641 1928641 IN     school 1811220 7775   Switzerland County School Corp 181122001811 7993 Switzerland Co Senior High School   Regular School No High 09 12 2021   adult                         1.0 1.0                       2.0                         1 1                 2
1928833 1928833 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No High 07 12 2021   adult                         2.0 1.0                       3.0                         2 1                 3
1929221 1929221 IN     school 1812090 8030   Vigo County School Corp 181209001917 8441 Terre Haute North Vigo High School   Regular School No High 09 12 2021   adult                         1.0 0.0                       1.0                         1 0                 1
1929433 1929433 IN     school 1812180 8050   MSD Wabash County Schools 181218001945 8651 Northfield Jr-Sr High School   Regular School No High 07 12 2021   adult                         0.0 1.0                       1.0                         0 1                 1
1929461 1929461 IN     school 1812180 8050   MSD Wabash County Schools 181218001951 8673 White's Jr-Sr High School   Regular School No High 07 12 2021   adult                         2.0 0.0                       2.0                         2 0                 2
1929584 1929584 IN     school 1812390 8130   Warrick County School Corp 181239001975 8789 Boonville High School   Regular School No High 09 12 2021   adult                         1.0 1.0                       2.0                         1 1                 2
1929601 1929601 IN     school 1812390 8130   Warrick County School Corp 181239001977 8809 Castle High School   Regular School No High 09 12 2021   adult                         8.0 2.0                       10.0                         8 2                 10
1929628 1929628 IN     school 1809810 8205   Salem Community Schools 180981001600 8857 Salem High School   Regular School No High 09 12 2021   adult                         0.0 1.0                       1.0                         0 1                 1
1929730 1929730 IN     school 1808190 8375   Northeastern Wayne Schools 180819001406 8927 Northeastern High School   Regular School No High 09 12 2021   adult                         0.0 1.0                       1.0                         0 1                 1
1929748 1929748 IN     school 1809510 8385   Richmond Community Schools 180951001566 8993 Richmond High School   Regular School No High 09 12 2021   adult                         6.0 4.0                       10.0                         6 4                 10
1929931 1929931 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2021   adult                         2.0 1.0                       3.0                         2 1                 3
1929954 1929954 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2021   adult                         4.0 0.0                       4.0                         4 0                 4
1930004 1930004 IN     school 1802280 8665   Whitley County Con Schools 180228000267 9187 Columbia City High School   Regular School No High 09 12 2021   adult                         2.0 8.0                       10.0                         2 8                 10
1930180 1930180 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2021   adult                         2.0 0.0                       2.0                         2 0                 2
1930187 1930187 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2021   adult                         43.0 0.0                       43.0                         43 0                 43
1930200 1930200 IN     school 1800006 9100   Indiana Department of Correction 180000602453 5616 Dept of Correction Adult Schools   Special Education School No High 07 12 2021   adult                         70.0 3.0                       73.0                         70 3                 73
1930537 1930537 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   adult                         10.0 4.0                       14.0                         10 4                 14
1930553 1930553 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   adult                         4.0 4.0                       8.0                         4 4                 8
1930674 1930674 IN     school 1800113 9730   Neighbors' New Vistas High School 180011302544 6864 Neighbors' New Vistas High School   Regular School Yes High 09 12 2021   adult                         38.0 32.0                       70.0                         38 32                 70
1918957 1918957 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_1                         48.0 47.0                       95.0                         48 47                 95
1918980 1918980 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2021   grade_1                         60.0 53.0                       113.0                         60 53                 113
1918998 1918998 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2021   grade_1                         48.0 55.0                       103.0                         48 55                 103
1919006 1919006 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_1                         24.0 31.0                       55.0                         24 31                 55
1919013 1919013 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_1                         55.0 38.0                       93.0                         55 38                 93
1919030 1919030 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2021   grade_1                         56.0 41.0                       97.0                         56 41                 97
1919041 1919041 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2021   grade_1                         39.0 42.0                       81.0                         39 42                 81
1919048 1919048 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2021   grade_1                         32.0 24.0                       56.0                         32 24                 56
1919055 1919055 IN     school 1800030 125   MSD Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2021   grade_1                         80.0 72.0                       152.0                         80 72                 152
1919062 1919062 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2021   grade_1                         20.0 10.0                       30.0                         20 10                 30
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
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
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
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
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
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
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
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
1919197 1919197 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2021   grade_1                         44.0 35.0                       79.0                         44 35                 79
1919205 1919205 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2021   grade_1                         41.0 51.0                       92.0                         41 51                 92
1919213 1919213 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_1                         21.0 23.0                       44.0                         21 23                 44
1919221 1919221 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2021   grade_1                         34.0 25.0                       59.0                         34 25                 59
1919232 1919232 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2021   grade_1                         32.0 31.0                       63.0                         32 31                 63
1919240 1919240 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2021   grade_1                         52.0 51.0                       103.0                         52 51                 103
1919247 1919247 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2021   grade_1                         60.0 48.0                       108.0                         60 48                 108
1919255 1919255 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2021   grade_1                         43.0 26.0                       69.0                         43 26                 69
1919263 1919263 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary School   Regular School No Elementary KG 05 2021   grade_1                         37.0 48.0                       85.0                         37 48                 85
1919270 1919270 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No Elementary PK 05 2021   grade_1                         48.0 42.0                       90.0                         48 42                 90
1919283 1919283 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary School   Regular School No Elementary PK 05 2021   grade_1                         47.0 48.0                       95.0                         47 48                 95
1919291 1919291 IN     school 1803630 235   Fort Wayne Community Schools 180363000543 186 Mabel K Holland Elementary School   Regular School No Elementary PK 05 2021   grade_1                         37.0 33.0                       70.0                         37 33                 70
1919299 1919299 IN     school 1803630 235   Fort Wayne Community Schools 180363000532 189 Indian Village Elementary School   Regular School No Elementary PK 05 2021   grade_1                         33.0 29.0                       62.0                         33 29                 62
1919307 1919307 IN     school 1803630 235   Fort Wayne Community Schools 180363000535 193 John S Irwin Elementary School   Regular School No Elementary KG 05 2021   grade_1                         23.0 25.0                       48.0                         23 25                 48
1919314 1919314 IN     school 1803630 235   Fort Wayne Community Schools 180363000541 197 Lindley Elementary School   Regular School No Elementary PK 05 2021   grade_1                         28.0 23.0                       51.0                         28 23                 51
1919322 1919322 IN     school 1803630 235   Fort Wayne Community Schools 180363000544 205 Maplewood Elementary School   Regular School No Elementary PK 05 2021   grade_1                         45.0 30.0                       75.0                         45 30                 75
1919330 1919330 IN     school 1803630 235   Fort Wayne Community Schools 180363000572 209 Willard Shambaugh Elementary Sch   Regular School No Elementary KG 05 2021   grade_1                         35.0 30.0                       65.0                         35 30                 65
1919337 1919337 IN     school 1803630 235   Fort Wayne Community Schools 180363000551 217 Northcrest Elementary School   Regular School No Elementary PK 05 2021   grade_1                         40.0 32.0                       72.0                         40 32                 72
1919350 1919350 IN     school 1803630 235   Fort Wayne Community Schools 180363000524 221 Francis M Price Elementary School   Regular School No Elementary KG 05 2021   grade_1                         31.0 32.0                       63.0                         31 32                 63
1919357 1919357 IN     school 1803630 235   Fort Wayne Community Schools 180363000559 233 Saint Joseph Central School   Regular School No Elementary KG 05 2021   grade_1                         34.0 24.0                       58.0                         34 24                 58
1919364 1919364 IN     school 1803630 235   Fort Wayne Community Schools 180363000558 239 Robert C Harris Elementary School   Regular School No Elementary KG 05 2021   grade_1                         23.0 31.0                       54.0                         23 31                 54
1919378 1919378 IN     school 1803630 235   Fort Wayne Community Schools 180363000564 249 Levan R Scott Academy   Regular School No Elementary PK 05 2021   grade_1                         37.0 39.0                       76.0                         37 39                 76
1919386 1919386 IN     school 1803630 235   Fort Wayne Community Schools 180363000563 253 South Wayne Elementary School   Regular School No Elementary PK 05 2021   grade_1                         38.0 30.0                       68.0                         38 30                 68
1919394 1919394 IN     school 1803630 235   Fort Wayne Community Schools 180363000948 257 Study Elementary School   Regular School No Elementary PK 05 2021   grade_1                         22.0 17.0                       39.0                         22 17                 39
1919402 1919402 IN     school 1803630 235   Fort Wayne Community Schools 180363000567 265 Washington Elementary School   Regular School No Elementary PK 05 2021   grade_1                         27.0 9.0                       36.0                         27 9                 36
1919410 1919410 IN     school 1803630 235   Fort Wayne Community Schools 180363000566 269 Washington Center Elementary Sch   Regular School No Elementary PK 05 2021   grade_1                         57.0 35.0                       92.0                         57 35                 92
1919418 1919418 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_1                         48.0 68.0                       116.0                         48 68                 116
1919425 1919425 IN     school 1803630 235   Fort Wayne Community Schools 180363000569 273 Waynedale Elementary School   Regular School No Elementary PK 05 2021   grade_1                         36.0 31.0                       67.0                         36 31                 67
1919433 1919433 IN     school 1803630 235   Fort Wayne Community Schools 180363000514 275 Arlington Elementary School   Regular School No Elementary KG 05 2021   grade_1                         35.0 30.0                       65.0                         35 30                 65
1919465 1919465 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2021   grade_1                         70.0 74.0                       144.0                         70 74                 144

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