enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,430 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school ▼ school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1284482 1284482 IN     school 1800270 3315   Avon Community School Corp 180027002095 2736 Avon Middle School South   Regular School No 2.0 07 08 2016   grade_7                         196.0 181.0                       377.0                         196 181                 377
1296520 1296520 IN     school 1800270 3315   Avon Community School Corp 180027002095 2736 Avon Middle School South   Regular School No Middle 07 08 2017   grade_7                         178.0 192.0                       370.0                         178 192                 370
1755136 1755136 IN     school 1800270 3315   Avon Community School Corp 180027002095 2736 Avon Middle School South   Regular School No Middle 07 08 2019   grade_7                         219.0 169.0                       388.0                         219 169                 388
1790874 1790874 IN     school 1800270 3315   Avon Community School Corp 180027002095 2736 Avon Middle School South   Regular School No Middle 07 08 2018   grade_7                         186.0 183.0                       369.0                         186 183                 369
1910581 1910581 IN     school 1800270 3315   Avon Community School Corp 180027002095 2736 Avon Middle School South   Regular School No Middle 07 08 2020   grade_7                         191.0 207.0                       398.0                         191 207                 398
1922533 1922533 IN     school 1800270 3315   Avon Community School Corp 180027002095 2736 Avon Middle School South   Regular School No Middle 07 08 2021   grade_7                         219.0 162.0                       381.0                         219 162                 381
1762711 1762711 IN     school 1800184 9040   Avondale Meadows Middle School 180018402620 7094 Avondale Meadows Middle School   Regular School Yes Middle 06 08 2019   grade_7                         31.0 27.0                       58.0                         31 27                 58
1798490 1798490 IN     school 1800184 9040   Avondale Meadows Middle School 180018402620 7094 Avondale Meadows Middle School   Regular School Yes Middle 06 07 2018   grade_7                         17.0 17.0                       34.0                         17 17                 34
1918165 1918165 IN     school 1800184 9040   Avondale Meadows Middle School 180018402620 7094 Avondale Meadows Middle School   Regular School Yes Middle 06 08 2020   grade_7                         33.0 29.0                       62.0                         33 29                 62
1930121 1930121 IN     school 1800184 9040   Avondale Meadows Middle School 180018402620 7094 Avondale Meadows Middle School   Regular School Yes Middle 06 08 2021   grade_7                         30.0 31.0                       61.0                         30 31                 61
1912205 1912205 IN     school 1803870 4690   Gary Community School Corp 180387002460 4105 Bailly Middle School   Regular School No Middle 06 08 2020   grade_7                         78.0 71.0                       149.0                         78 71                 149
1924164 1924164 IN     school 1803870 4690   Gary Community School Corp 180387002460 4105 Bailly Middle School   Regular School No Middle 06 08 2021   grade_7                         103.0 77.0                       180.0                         103 77                 180
1286164 1286164 IN     school 1803870 4690   Gary Community School Corp 180387002460 4105 Bailly Preparatory Academy   Regular School No 1.0 KG 08 2016   grade_7                         27.0 15.0                       42.0                         27 15                 42
1298207 1298207 IN     school 1803870 4690   Gary Community School Corp 180387002460 4105 Bailly Preparatory Academy   Regular School No Elementary KG 08 2017   grade_7                         29.0 23.0                       52.0                         29 23                 52
1792534 1792534 IN     school 1803870 4690   Gary Community School Corp 180387002460 4105 Bailly Preparatory Academy   Regular School No Elementary KG 08 2018   grade_7                         54.0 27.0                       81.0                         54 27                 81
1792504 1792504 IN     school 1803870 4690   Gary Community School Corp 180387000613 4053 Banneker Elementary at Marquette   Regular School No Elementary KG 08 2018   grade_7                         24.0 18.0                       42.0                         24 18                 42
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
1286595 1286595 IN     school 1806570 4925   Michigan City Area Schools 180657001140 4789 Barker Middle School   Regular School No 2.0 07 08 2016   grade_7                         111.0 97.0                       208.0                         111 97                 208
1298632 1298632 IN     school 1806570 4925   Michigan City Area Schools 180657001140 4789 Barker Middle School   Regular School No Middle 07 08 2017   grade_7                         86.0 102.0                       188.0                         86 102                 188
1757161 1757161 IN     school 1806570 4925   Michigan City Area Schools 180657001140 4789 Barker Middle School   Regular School No Middle 07 08 2019   grade_7                         99.0 108.0                       207.0                         99 108                 207
1792953 1792953 IN     school 1806570 4925   Michigan City Area Schools 180657001140 4789 Barker Middle School   Regular School No Middle 07 08 2018   grade_7                         111.0 97.0                       208.0                         111 97                 208
1912597 1912597 IN     school 1806570 4925   Michigan City Area Schools 180657001140 4789 Barker Middle School   Regular School No Middle 07 08 2020   grade_7                         121.0 98.0                       219.0                         121 98                 219
1924548 1924548 IN     school 1806570 4925   Michigan City Area Schools 180657001140 4789 Barker Middle School   Regular School No Middle 07 08 2021   grade_7                         96.0 107.0                       203.0                         96 107                 203
1160893 1160893 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2015   grade_7                         35.0 22.0                       57.0                         35 22                 57
1282295 1282295 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2016   grade_7                         28.0 37.0                       65.0                         28 37                 65
1294333 1294333 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No Other 06 12 2017   grade_7                         28.0 29.0                       57.0                         28 29                 57
1752950 1752950 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2019   grade_7                         43.0 39.0                       82.0                         43 39                 82
1788691 1788691 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2018   grade_7                         21.0 40.0                       61.0                         21 40                 61
1908381 1908381 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2020   grade_7                         38.0 37.0                       75.0                         38 37                 75
1920356 1920356 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2021   grade_7                         32.0 43.0                       75.0                         32 43                 75
1168457 1168457 IN     school 1800390 6895   Batesville Community Sch Corp 180039000085 7219 Batesville Middle School   Regular School No 2.0 06 08 2015   grade_7                         93.0 57.0                       150.0                         93 57                 150
1289852 1289852 IN     school 1800390 6895   Batesville Community School Corp 180039000085 7219 Batesville Middle School   Regular School No 2.0 06 08 2016   grade_7                         84.0 69.0                       153.0                         84 69                 153
1301875 1301875 IN     school 1800390 6895   Batesville Community School Corp 180039000085 7219 Batesville Middle School   Regular School No Middle 06 08 2017   grade_7                         97.0 67.0                       164.0                         97 67                 164
1760385 1760385 IN     school 1800390 6895   Batesville Community School Corp 180039000085 7219 Batesville Middle School   Regular School No Middle 06 08 2019   grade_7                         86.0 77.0                       163.0                         86 77                 163
1796193 1796193 IN     school 1800390 6895   Batesville Community School Corp 180039000085 7219 Batesville Middle School   Regular School No Middle 06 08 2018   grade_7                         80.0 72.0                       152.0                         80 72                 152
1915796 1915796 IN     school 1800390 6895   Batesville Community School Corp 180039000085 7219 Batesville Middle School   Regular School No Middle 06 08 2020   grade_7                         100.0 71.0                       171.0                         100 71                 171
1927721 1927721 IN     school 1800390 6895   Batesville Community School Corp 180039000085 7219 Batesville Middle School   Regular School No Middle 06 08 2021   grade_7                         100.0 70.0                       170.0                         100 70                 170
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
1290918 1290918 IN     school 1811340 7865   Tippecanoe School Corp 181134001822 8025 Battle Ground Middle School   Regular School No 2.0 06 08 2016   grade_7                         101.0 80.0                       181.0                         101 80                 181
1302946 1302946 IN     school 1811340 7865   Tippecanoe School Corp 181134001822 8025 Battle Ground Middle School   Regular School No Middle 06 08 2017   grade_7                         104.0 94.0                       198.0                         104 94                 198
1761446 1761446 IN     school 1811340 7865   Tippecanoe School Corp 181134001822 8025 Battle Ground Middle School   Regular School No Middle 06 08 2019   grade_7                         116.0 111.0                       227.0                         116 111                 227
1797262 1797262 IN     school 1811340 7865   Tippecanoe School Corp 181134001822 8025 Battle Ground Middle School   Regular School No Middle 06 08 2018   grade_7                         100.0 95.0                       195.0                         100 95                 195
1916853 1916853 IN     school 1811340 7865   Tippecanoe School Corp 181134001822 8025 Battle Ground Middle School   Regular School No Middle 06 08 2020   grade_7                         136.0 136.0                       272.0                         136 136                 272
1928784 1928784 IN     school 1811340 7865   Tippecanoe School Corp 181134001822 8025 Battle Ground Middle School   Regular School No Middle 06 08 2021   grade_7                         133.0 121.0                       254.0                         133 121                 254
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
1286799 1286799 IN     school 1807860 5075   North Lawrence Com Schools 180786001336 4905 Bedford Middle School   Regular School No 2.0 06 08 2016   grade_7                         77.0 94.0                       171.0                         77 94                 171
1298836 1298836 IN     school 1807860 5075   North Lawrence Com Schools 180786001336 4905 Bedford Middle School   Regular School No Middle 06 08 2017   grade_7                         99.0 86.0                       185.0                         99 86                 185
1757365 1757365 IN     school 1807860 5075   North Lawrence Com Schools 180786001336 4905 Bedford Middle School   Regular School No Middle 06 08 2019   grade_7                         111.0 108.0                       219.0                         111 108                 219
1793157 1793157 IN     school 1807860 5075   North Lawrence Com Schools 180786001336 4905 Bedford Middle School   Regular School No Middle 06 08 2018   grade_7                         101.0 89.0                       190.0                         101 89                 190
1912790 1912790 IN     school 1807860 5075   North Lawrence Com Schools 180786001336 4905 Bedford Middle School   Regular School No Middle 06 08 2020   grade_7                         112.0 86.0                       198.0                         112 86                 198
1924716 1924716 IN     school 1807860 5075   North Lawrence Com Schools 180786001336 4905 Bedford Middle School   Regular School No Middle 07 08 2021   grade_7                         130.0 118.0                       248.0                         130 118                 248
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
1287683 1287683 IN     school 1800450 5380   Beech Grove City Schools 180045000092 5453 Beech Grove Middle School   Regular School No 2.0 07 08 2016   grade_7                         129.0 117.0                       246.0                         129 117                 246
1299721 1299721 IN     school 1800450 5380   Beech Grove City Schools 180045000092 5453 Beech Grove Middle School   Regular School No Middle 07 08 2017   grade_7                         119.0 117.0                       236.0                         119 117                 236
1758260 1758260 IN     school 1800450 5380   Beech Grove City Schools 180045000092 5453 Beech Grove Middle School   Regular School No Middle 07 08 2019   grade_7                         132.0 138.0                       270.0                         132 138                 270
1794050 1794050 IN     school 1800450 5380   Beech Grove City Schools 180045000092 5453 Beech Grove Middle School   Regular School No Middle 07 08 2018   grade_7                         113.0 116.0                       229.0                         113 116                 229
1913689 1913689 IN     school 1800450 5380   Beech Grove City Schools 180045000092 5453 Beech Grove Middle School   Regular School No Middle 07 08 2020   grade_7                         116.0 120.0                       236.0                         116 120                 236
1925593 1925593 IN     school 1800450 5380   Beech Grove City Schools 180045000092 5453 Beech Grove Middle School   Regular School No Middle 07 08 2021   grade_7                         118.0 115.0                       233.0                         118 115                 233
1159486 1159486 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2015   grade_7                         49.0 66.0                       115.0                         49 66                 115
1280876 1280876 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No 2.0 05 08 2016   grade_7                         53.0 70.0                       123.0                         53 70                 123
1292939 1292939 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2017   grade_7                         69.0 54.0                       123.0                         69 54                 123
1751570 1751570 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2019   grade_7                         43.0 56.0                       99.0                         43 56                 99
1787312 1787312 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_7                         49.0 59.0                       108.0                         49 59                 108
1907011 1907011 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2020   grade_7                         52.0 64.0                       116.0                         52 64                 116
1918977 1918977 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2021   grade_7                         50.0 72.0                       122.0                         50 72                 122
1165729 1165729 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No 2.0 07 08 2015   grade_7                         294.0 270.0                       564.0                         294 270                 564
1287125 1287125 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No 2.0 07 08 2016   grade_7                         311.0 257.0                       568.0                         311 257                 568
1299165 1299165 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 06 08 2017   grade_7                         301.0 265.0                       566.0                         301 265                 566
1757703 1757703 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 07 08 2019   grade_7                         317.0 261.0                       578.0                         317 261                 578
1793492 1793492 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 07 08 2018   grade_7                         301.0 303.0                       604.0                         301 303                 604
1913122 1913122 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 07 08 2020   grade_7                         286.0 257.0                       543.0                         286 257                 543
1925031 1925031 IN     school 1805670 5330   MSD Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No Middle 07 08 2021   grade_7                         304.0 269.0                       573.0                         304 269                 573
1164726 1164726 IN     school 1803870 4690   Gary Community School Corp 180387000613 4053 Benjamin Banneker Achievement Ctr   Regular School No 1.0 KG 08 2015   grade_7                         27.0 31.0                       58.0                         27 31                 58
1286116 1286116 IN     school 1803870 4690   Gary Community School Corp 180387000613 4053 Benjamin Banneker Achievement Ctr   Regular School No 1.0 KG 08 2016   grade_7                         21.0 21.0                       42.0                         21 21                 42
1298159 1298159 IN     school 1803870 4690   Gary Community School Corp 180387000613 4053 Benjamin Banneker Achievement Ctr   Regular School No Elementary KG 08 2017   grade_7                         16.0 23.0                       39.0                         16 23                 39
1168094 1168094 IN     school 1811970 6560   Valparaiso Community Schools 181197001881 6885 Benjamin Franklin Mid Sch   Regular School No 2.0 06 08 2015   grade_7                         149.0 156.0                       305.0                         149 156                 305
1289492 1289492 IN     school 1811970 6560   Valparaiso Community Schools 181197001881 6885 Benjamin Franklin Mid Sch   Regular School No 2.0 06 08 2016   grade_7                         131.0 123.0                       254.0                         131 123                 254
1301513 1301513 IN     school 1811970 6560   Valparaiso Community Schools 181197001881 6885 Benjamin Franklin Middle School   Regular School No Middle 06 08 2017   grade_7                         143.0 123.0                       266.0                         143 123                 266
1760004 1760004 IN     school 1811970 6560   Valparaiso Community Schools 181197001881 6885 Benjamin Franklin Middle School   Regular School No Middle 06 08 2019   grade_7                         150.0 156.0                       306.0                         150 156                 306
1795832 1795832 IN     school 1811970 6560   Valparaiso Community Schools 181197001881 6885 Benjamin Franklin Middle School   Regular School No Middle 06 08 2018   grade_7                         134.0 98.0                       232.0                         134 98                 232
1915413 1915413 IN     school 1811970 6560   Valparaiso Community Schools 181197001881 6885 Benjamin Franklin Middle School   Regular School No Middle 06 08 2020   grade_7                         128.0 139.0                       267.0                         128 139                 267
1927340 1927340 IN     school 1811970 6560   Valparaiso Community Schools 181197001881 6885 Benjamin Franklin Middle School   Regular School No Middle 06 08 2021   grade_7                         129.0 142.0                       271.0                         129 142                 271
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
1289929 1289929 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle School   Regular School No 2.0 07 08 2016   grade_7                         106.0 95.0                       201.0                         106 95                 201
1301954 1301954 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle School   Regular School No Middle 07 08 2017   grade_7                         84.0 88.0                       172.0                         84 88                 172
1760464 1760464 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle School   Regular School No Middle 07 08 2019   grade_7                         83.0 78.0                       161.0                         83 78                 161
1796272 1796272 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle School   Regular School No Middle 07 08 2018   grade_7                         100.0 102.0                       202.0                         100 102                 202
1915875 1915875 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle School   Regular School No Middle 07 08 2020   grade_7                         86.0 95.0                       181.0                         86 95                 181
1927800 1927800 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle School   Regular School No Middle 07 08 2021   grade_7                         84.0 74.0                       158.0                         84 74                 158
1160198 1160198 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         74.0 74.0                       148.0                         74 74                 148
1281592 1281592 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_7                         84.0 72.0                       156.0                         84 72                 156
1293648 1293648 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High School   Regular School No High 07 12 2017   grade_7                         98.0 80.0                       178.0                         98 80                 178
1752269 1752269 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High School   Regular School No High 07 12 2019   grade_7                         64.0 77.0                       141.0                         64 77                 141
1788015 1788015 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High School   Regular School No High 07 12 2018   grade_7                         60.0 100.0                       160.0                         60 100                 160
1907707 1907707 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High School   Regular School No High 07 12 2020   grade_7                         73.0 57.0                       130.0                         73 57                 130
1919674 1919674 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High School   Regular School No High 07 12 2021   grade_7                         73.0 67.0                       140.0                         73 67                 140
1907730 1907730 IN     school 1800570 515   Blackford County Schools 180057000102 489 Blackford Jr-Sr High School   Regular School No High 07 12 2020   grade_7                         54.0 54.0                       108.0                         54 54                 108
1919697 1919697 IN     school 1800570 515   Blackford County Schools 180057000102 489 Blackford Jr-Sr High School   Regular School No High 07 12 2021   grade_7                         67.0 55.0                       122.0                         67 55                 122
1160223 1160223 IN     school 1800570 515   Blackford County Schools 180057000103 491 Blackford Junior High School   Regular School No 2.0 07 08 2015   grade_7                         83.0 77.0                       160.0                         83 77                 160
1281617 1281617 IN     school 1800570 515   Blackford County Schools 180057000103 491 Blackford Junior High School   Regular School No 2.0 07 08 2016   grade_7                         63.0 59.0                       122.0                         63 59                 122

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