enrollments

Data source: Big Local News · About: Big Local

3,530 rows where grade = "grade_7" and state = "IN" sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,430 ✖
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
1763250 1763250 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2019   grade_7                         7.0 0.0                       7.0                         7 0                 7
1789357 1789357 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Other 04 11 2018   grade_7                         201.0 176.0                       377.0                         201 176                 377
1790916 1790916 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Middle 04 08 2018   grade_7                         96.0 85.0                       181.0                         96 85                 181
1791100 1791100 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No Middle 04 08 2018   grade_7                         48.0 43.0                       91.0                         48 43                 91
1796546 1796546 IN     school 1810290 7205   South Bend Community School Corp 181029002296 7521 Brown Intermediate Center   Regular School No Middle 04 08 2018   grade_7                         37.0 54.0                       91.0                         37 54                 91
1798996 1798996 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2018   grade_7                         19.0 0.0                       19.0                         19 0                 19
1910623 1910623 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2020   grade_7                         101.0 92.0                       193.0                         101 92                 193
1910808 1910808 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No Middle 04 08 2020   grade_7                         34.0 37.0                       71.0                         34 37                 71
1918712 1918712 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2020   grade_7                         13.0 0.0                       13.0                         13 0                 13
1920986 1920986 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Middle 04 08 2021   grade_7                         0.0 1.0                       1.0                         0 1                 1
1922575 1922575 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2021   grade_7                         101.0 97.0                       198.0                         101 97                 198
1922767 1922767 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No Middle 04 08 2021   grade_7                         45.0 37.0                       82.0                         45 37                 82
1923184 1923184 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 04 08 2021   grade_7                         126.0 117.0                       243.0                         126 117                 243
1930700 1930700 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2021   grade_7                         5.0 0.0                       5.0                         5 0                 5
1159486 1159486 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2015   grade_7                         49.0 66.0                       115.0                         49 66                 115
1160268 1160268 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No 2.0 05 08 2015   grade_7                         125.0 141.0                       266.0                         125 141                 266
1160555 1160555 IN     school 1801920 1000   Clarksville Com School Corp 180192000248 851 Clarksville Middle School   Regular School No 2.0 05 08 2015   grade_7                         57.0 54.0                       111.0                         57 54                 111
1161392 1161392 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001391 1549 Dubois Middle School   Regular School No 2.0 05 08 2015   grade_7                         34.0 45.0                       79.0                         34 45                 79
1161917 1161917 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002057 1931 Highland Hills Middle School   Regular School No 2.0 05 08 2015   grade_7                         211.0 184.0                       395.0                         211 184                 395
1161922 1161922 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No 2.0 05 08 2015   grade_7                         113.0 133.0                       246.0                         113 133                 246
1161927 1161927 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001276 1937 Nathaniel Scribner Middle School   Regular School No 2.0 05 08 2015   grade_7                         102.0 94.0                       196.0                         102 94                 196
1162047 1162047 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000589 2123 Brookville Middle Sch   Regular School No 2.0 05 08 2015   grade_7                         56.0 59.0                       115.0                         56 59                 115
1162324 1162324 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No 2.0 05 08 2015   grade_7                         55.0 41.0                       96.0                         55 41                 96
1164283 1164283 IN     school 1809300 4515   Prairie Heights Com Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No 2.0 05 08 2015   grade_7                         56.0 60.0                       116.0                         56 60                 116
1164461 1164461 IN     school 1805450 4615   Lake Central School Corp 180545000985 3831 Michael Grimmer Middle School   Regular School No 2.0 05 08 2015   grade_7                         110.0 115.0                       225.0                         110 115                 225
1164479 1164479 IN     school 1805450 4615   Lake Central School Corp 180545002420 3838 Hal E Clark Middle School   Regular School No 2.0 05 08 2015   grade_7                         153.0 120.0                       273.0                         153 120                 273
1164497 1164497 IN     school 1805450 4615   Lake Central School Corp 180545000982 3841 Kahler Middle School   Regular School No 2.0 05 08 2015   grade_7                         137.0 121.0                       258.0                         137 121                 258
1164544 1164544 IN     school 1811460 4645   Tri-Creek School Corporation 181146001851 3851 Lowell Middle School   Regular School No 2.0 05 08 2015   grade_7                         116.0 143.0                       259.0                         116 143                 259
1164808 1164808 IN     school 1803870 4690   Gary Community School Corp 180387002199 4168 Wm A Wirt/Emerson VPA   Regular School No 4.0 05 12 2015   grade_7                         35.0 48.0                       83.0                         35 48                 83
1166990 1166990 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001070 6001 Loogootee Middle School   Regular School No 2.0 05 08 2015   grade_7                         38.0 37.0                       75.0                         38 37                 75
1167626 1167626 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No 2.0 05 08 2015   grade_7                         97.0 91.0                       188.0                         97 91                 188
1168315 1168315 IN     school 1802220 6750   Cloverdale Community Schools 180222001283 7085 Cloverdale Middle School   Regular School No 2.0 05 08 2015   grade_7                         44.0 53.0                       97.0                         44 53                 97
1168753 1168753 IN     school 1810290 7205   South Bend Community Sch Corp 181029001656 7321 Greene Intermediate Center   Regular School No 2.0 05 08 2015   grade_7                         30.0 28.0                       58.0                         30 28                 58
1168769 1168769 IN     school 1810290 7205   South Bend Community Sch Corp 181029001650 7425 Clay Intermediate Center   Regular School No 2.0 05 08 2015   grade_7                         65.0 59.0                       124.0                         65 59                 124
1168792 1168792 IN     school 1810290 7205   South Bend Community Sch Corp 181029001645 7510 Jackson Intermediate Center   Regular School No 2.0 05 08 2015   grade_7                         64.0 65.0                       129.0                         64 65                 129
1168797 1168797 IN     school 1810290 7205   South Bend Community Sch Corp 181029001709 7512 LaSalle Intermediate Academy   Regular School No 2.0 05 08 2015   grade_7                         93.0 102.0                       195.0                         93 102                 195
1168835 1168835 IN     school 1810290 7205   South Bend Community Sch Corp 181029001681 7537 Edison Intermediate Center   Regular School No 2.0 05 08 2015   grade_7                         65.0 46.0                       111.0                         65 46                 111
1168853 1168853 IN     school 1810290 7205   South Bend Community Sch Corp 181029001682 7549 Jefferson Intermediate Center   Regular School No 2.0 05 08 2015   grade_7                         80.0 67.0                       147.0                         80 67                 147
1168866 1168866 IN     school 1810290 7205   South Bend Community Sch Corp 181029001661 7559 Dickinson Fine Arts Academy   Regular School No 2.0 05 08 2015   grade_7                         95.0 72.0                       167.0                         95 72                 167
1168896 1168896 IN     school 1810290 7205   South Bend Community Sch Corp 181029001666 7581 Marshall Intermediate Center   Regular School No 2.0 05 08 2015   grade_7                         65.0 44.0                       109.0                         65 44                 109
1168919 1168919 IN     school 1810290 7205   South Bend Community Sch Corp 181029001679 7597 Navarre Intermediate Center   Regular School No 2.0 05 08 2015   grade_7                         88.0 69.0                       157.0                         88 69                 157
1169072 1169072 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No 2.0 05 08 2015   grade_7                         60.0 58.0                       118.0                         60 58                 118
1169271 1169271 IN     school 1803780 7605   Fremont Community Schools 180378000177 7884 Fremont Middle School   Regular School No 2.0 05 08 2015   grade_7                         34.0 45.0                       79.0                         34 45                 79
1170189 1170189 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No 2.0 05 08 2015   grade_7                         47.0 46.0                       93.0                         47 46                 93
1170363 1170363 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle Sch   Regular School No 2.0 05 08 2015   grade_7                         74.0 57.0                       131.0                         74 57                 131
1170458 1170458 IN     school 1809510 8385   Richmond Community Schools 180951001561 8997 Test Intermediate School   Regular School No 2.0 05 08 2015   grade_7                         93.0 74.0                       167.0                         93 74                 167
1170463 1170463 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No 2.0 05 08 2015   grade_7                         79.0 83.0                       162.0                         79 83                 162
1170568 1170568 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle Sch   Regular School No 2.0 05 08 2015   grade_7                         53.0 59.0                       112.0                         53 59                 112
1170920 1170920 IN     school 1800028 9400   KIPP Indpls College Preparatory 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes 2.0 05 08 2015   grade_7                         48.0 58.0                       106.0                         48 58                 106
1171241 1171241 IN     school 1800128 9745   Tindley Preparatory Academy 180012802545 5336 Tindley Preparatory Academy   Regular School Yes 2.0 05 08 2015   grade_7                         95.0 0.0                       95.0                         95 0                 95
1171412 1171412 IN     school 1800101 9880   Career Academy at South Bend 180010102521 7564 Career Academy at South Bend   Regular School Yes 4.0 05 12 2015   grade_7                         39.0 31.0                       70.0                         39 31                 70
1171497 1171497 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2015   grade_7                         0.0 106.0                       106.0                         0 106                 106
1280876 1280876 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2016   grade_7                         53.0 70.0                       123.0                         53 70                 123
1281663 1281663 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No 2.0 05 08 2016   grade_7                         150.0 124.0                       274.0                         150 124                 274
1281950 1281950 IN     school 1801920 1000   Clarksville Com School Corp 180192000248 851 Clarksville Middle School   Regular School No 2.0 05 08 2016   grade_7                         42.0 50.0                       92.0                         42 50                 92
1282084 1282084 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_7                         3.0 0.0                       3.0                         3 0                 3
1282795 1282795 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001391 1549 Dubois Middle School   Regular School No 2.0 05 08 2016   grade_7                         39.0 26.0                       65.0                         39 26                 65
1282976 1282976 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No 2.0 05 09 2016   grade_7                         190.0 187.0                       377.0                         190 187                 377
1283006 1283006 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No 2.0 05 09 2016   grade_7                         129.0 98.0                       227.0                         129 98                 227
1283328 1283328 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002057 1931 Highland Hills Middle School   Regular School No 2.0 05 08 2016   grade_7                         218.0 185.0                       403.0                         218 185                 403
1283333 1283333 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No 2.0 05 08 2016   grade_7                         114.0 121.0                       235.0                         114 121                 235
1283338 1283338 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001276 1937 Nathaniel Scribner Middle School   Regular School No 2.0 05 08 2016   grade_7                         122.0 93.0                       215.0                         122 93                 215
1283457 1283457 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000589 2123 Brookville Middle Sch   Regular School No 2.0 05 08 2016   grade_7                         57.0 58.0                       115.0                         57 58                 115
1283736 1283736 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No 2.0 05 08 2016   grade_7                         71.0 46.0                       117.0                         71 46                 117
1283880 1283880 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No 2.0 05 08 2016   grade_7                         144.0 127.0                       271.0                         144 127                 271
1285688 1285688 IN     school 1809300 4515   Prairie Heights Com Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No 2.0 05 08 2016   grade_7                         53.0 45.0                       98.0                         53 45                 98
1285848 1285848 IN     school 1805450 4615   Lake Central School Corp 180545000985 3831 Michael Grimmer Middle School   Regular School No 2.0 05 08 2016   grade_7                         131.0 118.0                       249.0                         131 118                 249
1285865 1285865 IN     school 1805450 4615   Lake Central School Corp 180545002420 3838 Hal E Clark Middle School   Regular School No 2.0 05 08 2016   grade_7                         146.0 131.0                       277.0                         146 131                 277
1285883 1285883 IN     school 1805450 4615   Lake Central School Corp 180545000982 3841 Kahler Middle School   Regular School No 2.0 05 08 2016   grade_7                         130.0 106.0                       236.0                         130 106                 236
1285930 1285930 IN     school 1811460 4645   Tri-Creek School Corporation 181146001851 3851 Lowell Middle School   Regular School No 2.0 05 08 2016   grade_7                         142.0 114.0                       256.0                         142 114                 256
1286201 1286201 IN     school 1803870 4690   Gary Community School Corp 180387002199 4168 Wm A Wirt/Emerson VPA   Regular School No 4.0 05 12 2016   grade_7                         30.0 46.0                       76.0                         30 46                 76
1288388 1288388 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001070 6001 Loogootee Middle School   Regular School No 2.0 05 08 2016   grade_7                         39.0 29.0                       68.0                         39 29                 68
1289024 1289024 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No 2.0 05 08 2016   grade_7                         73.0 103.0                       176.0                         73 103                 176
1289707 1289707 IN     school 1802220 6750   Cloverdale Community Schools 180222001283 7085 Cloverdale Middle School   Regular School No 2.0 05 08 2016   grade_7                         43.0 48.0                       91.0                         43 48                 91
1290144 1290144 IN     school 1810290 7205   South Bend Community Sch Corp 181029001656 7321 Greene Intermediate Center   Regular School No 2.0 05 08 2016   grade_7                         30.0 18.0                       48.0                         30 18                 48
1290161 1290161 IN     school 1810290 7205   South Bend Community Sch Corp 181029001650 7425 Clay Intermediate Center   Regular School No 2.0 05 08 2016   grade_7                         50.0 43.0                       93.0                         50 43                 93
1290183 1290183 IN     school 1810290 7205   South Bend Community Sch Corp 181029001645 7510 Jackson Intermediate Center   Regular School No 2.0 05 08 2016   grade_7                         66.0 62.0                       128.0                         66 62                 128
1290188 1290188 IN     school 1810290 7205   South Bend Community Sch Corp 181029001709 7512 LaSalle Intermediate Academy   Regular School No 2.0 05 08 2016   grade_7                         124.0 112.0                       236.0                         124 112                 236
1290221 1290221 IN     school 1810290 7205   South Bend Community Sch Corp 181029001681 7537 Edison Intermediate Center   Regular School No 2.0 05 08 2016   grade_7                         51.0 52.0                       103.0                         51 52                 103
1290239 1290239 IN     school 1810290 7205   South Bend Community Sch Corp 181029001682 7549 Jefferson Intermediate Center   Regular School No 2.0 05 08 2016   grade_7                         78.0 70.0                       148.0                         78 70                 148
1290252 1290252 IN     school 1810290 7205   South Bend Community Sch Corp 181029001661 7559 Dickinson Fine Arts Academy   Regular School No 2.0 05 08 2016   grade_7                         88.0 63.0                       151.0                         88 63                 151
1290283 1290283 IN     school 1810290 7205   South Bend Community Sch Corp 181029001666 7581 Marshall Intermediate Center   Regular School No 2.0 05 08 2016   grade_7                         56.0 49.0                       105.0                         56 49                 105
1290307 1290307 IN     school 1810290 7205   South Bend Community Sch Corp 181029001679 7597 Navarre Intermediate Center   Regular School No 2.0 05 08 2016   grade_7                         79.0 56.0                       135.0                         79 56                 135
1290457 1290457 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No 2.0 05 08 2016   grade_7                         56.0 62.0                       118.0                         56 62                 118
1290654 1290654 IN     school 1803780 7605   Fremont Community Schools 180378000177 7884 Fremont Middle School   Regular School No 2.0 05 08 2016   grade_7                         35.0 23.0                       58.0                         35 23                 58
1291577 1291577 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No 2.0 05 08 2016   grade_7                         57.0 59.0                       116.0                         57 59                 116
1291750 1291750 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No 2.0 05 08 2016   grade_7                         51.0 51.0                       102.0                         51 51                 102
1291845 1291845 IN     school 1809510 8385   Richmond Community Schools 180951001561 8997 Test Intermediate School   Regular School No 2.0 05 08 2016   grade_7                         94.0 73.0                       167.0                         94 73                 167
1291850 1291850 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No 2.0 05 08 2016   grade_7                         83.0 82.0                       165.0                         83 82                 165
1291957 1291957 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle Sch   Regular School No 2.0 05 08 2016   grade_7                         58.0 57.0                       115.0                         58 57                 115
1292288 1292288 IN     school 1800028 9400   KIPP Indpls College Preparatory 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes 2.0 05 08 2016   grade_7                         56.0 58.0                       114.0                         56 58                 114
1292609 1292609 IN     school 1800128 9745   Tindley Preparatory Academy 180012802545 5336 Tindley Preparatory Academy   Regular School Yes 2.0 05 08 2016   grade_7                         62.0 0.0                       62.0                         62 0                 62
1292872 1292872 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2016   grade_7                         0.0 95.0                       95.0                         0 95                 95
1292911 1292911 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes 2.0 05 08 2016   grade_7                         41.0 33.0                       74.0                         41 33                 74
1292939 1292939 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2017   grade_7                         69.0 54.0                       123.0                         69 54                 123
1293712 1293712 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2017   grade_7                         145.0 112.0                       257.0                         145 112                 257
1293718 1293718 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No Middle 05 08 2017   grade_7                         155.0 152.0                       307.0                         155 152                 307
1294008 1294008 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2017   grade_7                         54.0 54.0                       108.0                         54 54                 108
1294831 1294831 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001391 1549 Dubois Middle School   Regular School No Middle 05 08 2017   grade_7                         39.0 33.0                       72.0                         39 33                 72
1295014 1295014 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Other 05 10 2017   grade_7                         173.0 198.0                       371.0                         173 198                 371

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