enrollments

Data source: Big Local News · About: Big Local

702 rows where grade = "grade_6", state = "IN" and year = 2016 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 702 ✖

grade ✖

  • grade_6 · 702 ✖
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
1281028 1281028 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative Education School No 4.0 01 10 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1282091 1282091 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 4.0 06 12 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1282613 1282613 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1285173 1285173 IN     school 1806120 3995   Madison Consolidated Schools 180612001088 3333 Emery O Muncie Elem School   Regular School No 1.0 PK 06 2016   grade_6                         0.0 1.0                       1.0                         0 1                 1
1285719 1285719 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1286415 1286415 IN     school 1804560 4720   School Town of Highland 180456000767 4290 Mildred Merkley Elem School   Regular School No 1.0 KG 06 2016   grade_6                         0.0 1.0                       1.0                         0 1                 1
1286449 1286449 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No 1.0 01 06 2016   grade_6                         0.0 1.0                       1.0                         0 1                 1
1286462 1286462 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1288458 1288458 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1289723 1289723 IN     school 1803990 6755   Greencastle Community Sch Corp 180399000693 7102 Tzouanakis Intermediate School   Regular School No 1.0 01 06 2016   grade_6                         1.0 0.0                       1.0                         1 0                 1
1291123 1291123 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 01 12 2016   grade_6                         10.0 0.0                       10.0                         10 0                 10
1292487 1292487 IN     school 1800162 9630   Carpe Diem - Shadeland 180016202575 5978 Carpe Diem - Shadeland   Regular School Yes 4.0 06 10 2016   grade_6                         6.0 4.0                       10.0                         6 4                 10
1287052 1287052 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No 1.0 01 06 2016   grade_6                         50.0 50.0                       100.0                         50 50                 100
1288569 1288569 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000118 6173 Binford Elementary School   Regular School No 1.0 03 06 2016   grade_6                         56.0 44.0                       100.0                         56 44                 100
1283735 1283735 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No 2.0 05 08 2016   grade_6                         43.0 58.0                       101.0                         43 58                 101
1287603 1287603 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No 1.0 PK 06 2016   grade_6                         54.0 47.0                       101.0                         54 47                 101
1287628 1287628 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No 1.0 PK 06 2016   grade_6                         46.0 55.0                       101.0                         46 55                 101
1291259 1291259 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000487 8365 Vogel Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         45.0 56.0                       101.0                         45 56                 101
1286926 1286926 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2016   grade_6                         42.0 60.0                       102.0                         42 60                 102
1290921 1290921 IN     school 1811340 7865   Tippecanoe School Corp 181134001833 8026 Wainwright Middle School   Regular School No 2.0 06 08 2016   grade_6                         59.0 43.0                       102.0                         59 43                 102
1281622 1281622 IN     school 1800570 515   Blackford County Schools 180057000108 494 North Side Elementary School   Regular School No 2.0 04 06 2016   grade_6                         57.0 46.0                       103.0                         57 46                 103
1285469 1285469 IN     school 1807830 4315   North Knox School Corp 180783001335 3545 North Knox Intermediate   Regular School No 1.0 03 06 2016   grade_6                         42.0 61.0                       103.0                         42 61                 103
1287595 1287595 IN     school 1812810 5375   M S D Wayne Township 181281002035 5257 McClelland Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         59.0 44.0                       103.0                         59 44                 103
1287658 1287658 IN     school 1812810 5375   M S D Wayne Township 181281002031 5274 Chapelwood Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         54.0 49.0                       103.0                         54 49                 103
1281949 1281949 IN     school 1801920 1000   Clarksville Com School Corp 180192000248 851 Clarksville Middle School   Regular School No 2.0 05 08 2016   grade_6                         53.0 51.0                       104.0                         53 51                 104
1283456 1283456 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000589 2123 Brookville Middle Sch   Regular School No 2.0 05 08 2016   grade_6                         53.0 51.0                       104.0                         53 51                 104
1288945 1288945 IN     school 1801710 6055   Central Noble Com School Corp 180171000230 6453 Central Noble Junior Senior HS   Regular School No 4.0 06 12 2016   grade_6                         56.0 49.0                       105.0                         56 49                 105
1287189 1287189 IN     school 1805670 5330   M S D Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No 1.0 01 06 2016   grade_6                         52.0 54.0                       106.0                         52 54                 106
1290456 1290456 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No 2.0 05 08 2016   grade_6                         63.0 43.0                       106.0                         63 43                 106
1290579 1290579 IN     school 1810560 7445   South Spencer County Sch Corp 181056001734 7797 South Spencer Middle School   Regular School No 2.0 06 08 2016   grade_6                         50.0 57.0                       107.0                         50 57                 107
1285248 1285248 IN     school 1805190 4015   Jennings County School Corporation 180519000924 3397 North Vernon Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         56.0 52.0                       108.0                         56 52                 108
1287164 1287164 IN     school 1805670 5330   M S D Lawrence Township 180567001027 5289 Harrison Hill Elementary School   Regular School No 1.0 01 06 2016   grade_6                         60.0 48.0                       108.0                         60 48                 108
1280887 1280887 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No 2.0 06 08 2016   grade_6                         58.0 51.0                       109.0                         58 51                 109
1287133 1287133 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No 1.0 01 06 2016   grade_6                         61.0 48.0                       109.0                         61 48                 109
1292593 1292593 IN     school 1800123 9735   Inspire Academy - A Sch of Inquiry 180012302560 1518 Inspire Academy - A Sch of Inquiry   Regular School Yes 1.0 KG 07 2016   grade_6                         9.0 2.0                       11.0                         9 2                 11
1282828 1282828 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064002177 1586 Cedar Crest Intermediate School   Regular School No 2.0 05 06 2016   grade_6                         58.0 52.0                       110.0                         58 52                 110
1283151 1283151 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         56.0 55.0                       111.0                         56 55                 111
1284746 1284746 IN     school 1802040 3470   Northwestern School Corp 180204000254 2904 Northwestern Elementary Sch   Regular School No 1.0 KG 06 2016   grade_6                         62.0 49.0                       111.0                         62 49                 111
1287140 1287140 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No 1.0 01 06 2016   grade_6                         57.0 54.0                       111.0                         57 54                 111
1287196 1287196 IN     school 1805670 5330   M S D Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No 1.0 01 06 2016   grade_6                         51.0 60.0                       111.0                         51 60                 111
1289384 1289384 IN     school 1809180 6520   Porter Township School Corp 180918000523 6839 Boone Grove Middle School   Regular School No 2.0 06 08 2016   grade_6                         55.0 56.0                       111.0                         55 56                 111
1291749 1291749 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No 2.0 05 08 2016   grade_6                         55.0 56.0                       111.0                         55 56                 111
1292910 1292910 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes 2.0 05 08 2016   grade_6                         64.0 47.0                       111.0                         64 47                 111
1287620 1287620 IN     school 1812810 5375   M S D Wayne Township 181281000238 5267 North Wayne Elem School   Regular School No 1.0 KG 06 2016   grade_6                         55.0 57.0                       112.0                         55 57                 112
1291526 1291526 IN     school 1806270 8045   Manchester Community Schools 180627001102 8645 Manchester Intermediate School   Regular School No 2.0 04 06 2016   grade_6                         49.0 63.0                       112.0                         49 63                 112
1287174 1287174 IN     school 1805670 5330   M S D Lawrence Township 180567002278 5293 Indian Creek Elementary School   Regular School No 1.0 01 06 2016   grade_6                         56.0 57.0                       113.0                         56 57                 113
1285687 1285687 IN     school 1809300 4515   Prairie Heights Com Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No 2.0 05 08 2016   grade_6                         53.0 61.0                       114.0                         53 61                 114
1291021 1291021 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001868 8206 Union County Middle School   Regular School No 2.0 06 08 2016   grade_6                         58.0 56.0                       114.0                         58 56                 114
1286841 1286841 IN     school 1806900 5085   Mitchell Community Schools 180690002151 4924 Mitchell Jr High School   Regular School No 2.0 06 08 2016   grade_6                         61.0 54.0                       115.0                         61 54                 115
1286997 1286997 IN     school 1803300 5280   Elwood Community School Corp 180330002309 5151 Elwood Intermediate School   Regular School No 1.0 03 06 2016   grade_6                         61.0 54.0                       115.0                         61 54                 115
1291051 1291051 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000482 8229 Scott Elementary School   Regular School No 1.0 PK 06 2016   grade_6                         52.0 63.0                       115.0                         52 63                 115
1290160 1290160 IN     school 1810290 7205   South Bend Community Sch Corp 181029001650 7425 Clay Intermediate Center   Regular School No 2.0 05 08 2016   grade_6                         54.0 62.0                       116.0                         54 62                 116
1290182 1290182 IN     school 1810290 7205   South Bend Community Sch Corp 181029001645 7510 Jackson Intermediate Center   Regular School No 2.0 05 08 2016   grade_6                         75.0 41.0                       116.0                         75 41                 116
1289619 1289619 IN     school 1807110 6620   Eastern Pulaski Com Sch Corp 180711001206 6996 Winamac Community Middle School   Regular School No 2.0 06 08 2016   grade_6                         64.0 53.0                       117.0                         64 53                 117
1281793 1281793 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle School   Regular School No 2.0 06 08 2016   grade_6                         62.0 56.0                       118.0                         62 56                 118
1282837 1282837 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001777 1587 Southridge Middle School   Regular School No 2.0 06 08 2016   grade_6                         54.0 64.0                       118.0                         54 64                 118
1286871 1286871 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002418 5012 Lapel Middle School   Regular School No 2.0 06 08 2016   grade_6                         58.0 60.0                       118.0                         58 60                 118
1290220 1290220 IN     school 1810290 7205   South Bend Community Sch Corp 181029001681 7537 Edison Intermediate Center   Regular School No 2.0 05 08 2016   grade_6                         70.0 48.0                       118.0                         70 48                 118
1291219 1291219 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000477 8339 McGary Middle School   Regular School No 2.0 06 08 2016   grade_6                         65.0 53.0                       118.0                         65 53                 118
1289398 1289398 IN     school 1811700 6530   Union Township School Corp 181170000793 6843 Union Township Middle Sch   Regular School No 2.0 06 08 2016   grade_6                         56.0 63.0                       119.0                         56 63                 119
1283527 1283527 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 PK 06 2016   grade_6                         4.0 8.0                       12.0                         4 8                 12
1287640 1287640 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_6                         11.0 1.0                       12.0                         11 1                 12
1291600 1291600 IN     school 1806080 8115   M S D Warren County 180608001072 8733 Pine Village Elementary Sch   Regular School No 1.0 KG 06 2016   grade_6                         4.0 8.0                       12.0                         4 8                 12
1285793 1285793 IN     school 1804620 4590   River Forest Community Sch Corp 180462000780 3801 River Forest Middle School   Regular School No 2.0 06 08 2016   grade_6                         56.0 64.0                       120.0                         56 64                 120
1291063 1291063 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002507 8231 Oak Hill Elementary   Regular School No 1.0 KG 06 2016   grade_6                         58.0 62.0                       120.0                         58 62                 120
1284345 1284345 IN     school 1810360 3190   South Harrison Com Schools 181036000385 2663 Corydon Intermediate School   Regular School No 2.0 04 06 2016   grade_6                         59.0 62.0                       121.0                         59 62                 121
1285190 1285190 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080002547 3343 Southwestern Middle School   Regular School No 2.0 06 08 2016   grade_6                         68.0 53.0                       121.0                         68 53                 121
1286776 1286776 IN     school 1807860 5075   North Lawrence Com Schools 180786000446 4878 Oolitic Middle School   Regular School No 2.0 06 08 2016   grade_6                         60.0 61.0                       121.0                         60 61                 121
1287211 1287211 IN     school 1805670 5330   M S D Lawrence Township 180567001066 5299 Sunnyside Elementary School   Regular School No 1.0 01 06 2016   grade_6                         73.0 48.0                       121.0                         73 48                 121
1289075 1289075 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         61.0 60.0                       121.0                         61 60                 121
1283744 1283744 IN     school 1805910 2950   Linton-Stockton School Corp 180591002147 2438 Linton-Stockton Jr High School   Regular School No 2.0 06 08 2016   grade_6                         65.0 57.0                       122.0                         65 57                 122
1287157 1287157 IN     school 1805670 5330   M S D Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No 1.0 01 06 2016   grade_6                         66.0 56.0                       122.0                         66 56                 122
1284768 1284768 IN     school 1803150 3480   Eastern Howard School Corporation 180315002589 2914 Eastern Middle School   Regular School No 2.0 06 08 2016   grade_6                         56.0 67.0                       123.0                         56 67                 123
1284996 1284996 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle School   Regular School No 2.0 06 08 2016   grade_6                         63.0 60.0                       123.0                         63 60                 123
1285070 1285070 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No 2.0 06 08 2016   grade_6                         59.0 64.0                       123.0                         59 64                 123
1288735 1288735 IN     school 1804140 5900   Monroe-Gregg School District 180414002129 6315 Monrovia Middle School   Regular School No 2.0 06 08 2016   grade_6                         68.0 55.0                       123.0                         68 55                 123
1284641 1284641 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No 2.0 06 08 2016   grade_6                         57.0 67.0                       124.0                         57 67                 124
1286862 1286862 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002049 5009 Frankton Elementary School   Regular School No 1.0 PK 06 2016   grade_6                         74.0 51.0                       125.0                         74 51                 125
1284837 1284837 IN     school 1805370 3500   Kokomo School Corporation 180537001018 2963 Maple Crest Middle School   Regular School No 2.0 06 08 2016   grade_6                         74.0 52.0                       126.0                         74 52                 126
1287612 1287612 IN     school 1812810 5375   M S D Wayne Township 181281002037 5265 Robey Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         59.0 67.0                       126.0                         59 67                 126
1287650 1287650 IN     school 1812810 5375   M S D Wayne Township 181281002042 5273 Westlake Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         61.0 65.0                       126.0                         61 65                 126
1289683 1289683 IN     school 1807980 6715   North Putnam Community Schools 180798000316 7049 North Putnam Middle Sch   Regular School No 2.0 06 08 2016   grade_6                         65.0 61.0                       126.0                         65 61                 126
1291262 1291262 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000488 8369 Washington Middle School   Regular School No 2.0 06 08 2016   grade_6                         69.0 57.0                       126.0                         69 57                 126
1284186 1284186 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001407 2567 Sugar Creek Elementary Sch   Regular School No 1.0 KG 06 2016   grade_6                         75.0 52.0                       127.0                         75 52                 127
1289202 1289202 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001282 6745 William Tell Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         68.0 59.0                       127.0                         68 59                 127
1280875 1280875 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2016   grade_6                         71.0 57.0                       128.0                         71 57                 128
1282542 1282542 IN     school 1803840 1820   Garrett-Keyser-Butler Com 180384001389 1331 Garrett Middle Sch   Regular School No 2.0 06 08 2016   grade_6                         59.0 70.0                       129.0                         59 70                 129
1292334 1292334 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes 1.0 KG 08 2016   grade_6                         8.0 5.0                       13.0                         8 5                 13
1292889 1292889 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes 4.0 KG 12 2016   grade_6                         3.0 10.0                       13.0                         3 10                 13
1281476 1281476 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2016   grade_6                         64.0 67.0                       131.0                         64 67                 131
1281095 1281095 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No 2.0 06 08 2016   grade_6                         76.0 56.0                       132.0                         76 56                 132
1281416 1281416 IN     school 1802850 255   East Allen County Schools 180285000354 301 New Haven Middle School   Regular School No 2.0 06 08 2016   grade_6                         63.0 69.0                       132.0                         63 69                 132
1291356 1291356 IN     school 1812090 8030   Vigo County School Corp 181209001915 8481 Sarah Scott Middle School   Regular School No 2.0 06 08 2016   grade_6                         67.0 65.0                       132.0                         67 65                 132
1286888 1286888 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         60.0 73.0                       133.0                         60 73                 133
1290306 1290306 IN     school 1810290 7205   South Bend Community Sch Corp 181029001679 7597 Navarre Intermediate Center   Regular School No 2.0 05 08 2016   grade_6                         63.0 70.0                       133.0                         63 70                 133
1284588 1284588 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001170 2687 Cascade Middle School   Regular School No 2.0 06 08 2016   grade_6                         68.0 67.0                       135.0                         68 67                 135
1287586 1287586 IN     school 1812810 5375   M S D Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No 1.0 PK 06 2016   grade_6                         64.0 71.0                       135.0                         64 71                 135
1288435 1288435 IN     school 1808340 5625   Oak Hill United School Corp 180834001431 2306 Swayzee Elementary School   Regular School No 2.0 05 06 2016   grade_6                         65.0 70.0                       135.0                         65 70                 135
1290238 1290238 IN     school 1810290 7205   South Bend Community Sch Corp 181029001682 7549 Jefferson Intermediate Center   Regular School No 2.0 05 08 2016   grade_6                         72.0 63.0                       135.0                         72 63                 135
1291813 1291813 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000215 8983 Centerville-Abington Elem School   Regular School No 1.0 03 06 2016   grade_6                         75.0 61.0                       136.0                         75 61                 136

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