Data source: Big Local News · About: Big Local

7,833 rows where grade = "grade_2" and state = "WI" sorted by ccd_school_high_grade descending

View and edit SQL

year

grade

  • grade_2 · 7,833
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
112237 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes 4.0 KG 12 2015   grade_2                                                   29                                             29
112508 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   grade_2                                                   1                                             1
113254 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative Education School Yes 4.0 KG 12 2015   grade_2                                                   6                                             6
113470 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes 4.0 PK 12 2015   grade_2                                                   4                                             4
113879 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes 4.0 PK 12 2015   grade_2                                                   2                                             2
115378 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_2                                                   3                                             3
115894 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627003339 800 Hayward Ctr for Individualized Learning charter Regular School Yes 4.0 PK 12 2015   grade_2                                                   9                                             9
116736 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002910 800 Kenosha eSchool K-12 charter Regular School Yes 4.0 KG 12 2015   grade_2                                                   8                                             8
118363 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2015   grade_2                                                   20                                             20
118589 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No 4.0 PK 12 2015   grade_2                                                   11                                             11
118604 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes 4.0 PK 12 2015   grade_2                                                   49                                             49
118674 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   grade_2                                                   2                                             2
119345 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong Amer Peace Academy K3-12 charter Regular School Yes 4.0 PK 12 2015   grade_2                                                   100                                             100
119648 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No 4.0 PK 12 2015   grade_2                                                   31                                             31
119907 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002993 840 Obama School of Career and Technical Education   Regular School No 4.0 PK 12 2015   grade_2                                                   19                                             19
120142 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002967 875 Universal Academy for the College Bound charter Regular School Yes 4.0 PK 12 2015   grade_2                                                   71                                             71
120226 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 WI Conservatory of Lifelong Learning   Regular School No 4.0 PK 12 2015   grade_2                                                   41                                             41
120251 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes 4.0 PK 12 2015   grade_2                                                   99                                             99
120478 WI Marquette   school 5509870 3689 Public school Montello 550987003016 800 Montello Virtual Charter School charter Regular School Yes 4.0 KG 12 2015   grade_2                                                   1                                             1
121163 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes 4.0 PK 12 2015   grade_2                                                   31                                             31
122264 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No 4.0 PK 12 2015   grade_2                                                   25                                             25
123690 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No 4.0 PK 12 2015   grade_2                                                   14                                             14
123904 WI Washburn   school 5514220 5474 Public school Spooner Area 551422002971 850 Spooner Area Virtual Education Academy charter Regular School Yes 4.0 PK 12 2015   grade_2                                                   7                                             7
282211 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes 4.0 KG 12 2016   grade_2                                                   25                                             25
282488 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   grade_2                                                   1                                             1
282693 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No 4.0 PK 12 2016   grade_2                                                   1                                             1
283236 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative Education School Yes 4.0 KG 12 2016   grade_2                                                   8                                             8
283448 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes 4.0 PK 12 2016   grade_2                                                   9                                             9
284507 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes 4.0 PK 12 2016   grade_2                                                   6                                             6
285428 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_2                                                   2                                             2
285897 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627003339 800 Hayward Ctr for Individualized Learning charter Regular School Yes 4.0 PK 12 2016   grade_2                                                   15                                             15
286334 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2016   grade_2                                                   2                                             2
286742 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002910 800 Kenosha eSchool K-12 charter Regular School Yes 4.0 KG 12 2016   grade_2                                                   4                                             4
288359 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2016   grade_2                                                   19                                             19
288589 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No 4.0 PK 12 2016   grade_2                                                   8                                             8
288604 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes 4.0 PK 12 2016   grade_2                                                   57                                             57
288674 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_2                                                   2                                             2
289326 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong Amer Peace Academy K3-12 charter Regular School Yes 4.0 PK 12 2016   grade_2                                                   117                                             117
289617 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No 4.0 PK 12 2016   grade_2                                                   44                                             44
289876 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002993 840 Obama School of Career and Technical Education   Regular School No 4.0 PK 12 2016   grade_2                                                   21                                             21
290097 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002967 875 Universal Academy for the College Bound charter Regular School Yes 4.0 PK 12 2016   grade_2                                                   91                                             91
290183 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 WI Conservatory of Lifelong Learning   Regular School No 4.0 PK 12 2016   grade_2                                                   49                                             49
290208 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes 4.0 PK 12 2016   grade_2                                                   94                                             94
291121 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes 4.0 PK 12 2016   grade_2                                                   24                                             24
292145 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes 4.0 KG 12 2016   grade_2                                                   1                                             1
292227 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No 4.0 PK 12 2016   grade_2                                                   25                                             25
293084 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606002989 850 Saint Croix Academy of Virtual Education charter Regular School Yes 4.0 KG 12 2016   grade_2                                                   1                                             1
293645 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No 4.0 PK 12 2016   grade_2                                                   17                                             17
326109 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   grade_2                                                   22                                             22
326387 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_2                                                   1                                             1
327132 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_2                                                   5                                             5
327354 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2017   grade_2                                                   4                                             4
328406 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes Other PK 12 2017   grade_2                                                   13                                             13
329301 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_2                                                   2                                             2
329776 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627003339 800 Hayward Ctr for Individualized Learning charter Regular School Yes Other PK 12 2017   grade_2                                                   23                                             23
330209 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2017   grade_2                                                   3                                             3
330621 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002910 800 Kenosha eSchool K-12 charter Regular School Yes Other KG 12 2017   grade_2                                                   7                                             7
332233 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2017   grade_2                                                   30                                             30
332460 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2017   grade_2                                                   8                                             8
332475 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes Other PK 12 2017   grade_2                                                   57                                             57
332544 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2017   grade_2                                                   1                                             1
333196 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong American Peace Academy K3-12 charter Regular School Yes Other PK 12 2017   grade_2                                                   137                                             137
333487 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No Other PK 12 2017   grade_2                                                   48                                             48
333772 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002993 840 Obama School of Career and Technical Education   Regular School No Other PK 12 2017   grade_2                                                   19                                             19
333989 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002967 875 Universal Academy for the College Bound charter Regular School Yes Other PK 12 2017   grade_2                                                   72                                             72
334075 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 Wisconsin Conservatory of Lifelong Learning   Regular School No Other PK 12 2017   grade_2                                                   35                                             35
334100 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2017   grade_2                                                   91                                             91
334311 WI Marquette   school 5509870 3689 Public school Montello 550987003016 800 Montello Virtual Charter School charter Regular School Yes Other KG 12 2017   grade_2                                                   1                                             1
334975 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2017   grade_2                                                   31                                             31
336023 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes Other KG 12 2017   grade_2                                                   1                                             1
336106 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No Other PK 12 2017   grade_2                                                   16                                             16
336337 WI Racine   school 5512360 4620 Public school Racine Unified 551236003045 801 Racine Alternative Learning   Alternative School No Other KG 12 2017   grade_2                                                   1                                             1
336961 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606002989 850 Saint Croix Academy of Virtual Education charter Regular School Yes Other KG 12 2017   grade_2                                                   3                                             3
337536 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No Other PK 12 2017   grade_2                                                   28                                             28
338452 WI Manitowoc   school 5515120 5824 Public school Two Rivers Public 551512003037 810 Lighthouse Learning Academy charter Regular School Yes Other PK 12 2017   grade_2                                                   1                                             1
2318597 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2020   grade_2                                                   16                                             16
2319659 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2020   grade_2                                                   7                                             7
2319885 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2020   grade_2                                                   3                                             3
2320297 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2020   grade_2                                                   1                                             1
2320964 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes Other PK 12 2020   grade_2                                                   12                                             12
2321846 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative School No Other KG 12 2020   grade_2                                                   1                                             1
2322320 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627003339 800 Hayward Ctr for Individualized Learning charter Regular School Yes Other PK 12 2020   grade_2                                                   13                                             13
2322745 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 12 2020   grade_2                                                   25                                             25
2322785 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   grade_2                                                   1                                             1
2323849 WI Jefferson   school 5507710 2898 Public school Lake Mills Area 550771002901 9803 JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive charter Alternative School Yes Other PK 12 2020   grade_2                                                   1                                             1
2324846 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002598 9100 Rural Virtual Academy charter Regular School Yes Other PK 12 2020   grade_2                                                   42                                             42
2324869 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2020   grade_2                                                   22                                             22
2325088 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2020   grade_2                                                   14                                             14
2325104 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes Other PK 12 2020   grade_2                                                   69                                             69
2325828 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong American Peace Academy K3-12 charter Regular School Yes Other PK 12 2020   grade_2                                                   150                                             150
2326106 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No Other PK 12 2020   grade_2                                                   56                                             56
2326386 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002993 840 Obama School of Career and Technical Education   Regular School No Other PK 12 2020   grade_2                                                   19                                             19
2326680 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 Wisconsin Conservatory of Lifelong Learning   Regular School No Other PK 12 2020   grade_2                                                   25                                             25
2326705 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2020   grade_2                                                   95                                             95
2327259 WI Wood   school 5510380 3906 Public school Nekoosa 551038003089 800 WISE Academy charter Regular School Yes Other PK 12 2020   grade_2                                                   17                                             17
2327617 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2020   grade_2                                                   8                                             8
2328673 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes Other KG 12 2020   grade_2                                                   1                                             1
2328756 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No Other PK 12 2020   grade_2                                                   19                                             19
2328968 WI Racine   school 5512360 4620 Public school Racine Unified 551236003045 801 Racine Alternative Learning   Alternative School No Other KG 12 2020   grade_2                                                   1                                             1
2329347 WI Fond du Lac   school 5513020 4872 Public school Ripon Area 551302003102 800 Odyssey Academy of Virtual Learning charter Regular School Yes Other PK 12 2020   grade_2                                                   14                                             14

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