Data source: Big Local News · About: Big Local

506 rows where grade = "grade_8", state = "IN" and year = 2016 sorted by total

View and edit SQL

year

  • 2016 · 506

grade

  • grade_8 · 506
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
1281036 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 08 12 2016   grade_8                         1.0 0.0                       1.0                         1 0                 1
1282154 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 08 2016   grade_8                         1.0 0.0                       1.0                         1 0                 1
1284649 IN     school 1807440 3445   New Castle Community Sch Corp 180744001290 2825 New Castle High School   Regular School No 3.0 07 12 2016   grade_8                         0.0 1.0                       1.0                         0 1                 1
1284793 IN     school 1804470 3490   Western School Corp 180447002224 2923 Western Intermediate School   Regular School No 1.0 02 08 2016   grade_8                         0.0 1.0                       1.0                         0 1                 1
1286035 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch Elementary School   Regular School No 1.0 PK 08 2016   grade_8                         0.0 1.0                       1.0                         0 1                 1
1289746 IN     school 1811730 6795   Union School Corporation 181173001875 7119 Union Junior & High School   Regular School No 3.0 07 12 2016   grade_8                         4.0 6.0                       10.0                         4 6                 10
1292846 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2016   grade_8                         9.0 1.0                       10.0                         9 1                 10
1281399 IN     school 1802850 255   East Allen County Schools 180285000361 285 Woodlan Jr/Sr High School   Regular School No 3.0 07 12 2016   grade_8                         56.0 45.0                       101.0                         56 45                 101
1282824 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001745 1583 Forest Park Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         44.0 57.0                       101.0                         44 57                 101
1285483 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No 3.0 07 12 2016   grade_8                         42.0 59.0                       101.0                         42 59                 101
1289654 IN     school 1810500 6705   South Putnam Community Schools 181050002542 7056 South Putnam Middle School   Regular School No 2.0 06 08 2016   grade_8                         55.0 46.0                       101.0                         55 46                 101
1284734 IN     school 1811250 3460   Taylor Community School Corp 181125001263 2896 Taylor Middle School   Regular School No 2.0 06 08 2016   grade_8                         51.0 52.0                       103.0                         51 52                 103
1285795 IN     school 1804620 4590   River Forest Community Sch Corp 180462000780 3801 River Forest Middle School   Regular School No 2.0 06 08 2016   grade_8                         48.0 56.0                       104.0                         48 56                 104
1290923 IN     school 1811340 7865   Tippecanoe School Corp 181134001833 8026 Wainwright Middle School   Regular School No 2.0 06 08 2016   grade_8                         57.0 48.0                       105.0                         57 48                 105
1289685 IN     school 1807980 6715   North Putnam Community Schools 180798000316 7049 North Putnam Middle Sch   Regular School No 2.0 06 08 2016   grade_8                         58.0 48.0                       106.0                         58 48                 106
1289824 IN     school 1810530 6865   South Ripley Com Sch Corp 181053002482 7174 South Ripley Junior High School   Regular School No 2.0 07 08 2016   grade_8                         57.0 49.0                       106.0                         57 49                 106
1284590 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001170 2687 Cascade Middle School   Regular School No 2.0 06 08 2016   grade_8                         53.0 54.0                       107.0                         53 54                 107
1281795 IN     school 1802700 755   Delphi Community School Corp 180270000327 609 Delphi Community Middle School   Regular School No 2.0 06 08 2016   grade_8                         56.0 52.0                       108.0                         56 52                 108
1283746 IN     school 1805910 2950   Linton-Stockton School Corp 180591002147 2438 Linton-Stockton Jr High School   Regular School No 2.0 06 08 2016   grade_8                         57.0 51.0                       108.0                         57 51                 108
1285689 IN     school 1809300 4515   Prairie Heights Com Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No 2.0 05 08 2016   grade_8                         51.0 57.0                       108.0                         51 57                 108
1290774 IN     school 1811220 7775   Switzerland County School Corp 181122000806 7987 Switzerland Co Middle School   Regular School No 2.0 07 08 2016   grade_8                         52.0 56.0                       108.0                         52 56                 108
1282511 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000405 1317 Eastside Junior-Senior High School   Regular School No 3.0 07 12 2016   grade_8                         60.0 49.0                       109.0                         60 49                 109
1288308 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elem/Middle School   Regular School No 1.0 KG 08 2016   grade_8                         59.0 50.0                       109.0                         59 50                 109
1290344 IN     school 1811910 7215   Union-North United School Corp 181191001879 7399 LaVille Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         61.0 48.0                       109.0                         61 48                 109
1283101 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No 4.0 01 12 2016   grade_8                         8.0 3.0                       11.0                         8 3                 11
1290083 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   grade_8                         9.0 2.0                       11.0                         9 2                 11
1292634 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 02 12 2016   grade_8                         11.0 0.0                       11.0                         11 0                 11
1283458 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000589 2123 Brookville Middle Sch   Regular School No 2.0 05 08 2016   grade_8                         56.0 54.0                       110.0                         56 54                 110
1291023 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_8                         62.0 48.0                       110.0                         62 48                 110
1284259 IN     school 1803120 3145   Eastern Hancock Co Com Sch Corp 180312000658 2582 Eastern Hancock Middle School   Regular School No 2.0 06 08 2016   grade_8                         58.0 54.0                       112.0                         58 54                 112
1285463 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         56.0 56.0                       112.0                         56 56                 112
1286873 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002418 5012 Lapel Middle School   Regular School No 2.0 06 08 2016   grade_8                         61.0 51.0                       112.0                         61 51                 112
1290222 IN     school 1810290 7205   South Bend Community Sch Corp 181029001681 7537 Edison Intermediate Center   Regular School No 2.0 05 08 2016   grade_8                         67.0 45.0                       112.0                         67 45                 112
1290458 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No 2.0 05 08 2016   grade_8                         60.0 52.0                       112.0                         60 52                 112
1281951 IN     school 1801920 1000   Clarksville Com School Corp 180192000248 851 Clarksville Middle School   Regular School No 2.0 05 08 2016   grade_8                         53.0 60.0                       113.0                         53 60                 113
1281651 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002066 539 Western Boone Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         64.0 50.0                       114.0                         64 50                 114
1285666 IN     school 1813230 4455   Whitko Community School Corp 181323000068 3644 Whitko Middle School   Regular School No 2.0 06 08 2016   grade_8                         63.0 52.0                       115.0                         63 52                 115
1291221 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000477 8339 McGary Middle School   Regular School No 2.0 06 08 2016   grade_8                         58.0 57.0                       115.0                         58 57                 115
1291808 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000216 8982 Centerville-Abington Jr High Sch   Regular School No 2.0 07 08 2016   grade_8                         64.0 51.0                       115.0                         64 51                 115
1286085 IN     school 1802910 4680   Lake Station Community Schools 180291000380 3965 Thomas A Edison Jr-Sr HS   Regular School No 3.0 07 12 2016   grade_8                         63.0 54.0                       117.0                         63 54                 117
1286778 IN     school 1807860 5075   North Lawrence Com Schools 180786000446 4878 Oolitic Middle School   Regular School No 2.0 06 08 2016   grade_8                         60.0 57.0                       117.0                         60 57                 117
1290754 IN     school 1810860 7715   Southwest School Corp 181086002359 7961 Sullivan Middle School   Regular School No 2.0 06 08 2016   grade_8                         71.0 46.0                       117.0                         71 46                 117
1283623 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002273 2299 Eastbrook Junior High School   Regular School No 2.0 07 08 2016   grade_8                         59.0 59.0                       118.0                         59 59                 118
1284643 IN     school 1808280 3435   Shenandoah School Corporation 180828001421 2819 Shenandoah Middle School   Regular School No 2.0 06 08 2016   grade_8                         61.0 57.0                       118.0                         61 57                 118
1291958 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle Sch   Regular School No 2.0 05 08 2016   grade_8                         59.0 59.0                       118.0                         59 59                 118
1289788 IN     school 1801770 6825   Randolph Central School Corp 180177000235 7129 Lee L Driver Middle School   Regular School No 2.0 06 08 2016   grade_8                         59.0 60.0                       119.0                         59 60                 119
1292289 IN     school 1800028 9400   KIPP Indpls College Preparatory 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes 2.0 05 08 2016   grade_8                         55.0 64.0                       119.0                         55 64                 119
1282085 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_8                         8.0 4.0                       12.0                         8 4                 12
1292336 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes 1.0 KG 08 2016   grade_8                         3.0 9.0                       12.0                         3 9                 12
1292557 IN     school 1800065 9690   Renaissance Academy Charter School 180006502415 4711 Renaissance Academy Charter School   Regular School Yes 1.0 KG 08 2016   grade_8                         6.0 6.0                       12.0                         6 6                 12
1286920 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2016   grade_8                         68.0 52.0                       120.0                         68 52                 120
1282270 IN     school 1802440 1300   Crawford Co Com School Corp 180244000279 1059 Crawford County Jr-Sr HS   Regular School No 3.0 07 12 2016   grade_8                         59.0 63.0                       122.0                         59 63                 122
1286854 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002050 5005 Frankton Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         64.0 59.0                       123.0                         64 59                 123
1287705 IN     school 1804770 5385   Indianapolis Public Schools 180477002597 5466 Arlington Community Middle School   Regular School No 2.0 07 08 2016   grade_8                         71.0 52.0                       123.0                         71 52                 123
1289400 IN     school 1811700 6530   Union Township School Corp 181170000793 6843 Union Township Middle Sch   Regular School No 2.0 06 08 2016   grade_8                         63.0 61.0                       124.0                         63 61                 124
1289588 IN     school 1807950 6600   M S D North Posey Co Schools 180795001365 6973 North Posey Jr High School   Regular School No 2.0 07 08 2016   grade_8                         66.0 58.0                       124.0                         66 58                 124
1280877 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2016   grade_8                         57.0 68.0                       125.0                         57 68                 125
1281833 IN     school 1810680 815   Southeastern School Corp 181068001755 689 Lewis Cass Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         75.0 51.0                       126.0                         75 51                 126
1291009 IN     school 1811400 7945   Tipton Community School Corp 181140001842 8167 Tipton Middle School   Regular School No 2.0 06 08 2016   grade_8                         65.0 61.0                       126.0                         65 61                 126
1291515 IN     school 1806270 8045   Manchester Community Schools 180627001103 8625 Manchester Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         62.0 64.0                       126.0                         62 64                 126
1291751 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle School   Regular School No 2.0 05 08 2016   grade_8                         72.0 54.0                       126.0                         72 54                 126
1282839 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001777 1587 Southridge Middle School   Regular School No 2.0 06 08 2016   grade_8                         58.0 69.0                       127.0                         58 69                 127
1289386 IN     school 1809180 6520   Porter Township School Corp 180918000523 6839 Boone Grove Middle School   Regular School No 2.0 06 08 2016   grade_8                         72.0 55.0                       127.0                         72 55                 127
1285072 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No 2.0 06 08 2016   grade_8                         68.0 60.0                       128.0                         68 60                 128
1290162 IN     school 1810290 7205   South Bend Community Sch Corp 181029001650 7425 Clay Intermediate Center   Regular School No 2.0 05 08 2016   grade_8                         70.0 59.0                       129.0                         70 59                 129
1287642 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_8                         12.0 1.0                       13.0                         12 1                 13
1287913 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No 1.0 PK 08 2016   grade_8                         7.0 6.0                       13.0                         7 6                 13
1291905 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_8                         9.0 4.0                       13.0                         9 4                 13
1289067 IN     school 1808640 6155   Paoli Community School Corp 180864001438 6581 Paoli Jr & Sr High School   Regular School No 3.0 07 12 2016   grade_8                         64.0 66.0                       130.0                         64 66                 130
1286991 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         57.0 74.0                       131.0                         57 74                 131
1283485 IN     school 1809630 2645   Rochester Community Sch Corp 180963001577 2177 Rochester Community Md Sch   Regular School No 2.0 06 08 2016   grade_8                         62.0 70.0                       132.0                         62 70                 132
1285654 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137000397 3619 Tippecanoe Valley Middle School   Regular School No 2.0 06 08 2016   grade_8                         78.0 54.0                       132.0                         78 54                 132
1291225 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000480 8345 Perry Heights Middle School   Regular School No 2.0 06 08 2016   grade_8                         74.0 58.0                       132.0                         74 58                 132
1290184 IN     school 1810290 7205   South Bend Community Sch Corp 181029001645 7510 Jackson Intermediate Center   Regular School No 2.0 05 08 2016   grade_8                         69.0 64.0                       133.0                         69 64                 133
1291264 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000488 8369 Washington Middle School   Regular School No 2.0 06 08 2016   grade_8                         65.0 69.0                       134.0                         65 69                 134
1286843 IN     school 1806900 5085   Mitchell Community Schools 180690002151 4924 Mitchell Jr High School   Regular School No 2.0 06 08 2016   grade_8                         67.0 68.0                       135.0                         67 68                 135
1289717 IN     school 1803990 6755   Greencastle Community Sch Corp 180399000689 7093 Greencastle Middle School   Regular School No 2.0 06 08 2016   grade_8                         80.0 56.0                       136.0                         80 56                 136
1289933 IN     school 1809120 7150   John Glenn School Corporation 180912001504 5916 Harold C Urey Middle School   Regular School No 2.0 07 08 2016   grade_8                         77.0 59.0                       136.0                         77 59                 136
1291319 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001740 8434 South Vermillion Middle School   Regular School No 2.0 06 08 2016   grade_8                         75.0 62.0                       137.0                         75 62                 137
1288737 IN     school 1804140 5900   Monroe-Gregg School District 180414002129 6315 Monrovia Middle School   Regular School No 2.0 06 08 2016   grade_8                         69.0 69.0                       138.0                         69 69                 138
1284827 IN     school 1805370 3500   Kokomo School Corporation 180537000998 2955 Central Middle School   Regular School No 2.0 06 08 2016   grade_8                         65.0 75.0                       140.0                         65 75                 140
1288224 IN     school 1810920 5400   School Town of Speedway 181092001784 5889 Speedway Junior High School   Regular School No 2.0 07 08 2016   grade_8                         77.0 63.0                       140.0                         77 63                 140
1290631 IN     school 1805340 7525   Knox Community School Corp 180534000939 7837 Knox Community Middle School   Regular School No 2.0 06 08 2016   grade_8                         62.0 78.0                       140.0                         62 78                 140
1284297 IN     school 1800690 3180   North Harrison Com School Corp 180069000145 2625 North Harrison Middle School   Regular School No 2.0 06 08 2016   grade_8                         59.0 82.0                       141.0                         59 82                 141
1284998 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000181 3107 Brownstown Central Middle School   Regular School No 2.0 06 08 2016   grade_8                         71.0 70.0                       141.0                         71 70                 141
1290943 IN     school 1811340 7865   Tippecanoe School Corp 181134001828 8041 Klondike Middle School   Regular School No 2.0 06 08 2016   grade_8                         79.0 62.0                       141.0                         79 62                 141
1284770 IN     school 1803150 3480   Eastern Howard School Corporation 180315002589 2914 Eastern Middle School   Regular School No 2.0 06 08 2016   grade_8                         74.0 68.0                       142.0                         74 68                 142
1290253 IN     school 1810290 7205   South Bend Community Sch Corp 181029001661 7559 Dickinson Fine Arts Academy   Regular School No 2.0 05 08 2016   grade_8                         81.0 61.0                       142.0                         81 61                 142
1290932 IN     school 1811340 7865   Tippecanoe School Corp 181134001825 8033 East Tipp Middle School   Regular School No 2.0 06 08 2016   grade_8                         67.0 78.0                       145.0                         67 78                 145
1285749 IN     school 1805520 4535   Lakeland School Corporation 180552002145 3743 Lakeland Middle School   Regular School No 2.0 06 08 2016   grade_8                         73.0 73.0                       146.0                         73 73                 146
1288704 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045002325 6261 Southmont Jr High School   Regular School No 2.0 07 08 2016   grade_8                         76.0 70.0                       146.0                         76 70                 146
1290240 IN     school 1810290 7205   South Bend Community Sch Corp 181029001682 7549 Jefferson Intermediate Center   Regular School No 2.0 05 08 2016   grade_8                         76.0 70.0                       146.0                         76 70                 146
1285447 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001302 3418 Indian Creek Middle School   Regular School No 2.0 06 08 2016   grade_8                         72.0 75.0                       147.0                         72 75                 147
1288668 IN     school 1807900 5835   North Montgomery Com Sch Corp 180790002293 6244 Northridge Middle School   Regular School No 2.0 06 08 2016   grade_8                         78.0 69.0                       147.0                         78 69                 147
1289563 IN     school 1807290 6590   M S D Mount Vernon 180729001227 6953 Mount Vernon Jr High Sch   Regular School No 2.0 06 08 2016   grade_8                         77.0 70.0                       147.0                         77 70                 147
1291851 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No 2.0 05 08 2016   grade_8                         73.0 74.0                       147.0                         73 74                 147
1281882 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia Middle School   Regular School No 2.0 06 08 2016   grade_8                         85.0 63.0                       148.0                         85 63                 148
1282447 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001036 1209 Greendale Middle School   Regular School No 2.0 06 08 2016   grade_8                         64.0 84.0                       148.0                         64 84                 148
1291358 IN     school 1812090 8030   Vigo County School Corp 181209001915 8481 Sarah Scott Middle School   Regular School No 2.0 06 08 2016   grade_8                         74.0 74.0                       148.0                         74 74                 148
1281593 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         73.0 76.0                       149.0                         73 76                 149

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