enrollments

Data source: Big Local News · About: Big Local

11,966 rows where state = "IN" and year = 2020 sorted by grade

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 11,866 ✖
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
1914942 1914942 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2020   adult                         7.0 3.0                       10.0                         7 3                 10
1915099 1915099 IN     school 1801740 6325   Perry Central Com Schools Corp 180174000234 6708 Perry Central Jr-Sr High School   Regular School No High 07 12 2020   adult                         1.0 1.0                       2.0                         1 1                 2
1915107 1915107 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2020   adult                         1.0 0.0                       1.0                         1 0                 1
1915225 1915225 IN     school 1802800 6470   Duneland School Corporation 180280000333 6925 Chesterton Senior High School   Regular School No High 09 12 2020   adult                         2.0 2.0                       4.0                         2 2                 4
1915297 1915297 IN     school 1809180 6520   Porter Township School Corp 180918001521 6838 Boone Grove High School   Regular School No High 09 12 2020   adult                         3.0 6.0                       9.0                         3 6                 9
1915313 1915313 IN     school 1811700 6530   Union Township School Corp 181170001873 6841 Wheeler High School   Regular School No High 09 12 2020   adult                         1.0 0.0                       1.0                         1 0                 1
1915337 1915337 IN     school 1809150 6550   Portage Township Schools 180915001514 6853 Portage High School   Regular School No High 09 12 2020   adult                         13.0 5.0                       18.0                         13 5                 18
1915550 1915550 IN     school 1809360 6630   West Central School Corp 180936001529 7025 West Central Senior High School   Regular School No High 09 12 2020   adult                         2.0 1.0                       3.0                         2 1                 3
1915610 1915610 IN     school 1807980 6715   North Putnam Community Schools 180798001369 7061 North Putnam Sr High School   Regular School No High 09 12 2020   adult                         1.0 0.0                       1.0                         1 0                 1
1915616 1915616 IN     school 1802220 6750   Cloverdale Community Schools 180222000265 7077 Cloverdale High School   Regular School No High 09 12 2020   adult                         1.0 0.0                       1.0                         1 0                 1
1915778 1915778 IN     school 1810530 6865   South Ripley Com Sch Corp 181053001729 7182 South Ripley High School   Regular School No High 09 12 2020   adult                         3.0 0.0                       3.0                         3 0                 3
1915784 1915784 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2020   adult                         2.0 2.0                       4.0                         2 2                 4
1915869 1915869 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High School   Regular School No High 09 12 2020   adult                         2.0 2.0                       4.0                         2 2                 4
1915881 1915881 IN     school 1809120 7150   John Glenn School Corporation 180912001505 7453 John Glenn High School   Regular School No High 09 12 2020   adult                         3.0 1.0                       4.0                         3 1                 4
1915941 1915941 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001451 7353 Penn High School   Regular School No High 09 12 2020   adult                         176.0 314.0                       490.0                         176 314                 490
1916013 1916013 IN     school 1806840 7200   School City of Mishawaka 180684001183 7461 Mishawaka High School   Regular School No High 09 12 2020   adult                         14.0 4.0                       18.0                         14 4                 18
1916257 1916257 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No Prekindergarten PK PK 2020   adult                         34.0 23.0                       57.0                         34 23                 57
1916321 1916321 IN     school 1810020 7255   Scott County School District 2 181002001612 7641 Scottsburg Senior High School   Regular School No High 09 12 2020   adult                         20.0 9.0                       29.0                         20 9                 29
1916378 1916378 IN     school 1808310 7350   Northwestern Con School Corp 180831001423 7689 Triton Central High School   Regular School No High 09 12 2020   adult                         1.0 1.0                       2.0                         1 1                 2
1916534 1916534 IN     school 1808460 7495   Oregon-Davis School Corp 180846001435 7831 Oregon-Davis Jr-Sr High School   Regular School No High 07 12 2020   adult                         0.0 1.0                       1.0                         0 1                 1
1916542 1916542 IN     school 1807800 7515   North Judson-San Pierre Sch Corp 180780001330 7849 N Judson-San Pierre Jr Sr High Sch   Regular School No High 07 12 2020   adult                         1.0 0.0                       1.0                         1 0                 1
1916558 1916558 IN     school 1805340 7525   Knox Community School Corp 180534000938 7833 Knox Community High School   Regular School No High 09 12 2020   adult                         4.0 1.0                       5.0                         4 1                 5
1916576 1916576 IN     school 1803780 7605   Fremont Community Schools 180378000601 7877 Fremont High School   Regular School No High 09 12 2020   adult                         0.0 1.0                       1.0                         0 1                 1
1916593 1916593 IN     school 1804230 7610   Hamilton Community Schools 180423000724 7885 Hamilton Community High School   Regular School No High 07 12 2020   adult                         2.0 1.0                       3.0                         2 1                 3
1916860 1916860 IN     school 1811340 7865   Tippecanoe School Corp 181134001835 8029 William Henry Harrison High School   Regular School No High 09 12 2020   adult                         0.0 1.0                       1.0                         0 1                 1
1917239 1917239 IN     school 1808070 8010   North Vermillion Com Sch Corp 180807001384 8394 North Vermillion High School   Regular School No High 07 12 2020   adult                         1.0 0.0                       1.0                         1 0                 1
1917288 1917288 IN     school 1812090 8030   Vigo County School Corp 181209001917 8441 Terre Haute North Vigo High School   Regular School No High 09 12 2020   adult                         2.0 0.0                       2.0                         2 0                 2
1917504 1917504 IN     school 1812180 8050   M S D Wabash County Schools 181218001945 8651 Northfield Jr-Sr High School   Regular School No High 07 12 2020   adult                         2.0 2.0                       4.0                         2 2                 4
1917546 1917546 IN     school 1812150 8060   Wabash City Schools 181215001940 8693 Wabash High School   Regular School No High 09 12 2020   adult                         1.0 0.0                       1.0                         1 0                 1
1917656 1917656 IN     school 1812390 8130   Warrick County School Corp 181239001975 8789 Boonville High School   Regular School No High 09 12 2020   adult                         4.0 1.0                       5.0                         4 1                 5
1917674 1917674 IN     school 1812390 8130   Warrick County School Corp 181239001977 8809 Castle High School   Regular School No High 09 12 2020   adult                         11.0 2.0                       13.0                         11 2                 13
1917784 1917784 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000217 8981 Centerville Sr High School   Regular School No High 09 12 2020   adult                         0.0 3.0                       3.0                         0 3                 3
1917820 1917820 IN     school 1809510 8385   Richmond Community Schools 180951001566 8993 Richmond High School   Regular School No High 09 12 2020   adult                         7.0 3.0                       10.0                         7 3                 10
1917931 1917931 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000146 9089 Bluffton High School   Regular School No High 09 12 2020   adult                         0.0 1.0                       1.0                         0 1                 1
1917973 1917973 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No High 07 12 2020   adult                         1.0 0.0                       1.0                         1 0                 1
1918027 1918027 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2020   adult                         3.0 0.0                       3.0                         3 0                 3
1918074 1918074 IN     school 1802280 8665   Whitley County Con Schools 180228000267 9187 Columbia City High School   Regular School No High 09 12 2020   adult                         2.0 4.0                       6.0                         2 4                 6
1918129 1918129 IN     school 1800119 8820   Edison Learning Roosevelt 180011900645 4033 Theodore Roosevelt Car & Tech Acad   Regular School No High 07 12 2020   adult                         22.0 14.0                       36.0                         22 14                 36
1918226 1918226 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2020   adult                         6.0 0.0                       6.0                         6 0                 6
1918233 1918233 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2020   adult                         39.0 0.0                       39.0                         39 0                 39
1918542 1918542 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 2020   adult                         11.0 8.0                       19.0                         11 8                 19
1918583 1918583 IN     school 1800038 9620   Burris Laboratory School 180003800185 1441 Burris Laboratory School   Regular School No Other KG 12 2020   adult                         1.0 0.0                       1.0                         1 0                 1
1918687 1918687 IN     school 1800113 9730   Neighbors' New Vistas High School 180011302544 6864 Neighbors' New Vistas High School   Regular School Yes High 09 12 2020   adult                         47.0 43.0                       90.0                         47 43                 90
1918835 1918835 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other 01 12 2020   adult                         0.0 2.0                       2.0                         0 2                 2
1906991 1906991 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   grade_1                         49.0 46.0                       95.0                         49 46                 95
1907014 1907014 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2020   grade_1                         46.0 56.0                       102.0                         46 56                 102
1907032 1907032 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2020   grade_1                         45.0 60.0                       105.0                         45 60                 105
1907040 1907040 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_1                         36.0 22.0                       58.0                         36 22                 58
1907047 1907047 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2020   grade_1                         37.0 46.0                       83.0                         37 46                 83
1907064 1907064 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2020   grade_1                         51.0 48.0                       99.0                         51 48                 99
1907075 1907075 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2020   grade_1                         31.0 38.0                       69.0                         31 38                 69
1907082 1907082 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2020   grade_1                         45.0 33.0                       78.0                         45 33                 78
1907089 1907089 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2020   grade_1                         78.0 55.0                       133.0                         78 55                 133
1907096 1907096 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2020   grade_1                         15.0 23.0                       38.0                         15 23                 38
1907107 1907107 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2020   grade_1                         29.0 22.0                       51.0                         29 22                 51
1907115 1907115 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2020   grade_1                         62.0 38.0                       100.0                         62 38                 100
1907131 1907131 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2020   grade_1                         43.0 57.0                       100.0                         43 57                 100
1907138 1907138 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2020   grade_1                         36.0 41.0                       77.0                         36 41                 77
1907145 1907145 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2020   grade_1                         53.0 33.0                       86.0                         53 33                 86
1907153 1907153 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2020   grade_1                         48.0 69.0                       117.0                         48 69                 117
1907184 1907184 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   grade_1                         37.0 34.0                       71.0                         37 34                 71
1907225 1907225 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2020   grade_1                         63.0 54.0                       117.0                         63 54                 117
1907231 1907231 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2020   grade_1                         37.0 40.0                       77.0                         37 40                 77
1907239 1907239 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2020   grade_1                         37.0 33.0                       70.0                         37 33                 70
1907247 1907247 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2020   grade_1                         21.0 28.0                       49.0                         21 28                 49
1907255 1907255 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2020   grade_1                         28.0 22.0                       50.0                         28 22                 50
1907266 1907266 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2020   grade_1                         29.0 30.0                       59.0                         29 30                 59
1907274 1907274 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2020   grade_1                         57.0 47.0                       104.0                         57 47                 104
1907281 1907281 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2020   grade_1                         46.0 53.0                       99.0                         46 53                 99
1907289 1907289 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2020   grade_1                         31.0 32.0                       63.0                         31 32                 63
1907297 1907297 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary School   Regular School No Elementary KG 05 2020   grade_1                         55.0 50.0                       105.0                         55 50                 105
1907304 1907304 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No Elementary PK 05 2020   grade_1                         51.0 42.0                       93.0                         51 42                 93
1907317 1907317 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary School   Regular School No Elementary PK 05 2020   grade_1                         58.0 38.0                       96.0                         58 38                 96
1907325 1907325 IN     school 1803630 235   Fort Wayne Community Schools 180363000543 186 Mabel K Holland Elementary School   Regular School No Elementary PK 05 2020   grade_1                         40.0 36.0                       76.0                         40 36                 76
1907333 1907333 IN     school 1803630 235   Fort Wayne Community Schools 180363000532 189 Indian Village Elementary School   Regular School No Elementary PK 05 2020   grade_1                         31.0 35.0                       66.0                         31 35                 66
1907341 1907341 IN     school 1803630 235   Fort Wayne Community Schools 180363000535 193 John S Irwin Elementary School   Regular School No Elementary KG 05 2020   grade_1                         25.0 26.0                       51.0                         25 26                 51
1907348 1907348 IN     school 1803630 235   Fort Wayne Community Schools 180363000541 197 Lindley Elementary School   Regular School No Elementary PK 05 2020   grade_1                         28.0 26.0                       54.0                         28 26                 54
1907356 1907356 IN     school 1803630 235   Fort Wayne Community Schools 180363000544 205 Maplewood Elementary School   Regular School No Elementary PK 05 2020   grade_1                         48.0 32.0                       80.0                         48 32                 80
1907364 1907364 IN     school 1803630 235   Fort Wayne Community Schools 180363000572 209 Willard Shambaugh Elementary Sch   Regular School No Elementary KG 05 2020   grade_1                         23.0 25.0                       48.0                         23 25                 48
1907371 1907371 IN     school 1803630 235   Fort Wayne Community Schools 180363000551 217 Northcrest Elementary School   Regular School No Elementary PK 05 2020   grade_1                         30.0 33.0                       63.0                         30 33                 63
1907384 1907384 IN     school 1803630 235   Fort Wayne Community Schools 180363000524 221 Francis M Price Elementary School   Regular School No Elementary PK 05 2020   grade_1                         32.0 42.0                       74.0                         32 42                 74
1907392 1907392 IN     school 1803630 235   Fort Wayne Community Schools 180363000559 233 Saint Joseph Central School   Regular School No Elementary KG 05 2020   grade_1                         34.0 33.0                       67.0                         34 33                 67
1907399 1907399 IN     school 1803630 235   Fort Wayne Community Schools 180363000558 239 Robert C Harris Elementary School   Regular School No Elementary KG 05 2020   grade_1                         34.0 31.0                       65.0                         34 31                 65
1907413 1907413 IN     school 1803630 235   Fort Wayne Community Schools 180363000564 249 Levan R Scott Academy   Regular School No Elementary PK 05 2020   grade_1                         24.0 23.0                       47.0                         24 23                 47
1907421 1907421 IN     school 1803630 235   Fort Wayne Community Schools 180363000563 253 South Wayne Elementary School   Regular School No Elementary PK 05 2020   grade_1                         24.0 31.0                       55.0                         24 31                 55
1907429 1907429 IN     school 1803630 235   Fort Wayne Community Schools 180363000948 257 Study Elementary School   Regular School No Elementary PK 05 2020   grade_1                         19.0 27.0                       46.0                         19 27                 46
1907437 1907437 IN     school 1803630 235   Fort Wayne Community Schools 180363000567 265 Washington Elementary School   Regular School No Elementary PK 05 2020   grade_1                         20.0 13.0                       33.0                         20 13                 33
1907445 1907445 IN     school 1803630 235   Fort Wayne Community Schools 180363000566 269 Washington Center Elementary Sch   Regular School No Elementary KG 05 2020   grade_1                         41.0 39.0                       80.0                         41 39                 80
1907452 1907452 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No Elementary KG 05 2020   grade_1                         44.0 63.0                       107.0                         44 63                 107
1907459 1907459 IN     school 1803630 235   Fort Wayne Community Schools 180363000569 273 Waynedale Elementary School   Regular School No Elementary PK 05 2020   grade_1                         48.0 34.0                       82.0                         48 34                 82
1907467 1907467 IN     school 1803630 235   Fort Wayne Community Schools 180363000514 275 Arlington Elementary School   Regular School No Elementary KG 05 2020   grade_1                         34.0 30.0                       64.0                         34 30                 64
1907499 1907499 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2020   grade_1                         70.0 75.0                       145.0                         70 75                 145
1907504 1907504 IN     school 1802850 255   East Allen County Schools 180285000346 281 Heritage Elementary School   Regular School No Elementary KG 06 2020   grade_1                         44.0 33.0                       77.0                         44 33                 77
1907520 1907520 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary School   Regular School No Elementary KG 03 2020   grade_1                         107.0 106.0                       213.0                         107 106                 213
1907541 1907541 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2020   grade_1                         105.0 83.0                       188.0                         105 83                 188
1907548 1907548 IN     school 1802850 255   East Allen County Schools 180285002514 323 Woodlan Elementary School   Regular School No Elementary KG 06 2020   grade_1                         26.0 35.0                       61.0                         26 35                 61
1907561 1907561 IN     school 1800360 365   Bartholomew Con School Corp 180036002188 328 Clifty Creek Elementary School   Regular School No Elementary PK 06 2020   grade_1                         58.0 36.0                       94.0                         58 36                 94
1907570 1907570 IN     school 1800360 365   Bartholomew Con School Corp 180036002421 346 CSA Lincoln Campus   Regular School No Elementary KG 06 2020   grade_1                         28.0 26.0                       54.0                         28 26                 54
1907578 1907578 IN     school 1800360 365   Bartholomew Con School Corp 180036000075 353 Mount Healthy Elementary School   Regular School No Elementary KG 06 2020   grade_1                         35.0 26.0                       61.0                         35 26                 61
1907588 1907588 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No Elementary PK 06 2020   grade_1                         47.0 52.0                       99.0                         47 52                 99

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