Data source: Big Local News · About: Big Local

3,931 rows where grade = "grade_9" and state = "WI" sorted by county

View and edit SQL

year

grade

  • grade_9 · 3,831
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
3074689 WI Barron   school 5500870 308 Public school Barron Area 550087000114 30 Barron High   Regular School No High 09 12 2019   grade_9                                                   91                                             91
3075444 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2019   grade_9                                                   7                                             7
3075459 WI Barron   school 5502130 903 Public school Cameron 550213000257 40 Cameron High   Regular School No High 09 12 2019   grade_9                                                   65                                             65
3075642 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102807 400 Chetek-Weyerhaeuser High   Regular School No High 09 12 2019   grade_9                                                   58                                             58
3075668 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2019   grade_9                                                   1                                             1
3076053 WI Barron   school 5503090 1260 Public school Cumberland 550309000344 60 Cumberland High   Regular School No High 09 12 2019   grade_9                                                   68                                             68
3076065 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Career and Technical School Yes High 07 12 2019   grade_9                                                   7                                             7
3076078 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2019   grade_9                                                   1                                             1
3084437 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218001586 40 Prairie Farm High   Regular School No High 09 12 2019   grade_9                                                   26                                             26
3084979 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001699 180 Rice Lake High   Regular School No High 09 12 2019   grade_9                                                   168                                             168
3086786 WI Barron   school 5515060 5810 Public school Turtle Lake 551506001956 40 Turtle Lake High   Regular School No High 09 12 2019   grade_9                                                   29                                             29
3089428 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2018   grade_9                                                   7                                             7
3089445 WI Barron   school 5500870 308 Public school Barron Area 550087000114 30 Barron High   Regular School No High 09 12 2018   grade_9                                                   99                                             99
3090195 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2018   grade_9                                                   4                                             4
3090209 WI Barron   school 5502130 903 Public school Cameron 550213000257 40 Cameron High   Regular School No High 09 12 2018   grade_9                                                   64                                             64
3090393 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102807 400 Chetek-Weyerhaeuser High   Regular School No High 09 12 2018   grade_9                                                   70                                             70
3090419 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2018   grade_9                                                   2                                             2
3090800 WI Barron   school 5503090 1260 Public school Cumberland 550309000344 60 Cumberland High   Regular School No High 09 12 2018   grade_9                                                   85                                             85
3090812 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Career and Technical School Yes High 07 12 2018   grade_9                                                   7                                             7
3090821 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2018   grade_9                                                   3                                             3
3099132 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218001586 40 Prairie Farm High   Regular School No High 09 12 2018   grade_9                                                   21                                             21
3099696 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281002932 450 Northern Lakes Regional Academy charter Regular School Yes High 09 12 2018   grade_9                                                   12                                             12
3099701 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001699 180 Rice Lake High   Regular School No High 09 12 2018   grade_9                                                   201                                             201
3101487 WI Barron   school 5515060 5810 Public school Turtle Lake 551506001956 40 Turtle Lake High   Regular School No High 09 12 2018   grade_9                                                   26                                             26
112571 WI Bayfield   school 5500900 315 Public school Bayfield 550090000121 40 Bayfield High   Regular School No 3.0 09 12 2015   grade_9                                                   40                                             40
114229 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000396 40 Drummond High   Regular School No 3.0 09 12 2015   grade_9                                                   22                                             22
123778 WI Bayfield   school 5512030 4522 Public school South Shore 551203001574 100 South Shore Jr/Sr High   Regular School No 3.0 07 12 2015   grade_9                                                   10                                             10
124840 WI Bayfield   school 5515540 6027 Public school Washburn 551554001985 40 Washburn High   Regular School No 3.0 09 12 2015   grade_9                                                   44                                             44
282551 WI Bayfield   school 5500900 315 Public school Bayfield 550090000121 40 Bayfield High   Regular School No 3.0 09 12 2016   grade_9                                                   28                                             28
284211 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000396 40 Drummond High   Regular School No 3.0 09 12 2016   grade_9                                                   33                                             33
293730 WI Bayfield   school 5512030 4522 Public school South Shore 551203001574 100 South Shore Jr/Sr High   Regular School No 3.0 07 12 2016   grade_9                                                   19                                             19
294774 WI Bayfield   school 5515540 6027 Public school Washburn 551554001985 40 Washburn High   Regular School No 3.0 09 12 2016   grade_9                                                   40                                             40
326450 WI Bayfield   school 5500900 315 Public school Bayfield 550090000121 40 Bayfield High   Regular School No High 09 12 2017   grade_9                                                   32                                             32
328109 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000396 40 Drummond High   Regular School No High 09 12 2017   grade_9                                                   28                                             28
337622 WI Bayfield   school 5512030 4522 Public school South Shore 551203001574 100 South Shore Jr/Sr High   Regular School No High 07 12 2017   grade_9                                                   15                                             15
338677 WI Bayfield   school 5515540 6027 Public school Washburn 551554001985 40 Washburn High   Regular School No High 09 12 2017   grade_9                                                   37                                             37
2318949 WI Bayfield   school 5500900 315 Public school Bayfield 550090000121 40 Bayfield High   Regular School No High 09 12 2020   grade_9                                                   25                                             25
2320654 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000396 40 Drummond High   Regular School No High 09 12 2020   grade_9                                                   29                                             29
2330229 WI Bayfield   school 5512030 4522 Public school South Shore 551203001574 100 South Shore Jr/Sr High   Regular School No High 07 12 2020   grade_9                                                   15                                             15
2331354 WI Bayfield   school 5515540 6027 Public school Washburn 551554001985 40 Washburn High   Regular School No High 09 12 2020   grade_9                                                   46                                             46
2333734 WI Bayfield   school 5500900 315 Public school Bayfield 550090000121 40 Bayfield High   Regular School No High 09 12 2021   grade_9                                                   22                                             22
2335454 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000396 40 Drummond High   Regular School No High 09 12 2021   grade_9                                                   31                                             31
2345132 WI Bayfield   school 5512030 4522 Public school South Shore 551203001574 100 South Shore Jr/Sr High   Regular School No High 07 12 2021   grade_9                                                   14                                             14
2346277 WI Bayfield   school 5515540 6027 Public school Washburn 551554001985 40 Washburn High   Regular School No High 09 12 2021   grade_9                                                   55                                             55
3074724 WI Bayfield   school 5500900 315 Public school Bayfield 550090000121 40 Bayfield High   Regular School No High 09 12 2019   grade_9                                                   27                                             27
3076426 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000396 40 Drummond High   Regular School No High 09 12 2019   grade_9                                                   26                                             26
3085947 WI Bayfield   school 5512030 4522 Public school South Shore 551203001574 100 South Shore Jr/Sr High   Regular School No High 07 12 2019   grade_9                                                   15                                             15
3087051 WI Bayfield   school 5515540 6027 Public school Washburn 551554001985 40 Washburn High   Regular School No High 09 12 2019   grade_9                                                   56                                             56
3089479 WI Bayfield   school 5500900 315 Public school Bayfield 550090000121 40 Bayfield High   Regular School No High 09 12 2018   grade_9                                                   25                                             25
3091172 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000396 40 Drummond High   Regular School No High 09 12 2018   grade_9                                                   37                                             37
3100678 WI Bayfield   school 5512030 4522 Public school South Shore 551203001574 100 South Shore Jr/Sr High   Regular School No High 07 12 2018   grade_9                                                   7                                             7
3101748 WI Bayfield   school 5515540 6027 Public school Washburn 551554001985 40 Washburn High   Regular School No High 09 12 2018   grade_9                                                   42                                             42
112322 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000081 20 Ashwaubenon High   Regular School No 3.0 09 12 2015   grade_9                                                   261                                             261
114003 WI Brown   school 5503210 1414 Public school De Pere 550321000361 20 De Pere High   Regular School No 3.0 09 12 2015   grade_9                                                   353                                             353
114120 WI Brown   school 5503660 1407 Public school Denmark 550366002936 450 Denmark Community School charter Regular School Yes 3.0 07 12 2015   grade_9                                                   5                                             5
114135 WI Brown   school 5503660 1407 Public school Denmark 550366000388 80 Denmark High   Regular School No 3.0 09 12 2015   grade_9                                                   102                                             102
115383 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative Education School No 4.0 PK 12 2015   grade_9                                                   5                                             5
115429 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative Education School No 4.0 PK 12 2015   grade_9                                                   7                                             7
115438 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000618 180 East High   Regular School No 3.0 09 12 2015   grade_9                                                   301                                             301
115506 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002857 445 John Dewey Academy of Learning charter Regular School Yes 3.0 08 12 2015   grade_9                                                   11                                             11
115601 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000636 540 Preble High   Regular School No 3.0 09 12 2015   grade_9                                                   556                                             556
115618 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000638 600 Southwest High   Regular School No 3.0 09 12 2015   grade_9                                                   325                                             325
115659 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000644 720 West High   Regular School No 3.0 09 12 2015   grade_9                                                   201                                             201
116110 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000716 20 Bay Port High   Regular School No 3.0 09 12 2015   grade_9                                                   453                                             453
122317 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001600 100 Pulaski High   Regular School No 3.0 09 12 2015   grade_9                                                   263                                             263
125776 WI Brown   school 5516320 6328 Public school West De Pere 551632002752 400 Phantom Knight School of Opportunity charter Regular School Yes 3.0 07 12 2015   grade_9                                                   5                                             5
125781 WI Brown   school 5516320 6328 Public school West De Pere 551632002138 120 West De Pere High   Regular School No 3.0 09 12 2015   grade_9                                                   217                                             217
126366 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No 3.0 09 12 2015   grade_9                                                   126                                             126
282302 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000081 20 Ashwaubenon High   Regular School No 3.0 09 12 2016   grade_9                                                   257                                             257
283981 WI Brown   school 5503210 1414 Public school De Pere 550321000361 20 De Pere High   Regular School No 3.0 09 12 2016   grade_9                                                   332                                             332
284100 WI Brown   school 5503660 1407 Public school Denmark 550366002936 450 Denmark Community School charter Regular School Yes 3.0 07 12 2016   grade_9                                                   8                                             8
284115 WI Brown   school 5503660 1407 Public school Denmark 550366000388 80 Denmark High   Regular School No 3.0 09 12 2016   grade_9                                                   117                                             117
285388 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative Education School No 4.0 PK 12 2016   grade_9                                                   1                                             1
285434 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative Education School No 4.0 PK 12 2016   grade_9                                                   3                                             3
285443 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000618 180 East High   Regular School No 3.0 09 12 2016   grade_9                                                   348                                             348
285510 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002857 445 John Dewey Academy of Learning charter Regular School Yes 3.0 08 12 2016   grade_9                                                   26                                             26
285606 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000636 540 Preble High   Regular School No 3.0 09 12 2016   grade_9                                                   512                                             512
285623 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000638 600 Southwest High   Regular School No 3.0 09 12 2016   grade_9                                                   275                                             275
285663 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000644 720 West High   Regular School No 3.0 09 12 2016   grade_9                                                   205                                             205
286107 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000716 20 Bay Port High   Regular School No 3.0 09 12 2016   grade_9                                                   448                                             448
292281 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001600 100 Pulaski High   Regular School No 3.0 09 12 2016   grade_9                                                   284                                             284
295716 WI Brown   school 5516320 6328 Public school West De Pere 551632002752 400 Phantom Knight School of Opportunity charter Regular School Yes 3.0 07 12 2016   grade_9                                                   8                                             8
295721 WI Brown   school 5516320 6328 Public school West De Pere 551632002138 120 West De Pere High   Regular School No 3.0 09 12 2016   grade_9                                                   239                                             239
296303 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No 3.0 09 12 2016   grade_9                                                   119                                             119
326200 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000081 20 Ashwaubenon High   Regular School No High 09 12 2017   grade_9                                                   249                                             249
327900 WI Brown   school 5503210 1414 Public school De Pere 550321000361 20 De Pere High   Regular School No High 09 12 2017   grade_9                                                   347                                             347
328008 WI Brown   school 5503660 1407 Public school Denmark 550366002936 450 Denmark Community School charter Regular School Yes High 07 12 2017   grade_9                                                   8                                             8
328023 WI Brown   school 5503660 1407 Public school Denmark 550366000388 80 Denmark High   Regular School No High 09 12 2017   grade_9                                                   107                                             107
329260 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2017   grade_9                                                   4                                             4
329308 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative School No Other PK 12 2017   grade_9                                                   5                                             5
329317 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000618 180 East High   Regular School No High 09 12 2017   grade_9                                                   327                                             327
329385 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002857 445 John Dewey Academy of Learning charter Regular School Yes High 08 12 2017   grade_9                                                   15                                             15
329481 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000636 540 Preble High   Regular School No High 09 12 2017   grade_9                                                   578                                             578
329498 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000638 600 Southwest High   Regular School No High 09 12 2017   grade_9                                                   297                                             297
329540 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000644 720 West High   Regular School No High 09 12 2017   grade_9                                                   208                                             208
329989 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000716 20 Bay Port High   Regular School No High 09 12 2017   grade_9                                                   470                                             470
336159 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001600 100 Pulaski High   Regular School No High 09 12 2017   grade_9                                                   291                                             291
339641 WI Brown   school 5516320 6328 Public school West De Pere 551632002752 400 Phantom Knight School of Opportunity charter Regular School Yes High 07 12 2017   grade_9                                                   4                                             4
339646 WI Brown   school 5516320 6328 Public school West De Pere 551632002138 120 West De Pere High   Regular School No High 09 12 2017   grade_9                                                   228                                             228
340244 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No High 09 12 2017   grade_9                                                   130                                             130

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