Data source: Big Local News · About: Big Local

686 rows where grade = "grade_6", state = "IN" and year = 2021 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2021 · 686

grade

  • grade_6 · 686
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
1925549 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_6                         4.0 0.0                       4.0                         4 0                 4
1927140 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_6                         2.0 0.0                       2.0                         2 0                 2
1927212 IN     school   6530   Union Township School Corp   6811 Porter County Education Services             2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1927247 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_6                         3.0 0.0                       3.0                         3 0                 3
1927330 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_6                         6.0 0.0                       6.0                         6 0                 6
1919155 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_6                         41.0 34.0                       75.0                         41 34                 75
1921141 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2021   grade_6                         8.0 2.0                       10.0                         8 2                 10
1924928 IN     school 1802640 5300   MSD Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2021   grade_6                         62.0 61.0                       123.0                         62 61                 123
1924935 IN     school 1802640 5300   MSD Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2021   grade_6                         59.0 62.0                       121.0                         59 62                 121
1924945 IN     school 1802640 5300   MSD Decatur Township 180264000315 5185 Stephen Decatur Elementary School   Regular School No Elementary 01 06 2021   grade_6                         49.0 37.0                       86.0                         49 37                 86
1924952 IN     school 1802640 5300   MSD Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2021   grade_6                         50.0 60.0                       110.0                         50 60                 110
1924965 IN     school 1802640 5300   MSD Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2021   grade_6                         44.0 56.0                       100.0                         44 56                 100
1925039 IN     school 1805670 5330   MSD Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2021   grade_6                         52.0 55.0                       107.0                         52 55                 107
1925046 IN     school 1805670 5330   MSD Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2021   grade_6                         51.0 57.0                       108.0                         51 57                 108
1925056 IN     school 1805670 5330   MSD Lawrence Township 180567001026 5285 Crestview Elementary School   Regular School No Elementary 01 06 2021   grade_6                         62.0 54.0                       116.0                         62 54                 116
1925063 IN     school 1805670 5330   MSD Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No Elementary 01 06 2021   grade_6                         67.0 55.0                       122.0                         67 55                 122
1925070 IN     school 1805670 5330   MSD Lawrence Township 180567001027 5289 Harrison Hill Elementary School   Regular School No Elementary 01 06 2021   grade_6                         65.0 54.0                       119.0                         65 54                 119
1925080 IN     school 1805670 5330   MSD Lawrence Township 180567002278 5293 Indian Creek Elementary School   Regular School No Elementary 01 06 2021   grade_6                         70.0 56.0                       126.0                         70 56                 126
1925096 IN     school 1805670 5330   MSD Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No Elementary 01 06 2021   grade_6                         57.0 52.0                       109.0                         57 52                 109
1925103 IN     school 1805670 5330   MSD Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No Elementary 01 06 2021   grade_6                         46.0 45.0                       91.0                         46 45                 91
1925119 IN     school 1805670 5330   MSD Lawrence Township 180567001066 5299 Sunnyside Elementary School   Regular School No Elementary 01 06 2021   grade_6                         78.0 52.0                       130.0                         78 52                 130
1928011 IN     school 1810290 7205   South Bend Community School Corp 181029002699 7248 South Bend Virtual School   Regular School No Other 01 12 2021   grade_6                         3.0 2.0                       5.0                         3 2                 5
1929814 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2021   grade_6                         10.0 1.0                       11.0                         10 1                 11
1925846 IN     school 1804770 5385   Indianapolis Public Schools 180477002439 5577 Merle Sidener Gifted Academy   Regular School No Middle 02 08 2021   grade_6                         34.0 22.0                       56.0                         34 22                 56
1926296 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary 02 06 2021   grade_6                         80.0 78.0                       158.0                         80 78                 158
1928351 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2021   grade_6                         0.0 3.0                       3.0                         0 3                 3
1928999 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_6                         6.0 2.0                       8.0                         6 2                 8
1930089 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1919443 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2021   grade_6                         104.0 101.0                       205.0                         104 101                 205
1919505 IN     school 1802850 255   East Allen County Schools 180285000350 305 New Haven Intermediate School   Regular School No Elementary 03 06 2021   grade_6                         83.0 72.0                       155.0                         83 72                 155
1919704 IN     school 1800570 515   Blackford County Schools 180057000108 494 Blackford Intermediate School   Regular School No Elementary 03 06 2021   grade_6                         47.0 49.0                       96.0                         47 49                 96
1919969 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 03 12 2021   grade_6                         172.0 138.0                       310.0                         172 138                 310
1920838 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001391 1549 Northeast Dubois Intermediate Scho   Regular School No Elementary 03 06 2021   grade_6                         32.0 32.0                       64.0                         32 32                 64
1920972 IN     school 1800420 2260   Baugo Community Schools 180042002026 1707 Jimtown Intermediate School   Regular School No Elementary 03 06 2021   grade_6                         65.0 75.0                       140.0                         65 75                 140
1921675 IN     school 1806240 2825   Madison-Grant United School Corp 180624001098 2329 Park Elementary School   Regular School No Elementary 03 06 2021   grade_6                         37.0 33.0                       70.0                         37 33                 70
1922847 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1923154 IN     school 1804980 3945   Jay School Corporation 180498000913 3273 East Jay Elementary   Regular School No Elementary 03 06 2021   grade_6                         70.0 58.0                       128.0                         70 58                 128
1923526 IN     school 1807830 4315   North Knox School Corp 180783001335 3545 North Knox Intermediate   Regular School No Elementary 03 06 2021   grade_6                         47.0 41.0                       88.0                         47 41                 88
1923813 IN     school 1805520 4535   Lakeland School Corporation 180552002672 3739 Lakeland Intermediate School   Regular School No Elementary 03 06 2021   grade_6                         68.0 50.0                       118.0                         68 50                 118
1924911 IN     school 1803300 5280   Elwood Community School Corp 180330002309 5151 Elwood Intermediate School   Regular School No Elementary 03 06 2021   grade_6                         41.0 63.0                       104.0                         41 63                 104
1925614 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2021   grade_6                         1.0 1.0                       2.0                         1 1                 2
1926390 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000118 6173 Binford Elementary School   Regular School No Elementary 03 06 2021   grade_6                         76.0 45.0                       121.0                         76 45                 121
1929723 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000215 8983 Centerville-Abington Elem School   Regular School No Elementary 03 06 2021   grade_6                         67.0 81.0                       148.0                         67 81                 148
1929922 IN     school 1811430 8535   Tri-County School Corporation 181143001845 9143 Tri-County Intermediate School   Regular School No Elementary 03 06 2021   grade_6                         22.0 26.0                       48.0                         22 26                 48
1919455 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2021   grade_6                         97.0 100.0                       197.0                         97 100                 197
1920985 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Middle 04 08 2021   grade_6                         199.0 185.0                       384.0                         199 185                 384
1922230 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000699 2577 Maxwell Intermediate School   Regular School No Middle 04 06 2021   grade_6                         94.0 96.0                       190.0                         94 96                 190
1922248 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000695 2593 Greenfield Intermediate School   Regular School No Middle 04 06 2021   grade_6                         74.0 95.0                       169.0                         74 95                 169
1922387 IN     school 1810360 3190   South Harrison Com Schools 181036000385 2663 Corydon Intermediate School   Regular School No Middle 04 06 2021   grade_6                         102.0 57.0                       159.0                         102 57                 159
1922574 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2021   grade_6                         97.0 96.0                       193.0                         97 96                 193
1922766 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No Middle 04 08 2021   grade_6                         50.0 26.0                       76.0                         50 26                 76
1923183 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 04 08 2021   grade_6                         106.0 87.0                       193.0                         106 87                 193
1925011 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375001677 5207 Lillie Idella Kitley Intermediate   Regular School No Middle 04 06 2021   grade_6                         208.0 222.0                       430.0                         208 222                 430
1925601 IN     school 1800450 5380   Beech Grove City Schools 180045000095 5461 South Grove Intermediate School   Regular School No Middle 04 06 2021   grade_6                         111.0 122.0                       233.0                         111 122                 233
1928843 IN     school 1812870 7875   West Lafayette Com School Corp 181287002045 8135 West Lafayette Intermediate School   Regular School No Middle 04 06 2021   grade_6                         91.0 89.0                       180.0                         91 89                 180
1929431 IN     school 1806270 8045   Manchester Community Schools 180627001102 8645 Manchester Intermediate School   Regular School No Middle 04 06 2021   grade_6                         57.0 59.0                       116.0                         57 59                 116
1929459 IN     school 1812180 8050   MSD Wabash County Schools 181218002178 8657 Sharp Creek Elementary School   Regular School No Middle 04 06 2021   grade_6                         40.0 44.0                       84.0                         40 44                 84
1930699 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2021   grade_6                         9.0 0.0                       9.0                         9 0                 9
1919736 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2021   grade_6                         142.0 142.0                       284.0                         142 142                 284
1919742 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No Middle 05 08 2021   grade_6                         160.0 138.0                       298.0                         160 138                 298
1919824 IN     school 1800960 670   Brown County School Corporation 180096002556 571 Brown County Intermediate School   Regular School No Middle 05 06 2021   grade_6                         59.0 66.0                       125.0                         59 66                 125
1920038 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2021   grade_6                         35.0 54.0                       89.0                         35 54                 89
1920823 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2021   grade_6                         1.0 1.0                       2.0                         1 1                 2
1920868 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064002177 1586 Cedar Crest Intermediate School   Regular School No Middle 05 06 2021   grade_6                         38.0 55.0                       93.0                         38 55                 93
1921019 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Middle 05 09 2021   grade_6                         167.0 168.0                       335.0                         167 168                 335
1921365 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002057 1931 Highland Hills Middle School   Regular School No Middle 05 08 2021   grade_6                         194.0 188.0                       382.0                         194 188                 382
1921370 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No Middle 05 08 2021   grade_6                         132.0 96.0                       228.0                         132 96                 228
1921375 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001276 1937 Nathaniel Scribner Middle School   Regular School No Middle 05 08 2021   grade_6                         126.0 128.0                       254.0                         126 128                 254
1921702 IN     school 1806390 2865   Marion Community Schools 180639001115 2350 Justice Thurgood Marshall Intrmd   Regular School No Middle 05 06 2021   grade_6                         142.0 131.0                       273.0                         142 131                 273
1921770 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No Middle 05 08 2021   grade_6                         44.0 42.0                       86.0                         44 42                 86
1921813 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2021   grade_6                         33.0 28.0                       61.0                         33 28                 61
1921879 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No Middle 05 06 2021   grade_6                         264.0 223.0                       487.0                         264 223                 487
1921907 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate School   Regular School No Middle 05 06 2021   grade_6                         219.0 241.0                       460.0                         219 241                 460
1921918 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No Middle 05 08 2021   grade_6                         138.0 168.0                       306.0                         138 168                 306
1921938 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No Middle 05 06 2021   grade_6                         237.0 240.0                       477.0                         237 240                 477
1921954 IN     school 1804260 3025   Hamilton Heights School Corp 180426000727 2501 Hamilton Heights Middle School   Regular School No Middle 05 08 2021   grade_6                         83.0 79.0                       162.0                         83 79                 162
1921959 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1922004 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No Middle 05 06 2021   grade_6                         347.0 312.0                       659.0                         347 312                 659
1922198 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071002659 2543 New Palestine Intermediate School   Regular School No Middle 05 06 2021   grade_6                         137.0 135.0                       272.0                         137 135                 272
1922503 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2021   grade_6                         215.0 202.0                       417.0                         215 202                 417
1922506 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Middle 05 07 2021   grade_6                         208.0 201.0                       409.0                         208 201                 409
1922625 IN     school 1808970 3330   Plainfield Community School Corp 180897002694 3331 Pride Academy   Regular School No Secondary 05 11 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1922789 IN     school 1811250 3460   Taylor Community School Corp 181125001263 2896 Taylor Middle School   Regular School No Middle 05 08 2021   grade_6                         43.0 56.0                       99.0                         43 56                 99
1923123 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No Middle 05 08 2021   grade_6                         63.0 59.0                       122.0                         63 59                 122
1923433 IN     school 1803690 4225   Franklin Community School Corp 180369002440 3458 Custer Baker Intermediate School   Regular School No Middle 05 06 2021   grade_6                         195.0 174.0                       369.0                         195 174                 369
1923755 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2021   grade_6                         56.0 51.0                       107.0                         56 51                 107
1923781 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No Middle 05 06 2021   grade_6                         103.0 92.0                       195.0                         103 92                 195
1923833 IN     school 1804350 4580   Hanover Community School Corp 180435001908 3784 Hanover Central Middle School   Regular School No Middle 05 08 2021   grade_6                         115.0 101.0                       216.0                         115 101                 216
1923875 IN     school 1809690 4600   Merrillville Community School Corp 180969001581 3813 Merrillville Intermediate School   Regular School No Middle 05 06 2021   grade_6                         228.0 230.0                       458.0                         228 230                 458
1923910 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2021   grade_6                         99.0 85.0                       184.0                         99 85                 184
1923927 IN     school 1805450 4615   Lake Central School Corporation 180545002420 3838 Hal E Clark Middle School   Regular School No Middle 05 08 2021   grade_6                         113.0 109.0                       222.0                         113 109                 222
1923946 IN     school 1805450 4615   Lake Central School Corporation 180545000982 3841 Kahler Middle School   Regular School No Middle 05 08 2021   grade_6                         117.0 112.0                       229.0                         117 112                 229
1923991 IN     school 1811460 4645   Tri-Creek School Corporation 181146001851 3851 Lowell Middle School   Regular School No Middle 05 08 2021   grade_6                         113.0 105.0                       218.0                         113 105                 218
1924014 IN     school 1805460 4650   Lake Ridge New Tech Schools 180546000992 3893 Lake Ridge New Tech Middle School   Regular School No Middle 05 08 2021   grade_6                         64.0 60.0                       124.0                         64 60                 124
1924630 IN     school 1805580 4945   LaPorte Community School Corp 180558001012 4717 Kesling Intermediate School   Regular School No Middle 05 06 2021   grade_6                         248.0 208.0                       456.0                         248 208                 456
1924864 IN     school 1800150 5275   Anderson Community School Corp 180015002682 4967 Anderson Intermediate School   Regular School No Middle 05 06 2021   grade_6                         276.0 235.0                       511.0                         276 235                 511
1925317 IN     school 1812360 5360   MSD Warren Township 181236001961 5364 Creston Intermediate & Middle Schl   Regular School No Middle 05 08 2021   grade_6                         157.0 155.0                       312.0                         157 155                 312
1925322 IN     school 1812360 5360   MSD Warren Township 181236001970 5367 Stonybrook Intermediate & Middle   Regular School No Middle 05 08 2021   grade_6                         153.0 116.0                       269.0                         153 116                 269
1925327 IN     school 1812360 5360   MSD Warren Township 181236000229 5368 Raymond Park Intermediate & Middle   Regular School No Middle 05 08 2021   grade_6                         151.0 133.0                       284.0                         151 133                 284
1926157 IN     school 1809060 5485   Plymouth Community School Corp 180906002211 5956 Riverside Intermediate   Regular School No Middle 05 06 2021   grade_6                         140.0 122.0                       262.0                         140 122                 262

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