Data source: Big Local News · About: Big Local

3,371,677 rows sorted by low_income_int

View and edit SQL

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
111963 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2015   pk_12_total 2.0   1.0                   2.0 1.0             *     *   3 2   1                   2 1                 3
112378 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2015   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
112536 WI Barron   school 5500870 308 Public school Barron Area 550087002500 9410 North Star Academy charter Alternative Education School Yes 3.0 09 12 2015   pk_12_total 12.0   1.0                   8.0 5.0             *     1   13 12   1                   8 5             1   13
112576 WI Bayfield   school 5500900 315 Public school Bayfield 550090002358 60 La Pointe Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 7.0                   2.0   4.0 5.0             *         9 7                   2   4 5                 9
112845 WI Walworth   school   6013 Public Schools-Multidistrict Charters Big Foot UHS   9401 Walworth Co Educ Alt High charter           2015   pk_12_total 13.0   3.0                   11.0 5.0             *     4   16 13   3                   11 5             4   16
113107 WI Rusk   school 5501830 735 Public school Bruce 550183000234 20 Bruce Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 197.0   16.0 1.0             2.0   120.0 96.0             *     37   216 197   16 1             2   120 96             37   216
113193 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes 3.0 09 12 2015   pk_12_total 4.0                       3.0 1.0             *     *   4 4                       3 1                 4
113281 WI Barron   school   903 Public Schools-Multidistrict Charters Cameron   9410 North Star Academy charter           2015   pk_12_total 11.0                       8.0 3.0             *     3   11 11                       8 3             3   11
113311 WI Milwaukee   school 5500114 8114 Non District Charter Schools Capitol West Academy 550011403355 100 Capitol West Academy charter Regular School Yes 1.0 PK 08 2015   pk_12_total 11.0 241.0 15.0     6.0         11.0   137.0 147.0             *     26   284 11 241 15     6         11   137 147             26   284
113405 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2015   pk_12_total   384.0 5.0 1.0             4.0   197.0 197.0             *     30   394   384 5 1             4   197 197             30   394
113430 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Vocational Education School Yes 3.0 09 12 2015   pk_12_total 4.0   1.0     1.0             3.0 3.0             *     *   6 4   1     1             3 3                 6
113434 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No 1.0 PK 02 2015   pk_12_total 33.0   3.0                   18.0 18.0             *     3   36 33   3                   18 18             3   36
113480 WI Barron   school   1080 Public Schools-Multidistrict Charters Chetek-Weyerhaeuser Area   9410 North Star Academy charter           2015   pk_12_total 8.0                   1.0   5.0 4.0             *     1   9 8                   1   5 4             1   9
113664 WI Clark   school   1162 Public Schools-Multidistrict Charters Colby   9100 Rural Virtual Academy charter           2015   pk_12_total 2.0     1.0                 3.0               *     *   3 2     1                 3                   3
114104 WI Walworth   school   1380 Public Schools-Multidistrict Charters Delavan-Darien   9401 Walworth Co Educ Alt High charter           2015   pk_12_total 6.0   1.0     1.0             7.0 1.0             *     1   8 6   1     1             7 1             1   8
114761 WI Rusk   school 5514970 5757 Public school Flambeau 551497002684 410 Whitetail Academy charter Regular School Yes 3.0 09 12 2015   pk_12_total 5.0                       4.0 1.0             *     *   5 5                       4 1                 5
115257 WI Saint Croix   school 5505520 2198 Public school Glenwood City 550552002469 400 Transitional Skills Center charter Regular School Yes 3.0 10 12 2015   pk_12_total 9.0     1.0                 6.0 4.0             *     2   10 9     1                 6 4             2   10
115627 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000640 640 Tank Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 41.0 33.0 88.0 13.0   26.0         17.0   112.0 106.0             *     28   218 41 33 88 13   26         17   112 106             28   218
116286 WI Waupaca   school   2639 Public Schools-Multidistrict Charters Iola-Scandinavia   9408 Waupaca County Charter charter           2015   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
116471 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative Education School No 4.0 04 12 2015   pk_12_total   1.0                     1.0               *     *   1   1                     1                   1
116482 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2015   pk_12_total 3.0                       1.0 2.0             *     *   3 3                       1 2                 3
116617 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No 1.0 PK PK 2015   pk_12_total 30.0 55.0 68.0               9.0   82.0 80.0             *     11   162 30 55 68               9   82 80             11   162
117016 WI Kewaunee   school 5507410 2814 Public school Kewaunee 550741002768 490 Lakeshore Alternative School   Regular School No 3.0 10 12 2015   pk_12_total 4.0   1.0                   3.0 2.0             *     *   5 4   1                   3 2                 5
117035 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002554 405 Kiel eSchool charter Regular School Yes 3.0 07 12 2015   pk_12_total 5.0                       4.0 1.0             *     *   5 5                       4 1                 5
117291 WI Vernon   school   2863 Public Schools-Multidistrict Charters La Farge   9407 Vernon County Area Better Futures High charter           2015   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
117734 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002909 220 Innovative & Alternative Middle   Alternative Education School No 2.0 06 08 2015   pk_12_total 4.0 7.0 1.0               1.0   8.0 5.0             *         13 4 7 1               1   8 5                 13
117817 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002670 820 Metro School   Alternative Education School No 4.0 04 12 2015   pk_12_total 4.0 13.0 1.0               3.0   16.0 5.0             *     8   21 4 13 1               3   16 5             8   21
117994 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002714 9120 Manitowoc County Comprehensive Charter School charter Special Education School Yes 1.0 01 08 2015   pk_12_total 5.0 3.0                     5.0 3.0             *     *   8 5 3                     5 3                 8
118154 WI Dane   school 5508790 3332 Public school Marshall 550879001791 400 Marshall Charter charter Regular School Yes 3.0 10 12 2015   pk_12_total 5.0   2.0                   5.0 2.0             *     1   7 5   2                   5 2             1   7
119579 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000874 1078 Lad Lake Ultra   Alternative Education School No 4.0 06 12 2015   pk_12_total   6.0                     6.0               *     *   6   6                     6                   6
119936 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002686 865 Project Excel   Alternative Education School No 4.0 06 12 2015   pk_12_total   8.0 1.0                   7.0 2.0             *     *   9   8 1                   7 2                 9
120041 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000936 1086 Southeastern   Alternative Education School No 2.0 06 08 2015   pk_12_total 1.0 17.0 1.0                   12.0 7.0             *     6   19 1 17 1                   12 7             6   19
120045 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002578 805 St Charles Intensive Day Treatment   Alternative Education School No 3.0 07 12 2015   pk_12_total 2.0 33.0 1.0 1.0                 28.0 9.0             *     *   37 2 33 1 1                 28 9                 37
120283 WI Milwaukee   school 5500066 8127 Non District Charter Schools Milwaukee Collegiate Academy 550006602865 400 Milwaukee Collegiate Academy charter Regular School Yes 3.0 09 12 2015   pk_12_total 2.0 259.0                 1.0   116.0 146.0             *     25   262 2 259                 1   116 146             25   262
120288 WI Milwaukee   school 5500067 8128 Non District Charter Schools Milwaukee Math and Science Academy 550006702898 800 Milwaukee Math and Science Academy charter Regular School Yes 1.0 PK 08 2015   pk_12_total 5.0 319.0 6.0 1.0             4.0   160.0 175.0             *     35   335 5 319 6 1             4   160 175             35   335
120660 WI Juneau   school   3871 Public Schools-Multidistrict Charters Necedah Area   9405 Juneau County Charter School charter           2015   pk_12_total 8.0   1.0                   6.0 3.0             *         9 8   1                   6 3                 9
120922 WI Juneau   school 5510560 3948 Public school New Lisbon 551056002517 9405 Juneau County Charter School charter Regular School Yes 3.0 07 12 2015   pk_12_total 5.0                       5.0               *     *   5 5                       5                   5
121052 WI Waukesha   school 5510710 3976 Public school Norris 551071001395 20 Norris High   Regular School No 4.0 06 12 2015   pk_12_total 17.0 25.0 6.0 1.0             3.0   52.0               *     39   52 17 25 6 1             3   52               39   52
121131 WI Milwaukee   school 5500068 8130 Non District Charter Schools North Point Lighthouse Charter School 550006802922 800 North Point Lighthouse Charter School charter Regular School Yes 1.0 PK 06 2015   pk_12_total 1.0 281.0 5.0 1.0           1.0 1.0   168.0 122.0             *     31   290 1 281 5 1           1 1   168 122             31   290
121402 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001853 400 Falls Alternative Learning Site (FALS) charter Regular School Yes 3.0 09 12 2015   pk_12_total 16.0     1.0             1.0   8.0 10.0             *     2   18 16     1             1   8 10             2   18
121406 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095002736 410 New Path charter Alternative Education School Yes 4.0 06 12 2015   pk_12_total 9.0                   1.0   9.0 1.0             *     *   10 9                   1   9 1                 10
122236 WI Price   school   4571 Public Schools-Multidistrict Charters Prentice   9100 Rural Virtual Academy charter           2015   pk_12_total 3.0                       1.0 2.0             *     *   3 3                       1 2                 3
122741 WI Taylor   school   4795 Public Schools-Multidistrict Charters Rib Lake   9100 Rural Virtual Academy charter           2015   pk_12_total 6.0 1.0                     3.0 4.0             *         7 6 1                     3 4                 7
122923 WI Pierce   school 5513050 4893 Public school River Falls 551305002999 430 River Falls eSchool charter Regular School Yes 4.0 06 12 2015   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
123126 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 2015   pk_12_total 8.0                       3.0 5.0             *         8 8                       3 5                 8
123237 WI Milwaukee   school 5500043 8107 Non District Charter Schools School for Early Development and 550004302497 1279 School for Early Development and Achievement (SEDA) charter Regular School Yes 1.0 PK 02 2015   pk_12_total 3.0 22.0 3.0     1.0             22.0 7.0             *     *   29 3 22 3     1             22 7                 29
123243 WI Milwaukee   school 5500057 8121 Non District Charter Schools Seeds of Health Elementary Program 550005702692 100 Seeds of Health Elementary Program charter Regular School Yes 1.0 PK 08 2015   pk_12_total 21.0 17.0 408.0     3.0         5.0   257.0 197.0             *     28   454 21 17 408     3         5   257 197             28   454
123873 WI Marathon   school   5467 Public Schools-Multidistrict Charters Spencer   9100 Rural Virtual Academy charter           2015   pk_12_total 9.0   1.0                   5.0 5.0             *         10 9   1                   5 5                 10
123997 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001125 320 Juvenile Detention   Alternative Education School No 4.0 KG 12 2015   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
124045 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001145 350 Preschool Options   Special Education School No 1.0 PK PK 2015   pk_12_total 1.0     1.0                 1.0 1.0             *     *   2 1     1                 1 1                 2
124136 WI Marathon   school   5628 Public Schools-Multidistrict Charters Stratford   9100 Rural Virtual Academy charter           2015   pk_12_total 3.0                         3.0             *     *   3 3                         3                 3
124524 WI Portage   school 5500330 126 Public school Tomorrow River 550033002984 850 Central Wisconsin Virtual School charter Regular School Yes 4.0 06 12 2015   pk_12_total 2.0                         2.0             *     *   2 2                         2                 2
124566 WI Barron   school   5810 Public Schools-Multidistrict Charters Turtle Lake   9410 North Star Academy charter           2015   pk_12_total 3.0                         3.0             *     *   3 3                         3                 3
124618 WI Manitowoc   school   5824 Public Schools-Multidistrict Charters Two Rivers Public   9120 Manitowoc County Comprehensive Charter School charter           2015   pk_12_total     1.0 1.0                 2.0               *     *   2     1 1                 2                   2
124772 WI Vernon   school 5515360 5985 Public school Viroqua Area 551536002513 9407 Vernon County Area Better Futures High charter Regular School Yes 3.0 10 12 2015   pk_12_total 5.0     1.0                 6.0               *     *   6 5     1                 6                   6
125173 WI Waupaca   school   6195 Public Schools-Multidistrict Charters Waupaca   9408 Waupaca County Charter charter           2015   pk_12_total 2.0                       2.0               *     *   2 2                       2                   2
125458 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002349 190 Plank Road Complex   Alternative Education School No 4.0 KG 12 2015   pk_12_total 7.0 114.0 6.0     1.0         1.0   112.0 17.0             *     61   129 7 114 6     1         1   112 17             61   129
125670 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002918 410 Shared Journeys charter Alternative Education School Yes 3.0 07 12 2015   pk_12_total 7.0 4.0 7.0               2.0   3.0 17.0             *     1   20 7 4 7               2   3 17             1   20
125752 WI Washington   school 5516290 6307 Public school West Bend 551629002666 400 Washington Street School   Alternative Education School No 4.0 06 12 2015   pk_12_total 4.0 3.0                     5.0 2.0             *     1   7 4 3                     5 2             1   7
125820 WI Vernon   school   6321 Public Schools-Multidistrict Charters Westby Area   9407 Vernon County Area Better Futures High charter           2015   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
125903 WI Waupaca   school 5516500 6384 Public school Weyauwega-Fremont 551650002523 9408 Waupaca County Charter charter Regular School Yes 4.0 06 12 2015   pk_12_total 1.0                   1.0   2.0               *     *   2 1                   1   2                   2
126305 WI Juneau   school   6713 Public Schools-Multidistrict Charters Wonewoc-Union Center   9405 Juneau County Charter School charter           2015   pk_12_total   1.0                     1.0               *     *   1   1                     1                   1
281957 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes 1.0 KG 05 2016   pk_12_total 47.0 1.0 95.0     1.0         4.0   68.0 80.0             *     5   148 47 1 95     1         4   68 80             5   148
281969 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000692 400 Appleton Central High charter Regular School Yes 4.0 06 12 2016   pk_12_total 68.0 12.0 19.0 2.0                 61.0 40.0             *     4   101 68 12 19 2                 61 40             4   101
282024 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000050 80 Columbus Elementary   Regular School No 1.0 PK 06 2016   pk_12_total 87.0 20.0 18.0 3.0   16.0         10.0   88.0 66.0             *     27   154 87 20 18 3   16         10   88 66             27   154
282075 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000055 180 Highlands Elementary   Regular School No 1.0 PK 06 2016   pk_12_total 343.0 23.0 70.0 6.0   134.0       1.0 5.0   310.0 272.0             *     115   582 343 23 70 6   134       1 5   310 272             115   582
282084 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002350 190 Horizons Elementary   Regular School No 1.0 PK 06 2016   pk_12_total 194.0 26.0 81.0 3.0   48.0         4.0   193.0 163.0             *     63   356 194 26 81 3   48         4   193 163             63   356
282358 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2016   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
282516 WI Barron   school   308 Public Schools-Multidistrict Charters Barron Area   9410 North Star Academy charter           2016   pk_12_total 11.0   1.0                   10.0 2.0             *         12 11   1                   10 2                 12
282824 WI Walworth   school   6013 Public Schools-Multidistrict Charters Big Foot UHS   9401 Walworth Co Educ Alt High charter           2016   pk_12_total 8.0   2.0                   8.0 2.0             *         10 8   2                   8 2                 10
282859 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes 4.0 PK 12 2016   pk_12_total 2.0                       1.0 1.0             *     *   2 2                       1 1                 2
283089 WI Rusk   school 5501830 735 Public school Bruce 550183000234 20 Bruce Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 175.0 1.0 16.0 1.0             3.0   105.0 91.0             *     30   196 175 1 16 1             3   105 91             30   196
283176 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes 3.0 09 12 2016   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
283263 WI Barron   school 5502130 903 Public school Cameron 550213002500 9410 North Star Academy charter Alternative Education School Yes 3.0 09 12 2016   pk_12_total 11.0 1.0 1.0               1.0   11.0 3.0             *     2   14 11 1 1               1   11 3             2   14
283293 WI Milwaukee   school 5500114 8114 Non District Charter Schools Capitol West Academy 550011403355 100 Capitol West Academy charter Regular School Yes 1.0 PK 08 2016   pk_12_total 11.0 255.0 8.0     5.0         8.0   142.0 145.0             *     32   287 11 255 8     5         8   142 145             32   287
283387 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2016   pk_12_total   430.0 5.0 1.0             4.0   208.0 232.0             *     31   440   430 5 1             4   208 232             31   440
283412 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No 1.0 PK 03 2016   pk_12_total 42.0                       25.0 17.0             *     1   42 42                       25 17             1   42
283458 WI Barron   school   1080 Public Schools-Multidistrict Charters Chetek-Weyerhaeuser Area   9410 North Star Academy charter           2016   pk_12_total 8.0                   1.0   6.0 3.0             *     3   9 8                   1   6 3             3   9
283642 WI Clark   school   1162 Public Schools-Multidistrict Charters Colby   9100 Rural Virtual Academy charter           2016   pk_12_total 4.0                       2.0 2.0             *     *   4 4                       2 2                 4
284019 WI Vernon   school 5503240 1421 Public school De Soto Area 550324003022 810 De Soto Virtual School charter Regular School Yes 4.0 PK 12 2016   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
284082 WI Walworth   school   1380 Public Schools-Multidistrict Charters Delavan-Darien   9401 Walworth Co Educ Alt High charter           2016   pk_12_total 2.0   1.0                   1.0 2.0             *     *   3 2   1                   1 2                 3
284364 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002658 800 Second Avenue School   Alternative Education School No 4.0 04 12 2016   pk_12_total 4.0 3.0                 1.0   7.0 1.0             *     *   8 4 3                 1   7 1                 8
285171 WI Oconto   school 5505250 2128 Public school Gillett 550525002892 100 CRE8 Charter School charter Regular School Yes 1.0 PK 05 2016   pk_12_total 2.0   1.0                   1.0 2.0             *     *   3 2   1                   1 2                 3
285192 WI Oconto   school 5505250 2128 Public school Gillett 550525002906 450 Gillett's Occupation and Leadership Academy charter Regular School Yes 4.0 06 12 2016   pk_12_total 15.0     1.0             1.0   10.0 7.0             *     1   17 15     1             1   10 7             1   17
285263 WI Saint Croix   school 5505520 2198 Public school Glenwood City 550552002469 400 Transitional Skills Center charter Regular School Yes 3.0 10 12 2016   pk_12_total 10.0                       4.0 6.0             *     3   10 10                       4 6             3   10
285477 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No 1.0 PK KG 2016   pk_12_total 38.0 33.0 88.0 5.0   16.0         28.0   96.0 112.0             *     23   208 38 33 88 5   16         28   96 112             23   208
286284 WI Waupaca   school   2639 Public Schools-Multidistrict Charters Iola-Scandinavia   9408 Waupaca County Charter charter           2016   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
286473 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative Education School No 4.0 04 12 2016   pk_12_total     1.0                   1.0               *     *   1     1                   1                   1
286623 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No 1.0 PK PK 2016   pk_12_total 21.0 36.0 48.0     1.0         11.0   73.0 44.0             *     10   117 21 36 48     1         11   73 44             10   117
286705 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002317 280 Hillcrest School   Alternative Education School No 4.0 06 12 2016   pk_12_total 16.0 19.0 10.0               1.0   32.0 14.0             *     25   46 16 19 10               1   32 14             25   46
287023 WI Kewaunee   school 5507410 2814 Public school Kewaunee 550741002768 490 Lakeshore Alternative School   Regular School No 3.0 10 12 2016   pk_12_total     1.0                   1.0               *     *   1     1                   1                   1
287377 WI Jefferson   school   2898 Public Schools-Multidistrict Charters Lake Mills Area   9803 JEDI Virtual K-12 charter           2016   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
287730 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002909 220 Innovative & Alternative Middle   Alternative Education School No 2.0 06 08 2016   pk_12_total 1.0 2.0 3.0               2.0   4.0 4.0             *     2   8 1 2 3               2   4 4             2   8
287813 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002670 820 Metro School   Alternative Education School No 4.0 04 12 2016   pk_12_total 6.0 6.0 1.0 2.0             3.0   11.0 7.0             *     4   18 6 6 1 2             3   11 7             4   18
287989 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002714 9120 Manitowoc County Comprehensive Charter School charter Special Education School Yes 1.0 01 08 2016   pk_12_total 3.0 1.0                 1.0   4.0 1.0             *     *   5 3 1                 1   4 1                 5
288144 WI Dane   school 5508790 3332 Public school Marshall 550879001791 400 Marshall Charter charter Regular School Yes 3.0 10 12 2016   pk_12_total 4.0 1.0                     2.0 3.0             *     *   5 4 1                     2 3                 5
288249 WI Juneau   school 5508850 3360 Public school Mauston 550885003030 110 Mauston Montessori Charter School charter Regular School Yes 1.0 PK 02 2016   pk_12_total 6.0                       4.0 2.0             *     *   6 6                       4 2                 6
290002 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000936 1086 Southeastern   Alternative Education School No 2.0 06 08 2016   pk_12_total   20.0 1.0                   16.0 5.0             *     7   21   20 1                   16 5             7   21
290005 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002555 825 St Charles Behav Reassign Success Acad   Alternative Education School No 4.0 06 12 2016   pk_12_total   5.0 1.0                   5.0 1.0             *     *   6   5 1                   5 1                 6
290245 WI Milwaukee   school 5500067 8128 Non District Charter Schools Milwaukee Math and Science Academy 550006702898 800 Milwaukee Math and Science Academy charter Regular School Yes 1.0 PK 08 2016   pk_12_total 2.0 326.0 8.0 1.0             4.0   144.0 197.0             *     40   341 2 326 8 1             4   144 197             40   341

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