enrollments

Data source: Big Local News · About: Big Local

503 rows where grade = "grade_7", state = "IN" and year = 2015 sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 503 ✖

grade ✖

  • grade_7 · 503 ✖
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
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
1164754 1164754 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No 1.0 KG 07 2015   grade_7                         0.0 47.0                       47.0                         0 47                 47
1169100 1169100 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_7                         0.0 2.0                       2.0                         0 2                 2
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
1159643 1159643 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1160752 1160752 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 07 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1166620 1166620 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George W Carver School 87   Regular School No 1.0 PK 08 2015   grade_7                         1.0 6.0                       7.0                         1 6                 7
1167610 1167610 IN     school 1802970 6060   East Noble School Corp 180297000394 6485 Wayne Center Elem Sch   Regular School No 1.0 PK 07 2015   grade_7                         1.0 1.0                       2.0                         1 1                 2
1168952 1168952 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1170744 1170744 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1160683 1160683 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_7                         10.0 0.0                       10.0                         10 0                 10
1168691 1168691 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_7                         10.0 2.0                       12.0                         10 2                 12
1169697 1169697 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000475 8251 Lincoln School   Regular School No 1.0 KG 08 2015   grade_7                         10.0 8.0                       18.0                         10 8                 18
1170891 1170891 IN     school 1800143 9375   IN Math & Science Academy - South 180014302561 5671 IN Math & Science Academy - South   Regular School Yes 1.0 KG 08 2015   grade_7                         10.0 11.0                       21.0                         10 11                 21
1171061 1171061 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_7                         10.0 8.0                       18.0                         10 8                 18
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
1167695 1167695 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001790 6597 Owen Valley Middle School   Regular School No 2.0 07 08 2015   grade_7                         101.0 97.0                       198.0                         101 97                 198
1169296 1169296 IN     school 1811100 7615   M S D Steuben County 181110001798 7895 Angola Middle School   Regular School No 2.0 06 08 2015   grade_7                         101.0 133.0                       234.0                         101 133                 234
1169792 1169792 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000471 8318 Helfrich Park STEM Academy   Regular School No 2.0 06 08 2015   grade_7                         101.0 83.0                       184.0                         101 83                 184
1161094 1161094 IN     school 1804080 1730   Greensburg Community Schools 180408000705 1269 Greensburg Community Jr High   Regular School No 2.0 06 08 2015   grade_7                         102.0 94.0                       196.0                         102 94                 196
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
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
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
1168098 1168098 IN     school 1811970 6560   Valparaiso Community Schools 181197001890 6887 Thomas Jefferson Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         103.0 100.0                       203.0                         103 100                 203
1159676 1159676 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No 2.0 06 08 2015   grade_7                         104.0 101.0                       205.0                         104 101                 205
1165404 1165404 IN     school 1807860 5075   North Lawrence Com Schools 180786001336 4905 Bedford Middle School   Regular School No 2.0 06 08 2015   grade_7                         104.0 107.0                       211.0                         104 107                 211
1166376 1166376 IN     school 1804770 5385   Indianapolis Public Schools 180477002528 5516 Northwest Community Jr High School   Regular School No 2.0 07 08 2015   grade_7                         104.0 68.0                       172.0                         104 68                 172
1170558 1170558 IN     school 1808220 8435   Northern Wells Com Schools 180822002159 9088 Norwell Middle School   Regular School No 2.0 06 08 2015   grade_7                         104.0 89.0                       193.0                         104 89                 193
1160937 1160937 IN     school 1812450 1405   Washington Com Schools 181245002007 1123 Washington Junior High School   Regular School No 2.0 07 08 2015   grade_7                         105.0 90.0                       195.0                         105 90                 195
1168543 1168543 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         105.0 108.0                       213.0                         105 108                 213
1169580 1169580 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         105.0 86.0                       191.0                         105 86                 191
1169803 1169803 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000486 8323 Thompkins Middle School   Regular School No 2.0 06 08 2015   grade_7                         105.0 113.0                       218.0                         105 113                 218
1166282 1166282 IN     school 1800450 5380   Beech Grove City Schools 180045000092 5453 Beech Grove Middle School   Regular School No 2.0 07 08 2015   grade_7                         106.0 124.0                       230.0                         106 124                 230
1169527 1169527 IN     school 1811340 7865   Tippecanoe School Corp 181134001822 8025 Battle Ground Middle School   Regular School No 2.0 06 08 2015   grade_7                         107.0 104.0                       211.0                         107 104                 211
1170231 1170231 IN     school 1812390 8130   Warrick County School Corp 181239002454 8760 Castle South Middle School   Regular School No 2.0 06 08 2015   grade_7                         107.0 119.0                       226.0                         107 119                 226
1161305 1161305 IN     school 1807320 1970   Muncie Community Schools 180732002320 1431 Northside Middle School   Regular School No 2.0 06 08 2015   grade_7                         108.0 99.0                       207.0                         108 99                 207
1167095 1167095 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001547 6147 Edgewood Junior High School   Regular School No 2.0 06 08 2015   grade_7                         108.0 101.0                       209.0                         108 101                 209
1170272 1170272 IN     school 1812390 8130   Warrick County School Corp 181239001978 8775 Castle North Middle School   Regular School No 2.0 06 08 2015   grade_7                         108.0 142.0                       250.0                         108 142                 250
1159972 1159972 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No 3.0 07 12 2015   grade_7                         109.0 105.0                       214.0                         109 105                 214
1166239 1166239 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_7                         11.0 1.0                       12.0                         11 1                 12
1166504 1166504 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No 1.0 PK 08 2015   grade_7                         11.0 9.0                       20.0                         11 9                 20
1167785 1167785 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2015   grade_7                         11.0 8.0                       19.0                         11 8                 19
1170881 1170881 IN     school 1800017 9370   Fall Creek Academy 180001701788 5870 Fall Creek Academy   Regular School Yes 4.0 06 12 2015   grade_7                         11.0 12.0                       23.0                         11 12                 23
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
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
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
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
1165284 1165284 IN     school 1805580 4945   LaPorte Community School Corp 180558001012 4717 Kesling Middle School   Regular School No 2.0 06 08 2015   grade_7                         113.0 118.0                       231.0                         113 118                 231
1159579 1159579 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         114.0 143.0                       257.0                         114 143                 257
1170639 1170639 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         114.0 84.0                       198.0                         114 84                 198
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
1165200 1165200 IN     school 1806570 4925   Michigan City Area Schools 180657001140 4789 Barker Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         115.0 92.0                       207.0                         115 92                 207
1169839 1169839 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000481 8349 Plaza Park International Prep Acad   Regular School No 2.0 06 08 2015   grade_7                         115.0 99.0                       214.0                         115 99                 214
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
1164867 1164867 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Mdl/High Sch   Regular School No 4.0 06 12 2015   grade_7                         116.0 112.0                       228.0                         116 112                 228
1161697 1161697 IN     school 1803270 2305   Elkhart Community Schools 180327000440 1763 Pierre Moran Middle School   Regular School No 2.0 07 08 2015   grade_7                         117.0 108.0                       225.0                         117 108                 225
1165197 1165197 IN     school 1806570 4925   Michigan City Area Schools 180657001154 4788 Martin T Krueger Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         117.0 107.0                       224.0                         117 107                 224
1159536 1159536 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No 2.0 06 08 2015   grade_7                         118.0 112.0                       230.0                         118 112                 230
1159696 1159696 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No 2.0 06 08 2015   grade_7                         118.0 121.0                       239.0                         118 121                 239
1159700 1159700 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No 2.0 06 08 2015   grade_7                         119.0 117.0                       236.0                         119 117                 236
1170968 1170968 IN     school 1800031 9480   University Heights Preparatory Acd 180003102223 5864 University Heights Preparatory Acd   Regular School Yes 4.0 06 12 2015   grade_7                         12.0 11.0                       23.0                         12 11                 23
1171355 1171355 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes 1.0 KG 08 2015   grade_7                         12.0 12.0                       24.0                         12 12                 24
1171389 1171389 IN     school 1800088 9870   Discovery Charter School 180008802495 6824 Discovery Charter School   Regular School Yes 1.0 KG 08 2015   grade_7                         12.0 18.0                       30.0                         12 18                 30
1171472 1171472 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_7                         12.0 1.0                       13.0                         12 1                 13
1161190 1161190 IN     school 1802660 1875   Delaware Community School Corp 180266000323 1367 Delta Middle School   Regular School No 2.0 06 09 2015   grade_7                         120.0 104.0                       224.0                         120 104                 224
1160511 1160511 IN     school 1809370 940   West Clark Community Schools 180937001537 781 Silver Creek Middle School   Regular School No 2.0 06 08 2015   grade_7                         121.0 108.0                       229.0                         121 108                 229
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
1167165 1167165 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000130 6172 Lora L Batchelor Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         121.0 144.0                       265.0                         121 144                 265
1166001 1166001 IN     school 1808910 5350   M S D Pike Township 180891000513 5380 New Augusta Public Academy-North   Regular School No 2.0 06 08 2015   grade_7                         122.0 146.0                       268.0                         122 146                 268
1168032 1168032 IN     school 1809150 6550   Portage Township Schools 180915001519 6859 William Fegely Middle School   Regular School No 2.0 06 08 2015   grade_7                         123.0 129.0                       252.0                         123 129                 252
1169566 1169566 IN     school 1811340 7865   Tippecanoe School Corp 181134001920 8049 Wea Ridge Middle School   Regular School No 2.0 06 08 2015   grade_7                         123.0 98.0                       221.0                         123 98                 221
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
1161606 1161606 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No 2.0 06 09 2015   grade_7                         129.0 119.0                       248.0                         129 119                 248
1164892 1164892 IN     school 1804320 4710   School City of Hammond 180432000738 4425 Henry W Eggers Elem/Md Sch   Regular School No 2.0 06 08 2015   grade_7                         129.0 112.0                       241.0                         129 112                 241
1166770 1166770 IN     school 1804770 5385   Indianapolis Public Schools 180477002391 5659 Center for Inquiry II   Regular School No 1.0 KG 08 2015   grade_7                         13.0 16.0                       29.0                         13 16                 29
1160263 1160263 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No 1.0 03 08 2015   grade_7                         130.0 94.0                       224.0                         130 94                 224
1160801 1160801 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No 2.0 06 08 2015   grade_7                         130.0 112.0                       242.0                         130 112                 242
1168629 1168629 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876000794 7372 Discovery Middle School   Regular School No 2.0 06 08 2015   grade_7                         130.0 142.0                       272.0                         130 142                 272
1170686 1170686 IN     school 1802280 8665   Whitley Co Cons Schools 180228000824 9180 Indian Springs Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         130.0 151.0                       281.0                         130 151                 281
1161460 1161460 IN     school 1803960 2120   Greater Jasper Con Schs 180396000686 1575 Jasper Middle School   Regular School No 2.0 06 08 2015   grade_7                         131.0 125.0                       256.0                         131 125                 256
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
1167162 1167162 IN     school 1800630 5740   Monroe County Com Sch Corp 180063002232 6170 Tri-North Middle School   Regular School No 2.0 07 08 2015   grade_7                         132.0 124.0                       256.0                         132 124                 256
1165005 1165005 IN     school 1804560 4720   School Town of Highland 180456000764 4283 Highland Middle School   Regular School No 2.0 06 08 2015   grade_7                         133.0 119.0                       252.0                         133 119                 252
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
1159897 1159897 IN     school 1803630 235   Fort Wayne Community Schools 180363000560 240 Shawnee Middle School   Regular School No 2.0 06 08 2015   grade_7                         135.0 147.0                       282.0                         135 147                 282
1161309 1161309 IN     school 1807320 1970   Muncie Community Schools 180732001252 1437 Southside Middle School   Regular School No 2.0 06 08 2015   grade_7                         135.0 98.0                       233.0                         135 98                 233
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
1161694 1161694 IN     school 1803270 2305   Elkhart Community Schools 180327000445 1761 West Side Middle School   Regular School No 2.0 07 08 2015   grade_7                         136.0 148.0                       284.0                         136 148                 284
1166355 1166355 IN     school 1804770 5385   Indianapolis Public Schools 180477002526 5513 George Washington Comm Jr HS   Regular School No 2.0 07 08 2015   grade_7                         136.0 114.0                       250.0                         136 114                 250
1171378 1171378 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2015   grade_7                         136.0 152.0                       288.0                         136 152                 288
1160323 1160323 IN     school 1805790 665   Lebanon Community School Corp 180579001040 557 Lebanon Middle School   Regular School No 2.0 06 08 2015   grade_7                         137.0 119.0                       256.0                         137 119                 256
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
1167231 1167231 IN     school 1800630 5740   Monroe County Com Sch Corp 180063001123 6223 Jackson Creek Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         137.0 156.0                       293.0                         137 156                 293
1165310 1165310 IN     school 1805580 4945   LaPorte Community School Corp 180558001019 4745 Paul F Boston Middle School   Regular School No 2.0 06 08 2015   grade_7                         138.0 106.0                       244.0                         138 106                 244
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
1166451 1166451 IN     school 1804770 5385   Indianapolis Public Schools 180477000817 5546 Daniel Webster School 46   Regular School No 1.0 KG 08 2015   grade_7                         14.0 15.0                       29.0                         14 15                 29
1170837 1170837 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_7                         14.0 6.0                       20.0                         14 6                 20
1171193 1171193 IN     school 1800092 9715   Andrew Academy 180009202493 5785 Andrew Academy   Regular School Yes 1.0 KG 08 2015   grade_7                         14.0 8.0                       22.0                         14 8                 22
1165140 1165140 IN     school 1807560 4805   New Prairie United School Corp 180756001299 7345 New Prairie Middle School   Regular School No 2.0 06 08 2015   grade_7                         140.0 110.0                       250.0                         140 110                 250
1166138 1166138 IN     school 1812720 5370   M S D Washington Township 181272002022 5445 Northview Middle School   Regular School No 2.0 06 08 2015   grade_7                         143.0 121.0                       264.0                         143 121                 264

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