Data source: Big Local News · About: Big Local

2,924 rows where grade = "grade_9" and state = "IN" sorted by school_state_id

View and edit SQL

year

grade

  • grade_9 · 2,924
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
1159477 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   grade_9                         49.0 34.0                       83.0                         49 34                 83
1280867 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   grade_9                         47.0 53.0                       100.0                         47 53                 100
1292930 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_9                         42.0 49.0                       91.0                         42 49                 91
1751562 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_9                         38.0 40.0                       78.0                         38 40                 78
1787303 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_9                         49.0 53.0                       102.0                         49 53                 102
1907003 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   grade_9                         50.0 33.0                       83.0                         50 33                 83
1918969 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_9                         53.0 48.0                       101.0                         53 48                 101
1159505 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   grade_9                         53.0 60.0                       113.0                         53 60                 113
1280895 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2016   grade_9                         46.0 49.0                       95.0                         46 49                 95
1292957 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   grade_9                         57.0 44.0                       101.0                         57 44                 101
1751589 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2019   grade_9                         56.0 49.0                       105.0                         56 49                 105
1787330 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2018   grade_9                         60.0 43.0                       103.0                         60 43                 103
1907030 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2020   grade_9                         37.0 41.0                       78.0                         37 41                 78
1918996 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2021   grade_9                         39.0 50.0                       89.0                         39 50                 89
1159482 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No 3.0 09 12 2015   grade_9                         73.0 84.0                       157.0                         73 84                 157
1280872 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No 3.0 09 12 2016   grade_9                         94.0 92.0                       186.0                         94 92                 186
1292935 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   grade_9                         85.0 98.0                       183.0                         85 98                 183
1751567 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2019   grade_9                         97.0 80.0                       177.0                         97 80                 177
1787308 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2018   grade_9                         86.0 88.0                       174.0                         86 88                 174
1907008 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2020   grade_9                         79.0 89.0                       168.0                         79 89                 168
1918974 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2021   grade_9                         68.0 92.0                       160.0                         68 92                 160
1159533 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No 3.0 09 12 2015   grade_9                         289.0 289.0                       578.0                         289 289                 578
1280923 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No 3.0 09 12 2016   grade_9                         302.0 293.0                       595.0                         302 293                 595
1292985 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_9                         301.0 291.0                       592.0                         301 291                 592
1751617 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2019   grade_9                         340.0 338.0                       678.0                         340 338                 678
1787358 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2018   grade_9                         305.0 287.0                       592.0                         305 287                 592
1907058 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2020   grade_9                         317.0 302.0                       619.0                         317 302                 619
1919024 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   grade_9                         304.0 329.0                       633.0                         304 329                 633
1159974 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No 3.0 07 12 2015   grade_9                         121.0 102.0                       223.0                         121 102                 223
1281367 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No 3.0 07 12 2016   grade_9                         116.0 107.0                       223.0                         116 107                 223
1293421 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2017   grade_9                         114.0 118.0                       232.0                         114 118                 232
1752045 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2019   grade_9                         120.0 137.0                       257.0                         120 137                 257
1787790 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2018   grade_9                         135.0 105.0                       240.0                         135 105                 240
1907485 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2020   grade_9                         122.0 129.0                       251.0                         122 129                 251
1919451 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2021   grade_9                         104.0 132.0                       236.0                         104 132                 236
1159986 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No 3.0 07 12 2015   grade_9                         76.0 69.0                       145.0                         76 69                 145
1281379 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No 3.0 07 12 2016   grade_9                         84.0 79.0                       163.0                         84 79                 163
1293434 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2017   grade_9                         72.0 71.0                       143.0                         72 71                 143
1752057 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2019   grade_9                         72.0 68.0                       140.0                         72 68                 140
1787802 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2018   grade_9                         79.0 67.0                       146.0                         79 67                 146
1907497 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2020   grade_9                         84.0 67.0                       151.0                         84 67                 151
1919463 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2021   grade_9                         115.0 59.0                       174.0                         115 59                 174
1159603 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No 3.0 09 12 2015   grade_9                         298.0 276.0                       574.0                         298 276                 574
1280993 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No 3.0 09 12 2016   grade_9                         276.0 331.0                       607.0                         276 331                 607
1293056 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   grade_9                         285.0 317.0                       602.0                         285 317                 602
1751688 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2019   grade_9                         320.0 277.0                       597.0                         320 277                 597
1787429 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2018   grade_9                         338.0 325.0                       663.0                         338 325                 663
1907129 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2020   grade_9                         307.0 327.0                       634.0                         307 327                 634
1919095 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2021   grade_9                         331.0 310.0                       641.0                         331 310                 641
1159645 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_9                         4.0 0.0                       4.0                         4 0                 4
1281037 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 08 12 2016   grade_9                         2.0 1.0                       3.0                         2 1                 3
1293098 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   grade_9                         1.0 0.0                       1.0                         1 0                 1
1751723 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   grade_9                         1.0 0.0                       1.0                         1 0                 1
1907163 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2020   grade_9                         3.0 0.0                       3.0                         3 0                 3
1159650 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No 3.0 09 12 2015   grade_9                         271.0 233.0                       504.0                         271 233                 504
1281042 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No 3.0 09 12 2016   grade_9                         218.0 199.0                       417.0                         218 199                 417
1293103 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2017   grade_9                         193.0 208.0                       401.0                         193 208                 401
1751728 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2019   grade_9                         191.0 199.0                       390.0                         191 199                 390
1787472 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2018   grade_9                         214.0 189.0                       403.0                         214 189                 403
1907168 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2020   grade_9                         217.0 195.0                       412.0                         217 195                 412
1919134 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2021   grade_9                         216.0 201.0                       417.0                         216 201                 417
1159655 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No 3.0 09 12 2015   grade_9                         211.0 251.0                       462.0                         211 251                 462
1281047 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No 3.0 09 12 2016   grade_9                         234.0 246.0                       480.0                         234 246                 480
1293108 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2017   grade_9                         219.0 251.0                       470.0                         219 251                 470
1751733 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2019   grade_9                         235.0 239.0                       474.0                         235 239                 474
1787477 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2018   grade_9                         245.0 238.0                       483.0                         245 238                 483
1907173 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2020   grade_9                         224.0 250.0                       474.0                         224 250                 474
1919139 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2021   grade_9                         235.0 254.0                       489.0                         235 254                 489
1159660 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No 3.0 09 12 2015   grade_9                         180.0 186.0                       366.0                         180 186                 366
1281052 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No 3.0 09 12 2016   grade_9                         209.0 178.0                       387.0                         209 178                 387
1293113 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2017   grade_9                         197.0 193.0                       390.0                         197 193                 390
1751738 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2019   grade_9                         149.0 183.0                       332.0                         149 183                 332
1787482 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2018   grade_9                         156.0 159.0                       315.0                         156 159                 315
1907178 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2020   grade_9                         205.0 206.0                       411.0                         205 206                 411
1919144 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2021   grade_9                         181.0 198.0                       379.0                         181 198                 379
1758283 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2019   grade_9                         13.0 13.0                       26.0                         13 13                 26
1913713 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2020   grade_9                         21.0 19.0                       40.0                         21 19                 40
1925617 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2021   grade_9                         10.0 18.0                       28.0                         10 18                 28
1925619 IN     school 1804770 5385   Indianapolis Public Schools 180477002653 109 Thrival Academy   Regular School No Secondary 09 09 2021   grade_9                         20.0 21.0                       41.0                         20 21                 41
1159638 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_9                         0.0 1.0                       1.0                         0 1                 1
1281031 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_9                         1.0 0.0                       1.0                         1 0                 1
1293092 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_9                         0.0 2.0                       2.0                         0 2                 2
1787463 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_9                         0.0 1.0                       1.0                         0 1                 1
1159797 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No 3.0 09 12 2015   grade_9                         154.0 147.0                       301.0                         154 147                 301
1281189 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No 3.0 09 12 2016   grade_9                         209.0 164.0                       373.0                         209 164                 373
1293250 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No High 09 12 2017   grade_9                         188.0 178.0                       366.0                         188 178                 366
1751875 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No High 09 12 2019   grade_9                         178.0 170.0                       348.0                         178 170                 348
1787619 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No High 09 12 2018   grade_9                         192.0 143.0                       335.0                         192 143                 335
1907315 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No High 09 12 2020   grade_9                         201.0 181.0                       382.0                         201 181                 382
1919281 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No High 09 12 2021   grade_9                         201.0 158.0                       359.0                         201 158                 359
1159872 IN     school 1803630 235   Fort Wayne Community Schools 180363000552 219 Northrop High School   Regular School No 3.0 09 12 2015   grade_9                         287.0 307.0                       594.0                         287 307                 594
1281263 IN     school 1803630 235   Fort Wayne Community Schools 180363000552 219 Northrop High School   Regular School No 3.0 09 12 2016   grade_9                         278.0 258.0                       536.0                         278 258                 536
1293317 IN     school 1803630 235   Fort Wayne Community Schools 180363000552 219 Northrop High School   Regular School No High 09 12 2017   grade_9                         245.0 261.0                       506.0                         245 261                 506
1751942 IN     school 1803630 235   Fort Wayne Community Schools 180363000552 219 Northrop High School   Regular School No High 09 12 2019   grade_9                         247.0 253.0                       500.0                         247 253                 500
1787686 IN     school 1803630 235   Fort Wayne Community Schools 180363000552 219 Northrop High School   Regular School No High 09 12 2018   grade_9                         288.0 259.0                       547.0                         288 259                 547
1907382 IN     school 1803630 235   Fort Wayne Community Schools 180363000552 219 Northrop High School   Regular School No High 09 12 2020   grade_9                         287.0 284.0                       571.0                         287 284                 571
1919348 IN     school 1803630 235   Fort Wayne Community Schools 180363000552 219 Northrop High School   Regular School No High 09 12 2021   grade_9                         253.0 256.0                       509.0                         253 256                 509
1171266 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 03 11 2015   grade_9                         7.0 0.0                       7.0                         7 0                 7
1292635 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 02 12 2016   grade_9                         14.0 0.0                       14.0                         14 0                 14
1304673 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2017   grade_9                         10.0 0.0                       10.0                         10 0                 10

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