enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
3076298 3076298 WI Dane   school 5503270 1309 Public school Deerfield Community 550327000372 60 Deerfield Middle   Regular School No Middle 07 08 2019   grade_9                                                   1                                             1
3077645 3077645 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000623 300 Franklin Middle   Regular School No Middle 06 08 2019   grade_9                                                   1                                             1
3080376 3080376 WI Dane   school 5508790 3332 Public school Marshall 550879001014 60 Marshall Middle   Regular School No Middle 07 08 2019   grade_9                                                   2                                             2
3090965 3090965 WI Brown   school 5503210 1414 Public school De Pere 550321000362 30 De Pere Middle   Regular School No Middle 07 08 2018   grade_9                                                   1                                             1
3099299 3099299 WI Racine   school 5512360 4620 Public school Racine Unified 551236001616 280 Gilmore Middle   Regular School No Middle 06 08 2018   grade_9                                                   3                                             3
3099341 3099341 WI Racine   school 5512360 4620 Public school Racine Unified 551236001625 282 Jerstad-Agerholm Middle   Regular School No Middle 06 08 2018   grade_9                                                   1                                             1
3099380 3099380 WI Racine   school 5512360 4620 Public school Racine Unified 551236001631 284 McKinley Middle   Regular School No Middle 06 08 2018   grade_9                                                   1                                             1
3099394 3099394 WI Racine   school 5512360 4620 Public school Racine Unified 551236001633 286 Mitchell Middle   Regular School No Middle 06 08 2018   grade_9                                                   6                                             6
113891 113891 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No 4.0 08 09 2015   grade_9                                                   431                                             431
118027 118027 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000980 280 Washington Junior High   Regular School No 2.0 07 09 2015   grade_9                                                   185                                             185
118031 118031 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000981 300 Wilson Junior High   Regular School No 2.0 07 09 2015   grade_9                                                   184                                             184
118348 118348 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002598 9100 Rural Virtual Academy charter Regular School Yes 4.0 PK 09 2015   grade_9                                                   8                                             8
119701 119701 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001164 176 Meir School   Regular School No 4.0 03 09 2015   grade_9                                                   140                                             140
123979 123979 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No 2.0 07 09 2015   grade_9                                                   257                                             257
123983 123983 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002210 360 CARE charter Alternative Education School Yes 2.0 07 09 2015   grade_9                                                   11                                             11
124034 124034 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001877 240 P J Jacobs Junior High   Regular School No 2.0 07 09 2015   grade_9                                                   253                                             253
124188 124188 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No 4.0 08 09 2015   grade_9                                                   564                                             564
125290 125290 WI Marathon   school 5515900 6223 Public school Wausau 551590002054 200 John Muir Middle   Regular School No 2.0 06 09 2015   grade_9                                                   1                                             1
126196 126196 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002291 50 East Junior High   Regular School No 4.0 08 09 2015   grade_9                                                   391                                             391
283875 283875 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No 4.0 08 09 2016   grade_9                                                   413                                             413
288019 288019 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000980 280 Washington Junior High   Regular School No 2.0 07 09 2016   grade_9                                                   181                                             181
288023 288023 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000981 300 Wilson Junior High   Regular School No 2.0 07 09 2016   grade_9                                                   169                                             169
293912 293912 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No 2.0 07 09 2016   grade_9                                                   281                                             281
293916 293916 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002210 360 CARE charter Alternative Education School Yes 2.0 07 09 2016   grade_9                                                   13                                             13
293967 293967 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001877 240 P J Jacobs Junior High   Regular School No 2.0 07 09 2016   grade_9                                                   235                                             235
294122 294122 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No 4.0 08 09 2016   grade_9                                                   628                                             628
296134 296134 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002291 50 East Junior High   Regular School No 4.0 08 09 2016   grade_9                                                   391                                             391
327784 327784 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Other 08 09 2017   grade_9                                                   396                                             396
328699 328699 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002966 210 Fond du Lac STEM Institute charter Regular School Yes Other 06 09 2017   grade_9                                                   14                                             14
331885 331885 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000980 280 Washington Junior High   Regular School No Other 07 09 2017   grade_9                                                   151                                             151
331889 331889 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000981 300 Wilson Junior High   Regular School No Other 07 09 2017   grade_9                                                   167                                             167
337814 337814 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No Other 07 09 2017   grade_9                                                   283                                             283
337818 337818 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002210 360 CARE Concerned About Reaching Everyone charter Alternative School Yes Other 07 09 2017   grade_9                                                   12                                             12
337870 337870 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001877 240 P J Jacobs Junior High   Regular School No Other 07 09 2017   grade_9                                                   231                                             231
338028 338028 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No Other 08 09 2017   grade_9                                                   566                                             566
340073 340073 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002291 50 East Junior High   Regular School No Other 08 09 2017   grade_9                                                   350                                             350
2320322 2320322 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2020   grade_9                                                   408                                             408
2325791 2325791 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003111 454 Green Tree Preparatory Academy charter Regular School Yes Middle 06 09 2020   grade_9                                                   39                                             39
2326259 2326259 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003036 885 Milwaukee Excellence Charter School charter Regular School Yes Middle 06 09 2020   grade_9                                                   117                                             117
2330430 2330430 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No Middle 07 09 2020   grade_9                                                   268                                             268
2330434 2330434 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002210 360 CARE Concerned About Reaching Everyone charter Regular School Yes Middle 07 09 2020   grade_9                                                   9                                             9
2330485 2330485 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001877 240 P J Jacobs Junior High   Regular School No Middle 07 09 2020   grade_9                                                   231                                             231
2330500 2330500 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449003019 290 Point of Discovery School charter Regular School Yes Middle 06 09 2020   grade_9                                                   18                                             18
2330649 2330649 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No Secondary 08 09 2020   grade_9                                                   646                                             646
2335119 2335119 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2021   grade_9                                                   427                                             427
2345326 2345326 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No Middle 07 09 2021   grade_9                                                   274                                             274
2345379 2345379 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001877 240 P J Jacobs Junior High   Regular School No Middle 07 09 2021   grade_9                                                   222                                             222
3076097 3076097 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2019   grade_9                                                   443                                             443
3080227 3080227 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000980 280 Washington Junior High   Regular School No Middle 07 09 2019   grade_9                                                   202                                             202
3080231 3080231 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000981 300 Wilson Junior High   Regular School No Middle 07 09 2019   grade_9                                                   182                                             182
3086140 3086140 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No Middle 07 09 2019   grade_9                                                   283                                             283
3086144 3086144 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002210 360 CARE Concerned About Reaching Everyone charter Alternative School Yes Middle 07 09 2019   grade_9                                                   7                                             7
3086194 3086194 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001877 240 P J Jacobs Junior High   Regular School No Middle 07 09 2019   grade_9                                                   214                                             214
3086209 3086209 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449003019 290 Point of Discovery School charter Regular School Yes Middle 06 09 2019   grade_9                                                   16                                             16
3086355 3086355 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No Secondary 08 09 2019   grade_9                                                   598                                             598
3090838 3090838 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2018   grade_9                                                   455                                             455
3094959 3094959 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000980 280 Washington Junior High   Regular School No Middle 07 09 2018   grade_9                                                   181                                             181
3094963 3094963 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000981 300 Wilson Junior High   Regular School No Middle 07 09 2018   grade_9                                                   181                                             181
3100870 3100870 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No Middle 07 09 2018   grade_9                                                   258                                             258
3100873 3100873 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002210 360 CARE Concerned About Reaching Everyone charter Alternative School Yes Middle 07 09 2018   grade_9                                                   10                                             10
3100923 3100923 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001877 240 P J Jacobs Junior High   Regular School No Middle 07 09 2018   grade_9                                                   208                                             208
3100938 3100938 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449003019 290 Point of Discovery School charter Regular School Yes Middle 06 09 2018   grade_9                                                   10                                             10
3101079 3101079 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No Secondary 08 09 2018   grade_9                                                   578                                             578
3103147 3103147 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002291 50 East Junior High   Regular School No Secondary 08 09 2018   grade_9                                                   353                                             353
115926 115926 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627002867 250 Northern Waters Environmental School charter Regular School Yes 4.0 06 10 2015   grade_9                                                   5                                             5
117142 117142 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High School charter Alternative Education School Yes 4.0 09 10 2015   grade_9                                                   26                                             26
285930 285930 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627002867 250 Northern Waters Environmental School charter Regular School Yes 4.0 06 10 2016   grade_9                                                   5                                             5
288344 288344 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002598 9100 Rural Virtual Academy charter Regular School Yes 4.0 PK 10 2016   grade_9                                                   11                                             11
289670 289670 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001164 176 Meir School   Regular School No 4.0 03 10 2016   grade_9                                                   128                                             128
2319825 2319825 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   grade_9                                                   44                                             44
2340687 2340687 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003111 454 Green Tree Preparatory Academy charter Regular School Yes Middle 06 10 2021   grade_9                                                   58                                             58
2341137 2341137 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003036 885 Milwaukee Excellence Charter School charter Regular School Yes Middle 06 10 2021   grade_9                                                   99                                             99
2345395 2345395 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449003019 290 Point of Discovery School charter Regular School Yes Middle 06 10 2021   grade_9                                                   27                                             27
3091775 3091775 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002966 210 Fond du Lac STEM Institute charter Regular School Yes Middle 06 10 2018   grade_9                                                   19                                             19
287134 287134 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High School charter Alternative Education School Yes 4.0 09 11 2016   grade_9                                                   11                                             11
332218 332218 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002598 9100 Rural Virtual Academy charter Regular School Yes Other PK 11 2017   grade_9                                                   31                                             31
333545 333545 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001164 176 Meir School   Regular School No Other 03 11 2017   grade_9                                                   148                                             148
2334607 2334607 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 11 2021   grade_9                                                   25                                             25
2337611 2337611 WI Dane   school 5500082 8141 Non District Charter Schools Isthmus Montessori Academy Public 550008203085 8141 Isthmus Montessori Academy Public charter Regular School Yes Other PK 11 2021   grade_9                                                   7                                             7
2338515 2338515 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002887 250 La Crosse Polytechnic School charter Regular School Yes Secondary 06 11 2021   grade_9                                                   14                                             14
3077025 3077025 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002966 210 Fond du Lac STEM Institute charter Regular School Yes Secondary 06 11 2019   grade_9                                                   20                                             20
111756 111756 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2015   grade_9                                                   50                                             50
111770 111770 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2015   grade_9                                                   103                                             103
111809 111809 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No 3.0 09 12 2015   grade_9                                                   37                                             37
111826 111826 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No 3.0 07 12 2015   grade_9                                                   63                                             63
111842 111842 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No 3.0 09 12 2015   grade_9                                                   12                                             12
111857 111857 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No 3.0 09 12 2015   grade_9                                                   48                                             48
111874 111874 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond High   Regular School No 4.0 06 12 2015   grade_9                                                   32                                             32
111882 111882 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No 3.0 09 12 2015   grade_9                                                   104                                             104
111901 111901 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No 3.0 09 12 2015   grade_9                                                   98                                             98
111920 111920 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No 3.0 09 12 2015   grade_9                                                   216                                             216
111992 111992 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Appleton Career Academy charter Regular School Yes 3.0 09 12 2015   grade_9                                                   24                                             24
112005 112005 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes 3.0 07 12 2015   grade_9                                                   2                                             2
112019 112019 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   grade_9                                                   8                                             8
112060 112060 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000047 20 East High   Regular School No 3.0 09 12 2015   grade_9                                                   352                                             352
112179 112179 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000597 30 North High   Regular School No 3.0 09 12 2015   grade_9                                                   398                                             398
112191 112191 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002282 420 Renaissance School charter Regular School Yes 3.0 09 12 2015   grade_9                                                   54                                             54
112216 112216 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes 3.0 09 12 2015   grade_9                                                   43                                             43
112223 112223 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes 3.0 07 12 2015   grade_9                                                   10                                             10
112228 112228 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000048 40 West High   Regular School No 3.0 09 12 2015   grade_9                                                   323                                             323

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