enrollments

Data source: Big Local News · About: Big Local

693 rows where grade = "grade_6", state = "IN" and year = 2018 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 693 ✖

grade ✖

  • grade_6 · 693 ✖
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
1794005 1794005 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_6                         5.0 1.0                       6.0                         5 1                 6
1787493 1787493 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_6                         46.0 40.0                       86.0                         46 40                 86
1789482 1789482 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_6                         4.0 3.0                       7.0                         4 3                 7
1791067 1791067 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary 01 06 2018   grade_6                         25.0 20.0                       45.0                         25 20                 45
1791082 1791082 IN     school 1807440 3445   New Castle Community School Corp 180744001291 2861 Westwood Elementary School   Regular School No Elementary 01 06 2018   grade_6                         22.0 28.0                       50.0                         22 28                 50
1793377 1793377 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2018   grade_6                         51.0 58.0                       109.0                         51 58                 109
1793384 1793384 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2018   grade_6                         58.0 56.0                       114.0                         58 56                 114
1793394 1793394 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2018   grade_6                         50.0 30.0                       80.0                         50 30                 80
1793401 1793401 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2018   grade_6                         60.0 43.0                       103.0                         60 43                 103
1793413 1793413 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2018   grade_6                         49.0 58.0                       107.0                         49 58                 107
1793500 1793500 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2018   grade_6                         65.0 54.0                       119.0                         65 54                 119
1793507 1793507 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2018   grade_6                         63.0 55.0                       118.0                         63 55                 118
1793517 1793517 IN     school 1805670 5330   M S D Lawrence Township 180567001026 5285 Crestview Elementary School   Regular School No Elementary 01 06 2018   grade_6                         47.0 43.0                       90.0                         47 43                 90
1793524 1793524 IN     school 1805670 5330   M S D Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No Elementary 01 06 2018   grade_6                         59.0 74.0                       133.0                         59 74                 133
1793531 1793531 IN     school 1805670 5330   M S D Lawrence Township 180567001027 5289 Harrison Hill Elementary School   Regular School No Elementary 01 06 2018   grade_6                         71.0 63.0                       134.0                         71 63                 134
1793542 1793542 IN     school 1805670 5330   M S D Lawrence Township 180567002278 5293 Indian Creek Elementary School   Regular School No Elementary 01 06 2018   grade_6                         66.0 59.0                       125.0                         66 59                 125
1793557 1793557 IN     school 1805670 5330   M S D Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No Elementary 01 06 2018   grade_6                         59.0 66.0                       125.0                         59 66                 125
1793564 1793564 IN     school 1805670 5330   M S D Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No Elementary 01 06 2018   grade_6                         67.0 56.0                       123.0                         67 56                 123
1793571 1793571 IN     school 1805670 5330   M S D Lawrence Township 180567001034 5298 Skiles Test Elementary School   Regular School No Elementary 01 06 2018   grade_6                         47.0 42.0                       89.0                         47 42                 89
1793578 1793578 IN     school 1805670 5330   M S D Lawrence Township 180567001066 5299 Sunnyside Elementary School   Regular School No Elementary 01 06 2018   grade_6                         74.0 72.0                       146.0                         74 72                 146
1797468 1797468 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2018   grade_6                         8.0 2.0                       10.0                         8 2                 10
1794337 1794337 IN     school 1804770 5385   Indianapolis Public Schools 180477002439 5577 Merle Sidener Gifted Academy   Regular School No Middle 02 08 2018   grade_6                         34.0 24.0                       58.0                         34 24                 58
1796823 1796823 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2018   grade_6                         0.0 1.0                       1.0                         0 1                 1
1787782 1787782 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2018   grade_6                         98.0 93.0                       191.0                         98 93                 191
1789157 1789157 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_6                         6.0 1.0                       7.0                         6 1                 7
1789308 1789308 IN     school 1800420 2260   Baugo Community Schools 180042002026 1707 Jimtown Intermediate School   Regular School No Elementary 03 06 2018   grade_6                         62.0 67.0                       129.0                         62 67                 129
1791183 1791183 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1791544 1791544 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 03 08 2018   grade_6                         112.0 83.0                       195.0                         112 83                 195
1791871 1791871 IN     school 1807830 4315   North Knox School Corp 180783001335 3545 North Knox Intermediate   Regular School No Elementary 03 06 2018   grade_6                         52.0 48.0                       100.0                         52 48                 100
1793283 1793283 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2018   grade_6                         74.0 50.0                       124.0                         74 50                 124
1793359 1793359 IN     school 1803300 5280   Elwood Community School Corp 180330002309 5151 Elwood Intermediate School   Regular School No Elementary 03 06 2018   grade_6                         52.0 54.0                       106.0                         52 54                 106
1794914 1794914 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000118 6173 Binford Elementary School   Regular School No Elementary 03 06 2018   grade_6                         86.0 57.0                       143.0                         86 57                 143
1796424 1796424 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 03 12 2018   grade_6                         3.0 1.0                       4.0                         3 1                 4
1797896 1797896 IN     school 1812180 8050   M S D Wabash County Schools 181218002178 8657 Sharp Creek Elementary School   Regular School No Middle 03 07 2018   grade_6                         46.0 34.0                       80.0                         46 34                 80
1798160 1798160 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000215 8983 Centerville-Abington Elem School   Regular School No Elementary 03 06 2018   grade_6                         68.0 69.0                       137.0                         68 69                 137
1798358 1798358 IN     school 1811430 8535   Tri-County School Corporation 181143001845 9143 Tri-County Intermediate School   Regular School No Elementary 03 06 2018   grade_6                         27.0 21.0                       48.0                         27 21                 48
1787794 1787794 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2018   grade_6                         92.0 112.0                       204.0                         92 112                 204
1788046 1788046 IN     school 1800570 515   Blackford County Schools 180057000108 494 North Side Elementary School   Regular School No Middle 04 06 2018   grade_6                         51.0 53.0                       104.0                         51 53                 104
1789322 1789322 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Middle 04 06 2018   grade_6                         219.0 211.0                       430.0                         219 211                 430
1789356 1789356 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Other 04 11 2018   grade_6                         192.0 189.0                       381.0                         192 189                 381
1790578 1790578 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000699 2577 Maxwell Intermediate School   Regular School No Middle 04 06 2018   grade_6                         70.0 85.0                       155.0                         70 85                 155
1790596 1790596 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000695 2593 Greenfield Intermediate School   Regular School No Middle 04 06 2018   grade_6                         106.0 77.0                       183.0                         106 77                 183
1790736 1790736 IN     school 1810360 3190   South Harrison Com Schools 181036000385 2663 Corydon Intermediate School   Regular School No Middle 04 06 2018   grade_6                         68.0 71.0                       139.0                         68 71                 139
1790915 1790915 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Middle 04 08 2018   grade_6                         90.0 94.0                       184.0                         90 94                 184
1791099 1791099 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No Middle 04 08 2018   grade_6                         59.0 28.0                       87.0                         59 28                 87
1794058 1794058 IN     school 1800450 5380   Beech Grove City Schools 180045000095 5461 South Grove Intermediate School   Regular School No Middle 04 06 2018   grade_6                         127.0 139.0                       266.0                         127 139                 266
1794185 1794185 IN     school 1804770 5385   Indianapolis Public Schools 180477000885 5544 Riverside School 44   Regular School No Middle 04 06 2018   grade_6                         28.0 28.0                       56.0                         28 28                 56
1794313 1794313 IN     school 1804770 5385   Indianapolis Public Schools 180477002442 5569 Joyce Kilmer School 69   Regular School No Middle 04 06 2018   grade_6                         22.0 23.0                       45.0                         22 23                 45
1796545 1796545 IN     school 1810290 7205   South Bend Community School Corp 181029002296 7521 Brown Intermediate Center   Regular School No Middle 04 08 2018   grade_6                         64.0 38.0                       102.0                         64 38                 102
1797321 1797321 IN     school 1812870 7875   West Lafayette Com School Corp 181287002045 8135 West Lafayette Intermediate School   Regular School No Middle 04 06 2018   grade_6                         91.0 91.0                       182.0                         91 91                 182
1797867 1797867 IN     school 1806270 8045   Manchester Community Schools 180627001102 8645 Manchester Intermediate School   Regular School No Middle 04 06 2018   grade_6                         57.0 58.0                       115.0                         57 58                 115
1798995 1798995 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2018   grade_6                         5.0 0.0                       5.0                         5 0                 5
1787311 1787311 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_6                         49.0 51.0                       100.0                         49 51                 100
1788079 1788079 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2018   grade_6                         136.0 117.0                       253.0                         136 117                 253
1788085 1788085 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No Middle 05 08 2018   grade_6                         154.0 136.0                       290.0                         154 136                 290
1788169 1788169 IN     school 1800960 670   Brown County School Corporation 180096002556 571 Brown County Intermediate School   Regular School No Middle 05 06 2018   grade_6                         68.0 75.0                       143.0                         68 75                 143
1788373 1788373 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2018   grade_6                         61.0 36.0                       97.0                         61 36                 97
1788500 1788500 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 05 12 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1789174 1789174 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001391 1549 Dubois Middle School   Regular School No Middle 05 08 2018   grade_6                         32.0 30.0                       62.0                         32 30                 62
1789208 1789208 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064002177 1586 Cedar Crest Intermediate School   Regular School No Middle 05 06 2018   grade_6                         47.0 37.0                       84.0                         47 37                 84
1789574 1789574 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 05 12 2018   grade_6                         264.0 253.0                       517.0                         264 253                 517
1789713 1789713 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002057 1931 Highland Hills Middle School   Regular School No Middle 05 08 2018   grade_6                         222.0 211.0                       433.0                         222 211                 433
1789718 1789718 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No Middle 05 08 2018   grade_6                         140.0 131.0                       271.0                         140 131                 271
1789723 1789723 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001276 1937 Nathaniel Scribner Middle School   Regular School No Middle 05 08 2018   grade_6                         118.0 122.0                       240.0                         118 122                 240
1790054 1790054 IN     school 1806390 2865   Marion Community Schools 180639001115 2350 Justice Thurgood Marshall Intrmd   Regular School No Middle 05 06 2018   grade_6                         122.0 137.0                       259.0                         122 137                 259
1790122 1790122 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No Middle 05 08 2018   grade_6                         38.0 50.0                       88.0                         38 50                 88
1790164 1790164 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2018   grade_6                         28.0 21.0                       49.0                         28 21                 49
1790229 1790229 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No Middle 05 06 2018   grade_6                         253.0 233.0                       486.0                         253 233                 486
1790251 1790251 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate School   Regular School No Middle 05 06 2018   grade_6                         222.0 206.0                       428.0                         222 206                 428
1790262 1790262 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No Middle 05 08 2018   grade_6                         153.0 170.0                       323.0                         153 170                 323
1790281 1790281 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No Middle 05 06 2018   grade_6                         235.0 235.0                       470.0                         235 235                 470
1790303 1790303 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2018   grade_6                         1.0 0.0                       1.0                         1 0                 1
1790348 1790348 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No Middle 05 06 2018   grade_6                         311.0 292.0                       603.0                         311 292                 603
1790845 1790845 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2018   grade_6                         189.0 158.0                       347.0                         189 158                 347
1790848 1790848 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Middle 05 06 2018   grade_6                         198.0 155.0                       353.0                         198 155                 353
1791778 1791778 IN     school 1803690 4225   Franklin Community School Corp 180369002440 3458 Custer Baker Intermediate School   Regular School No Middle 05 06 2018   grade_6                         189.0 196.0                       385.0                         189 196                 385
1792092 1792092 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2018   grade_6                         64.0 42.0                       106.0                         64 42                 106
1792118 1792118 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No Middle 05 06 2018   grade_6                         99.0 97.0                       196.0                         99 97                 196
1792223 1792223 IN     school 1809690 4600   Merrillville Community School Corp 180969001581 3813 Merrillville Intermediate School   Regular School No Middle 05 07 2018   grade_6                         257.0 222.0                       479.0                         257 222                 479
1792259 1792259 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2018   grade_6                         121.0 101.0                       222.0                         121 101                 222
1792276 1792276 IN     school 1805450 4615   Lake Central School Corporation 180545002420 3838 Hal E Clark Middle School   Regular School No Middle 05 08 2018   grade_6                         162.0 122.0                       284.0                         162 122                 284
1792295 1792295 IN     school 1805450 4615   Lake Central School Corporation 180545000982 3841 Kahler Middle School   Regular School No Middle 05 08 2018   grade_6                         126.0 114.0                       240.0                         126 114                 240
1793841 1793841 IN     school 1812360 5360   M S D Warren Township 181236002490 5399 Creston Intermediate Academy   Regular School No Middle 05 06 2018   grade_6                         161.0 147.0                       308.0                         161 147                 308
1793844 1793844 IN     school 1812360 5360   M S D Warren Township 181236002477 5401 Stonybrook Intermediate Academy   Regular School No Middle 05 06 2018   grade_6                         143.0 145.0                       288.0                         143 145                 288
1793847 1793847 IN     school 1812360 5360   M S D Warren Township 181236002479 5402 Raymond Park Intermediate   Regular School No Middle 05 06 2018   grade_6                         166.0 161.0                       327.0                         166 161                 327
1794670 1794670 IN     school 1809060 5485   Plymouth Community School Corp 180906002211 5956 Riverside Intermediate   Regular School No Middle 05 06 2018   grade_6                         143.0 152.0                       295.0                         143 152                 295
1794730 1794730 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001070 6001 Loogootee Middle School   Regular School No Middle 05 08 2018   grade_6                         36.0 23.0                       59.0                         36 23                 59
1794778 1794778 IN     school 1808340 5625   Oak Hill United School Corp 180834001431 2306 Swayzee Elementary School   Regular School No Middle 05 06 2018   grade_6                         73.0 73.0                       146.0                         73 73                 146
1794804 1794804 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No Middle 05 08 2018   grade_6                         2.0 1.0                       3.0                         2 1                 3
1795135 1795135 IN     school 1806510 5925   M S D Martinsville Schools 180651002612 6334 Bell Intermediate Academy   Regular School No Middle 05 06 2018   grade_6                         164.0 166.0                       330.0                         164 166                 330
1795368 1795368 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No Middle 05 08 2018   grade_6                         77.0 99.0                       176.0                         77 99                 176
1795636 1795636 IN     school 1802800 6470   Duneland School Corporation 180280000336 6821 Liberty Intermediate School   Regular School No Middle 05 06 2018   grade_6                         92.0 94.0                       186.0                         92 94                 186
1795651 1795651 IN     school 1802800 6470   Duneland School Corporation 180280000338 6927 Westchester Intermediate School   Regular School No Middle 05 06 2018   grade_6                         145.0 121.0                       266.0                         145 121                 266
1796049 1796049 IN     school 1802220 6750   Cloverdale Community Schools 180222001283 7085 Cloverdale Middle School   Regular School No Middle 05 08 2018   grade_6                         29.0 41.0                       70.0                         29 41                 70
1796231 1796231 IN     school 1806630 6910   Milan Community Schools 180663002636 7212 Milan Intermediate School   Regular School No Middle 05 06 2018   grade_6                         43.0 35.0                       78.0                         43 35                 78
1796486 1796486 IN     school 1810290 7205   South Bend Community School Corp 181029001656 7321 Greene Intermediate Center   Regular School No Middle 05 08 2018   grade_6                         18.0 25.0                       43.0                         18 25                 43
1796502 1796502 IN     school 1810290 7205   South Bend Community School Corp 181029001650 7425 Clay International Academy   Regular School No Middle 05 08 2018   grade_6                         61.0 45.0                       106.0                         61 45                 106
1796524 1796524 IN     school 1810290 7205   South Bend Community School Corp 181029001645 7510 Jackson Middle School   Regular School No Middle 05 08 2018   grade_6                         52.0 56.0                       108.0                         52 56                 108
1796529 1796529 IN     school 1810290 7205   South Bend Community School Corp 181029001709 7512 LaSalle Academy   Regular School No Middle 05 08 2018   grade_6                         115.0 95.0                       210.0                         115 95                 210
1796560 1796560 IN     school 1810290 7205   South Bend Community School Corp 181029001681 7537 Edison Middle School   Regular School No Middle 05 08 2018   grade_6                         64.0 47.0                       111.0                         64 47                 111

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