Data source: Big Local News · About: Big Local

14,664 rows where state = "WI" and year = 2017 sorted by asian_int

View and edit SQL

year

  • 2017 · 14,664
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
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
325664 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2017   pk_12_total 68.0   5.0     1.0         1.0   38.0 37.0             32     14   75 68   5     1         1   38 37         32   14   75
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
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
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
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
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
325868 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2017   pk_12_total 145.0 1.0 6.0     1.0         2.0   78.0 77.0             29     6   155 145 1 6     1         2   78 77         29   6   155
325877 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2017   pk_12_total 57.0 1.0 9.0     1.0         1.0   64.0 5.0             24     18   69 57 1 9     1         1   64 5         24   18   69
326089 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2017   pk_12_total 65.0   1.0 1.0   1.0         1.0   26.0 43.0             12     2   69 65   1 1   1         1   26 43         12   2   69
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
326163 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes Elementary 03 05 2017   pk_12_total 58.0   2.0 8.0   1.0         3.0   33.0 39.0             34     7   72 58   2 8   1         3   33 39         34   7   72
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
326271 WI Eau Claire   school 5500630 217 Public school Augusta 550063000093 40 Augusta High   Regular School No High 09 12 2017   pk_12_total 128.0 1.0 13.0 5.0   1.0         2.0   86.0 64.0             51     32   150 128 1 13 5   1         2   86 64         51   32   150
326301 WI Saint Croix   school 5500720 231 Public school Baldwin-Woodville Area 550072000096 90 Viking Middle   Regular School No Middle 06 08 2017   pk_12_total 338.0 2.0 8.0 1.0   1.0         10.0   187.0 173.0             70     56   360 338 2 8 1   1         10   187 173         70   56   360
326321 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary PK 05 2017   pk_12_total 260.0 9.0 50.0 2.0   1.0         25.0   174.0 173.0             225     64   347 260 9 50 2   1         25   174 173         225   64   347
326328 WI Sauk   school 5500810 280 Public school Baraboo 550081002803 150 Baraboo Early Learning Cooperative   Regular School No Elementary PK PK 2017   pk_12_total 12.0 2.0 3.0     1.0         2.0   12.0 8.0             2     1   20 12 2 3     1         2   12 8         2   1   20
326330 WI Sauk   school 5500810 280 Public school Baraboo 550081002802 160 Baraboo Early Learning Cooperative Renewal Head Start of Baraboo   Regular School No Elementary PK PK 2017   pk_12_total 122.0 5.0 8.0 6.0   1.0         5.0   86.0 61.0             19     17   147 122 5 8 6   1         5   86 61         19   17   147
326366 WI Iowa   school 5500840 287 Public school Barneveld 550084000111 20 Barneveld Elementary   Regular School No Elementary PK 05 2017   pk_12_total 218.0 3.0 2.0     1.0         2.0   120.0 106.0             26     14   226 218 3 2     1         2   120 106         26   14   226
326374 WI Iowa   school 5500840 287 Public school Barneveld 550084000112 40 Barneveld High   Regular School No Other 06 12 2017   pk_12_total 213.0 1.0 3.0     1.0         6.0   104.0 120.0             26     15   224 213 1 3     1         6   104 120         26   15   224
326438 WI Bayfield   school 5500900 315 Public school Bayfield 550090000120 20 Bayfield Elementary   Regular School No Elementary PK 05 2017   pk_12_total 13.0   5.0 137.0   1.0         1.0   82.0 75.0             124     34   157 13   5 137   1         1   82 75         124   34   157
326446 WI Bayfield   school 5500900 315 Public school Bayfield 550090000121 40 Bayfield High   Regular School No High 09 12 2017   pk_12_total 24.0 1.0 9.0 87.0   1.0         1.0   58.0 65.0             78     38   123 24 1 9 87   1         1   58 65         78   38   123
326552 WI Dane   school 5500990 350 Public school Belleville 550099000133 60 Belleville Middle   Regular School No Middle 07 08 2017   pk_12_total 130.0   6.0     1.0         8.0   66.0 79.0             30     11   145 130   6     1         8   66 79         30   11   145
326565 WI Lafayette   school 5501020 364 Public school Belmont Community 550102000135 40 Belmont High   Regular School No Other 06 12 2017   pk_12_total 180.0 1.0 8.0     1.0             96.0 94.0             69     17   190 180 1 8     1             96 94         69   17   190
326589 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No Other PK 12 2017   pk_12_total 34.0 5.0 8.0     1.0         5.0   24.0 29.0             28     4   53 34 5 8     1         5   24 29         28   4   53
326623 WI Rock   school 5501050 413 Public school Beloit 550105000142 120 Hackett Elementary   Regular School No Elementary PK 03 2017   pk_12_total 87.0 90.0 154.0 5.0   1.0       1.0 37.0   207.0 168.0             324     58   375 87 90 154 5   1       1 37   207 168         324   58   375
326745 WI Washburn   school 5501170 441 Public school Birchwood 550117000169 40 Birchwood High   Regular School No High 09 12 2017   pk_12_total 60.0   2.0     1.0         2.0   37.0 28.0             31     12   65 60   2     1         2   37 28         31   12   65
326750 WI Washburn   school 5501170 441 Public school Birchwood 550117003374 210 Birchwood Middle   Regular School No Middle 06 08 2017   pk_12_total 55.0 1.0 1.0 1.0   1.0         2.0   26.0 35.0             27     14   61 55 1 1 1   1         2   26 35         27   14   61
326786 WI Jackson   school 5501260 476 Public school Black River Falls 550126000174 60 Black River Falls Middle   Regular School No Middle 06 08 2017   pk_12_total 258.0 7.0 16.0 78.0   1.0       1.0 9.0   191.0 179.0             165     50   370 258 7 16 78   1       1 9   191 179         165   50   370
326795 WI Jackson   school 5501260 476 Public school Black River Falls 550126002428 130 Red Creek Elementary   Regular School No Elementary 02 05 2017   pk_12_total 341.0 11.0 8.0 133.0   1.0         10.0   262.0 242.0             275     74   504 341 11 8 133   1         10   262 242         275   74   504
326800 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2017   pk_12_total 299.0 4.0 12.0 1.0   1.0         1.0   156.0 162.0             144     49   318 299 4 12 1   1         1   156 162         144   49   318
326851 WI Shawano   school 5501470 602 Public school Bonduel 550147000189 40 Bonduel High   Regular School No High 09 12 2017   pk_12_total 274.0 2.0 11.0 13.0   1.0         2.0   157.0 146.0             76     35   303 274 2 11 13   1         2   157 146         76   35   303
326875 WI Grant   school 5501500 609 Public school Boscobel Area 550150000194 60 Boscobel Junior High   Regular School No Middle 07 08 2017   pk_12_total 109.0 1.0 6.0     1.0             60.0 57.0             56     22   117 109 1 6     1             60 57         56   22   117
326894 WI Dunn   school 5501590 637 Public school Boyceville Community 550159000202 40 Boyceville High   Regular School No High 09 12 2017   pk_12_total 199.0 1.0 3.0     1.0         1.0   103.0 102.0             67     42   205 199 1 3     1         1   103 102         67   42   205
326930 WI Calumet   school 5501680 658 Public school Brillion 550168000207 40 Brillion High   Regular School No High 09 12 2017   pk_12_total 292.0   19.0 2.0   1.0         7.0   154.0 167.0             66     46   321 292   19 2   1         7   154 167         66   46   321
326935 WI Calumet   school 5501680 658 Public school Brillion 550168002384 21 Brillion Middle   Regular School No Middle 06 08 2017   pk_12_total 190.0 2.0 19.0 1.0   1.0         5.0   114.0 104.0             64     30   218 190 2 19 1   1         5   114 104         64   30   218
327004 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   pk_12_total 23.0 1.0 1209.0     1.0         1.0   600.0 635.0             1     91   1235 23 1 1209     1         1   600 635         1   91   1235
327123 WI Dane   school 5502100 896 Public school Cambridge 550210000298 60 Nikolay Middle   Regular School No Middle 06 08 2017   pk_12_total 186.0 4.0 8.0     1.0         4.0   110.0 93.0             51     29   203 186 4 8     1         4   110 93         51   29   203
327170 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000259 40 Campbellsport High   Regular School No High 09 12 2017   pk_12_total 398.0 2.0 18.0     1.0       1.0 6.0   212.0 214.0             78     59   426 398 2 18     1       1 6   212 214         78   59   426
327179 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No Elementary PK 05 2017   pk_12_total 202.0 1.0 24.0 1.0   1.0         10.0   131.0 108.0             78     54   239 202 1 24 1   1         10   131 108         78   54   239
327256 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Elementary PK PK 2017   pk_12_total 10.0         1.0             7.0 4.0             1     *   11 10         1             7 4         1       11
327449 WI Polk   school 5502580 1120 Public school Clayton 550258000290 40 Clayton High   Regular School No High 09 12 2017   pk_12_total 109.0         1.0             53.0 57.0             48     19   110 109         1             53 57         48   19   110
327466 WI Polk   school 5502610 1127 Public school Clear Lake 550261000291 20 Gaylord A Nelson Educational Center   Regular School No Elementary PK 06 2017   pk_12_total 320.0 1.0 11.0 1.0   1.0         8.0   180.0 162.0             140     47   342 320 1 11 1   1         8   180 162         140   47   342
327522 WI Buffalo   school 5502700 1155 Public school Cochrane-Fountain City 550270000307 40 Cochrane-Fountain City High   Regular School No High 07 12 2017   pk_12_total 310.0 3.0 11.0     1.0         6.0   171.0 160.0             101     40   331 310 3 11     1         6   171 160         101   40   331
327541 WI Clark   school 5502730 1162 Public school Colby 550273001226 210 Colby Middle   Regular School No Middle 06 08 2017   pk_12_total 149.0 1.0 49.0 1.0   1.0         1.0   109.0 93.0             105     26   202 149 1 49 1   1         1   109 93         105   26   202
327559 WI Marinette   school 5502760 1169 Public school Coleman 550276000314 60 Coleman High   Regular School No High 09 12 2017   pk_12_total 204.0 1.0 9.0     1.0         5.0   117.0 103.0             2     34   220 204 1 9     1         5   117 103         2   34   220
327564 WI Marinette   school 5502760 1169 Public school Coleman 550276002847 200 Coleman Middle   Regular School No Middle 06 08 2017   pk_12_total 135.0 1.0 3.0     1.0         6.0   70.0 76.0             1     13   146 135 1 3     1         6   70 76         1   13   146
327578 WI Dunn   school 5502790 1176 Public school Colfax 550279000316 40 Colfax High   Regular School No High 07 12 2017   pk_12_total 364.0 4.0 5.0 4.0   1.0         1.0   197.0 182.0             149     61   379 364 4 5 4   1         1   197 182         149   61   379
327603 WI Columbia   school 5502820 1183 Public school Columbus 550282002734 110 Discovery Charter School charter Regular School Yes Elementary KG 03 2017   pk_12_total 98.0 2.0 8.0     1.0         4.0   55.0 58.0             16     20   113 98 2 8     1         4   55 58         16   20   113
327608 WI Chippewa   school 5502880 1204 Public school Cornell 550288000323 20 Cornell Elementary   Regular School No Elementary PK 05 2017   pk_12_total 189.0 3.0 5.0 1.0   1.0             88.0 111.0             134     39   199 189 3 5 1   1             88 111         134   39   199
327634 WI Forest   school 5502910 1218 Public school Crandon 550291000327 60 Crandon High   Regular School No High 09 12 2017   pk_12_total 156.0 1.0 3.0 62.0   1.0       1.0 15.0   136.0 103.0             106     40   239 156 1 3 62   1       1 15   136 103         106   40   239
327673 WI Grant   school 5503030 1246 Public school Cuba City 550303000333 40 Cuba City High   Regular School No High 09 12 2017   pk_12_total 233.0 1.0 4.0     1.0         2.0   131.0 110.0             64     35   241 233 1 4     1         2   131 110         64   35   241
327731 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No Elementary PK 04 2017   pk_12_total 322.0 3.0 35.0 20.0   1.0         9.0   200.0 190.0             183     85   390 322 3 35 20   1         9   200 190         183   85   390
327739 WI Barron   school 5503090 1260 Public school Cumberland 550309000344 60 Cumberland High   Regular School No High 09 12 2017   pk_12_total 232.0 1.0 23.0 12.0   1.0         2.0   141.0 130.0             103     36   271 232 1 23 12   1         2   141 130         103   36   271
327744 WI Barron   school 5503090 1260 Public school Cumberland 550309000304 50 Cumberland Middle   Regular School No Middle 05 08 2017   pk_12_total 230.0 3.0 22.0 10.0   1.0       1.0 3.0   153.0 117.0             107     41   270 230 3 22 10   1       1 3   153 117         107   41   270
327849 WI Lafayette   school 5503150 1295 Public school Darlington Community 550315000348 40 Darlington High   Regular School No High 09 12 2017   pk_12_total 197.0 1.0 20.0     1.0             110.0 109.0             59     16   219 197 1 20     1             110 109         59   16   219
327998 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364003052 150 Wileman Elementary   Regular School No Elementary PK KG 2017   pk_12_total 94.0 5.0 146.0 2.0   1.0         11.0   130.0 129.0             174     51   259 94 5 146 2   1         11   130 129         174   51   259
328064 WI Iowa   school 5503690 1428 Public school Dodgeville 550369000393 60 Ridgeway Elementary   Regular School No Elementary PK 05 2017   pk_12_total 52.0 2.0 7.0 1.0   1.0         4.0   37.0 30.0             34     2   67 52 2 7 1   1         4   37 30         34   2   67
328135 WI Walworth   school 5504020 1540 Public school East Troy Community 550402000410 40 East Troy High   Regular School No High 09 12 2017   pk_12_total 527.0 3.0 34.0 5.0   1.0         13.0   280.0 303.0             95     50   583 527 3 34 5   1         13   280 303         95   50   583
328144 WI Walworth   school 5504020 1540 Public school East Troy Community 550402001640 100 Prairie View Elementary   Regular School No Elementary 02 05 2017   pk_12_total 361.0 6.0 30.0     1.0         19.0   224.0 193.0             117     51   417 361 6 30     1         19   224 193         117   51   417
328290 WI Marathon   school 5504080 1561 Public school Edgar 550408000441 40 Edgar High   Regular School No High 09 12 2017   pk_12_total 184.0 3.0 1.0 2.0   1.0             105.0 86.0             42     20   191 184 3 1 2   1             105 86         42   20   191
328295 WI Marathon   school 5504080 1561 Public school Edgar 550408002391 23 Edgar Middle   Regular School No Middle 06 08 2017   pk_12_total 120.0   1.0 2.0   1.0       1.0     60.0 65.0             35     17   125 120   1 2   1       1     60 65         35   17   125
328345 WI Trempealeau   school 5504200 1600 Public school Eleva-Strum 550420000450 60 Eleva-Strum High   Regular School No High 07 12 2017   pk_12_total 246.0 4.0 19.0 1.0   1.0         1.0   150.0 122.0             85     31   272 246 4 19 1   1         1   150 122         85   31   272
328387 WI Sheboygan   school 5504260 1631 Public school Elkhart Lake-Glenbeulah 550426000456 40 Elkhart Lake High   Regular School No High 09 12 2017   pk_12_total 144.0   1.0     1.0         4.0   70.0 80.0             40     24   150 144   1     1         4   70 80         40   24   150
328446 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000464 40 Ellsworth High   Regular School No High 09 12 2017   pk_12_total 469.0 3.0 6.0 2.0   1.0         10.0   267.0 224.0             116     61   491 469 3 6 2   1         10   267 224         116   61   491
328456 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000465 60 Hillcrest Elementary   Regular School No Elementary KG 04 2017   pk_12_total 335.0 1.0 12.0 2.0   1.0         7.0   178.0 180.0             108     47   358 335 1 12 2   1         7   178 180         108   47   358
328533 WI Pierce   school 5504350 1666 Public school Elmwood 550435000471 40 Elmwood High   Regular School No High 09 12 2017   pk_12_total 89.0   3.0     1.0             40.0 53.0             18     6   93 89   3     1             40 53         18   6   93
328542 WI Washington   school 5504410 1687 Public school Erin 550441000476 20 Erin Elementary   Regular School No Elementary PK 08 2017   pk_12_total 356.0 1.0 19.0     1.0         3.0   197.0 183.0             32     32   380 356 1 19     1         3   197 183         32   32   380
328579 WI Eau Claire   school 5504500 1729 Public school Fall Creek 550450000480 20 Fall Creek Elementary   Regular School No Elementary PK 05 2017   pk_12_total 381.0 5.0 1.0     1.0         1.0   202.0 187.0             100     63   389 381 5 1     1         1   202 187         100   63   389
328596 WI Columbia   school 5504530 1736 Public school Fall River 550453000483 20 Fall River Elementary   Regular School No Elementary PK 05 2017   pk_12_total 211.0 3.0 17.0 1.0   1.0         9.0   113.0 129.0             107     37   242 211 3 17 1   1         9   113 129         107   37   242
328695 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002966 210 Fond du Lac STEM Institute charter Regular School Yes Other 06 09 2017   pk_12_total 99.0 5.0 3.0     1.0         3.0   70.0 41.0             34     15   111 99 5 3     1         3   70 41         34   15   111
328788 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474002749 130 Fort Atkinson 4K   Regular School No Elementary PK PK 2017   pk_12_total 103.0 1.0 12.0     1.0             66.0 51.0             2     2   117 103 1 12     1             66 51         2   2   117
328815 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474000514 180 Rockwell Elementary   Regular School No Elementary PK 05 2017   pk_12_total 213.0 6.0 49.0     1.0       1.0 2.0   146.0 126.0             125     16   272 213 6 49     1       1 2   146 126         125   16   272
329035 WI Door   school 5505220 2114 Public school Gibraltar Area 550522002245 100 Gibraltar Elementary   Regular School No Elementary PK 06 2017   pk_12_total 234.0 1.0 35.0     1.0         9.0   150.0 130.0             85     22   280 234 1 35     1         9   150 130         85   22   280
329044 WI Door   school 5505220 2114 Public school Gibraltar Area 550522000561 120 Gibraltar High   Regular School No High 09 12 2017   pk_12_total 179.0   9.0 1.0   1.0         1.0   82.0 109.0             42     12   191 179   9 1   1         1   82 109         42   12   191
329061 WI Oconto   school 5505250 2128 Public school Gillett 550525000564 20 Gillett High   Regular School No High 09 12 2017   pk_12_total 134.0 2.0 7.0 4.0   1.0       1.0 4.0   78.0 75.0             65     28   153 134 2 7 4   1       1 4   78 75         65   28   153
329094 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537000574 60 Gilmanton High   Regular School No High 09 12 2017   pk_12_total 44.0         1.0         1.0   14.0 32.0             12     7   46 44         1         1   14 32         12   7   46
329189 WI Clark   school 5505640 2226 Public school Granton Area 550564000599 20 Granton Elementary   Regular School No Elementary PK 05 2017   pk_12_total 101.0   8.0     1.0         8.0   56.0 62.0             72     11   118 101   8     1         8   56 62         72   11   118
329197 WI Clark   school 5505640 2226 Public school Granton Area 550564000600 40 Granton High   Regular School No Other 06 12 2017   pk_12_total 98.0 1.0 11.0 1.0   1.0         4.0   66.0 50.0             72     18   116 98 1 11 1   1         4   66 50         72   18   116
329209 WI Burnett   school 5505670 2233 Public school Grantsburg 550567000602 80 Grantsburg High   Regular School No High 09 12 2017   pk_12_total 235.0 8.0 7.0 1.0   1.0         9.0   139.0 122.0             81     33   261 235 8 7 1   1         9   139 122         81   33   261
329743 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002913 130 Hartland Fine Arts Leadership Academy charter Regular School Yes Elementary KG 02 2017   pk_12_total 53.0 1.0 2.0     1.0         2.0   21.0 38.0             8     3   59 53 1 2     1         2   21 38         8   3   59
329751 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002837 200 LIFE-Learning Innovating Fueling Excelling Entrepreneur Magnet School   Regular School No Middle 06 08 2017   pk_12_total 67.0   2.0     1.0             39.0 31.0             11     13   70 67   2     1             39 31         11   13   70
329786 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627000690 40 Hayward High   Regular School No High 09 12 2017   pk_12_total 330.0 2.0 15.0 141.0   1.0       2.0 25.0   271.0 245.0             257     91   516 330 2 15 141   1       2 25   271 245         257   91   516
329811 WI Dodge   school 5500075 2525 Public school Herman-Neosho-Rubicon 550007503033 100 Honor Elementary   Regular School No Elementary PK 04 2017   pk_12_total 188.0   9.0     1.0         7.0   91.0 114.0             49     17   205 188   9     1         7   91 114         49   17   205
329824 WI Iowa   school 5506420 2527 Public school Highland 550642000698 20 Highland Community Elementary charter Regular School Yes Elementary PK 05 2017   pk_12_total 134.0 1.0 3.0     1.0         5.0   73.0 71.0             39     19   144 134 1 3     1         5   73 71         39   19   144
329832 WI Iowa   school 5506420 2527 Public school Highland 550642000699 40 Highland Community High charter Regular School Yes High 09 12 2017   pk_12_total 78.0         1.0         2.0   40.0 41.0             10     14   81 78         1         2   40 41         10   14   81
329921 WI Dodge   school 5506570 2576 Public school Horicon 550657000713 80 Horicon Junior High   Regular School No Middle 07 08 2017   pk_12_total 95.0 3.0 12.0     1.0         4.0   63.0 52.0             41     18   115 95 3 12     1         4   63 52         41   18   115
329924 WI Dodge   school 5506570 2576 Public school Horicon 550657000711 40 Van Brunt Elementary   Regular School No Elementary PK 06 2017   pk_12_total 315.0 7.0 29.0 2.0   1.0       1.0 23.0   193.0 185.0             160     78   378 315 7 29 2   1       1 23   193 185         160   78   378
329950 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002848 150 Hortonville Area K4 School   Regular School No Elementary PK PK 2017   pk_12_total 145.0 2.0 5.0     1.0         1.0   88.0 66.0             9     7   154 145 2 5     1         1   88 66         9   7   154
330023 WI Sheboygan   school 5506660 2605 Public school Howards Grove 550666000721 60 Howards Grove High   Regular School No High 09 12 2017   pk_12_total 258.0 5.0 5.0 2.0   1.0         1.0   142.0 130.0             31     32   272 258 5 5 2   1         1   142 130         31   32   272
330028 WI Sheboygan   school 5506660 2605 Public school Howards Grove 550666000563 125 Howards Grove Middle   Regular School No Middle 05 08 2017   pk_12_total 229.0 2.0 6.0     1.0         2.0   130.0 110.0             27     29   240 229 2 6     1         2   130 110         27   29   240
330064 WI Saint Croix   school 5506690 2611 Public school Hudson 550669000730 100 North Hudson Elementary   Regular School No Elementary KG 05 2017   pk_12_total 285.0   9.0     1.0       1.0 11.0   163.0 144.0             66     51   307 285   9     1       1 11   163 144         66   51   307
330161 WI Iowa   school 5506870 2646 Public school Iowa-Grant 550687000744 20 Iowa-Grant Elementary/Middle   Regular School No Elementary PK 08 2017   pk_12_total 524.0 1.0 34.0     1.0         6.0   277.0 289.0             227     82   566 524 1 34     1         6   277 289         227   82   566
330173 WI Iowa   school 5506870 2646 Public school Iowa-Grant 550687000745 40 Iowa-Grant High   Regular School No High 09 12 2017   pk_12_total 179.0 1.0 2.0     1.0         1.0   100.0 84.0             61     35   184 179 1 2     1         1   100 84         61   35   184
330178 WI Richland   school 5506960 2660 Public school Ithaca 550696000751 40 Ithaca Elementary   Regular School No Elementary PK 05 2017   pk_12_total 207.0   4.0     1.0       2.0 1.0   112.0 103.0             99     26   215 207   4     1       2 1   112 103         99   26   215

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