Data source: Big Local News · About: Big Local

2,237 rows where grade = "pk_12_total", state = "WI" and year = 2017 sorted by ccd_charter_school

View and edit SQL

year

  • 2017 · 2,237

grade

  • pk_12_total · 2,237
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
325625 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2017   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
325829 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2017   pk_12_total 13.0 1.0                     8.0 6.0             6     3   14 13 1                     8 6         6   3   14
326256 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2017   pk_12_total 5.0                       2.0 3.0             *     *   5 5                       2 3                 5
326415 WI Barron   school   308 Public Schools-Multidistrict Charters Barron Area   9410 North Star Academy charter           2017   pk_12_total 14.0   1.0                   10.0 5.0             2     2   15 14   1                   10 5         2   2   15
326726 WI Walworth   school   6013 Public Schools-Multidistrict Charters Big Foot UHS   9401 Walworth Co Educ Alt High charter           2017   pk_12_total 4.0   2.0                   2.0 4.0             *     *   6 4   2                   2 4                 6
327364 WI Barron   school   1080 Public Schools-Multidistrict Charters Chetek-Weyerhaeuser Area   9410 North Star Academy charter           2017   pk_12_total 10.0                       6.0 4.0             *     1   10 10                       6 4             1   10
327548 WI Clark   school   1162 Public Schools-Multidistrict Charters Colby   9100 Rural Virtual Academy charter           2017   pk_12_total 2.0                         2.0             *     *   2 2                         2                 2
327995 WI Walworth   school   1380 Public Schools-Multidistrict Charters Delavan-Darien   9401 Walworth Co Educ Alt High charter           2017   pk_12_total 4.0   2.0                   2.0 4.0             *     *   6 4   2                   2 4                 6
330367 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2017   pk_12_total 5.0                       2.0 3.0             *     *   5 5                       2 3                 5
330920 WI Vernon   school   5960 Public Schools-Multidistrict Charters Kickapoo Area   9407 Vernon County Area Better Futures High charter           2017   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
331160 WI Vernon   school   2863 Public Schools-Multidistrict Charters La Farge   9407 Vernon County Area Better Futures High charter           2017   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
331231 WI Walworth   school   2884 Public Schools-Multidistrict Charters Lake Geneva-Genoa City UHS   9401 Walworth Co Educ Alt High charter           2017   pk_12_total 20.0   2.0               2.0   12.0 12.0             5     1   24 20   2               2   12 12         5   1   24
331251 WI Jefferson   school   2898 Public Schools-Multidistrict Charters Lake Mills Area   9803 JEDI Virtual K-12 charter           2017   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
331824 WI Waupaca   school   3276 Public Schools-Multidistrict Charters Manawa   9408 Waupaca County Charter charter           2017   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
332095 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12             2017   pk_12_total 8.0                       2.0 6.0             1     1   8 8                       2 6         1   1   8
334256 WI Green   school   3682 Public Schools-Multidistrict Charters Monroe   9803 JEDI Virtual K-12 charter           2017   pk_12_total 3.0   1.0                   1.0 3.0             *     *   4 3   1                   1 3                 4
334351 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2017   pk_12_total 10.0   1.0 2.0             1.0   5.0 9.0             2     1   14 10   1 2             1   5 9         2   1   14
334495 WI Juneau   school   3871 Public Schools-Multidistrict Charters Necedah Area   9405 Juneau County Charter School charter           2017   pk_12_total 6.0                       3.0 3.0             *     *   6 6                       3 3                 6
335799 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2017   pk_12_total 5.0                       2.0 3.0             *     *   5 5                       2 3                 5
336075 WI Price   school   4571 Public Schools-Multidistrict Charters Prentice   9100 Rural Virtual Academy charter           2017   pk_12_total 12.0                       4.0 8.0                       12 12                       4 8                 12
336599 WI Taylor   school   4795 Public Schools-Multidistrict Charters Rib Lake   9100 Rural Virtual Academy charter           2017   pk_12_total 8.0 1.0                     5.0 4.0                   1   9 8 1                     5 4             1   9
337718 WI Marathon   school   5467 Public Schools-Multidistrict Charters Spencer   9100 Rural Virtual Academy charter           2017   pk_12_total 11.0   1.0                   8.0 4.0                   1   12 11   1                   8 4             1   12
337942 WI Dane   school   5621 Public Schools-Multidistrict Charters Stoughton Area   9803 JEDI Virtual K-12 charter           2017   pk_12_total 12.0   2.0               2.0   6.0 10.0             2     4   16 12   2               2   6 10         2   4   16
337975 WI Marathon   school   5628 Public Schools-Multidistrict Charters Stratford   9100 Rural Virtual Academy charter           2017   pk_12_total 5.0                       1.0 4.0             *     *   5 5                       1 4                 5
338051 WI Dane   school   5656 Public Schools-Multidistrict Charters Sun Prairie Area   9803 JEDI Virtual K-12 charter           2017   pk_12_total 9.0 1.0                     6.0 4.0             3         10 9 1                     6 4         3       10
338402 WI Barron   school   5810 Public Schools-Multidistrict Charters Turtle Lake   9410 North Star Academy charter           2017   pk_12_total 3.0   1.0               1.0   2.0 3.0             *     *   5 3   1               1   2 3                 5
339037 WI Waupaca   school   6195 Public Schools-Multidistrict Charters Waupaca   9408 Waupaca County Charter charter           2017   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
339686 WI Vernon   school   6321 Public Schools-Multidistrict Charters Westby Area   9407 Vernon County Area Better Futures High charter           2017   pk_12_total 3.0                       1.0 2.0             *     *   3 3                       1 2                 3
325608 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2017   pk_12_total 170.0 7.0 197.0 1.0             2.0   201.0 176.0             197     44   377 170 7 197 1             2   201 176         197   44   377
325617 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No Other 06 12 2017   pk_12_total 192.0 5.0 142.0     3.0         3.0   171.0 174.0             220     37   345 192 5 142     3         3   171 174         220   37   345
325627 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   pk_12_total 367.0 12.0 49.0 3.0   1.0         5.0   206.0 231.0             301     82   437 367 12 49 3   1         5   206 231         301   82   437
325636 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2017   pk_12_total 445.0 5.0 29.0 6.0   1.0         3.0   249.0 240.0             316     96   489 445 5 29 6   1         3   249 240         316   96   489
325641 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2017   pk_12_total 309.0 4.0 14.0 3.0           1.0 2.0   169.0 164.0             218     66   333 309 4 14 3           1 2   169 164         218   66   333
325646 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   pk_12_total 129.0 5.0 23.0 1.0             3.0   100.0 61.0             126     44   161 129 5 23 1             3   100 61         126   44   161
325655 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   pk_12_total 129.0   6.0 1.0                 65.0 71.0             100     29   136 129   6 1                 65 71         100   29   136
325668 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2017   pk_12_total 143.0 1.0 8.0               4.0   76.0 80.0             68     22   156 143 1 8               4   76 80         68   22   156
325677 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2017   pk_12_total 98.0 2.0 2.0     1.0         2.0   51.0 54.0             28     12   105 98 2 2     1         2   51 54         28   12   105
325682 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2017   pk_12_total 340.0 1.0 25.0 3.0   3.0         8.0   198.0 182.0             162     66   380 340 1 25 3   3         8   198 182         162   66   380
325693 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2017   pk_12_total 313.0 6.0 12.0 3.0   1.0       1.0 3.0   173.0 166.0             97     36   339 313 6 12 3   1       1 3   173 166         97   36   339
325700 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2017   pk_12_total 167.0 1.0 11.0 1.0   1.0         2.0   98.0 85.0             52     26   183 167 1 11 1   1         2   98 85         52   26   183
325711 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2017   pk_12_total 61.0 1.0 2.0     2.0         1.0   36.0 31.0             18     16   67 61 1 2     2         1   36 31         18   16   67
325716 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2017   pk_12_total 280.0 4.0 58.0 5.0           2.0 4.0   172.0 181.0             218     60   353 280 4 58 5           2 4   172 181         218   60   353
325726 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2017   pk_12_total 143.0 2.0 22.0 4.0                 98.0 73.0             80     24   171 143 2 22 4                 98 73         80   24   171
325731 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2017   pk_12_total 64.0   15.0     2.0         1.0   42.0 40.0             48     7   82 64   15     2         1   42 40         48   7   82
325734 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No Elementary 01 05 2017   pk_12_total 96.0   42.0               1.0   77.0 62.0             65     23   139 96   42               1   77 62         65   23   139
325740 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond High   Regular School No Other 06 12 2017   pk_12_total 162.0 1.0 46.0 1.0                 123.0 87.0             89     33   210 162 1 46 1                 123 87         89   33   210
325748 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000025 60 Bancroft Elementary   Regular School No Elementary PK KG 2017   pk_12_total 46.0   13.0 1.0                 32.0 28.0             22     6   60 46   13 1                 32 28         22   6   60
325752 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2017   pk_12_total 513.0 9.0 32.0     10.0         32.0   332.0 264.0             227     76   596 513 9 32     10         32   332 264         227   76   596
325759 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2017   pk_12_total 364.0 9.0 13.0 5.0   11.0       1.0 16.0   231.0 188.0             103     47   419 364 9 13 5   11       1 16   231 188         103   47   419
325764 WI Eau Claire   school 5500270 112 Public school Altoona 550027002925 100 Altoona Intermediate   Regular School No Elementary 04 05 2017   pk_12_total 180.0 2.0 13.0 1.0   5.0         19.0   100.0 120.0             83     18   220 180 2 13 1   5         19   100 120         83   18   220
325767 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2017   pk_12_total 291.0 5.0 21.0     2.0       1.0 25.0   189.0 156.0             127     38   345 291 5 21     2       1 25   189 156         127   38   345
325771 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2017   pk_12_total 416.0 4.0 20.0 5.0   6.0         10.0   232.0 229.0             135     63   461 416 4 20 5   6         10   232 229         135   63   461
325776 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2017   pk_12_total 307.0 4.0 5.0 1.0   1.0         9.0   170.0 157.0             134     44   327 307 4 5 1   1         9   170 157         134   44   327
325780 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2017   pk_12_total 323.0 2.0 9.0 2.0   1.0         4.0   185.0 156.0             135     48   341 323 2 9 2   1         4   185 156         135   48   341
325784 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2017   pk_12_total 367.0 3.0 14.0 2.0   3.0         13.0   223.0 179.0             155     49   402 367 3 14 2   3         13   223 179         155   49   402
325790 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2017   pk_12_total 730.0 4.0 34.0 15.0   9.0         17.0   440.0 369.0             311     114   809 730 4 34 15   9         17   440 369         311   114   809
325795 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 06 08 2017   pk_12_total 448.0 8.0 33.0 8.0   1.0         18.0   268.0 248.0             276     87   516 448 8 33 8   1         18   268 248         276   87   516
325799 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2017   pk_12_total 107.0   15.0 5.0   1.0         3.0   71.0 60.0             59     27   131 107   15 5   1         3   71 60         59   27   131
325806 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2017   pk_12_total 130.0 3.0 1.0 3.0             7.0   89.0 55.0             85     35   144 130 3 1 3             7   89 55         85   35   144
325814 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2017   pk_12_total 129.0 2.0 11.0 2.0             10.0   91.0 63.0             118     27   154 129 2 11 2             10   91 63         118   27   154
325821 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2017   pk_12_total 227.0 1.0 7.0 3.0   1.0         8.0   131.0 116.0             103     31   247 227 1 7 3   1         8   131 116         103   31   247
325837 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No Elementary PK 05 2017   pk_12_total 113.0 2.0 5.0 1.0                 64.0 57.0             67     13   121 113 2 5 1                 64 57         67   13   121
325844 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No Elementary PK 05 2017   pk_12_total 175.0 6.0 30.0 2.0   3.0         12.0   112.0 116.0             160     55   228 175 6 30 2   3         12   112 116         160   55   228
325859 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Elementary PK PK 2017   pk_12_total 659.0 25.0 106.0 2.0   119.0       1.0 70.0   504.0 478.0             345     143   982 659 25 106 2   119       1 70   504 478         345   143   982
325861 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002679 800 Appleton Cooperative Educational Center   Alternative School No Other 04 12 2017   pk_12_total 1.0   1.0 1.0                 2.0 1.0             *     *   3 1   1 1                 2 1                 3
325882 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003021 820 Appleview   Special Education School No Other PK 12 2017   pk_12_total 41.0                   2.0   22.0 21.0             7     *   43 41                   2   22 21         7       43
325892 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2017   pk_12_total 184.0 37.0 61.0 5.0   37.0       2.0 19.0   169.0 176.0             188     56   345 184 37 61 5   37       2 19   169 176         188   56   345
325900 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No Elementary PK 06 2017   pk_12_total 369.0 5.0 17.0     28.0         5.0   238.0 186.0             72     71   424 369 5 17     28         5   238 186         72   71   424
325918 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000050 80 Columbus Elementary   Regular School No Elementary PK 06 2017   pk_12_total 89.0 17.0 23.0 2.0   8.0         14.0   78.0 75.0             111     31   153 89 17 23 2   8         14   78 75         111   31   153
325927 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000047 20 East High   Regular School No High 09 12 2017   pk_12_total 967.0 54.0 161.0 12.0   171.0       1.0 4.0   711.0 659.0             511     202   1370 967 54 161 12   171       1 4   711 659         511   202   1370
325932 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000051 100 Edison Elementary   Regular School No Elementary PK 06 2017   pk_12_total 200.0 34.0 8.0 2.0   23.0         6.0   143.0 130.0             149     62   273 200 34 8 2   23         6   143 130         149   62   273
325941 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000052 120 Einstein Middle   Regular School No Middle 07 08 2017   pk_12_total 443.0 24.0 24.0 6.0   37.0         3.0   297.0 240.0             142     89   537 443 24 24 6   37         3   297 240         142   89   537
325944 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002426 130 Ferber Elementary   Regular School No Elementary PK 06 2017   pk_12_total 469.0 27.0 42.0     78.0       1.0 17.0   340.0 294.0             204     116   634 469 27 42     78       1 17   340 294         204   116   634
325967 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000054 160 Franklin Elementary   Regular School No Elementary PK 06 2017   pk_12_total 241.0 18.0 37.0 2.0   57.0       4.0 10.0   209.0 160.0             162     84   369 241 18 37 2   57       4 10   209 160         162   84   369
325976 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000055 180 Highlands Elementary   Regular School No Elementary PK 06 2017   pk_12_total 328.0 20.0 79.0 2.0   144.0       1.0 15.0   306.0 283.0             356     139   589 328 20 79 2   144       1 15   306 283         356   139   589
325985 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002350 190 Horizons Elementary   Regular School No Elementary PK 06 2017   pk_12_total 188.0 23.0 94.0 4.0   49.0         17.0   189.0 186.0             226     80   375 188 23 94 4   49         17   189 186         226   80   375
325993 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002366 195 Houdini Elementary   Regular School No Elementary PK 06 2017   pk_12_total 520.0 21.0 28.0 3.0   31.0         10.0   321.0 292.0             183     101   613 520 21 28 3   31         10   321 292         183   101   613
326001 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000056 200 Huntley Elementary   Regular School No Elementary PK 06 2017   pk_12_total 580.0 21.0 31.0 10.0   44.0       1.0 11.0   364.0 334.0             172     101   698 580 21 31 10   44       1 11   364 334         172   101   698
326009 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000057 240 Jefferson Elementary   Regular School No Elementary PK 06 2017   pk_12_total 231.0 29.0 58.0 2.0   19.0         19.0   186.0 172.0             211     52   358 231 29 58 2   19         19   186 172         211   52   358
326017 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000058 260 Johnston Elementary   Regular School No Elementary PK 06 2017   pk_12_total 295.0 37.0 50.0 5.0   91.0         19.0   260.0 237.0             251     109   497 295 37 50 5   91         19   260 237         251   109   497
326030 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000059 280 Lincoln Elementary   Regular School No Elementary PK 06 2017   pk_12_total 200.0 22.0 42.0 7.0   86.0         15.0   196.0 176.0             216     64   372 200 22 42 7   86         15   196 176         216   64   372
326039 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000060 300 Madison Middle   Regular School No Middle 07 08 2017   pk_12_total 466.0 23.0 93.0 6.0   94.0         5.0   332.0 355.0             290     103   687 466 23 93 6   94         5   332 355         290   103   687
326042 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000061 320 McKinley Elementary   Regular School No Elementary PK 06 2017   pk_12_total 297.0 30.0 99.0 1.0   89.0         15.0   272.0 259.0             292     84   531 297 30 99 1   89         15   272 259         292   84   531
326051 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000597 30 North High   Regular School No High 09 12 2017   pk_12_total 1249.0 78.0 121.0 7.0   171.0       4.0 6.0   840.0 796.0             431     206   1636 1249 78 121 7   171       4 6   840 796         431   206   1636
326068 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000062 340 Richmond Elementary   Regular School No Elementary PK 06 2017   pk_12_total 216.0 8.0 32.0 1.0   15.0         7.0   141.0 138.0             117     33   279 216 8 32 1   15         7   141 138         117   33   279
326096 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000048 40 West High   Regular School No High 09 12 2017   pk_12_total 736.0 76.0 104.0 7.0   147.0       1.0 11.0   562.0 520.0             472     198   1082 736 76 104 7   147       1 11   562 520         472   198   1082
326101 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000065 410 Wilson Middle   Regular School No Middle 07 08 2017   pk_12_total 218.0 23.0 60.0 2.0   79.0         9.0   202.0 189.0             229     69   391 218 23 60 2   79         9   202 189         229   69   391
326118 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003040 190 Arcadia Elementary   Regular School No Elementary PK 04 2017   pk_12_total 144.0 3.0 386.0 2.0   1.0         5.0   289.0 252.0             394     51   541 144 3 386 2   1         5   289 252         394   51   541
326126 WI Trempealeau   school 5500420 154 Public school Arcadia 550042000068 40 Arcadia High   Regular School No High 09 12 2017   pk_12_total 228.0 2.0 125.0               1.0   186.0 170.0             172     37   356 228 2 125               1   186 170         172   37   356
326131 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003041 290 Arcadia Middle   Regular School No Middle 05 08 2017   pk_12_total 144.0 3.0 203.0                   184.0 166.0             232     42   350 144 3 203                   184 166         232   42   350
326136 WI Lafayette   school 5500450 161 Public school Argyle 550045000069 20 Argyle Elementary   Regular School No Elementary PK 05 2017   pk_12_total 136.0   2.0               1.0   64.0 75.0             44     27   139 136   2               1   64 75         44   27   139
326145 WI Lafayette   school 5500450 161 Public school Argyle 550045000070 40 Argyle High   Regular School No Other 06 12 2017   pk_12_total 155.0   7.0     2.0         1.0   87.0 78.0             45     17   165 155   7     2         1   87 78         45   17   165
326153 WI Waukesha   school 5506180 2450 Public school Arrowhead UHS 550618000678 20 Arrowhead High   Regular School No High 09 12 2017   pk_12_total 2017.0 12.0 73.0 7.0   40.0       1.0 40.0   1118.0 1072.0             123     174   2190 2017 12 73 7   40       1 40   1118 1072         123   174   2190
326167 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2017   pk_12_total 461.0 3.0 12.0 121.0   6.0         32.0   349.0 286.0             297     113   635 461 3 12 121   6         32   349 286         297   113   635
326172 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2017   pk_12_total 273.0 2.0 10.0 96.0   1.0         21.0   218.0 185.0             228     54   403 273 2 10 96   1         21   218 185         228   54   403
326176 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2017   pk_12_total 187.0 3.0 7.0 108.0   1.0         29.0   152.0 183.0             225     55   335 187 3 7 108   1         29   152 183         225   55   335
326180 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2017   pk_12_total 218.0     93.0           1.0 26.0   171.0 167.0             213     65   338 218     93           1 26   171 167         213   65   338
326185 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2017   pk_12_total 172.0     1.0             2.0   93.0 82.0             140     10   175 172     1             2   93 82         140   10   175
326196 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000081 20 Ashwaubenon High   Regular School No High 09 12 2017   pk_12_total 821.0 31.0 67.0 38.0   24.0       1.0 60.0   555.0 487.0             239     126   1042 821 31 67 38   24       1 60   555 487         239   126   1042
326201 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000294 55 Cormier School and Early Learning Center   Regular School No Elementary PK KG 2017   pk_12_total 285.0 12.0 16.0 7.0   17.0         38.0   194.0 181.0             124     46   375 285 12 16 7   17         38   194 181         124   46   375

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