enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
1162063 1162063 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   grade_7                         21.0 12.0                       33.0                         21 12                 33
1162074 1162074 IN     school 1809630 2645   Rochester Community Sch Corp 180963001577 2177 Rochester Community Md Sch   Regular School No 2.0 06 08 2015   grade_7                         67.0 73.0                       140.0                         67 73                 140
1162097 1162097 IN     school 1801410 2650   Caston School Corporation 180141000207 2159 Caston Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         27.0 31.0                       58.0                         27 31                 58
1162109 1162109 IN     school 1802940 2725   East Gibson School Corporation 180294000622 2194 Waldo J Wood Memorial JHS   Regular School No 2.0 07 08 2015   grade_7                         33.0 29.0                       62.0                         33 29                 62
1162141 1162141 IN     school 1807770 2735   North Gibson School Corp 180777001327 2225 Princeton Community Middle   Regular School No 2.0 06 08 2015   grade_7                         98.0 69.0                       167.0                         98 69                 167
1162160 1162160 IN     school 1810350 2765   South Gibson School Corp 181035001689 2205 Haubstadt Community School   Regular School No 1.0 KG 08 2015   grade_7                         18.0 27.0                       45.0                         18 27                 45
1162175 1162175 IN     school 1810350 2765   South Gibson School Corp 181035002230 2214 Fort Branch Community School   Regular School No 1.0 KG 08 2015   grade_7                         22.0 31.0                       53.0                         22 31                 53
1162185 1162185 IN     school 1810350 2765   South Gibson School Corp 181035001691 2241 Owensville Community School   Regular School No 1.0 KG 08 2015   grade_7                         29.0 20.0                       49.0                         29 20                 49
1162212 1162212 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002273 2299 Eastbrook Junior High School   Regular School No 2.0 07 08 2015   grade_7                         59.0 58.0                       117.0                         59 58                 117
1162220 1162220 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624002279 2328 Madison-Grant Jr High Sch   Regular School No 2.0 07 08 2015   grade_7                         56.0 40.0                       96.0                         56 40                 96
1162246 1162246 IN     school 1806870 2855   Mississinewa Community School Corp 180687001190 2335 R J Baskett Middle School   Regular School No 2.0 06 08 2015   grade_7                         115.0 106.0                       221.0                         115 106                 221
1162266 1162266 IN     school 1806390 2865   Marion Community Schools 180639001112 2357 John L McCulloch Junior High Sch   Regular School No 2.0 07 08 2015   grade_7                         157.0 150.0                       307.0                         157 150                 307
1162306 1162306 IN     school 1800600 2920   Bloomfield School District 180060000113 2419 Bloomfield Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_7                         35.0 39.0                       74.0                         35 39                 74
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
1162334 1162334 IN     school 1805910 2950   Linton-Stockton School Corp 180591002147 2438 Linton-Stockton Jr High Sch   Regular School No 2.0 06 08 2015   grade_7                         57.0 48.0                       105.0                         57 48                 105
1162347 1162347 IN     school 1810110 2960   M S D Shakamak Schools 181011001623 2445 Shakamak Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         35.0 31.0                       66.0                         35 31                 66
1162363 1162363 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         35.0 31.0                       66.0                         35 31                 66
1162433 1162433 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001245 2476 Fishers Junior High School   Regular School No 2.0 07 08 2015   grade_7                         276.0 276.0                       552.0                         276 276                 552
1162465 1162465 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton Southeastern Jr High Sch   Regular School No 2.0 07 08 2015   grade_7                         317.0 310.0                       627.0                         317 310                 627
1162468 1162468 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002182 2490 Riverside Jr High   Regular School No 2.0 07 08 2015   grade_7                         262.0 227.0                       489.0                         262 227                 489
1162495 1162495 IN     school 1804260 3025   Hamilton Heights School Corp 180426000727 2501 Hamilton Heights Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         85.0 103.0                       188.0                         85 103                 188
1162504 1162504 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No 2.0 06 08 2015   grade_7                         289.0 245.0                       534.0                         289 245                 534
1162570 1162570 IN     school 1806480 3055   Sheridan Community Schools 180648001655 6780 Sheridan Middle School   Regular School No 2.0 06 08 2015   grade_7                         48.0 33.0                       81.0                         48 33                 81
1162579 1162579 IN     school 1801200 3060   Carmel Clay Schools 180120000195 2506 Clay Middle School   Regular School No 2.0 06 08 2015   grade_7                         209.0 196.0                       405.0                         209 196                 405
1162613 1162613 IN     school 1801200 3060   Carmel Clay Schools 180120000194 2511 Carmel Middle School   Regular School No 2.0 06 08 2015   grade_7                         195.0 175.0                       370.0                         195 175                 370
1162655 1162655 IN     school 1801200 3060   Carmel Clay Schools 180120002083 2520 Creekside Middle School   Regular School No 2.0 06 08 2015   grade_7                         255.0 259.0                       514.0                         255 259                 514
1162676 1162676 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 3.0 07 12 2015   grade_7                         4.0 0.0                       4.0                         4 0                 4
1162685 1162685 IN     school 1807650 3070   Noblesville Schools 180765001310 2521 Noblesville East Middle School   Regular School No 2.0 06 08 2015   grade_7                         184.0 179.0                       363.0                         184 179                 363
1162735 1162735 IN     school 1807650 3070   Noblesville Schools 180765000639 2542 Noblesville West Middle School   Regular School No 2.0 06 08 2015   grade_7                         232.0 216.0                       448.0                         232 216                 448
1162769 1162769 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001759 2566 Doe Creek Middle School   Regular School No 2.0 07 08 2015   grade_7                         149.0 134.0                       283.0                         149 134                 283
1162785 1162785 IN     school 1804050 3125   Greenfield-Central Com Schools 180405002476 2579 Greenfield Central Junior High Sch   Regular School No 2.0 07 08 2015   grade_7                         174.0 164.0                       338.0                         174 164                 338
1162826 1162826 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726001222 2559 Mt Vernon Middle School   Regular School No 2.0 06 08 2015   grade_7                         135.0 143.0                       278.0                         135 143                 278
1162850 1162850 IN     school 1803120 3145   Eastern Hancock Co Com Sch Corp 180312000658 2582 Eastern Hancock Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         58.0 56.0                       114.0                         58 56                 114
1162876 1162876 IN     school 1803720 3160   Lanesville Community School Corp 180372000593 2613 Lanesville Jr-Sr HS   Regular School No 3.0 07 12 2015   grade_7                         23.0 34.0                       57.0                         23 34                 57
1162889 1162889 IN     school 1800690 3180   North Harrison Com School Corp 180069000145 2625 North Harrison Middle School   Regular School No 2.0 06 08 2015   grade_7                         60.0 79.0                       139.0                         60 79                 139
1162909 1162909 IN     school 1810360 3190   South Harrison Com Schools 181036002283 2643 Corydon Central Jr High Sch   Regular School No 2.0 07 08 2015   grade_7                         91.0 101.0                       192.0                         91 101                 192
1162953 1162953 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr HS   Regular School No 4.0 06 12 2015   grade_7                         31.0 34.0                       65.0                         31 34                 65
1162958 1162958 IN     school 1808100 3295   North West Hendricks Schools 180810001670 2682 Tri-West Middle School   Regular School No 2.0 06 08 2015   grade_7                         83.0 67.0                       150.0                         83 67                 150
1163007 1163007 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000178 2713 Brownsburg West Middle School   Regular School No 2.0 06 08 2015   grade_7                         167.0 175.0                       342.0                         167 175                 342
1163025 1163025 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102002086 2720 Brownsburg East Middle School   Regular School No 2.0 06 08 2015   grade_7                         166.0 147.0                       313.0                         166 147                 313
1163054 1163054 IN     school 1800270 3315   Avon Community School Corp 180027002450 2730 Avon Middle School North   Regular School No 2.0 07 08 2015   grade_7                         158.0 165.0                       323.0                         158 165                 323
1163076 1163076 IN     school 1800270 3315   Avon Community School Corp 180027002095 2736 Avon Middle School South   Regular School No 2.0 07 08 2015   grade_7                         192.0 181.0                       373.0                         192 181                 373
1163120 1163120 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No 2.0 04 08 2015   grade_7                         110.0 103.0                       213.0                         110 103                 213
1163140 1163140 IN     school 1808970 3330   Plainfield Community Sch Corp 180897002357 2750 Plainfield Com Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         228.0 192.0                       420.0                         228 192                 420
1163182 1163182 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001170 2687 Cascade Middle School   Regular School No 2.0 06 08 2015   grade_7                         59.0 54.0                       113.0                         59 54                 113
1163193 1163193 IN     school 1800660 3405   Blue River Valley Schools 180066000141 2801 Blue River Valley Jr-Sr HS   Regular School No 3.0 07 12 2015   grade_7                         18.0 22.0                       40.0                         18 22                 40
1163210 1163210 IN     school 1810380 3415   South Henry School Corp 181038001702 2773 Tri Junior-Senior High School   Regular School No 3.0 07 12 2015   grade_7                         31.0 32.0                       63.0                         31 32                 63
1163236 1163236 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No 2.0 06 08 2015   grade_7                         56.0 54.0                       110.0                         56 54                 110
1163244 1163244 IN     school 1807440 3445   New Castle Community Sch Corp 180744001288 2829 New Castle Middle School   Regular School No 2.0 07 08 2015   grade_7                         134.0 140.0                       274.0                         134 140                 274
1163277 1163277 IN     school 1807440 3445   New Castle Community Sch Corp 180744001289 2853 Sunnyside Elementary School   Regular School No 1.0 KG 07 2015   grade_7                         0.0 1.0                       1.0                         0 1                 1
1163303 1163303 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No 2.0 04 08 2015   grade_7                         55.0 33.0                       88.0                         55 33                 88
1163327 1163327 IN     school 1811250 3460   Taylor Community School Corp 181125001263 2896 Taylor Middle School   Regular School No 2.0 06 08 2015   grade_7                         50.0 45.0                       95.0                         50 45                 95
1163351 1163351 IN     school 1802040 3470   Northwestern School Corp 180204002334 2907 Northwestern Middle School   Regular School No 2.0 07 08 2015   grade_7                         63.0 89.0                       152.0                         63 89                 152
1163366 1163366 IN     school 1803150 3480   Eastern Howard School Corp 180315000413 2919 Eastern Jr & Sr High School   Regular School No 3.0 07 12 2015   grade_7                         69.0 69.0                       138.0                         69 69                 138
1163377 1163377 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_7                         2.0 2.0                       4.0                         2 2                 4
1163382 1163382 IN     school 1804470 3490   Western School Corp 180447002225 2922 Western Middle School   Regular School No 2.0 06 08 2015   grade_7                         93.0 107.0                       200.0                         93 107                 200
1163417 1163417 IN     school 1805370 3500   Kokomo School Corporation 180537000995 2951 Bon Air Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         58.0 35.0                       93.0                         58 35                 93
1163421 1163421 IN     school 1805370 3500   Kokomo School Corporation 180537000998 2955 Central Middle School   Regular School No 2.0 06 08 2015   grade_7                         82.0 90.0                       172.0                         82 90                 172
1163433 1163433 IN     school 1805370 3500   Kokomo School Corporation 180537001018 2963 Maple Crest Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         78.0 70.0                       148.0                         78 70                 148
1163473 1163473 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000790 3025 Riverview School   Regular School No 2.0 06 08 2015   grade_7                         103.0 119.0                       222.0                         103 119                 222
1163498 1163498 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000784 3061 Crestview Middle School   Regular School No 2.0 06 08 2015   grade_7                         92.0 95.0                       187.0                         92 95                 187
1163533 1163533 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No 4.0 06 12 2015   grade_7                         14.0 6.0                       20.0                         14 6                 20
1163565 1163565 IN     school 1810080 3675   Seymour Community Schools 181008002214 3138 Seymour Middle School   Regular School No 2.0 06 08 2015   grade_7                         183.0 184.0                       367.0                         183 184                 367
1163591 1163591 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         67.0 69.0                       136.0                         67 69                 136
1163611 1163611 IN     school 1812060 3710   Crothersville Community Schools 181206001893 3121 Crothersville Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_7                         22.0 21.0                       43.0                         22 21                 43
1163629 1163629 IN     school 1805280 3785   Kankakee Valley School Corp 180528000934 3183 Kankakee Valley Middle School   Regular School No 2.0 06 08 2015   grade_7                         132.0 136.0                       268.0                         132 136                 268
1163665 1163665 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No 2.0 06 08 2015   grade_7                         66.0 60.0                       126.0                         66 60                 126
1163696 1163696 IN     school 1804980 3945   Jay School Corp 180498000912 3265 East Jay County Middle School   Regular School No 2.0 06 08 2015   grade_7                         97.0 106.0                       203.0                         97 106                 203
1163714 1163714 IN     school 1804980 3945   Jay School Corp 180498000918 3285 West Jay County Middle School   Regular School No 2.0 06 08 2015   grade_7                         43.0 39.0                       82.0                         43 39                 82
1163746 1163746 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No 2.0 06 08 2015   grade_7                         113.0 104.0                       217.0                         113 104                 217
1163785 1163785 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080002547 3343 Southwestern Middle School   Regular School No 2.0 06 08 2015   grade_7                         45.0 46.0                       91.0                         45 46                 91
1163834 1163834 IN     school 1805190 4015   Jennings County Schools 180519000925 3393 Jennings County Middle School   Regular School No 2.0 07 08 2015   grade_7                         176.0 163.0                       339.0                         176 163                 339
1163870 1163870 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000245 3427 Clark Pleasant Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         269.0 223.0                       492.0                         269 223                 492
1163918 1163918 IN     school 1801440 4205   Center Grove Com Sch Corp 180144000210 3441 Center Grove Middle Schl Central   Regular School No 2.0 06 08 2015   grade_7                         158.0 168.0                       326.0                         158 168                 326
1163922 1163922 IN     school 1801440 4205   Center Grove Com Sch Corp 180144001912 3443 Center Grove Middle School North   Regular School No 2.0 06 08 2015   grade_7                         160.0 161.0                       321.0                         160 161                 321
1163938 1163938 IN     school 1803240 4215   Edinburgh Community Sch Corp 180324000213 3449 Edinburgh Comm Middle School   Regular School No 2.0 06 08 2015   grade_7                         31.0 41.0                       72.0                         31 41                 72
1163966 1163966 IN     school 1803690 4225   Franklin Community School Corp 180369000580 3457 Franklin Community Middle School   Regular School No 2.0 07 08 2015   grade_7                         203.0 180.0                       383.0                         203 180                 383
1163998 1163998 IN     school 1804110 4245   Greenwood Community Sch Corp 180411000710 3475 Greenwood Middle School   Regular School No 2.0 06 08 2015   grade_7                         149.0 141.0                       290.0                         149 141                 290
1164040 1164040 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001302 3418 Indian Creek Middle School   Regular School No 2.0 06 08 2015   grade_7                         69.0 80.0                       149.0                         69 80                 149
1164055 1164055 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_7                         54.0 53.0                       107.0                         54 53                 107
1164075 1164075 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No 3.0 07 12 2015   grade_7                         46.0 51.0                       97.0                         46 51                 97
1164092 1164092 IN     school 1812120 4335   Vincennes Community Sch Corp 181212001928 3557 George Rogers Clark Sch   Regular School No 2.0 06 08 2015   grade_7                         99.0 82.0                       181.0                         99 82                 181
1164124 1164124 IN     school 1805550 4345   Wawasee Community School Corp 180555002354 3630 Wawasee Middle School   Regular School No 2.0 06 08 2015   grade_7                         103.0 66.0                       169.0                         103 66                 169
1164133 1164133 IN     school 1805550 4345   Wawasee Community School Corp 180555001001 3635 Milford School   Regular School No 1.0 KG 08 2015   grade_7                         43.0 22.0                       65.0                         43 22                 65
1164158 1164158 IN     school 1812420 4415   Warsaw Community Schools 181242002364 3607 Lakeview Middle School   Regular School No 2.0 07 08 2015   grade_7                         121.0 135.0                       256.0                         121 135                 256
1164191 1164191 IN     school 1812420 4415   Warsaw Community Schools 181242002000 3653 Edgewood Middle School   Regular School No 2.0 07 08 2015   grade_7                         154.0 140.0                       294.0                         154 140                 294
1164246 1164246 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137000397 3619 Tippecanoe Valley Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         84.0 60.0                       144.0                         84 60                 144
1164258 1164258 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         62.0 48.0                       110.0                         62 48                 110
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
1164295 1164295 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_7                         100.0 83.0                       183.0                         100 83                 183
1164341 1164341 IN     school 1805520 4535   Lakeland School Corporation 180552002145 3743 Lakeland Middle School   Regular School No 2.0 06 08 2015   grade_7                         76.0 72.0                       148.0                         76 72                 148
1164361 1164361 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_7                         5.0 2.0                       7.0                         5 2                 7
1164381 1164381 IN     school 1804350 4580   Hanover Community School Corp 180435001908 3784 Hanover Central Middle School   Regular School No 2.0 06 08 2015   grade_7                         79.0 79.0                       158.0                         79 79                 158
1164394 1164394 IN     school 1804620 4590   River Forest Community Sch Corp 180462000781 3791 River Forest Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_7                         48.0 53.0                       101.0                         48 53                 101
1164422 1164422 IN     school 1809690 4600   Merrillville Community School 180969001588 3811 Pierce Middle School   Regular School No 2.0 07 08 2015   grade_7                         259.0 279.0                       538.0                         259 279                 538
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

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