Data source: Big Local News · About: Big Local

674 rows where grade = "grade_6", state = "IN" and year = 2019 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2019 · 674

grade

  • grade_6 · 674
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
1758215 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_6                         7.0 4.0                       11.0                         7 4                 11
1751749 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_6                         33.0 40.0                       73.0                         33 40                 73
1757586 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2019   grade_6                         52.0 72.0                       124.0                         52 72                 124
1757593 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2019   grade_6                         68.0 52.0                       120.0                         68 52                 120
1757603 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2019   grade_6                         50.0 37.0                       87.0                         50 37                 87
1757610 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2019   grade_6                         52.0 48.0                       100.0                         52 48                 100
1757622 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2019   grade_6                         60.0 50.0                       110.0                         60 50                 110
1757711 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2019   grade_6                         57.0 57.0                       114.0                         57 57                 114
1757718 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2019   grade_6                         60.0 51.0                       111.0                         60 51                 111
1757728 IN     school 1805670 5330   M S D Lawrence Township 180567001026 5285 Crestview Elementary School   Regular School No Elementary 01 06 2019   grade_6                         58.0 43.0                       101.0                         58 43                 101
1757735 IN     school 1805670 5330   M S D Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No Elementary 01 06 2019   grade_6                         66.0 56.0                       122.0                         66 56                 122
1757742 IN     school 1805670 5330   M S D Lawrence Township 180567001027 5289 Harrison Hill Elementary School   Regular School No Elementary 01 06 2019   grade_6                         67.0 65.0                       132.0                         67 65                 132
1757752 IN     school 1805670 5330   M S D Lawrence Township 180567002278 5293 Indian Creek Elementary School   Regular School No Elementary 01 06 2019   grade_6                         66.0 56.0                       122.0                         66 56                 122
1757768 IN     school 1805670 5330   M S D Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No Elementary 01 06 2019   grade_6                         61.0 67.0                       128.0                         61 67                 128
1757775 IN     school 1805670 5330   M S D Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No Elementary 01 06 2019   grade_6                         47.0 47.0                       94.0                         47 47                 94
1757791 IN     school 1805670 5330   M S D Lawrence Township 180567001066 5299 Sunnyside Elementary School   Regular School No Elementary 01 06 2019   grade_6                         67.0 71.0                       138.0                         67 71                 138
1761663 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_6                         7.0 0.0                       7.0                         7 0                 7
1761674 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other 01 12 2019   grade_6                         2.0 0.0                       2.0                         2 0                 2
1753742 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 02 12 2019   grade_6                         5.0 1.0                       6.0                         5 1                 6
1758525 IN     school 1804770 5385   Indianapolis Public Schools 180477002439 5577 Merle Sidener Gifted Academy   Regular School No Middle 02 08 2019   grade_6                         31.0 24.0                       55.0                         31 24                 55
1752037 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2019   grade_6                         115.0 102.0                       217.0                         115 102                 217
1752300 IN     school 1800570 515   Blackford County Schools 180057000108 494 North Side Elementary School   Regular School No Elementary 03 06 2019   grade_6                         45.0 41.0                       86.0                         45 41                 86
1753571 IN     school 1800420 2260   Baugo Community Schools 180042002026 1707 Jimtown Intermediate School   Regular School No Elementary 03 06 2019   grade_6                         81.0 73.0                       154.0                         81 73                 154
1755442 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2019   grade_6                         3.0 2.0                       5.0                         3 2                 5
1756110 IN     school 1807830 4315   North Knox School Corp 180783001335 3545 North Knox Intermediate   Regular School No Elementary 03 06 2019   grade_6                         46.0 57.0                       103.0                         46 57                 103
1757492 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2019   grade_6                         51.0 50.0                       101.0                         51 50                 101
1757569 IN     school 1803300 5280   Elwood Community School Corp 180330002309 5151 Elwood Intermediate School   Regular School No Elementary 03 06 2019   grade_6                         53.0 51.0                       104.0                         53 51                 104
1758280 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2019   grade_6                         8.0 5.0                       13.0                         8 5                 13
1759096 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000118 6173 Binford Elementary School   Regular School No Elementary 03 06 2019   grade_6                         67.0 62.0                       129.0                         67 62                 129
1762376 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000215 8983 Centerville-Abington Elem School   Regular School No Elementary 03 06 2019   grade_6                         67.0 64.0                       131.0                         67 64                 131
1762577 IN     school 1811430 8535   Tri-County School Corporation 181143001845 9143 Tri-County Intermediate School   Regular School No Elementary 03 06 2019   grade_6                         28.0 26.0                       54.0                         28 26                 54
1752049 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2019   grade_6                         99.0 105.0                       204.0                         99 105                 204
1752564 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Middle 04 08 2019   grade_6                         169.0 160.0                       329.0                         169 160                 329
1753417 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_6                         4.0 0.0                       4.0                         4 0                 4
1753585 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Middle 04 06 2019   grade_6                         239.0 201.0                       440.0                         239 201                 440
1753630 IN     school 1806600 2275   Middlebury Community Schools 180660002427 1731 Heritage Intermediate School   Regular School No Middle 04 06 2019   grade_6                         2.0 0.0                       2.0                         2 0                 2
1754835 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000699 2577 Maxwell Intermediate School   Regular School No Middle 04 06 2019   grade_6                         80.0 86.0                       166.0                         80 86                 166
1754852 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000695 2593 Greenfield Intermediate School   Regular School No Middle 04 06 2019   grade_6                         90.0 86.0                       176.0                         90 86                 176
1754991 IN     school 1810360 3190   South Harrison Com Schools 181036000385 2663 Corydon Intermediate School   Regular School No Middle 04 06 2019   grade_6                         84.0 76.0                       160.0                         84 76                 160
1755111 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Middle 04 06 2019   grade_6                         187.0 201.0                       388.0                         187 201                 388
1755176 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2019   grade_6                         103.0 92.0                       195.0                         103 92                 195
1755359 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No Middle 04 08 2019   grade_6                         35.0 38.0                       73.0                         35 38                 73
1756018 IN     school 1803690 4225   Franklin Community School Corp 180369002440 3458 Custer Baker Intermediate School   Regular School No Middle 04 06 2019   grade_6                         170.0 194.0                       364.0                         170 194                 364
1758268 IN     school 1800450 5380   Beech Grove City Schools 180045000095 5461 South Grove Intermediate School   Regular School No Middle 04 06 2019   grade_6                         113.0 125.0                       238.0                         113 125                 238
1760615 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 04 12 2019   grade_6                         1.0 0.0                       1.0                         1 0                 1
1761505 IN     school 1812870 7875   West Lafayette Com School Corp 181287002045 8135 West Lafayette Intermediate School   Regular School No Middle 04 06 2019   grade_6                         85.0 99.0                       184.0                         85 99                 184
1762085 IN     school 1806270 8045   Manchester Community Schools 180627001102 8645 Manchester Intermediate School   Regular School No Middle 04 06 2019   grade_6                         64.0 64.0                       128.0                         64 64                 128
1762113 IN     school 1812180 8050   M S D Wabash County Schools 181218002178 8657 Sharp Creek Elementary School   Regular School No Middle 04 06 2019   grade_6                         44.0 40.0                       84.0                         44 40                 84
1763249 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2019   grade_6                         14.0 0.0                       14.0                         14 0                 14
1752332 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2019   grade_6                         127.0 139.0                       266.0                         127 139                 266
1752338 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No Middle 05 08 2019   grade_6                         148.0 140.0                       288.0                         148 140                 288
1752421 IN     school 1800960 670   Brown County School Corporation 180096002556 571 Brown County Intermediate School   Regular School No Middle 05 06 2019   grade_6                         66.0 62.0                       128.0                         66 62                 128
1752634 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2019   grade_6                         47.0 62.0                       109.0                         47 62                 109
1753434 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001391 1549 Dubois Middle School   Regular School No Middle 05 08 2019   grade_6                         32.0 32.0                       64.0                         32 32                 64
1753468 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064002177 1586 Cedar Crest Intermediate School   Regular School No Middle 05 06 2019   grade_6                         67.0 49.0                       116.0                         67 49                 116
1753836 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No High 05 12 2019   grade_6                         268.0 271.0                       539.0                         268 271                 539
1753977 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002057 1931 Highland Hills Middle School   Regular School No Middle 05 08 2019   grade_6                         224.0 193.0                       417.0                         224 193                 417
1753982 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No Middle 05 08 2019   grade_6                         123.0 126.0                       249.0                         123 126                 249
1753987 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001276 1937 Nathaniel Scribner Middle School   Regular School No Middle 05 08 2019   grade_6                         115.0 110.0                       225.0                         115 110                 225
1754319 IN     school 1806390 2865   Marion Community Schools 180639001115 2350 Justice Thurgood Marshall Intrmd   Regular School No Middle 05 06 2019   grade_6                         171.0 130.0                       301.0                         171 130                 301
1754386 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No Middle 05 08 2019   grade_6                         51.0 41.0                       92.0                         51 41                 92
1754427 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2019   grade_6                         16.0 33.0                       49.0                         16 33                 49
1754490 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No Middle 05 06 2019   grade_6                         258.0 232.0                       490.0                         258 232                 490
1754511 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate School   Regular School No Middle 05 06 2019   grade_6                         227.0 257.0                       484.0                         227 257                 484
1754522 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No Middle 05 08 2019   grade_6                         153.0 147.0                       300.0                         153 147                 300
1754541 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No Middle 05 06 2019   grade_6                         227.0 230.0                       457.0                         227 230                 457
1754563 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2019   grade_6                         2.0 0.0                       2.0                         2 0                 2
1754608 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No Middle 05 06 2019   grade_6                         319.0 300.0                       619.0                         319 300                 619
1754803 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071002659 2543 New Palestine Intermediate School   Regular School No Middle 05 06 2019   grade_6                         146.0 131.0                       277.0                         146 131                 277
1755107 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2019   grade_6                         191.0 187.0                       378.0                         191 187                 378
1755719 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No Middle 05 08 2019   grade_6                         80.0 60.0                       140.0                         80 60                 140
1755781 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 05 08 2019   grade_6                         109.0 78.0                       187.0                         109 78                 187
1756330 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2019   grade_6                         47.0 52.0                       99.0                         47 52                 99
1756356 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No Middle 05 06 2019   grade_6                         103.0 93.0                       196.0                         103 93                 196
1756418 IN     school 1804350 4580   Hanover Community School Corp 180435001908 3784 Hanover Central Middle School   Regular School No Middle 05 08 2019   grade_6                         103.0 84.0                       187.0                         103 84                 187
1756459 IN     school 1809690 4600   Merrillville Community School Corp 180969001581 3813 Merrillville Intermediate School   Regular School No Middle 05 06 2019   grade_6                         234.0 240.0                       474.0                         234 240                 474
1756494 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2019   grade_6                         101.0 105.0                       206.0                         101 105                 206
1756511 IN     school 1805450 4615   Lake Central School Corporation 180545002420 3838 Hal E Clark Middle School   Regular School No Middle 05 08 2019   grade_6                         148.0 134.0                       282.0                         148 134                 282
1756530 IN     school 1805450 4615   Lake Central School Corporation 180545000982 3841 Kahler Middle School   Regular School No Middle 05 08 2019   grade_6                         135.0 124.0                       259.0                         135 124                 259
1758052 IN     school 1812360 5360   M S D Warren Township 181236002490 5399 Creston Intermediate Academy   Regular School No Middle 05 06 2019   grade_6                         148.0 137.0                       285.0                         148 137                 285
1758055 IN     school 1812360 5360   M S D Warren Township 181236002477 5401 Stonybrook Intermediate Academy   Regular School No Middle 05 06 2019   grade_6                         153.0 157.0                       310.0                         153 157                 310
1758058 IN     school 1812360 5360   M S D Warren Township 181236002479 5402 Raymond Park Intermediate   Regular School No Middle 05 06 2019   grade_6                         173.0 140.0                       313.0                         173 140                 313
1758380 IN     school 1804770 5385   Indianapolis Public Schools 180477000885 5544 Riverside School 44   Regular School No Middle 05 06 2019   grade_6                         35.0 31.0                       66.0                         35 31                 66
1758501 IN     school 1804770 5385   Indianapolis Public Schools 180477002442 5569 Joyce Kilmer School 69   Regular School No Middle 05 06 2019   grade_6                         25.0 17.0                       42.0                         25 17                 42
1758856 IN     school 1809060 5485   Plymouth Community School Corp 180906002211 5956 Riverside Intermediate   Regular School No Middle 05 06 2019   grade_6                         134.0 128.0                       262.0                         134 128                 262
1758918 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001070 6001 Loogootee Middle School   Regular School No Middle 05 08 2019   grade_6                         35.0 38.0                       73.0                         35 38                 73
1758966 IN     school 1808340 5625   Oak Hill United School Corp 180834001431 2306 Swayzee Elementary School   Regular School No Middle 05 07 2019   grade_6                         76.0 72.0                       148.0                         76 72                 148
1758993 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No Middle 05 08 2019   grade_6                         3.0 0.0                       3.0                         3 0                 3
1759319 IN     school 1806510 5925   M S D Martinsville Schools 180651002612 6334 Bell Intermediate Academy   Regular School No Middle 05 06 2019   grade_6                         167.0 175.0                       342.0                         167 175                 342
1759543 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No Middle 05 08 2019   grade_6                         102.0 89.0                       191.0                         102 89                 191
1759808 IN     school 1802800 6470   Duneland School Corporation 180280000336 6821 Liberty Intermediate School   Regular School No Middle 05 06 2019   grade_6                         97.0 93.0                       190.0                         97 93                 190
1759823 IN     school 1802800 6470   Duneland School Corporation 180280000338 6927 Westchester Intermediate School   Regular School No Middle 05 06 2019   grade_6                         123.0 140.0                       263.0                         123 140                 263
1760219 IN     school 1802220 6750   Cloverdale Community Schools 180222001283 7085 Cloverdale Middle School   Regular School No Middle 05 08 2019   grade_6                         45.0 41.0                       86.0                         45 41                 86
1760423 IN     school 1806630 6910   Milan Community Schools 180663002636 7212 Milan Intermediate School   Regular School No Middle 05 06 2019   grade_6                         45.0 42.0                       87.0                         45 42                 87
1760983 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No Middle 05 08 2019   grade_6                         65.0 53.0                       118.0                         65 53                 118
1761157 IN     school 1805340 7525   Knox Community School Corp 180534000939 7837 Knox Community Middle School   Regular School No Middle 05 08 2019   grade_6                         85.0 60.0                       145.0                         85 60                 145
1761180 IN     school 1803780 7605   Fremont Community Schools 180378000177 7884 Fremont Middle School   Regular School No Middle 05 08 2019   grade_6                         38.0 42.0                       80.0                         38 42                 80
1761329 IN     school 1805400 7855   Lafayette School Corporation 180540000974 8073 Lafayette Sunnyside Intermediate   Regular School No Middle 05 06 2019   grade_6                         325.0 298.0                       623.0                         325 298                 623
1762134 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No Middle 05 08 2019   grade_6                         66.0 61.0                       127.0                         66 61                 127
1762311 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No Middle 05 08 2019   grade_6                         69.0 52.0                       121.0                         69 52                 121

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