Data source: Big Local News · About: Big Local

14,664 rows where state = "WI" and year = 2017 sorted by pacific_islander_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
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
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
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
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
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
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
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
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
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
326026 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002759 250 Kaleidoscope Academy charter Regular School Yes Middle 06 08 2017   pk_12_total 468.0 42.0 42.0 5.0   48.0       1.0 12.0   307.0 311.0             238     103   618 468 42 42 5   48       1 12   307 311         238   103   618
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
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
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
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
326205 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000083 45 Parkview Middle   Regular School No Middle 06 08 2017   pk_12_total 546.0 17.0 53.0 24.0   22.0       1.0 47.0   337.0 373.0             204     93   710 546 17 53 24   22       1 47   337 373         204   93   710
326209 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000084 50 Pioneer Elementary   Regular School No Elementary KG 05 2017   pk_12_total 404.0 15.0 17.0 7.0   25.0       1.0 28.0   248.0 249.0             119     57   497 404 15 17 7   25       1 28   248 249         119   57   497
326216 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No Elementary KG 05 2017   pk_12_total 530.0 25.0 57.0 19.0   23.0       1.0 60.0   354.0 361.0             286     91   715 530 25 57 19   23       1 60   354 361         286   91   715
326332 WI Sauk   school 5500810 280 Public school Baraboo 550081000103 40 Baraboo High   Regular School No High 09 12 2017   pk_12_total 834.0 3.0 73.0 34.0   9.0       1.0 10.0   507.0 457.0             305     137   964 834 3 73 34   9       1 10   507 457         305   137   964
326382 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   pk_12_total 42.0   14.0             1.0 1.0   29.0 29.0             30     2   58 42   14             1 1   29 29         30   2   58
326430 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No Elementary PK 04 2017   pk_12_total 204.0 59.0 35.0 1.0   6.0       1.0 15.0   180.0 141.0             199     60   321 204 59 35 1   6       1 15   180 141         199   60   321
326511 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096000130 180 Wilson Elementary   Regular School No Elementary PK 05 2017   pk_12_total 214.0 10.0 52.0     4.0       1.0 23.0   148.0 156.0             153     20   304 214 10 52     4       1 23   148 156         153   20   304
326616 WI Rock   school 5501050 413 Public school Beloit 550105000141 110 Gaston Elementary   Regular School No Elementary PK 03 2017   pk_12_total 189.0 68.0 67.0 5.0           1.0 38.0   195.0 173.0             276     50   368 189 68 67 5           1 38   195 173         276   50   368
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
326630 WI Rock   school 5501050 413 Public school Beloit 550105002330 180 McNeel Intermediate   Regular School No Elementary 04 08 2017   pk_12_total 273.0 133.0 220.0 1.0   4.0       1.0 57.0   332.0 357.0             535     58   689 273 133 220 1   4       1 57   332 357         535   58   689
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
326878 WI Shawano   school 5501560 623 Public school Bowler 550156000199 20 Bowler Elementary   Regular School No Elementary PK 06 2017   pk_12_total 92.0   12.0 74.0           1.0 20.0   102.0 97.0             100     46   199 92   12 74           1 20   102 97         100   46   199
326887 WI Shawano   school 5501560 623 Public school Bowler 550156000200 40 Bowler High   Regular School No High 07 12 2017   pk_12_total 63.0   3.0 47.0           1.0 19.0   68.0 65.0             61     31   133 63   3 47           1 19   68 65         61   31   133
326979 WI Milwaukee   school 5501800 721 Public school Brown Deer 550180000230 40 Brown Deer Middle/High   Regular School No High 07 12 2017   pk_12_total 191.0 415.0 52.0 5.0   85.0       1.0 42.0   406.0 385.0             332     131   791 191 415 52 5   85       1 42   406 385         332   131   791
327022 WI Racine   school 5501890 777 Public school Burlington Area 550189000239 60 Cooper Elementary   Regular School No Elementary PK 04 2017   pk_12_total 345.0 7.0 49.0 1.0   3.0       1.0 18.0   229.0 195.0             131     65   424 345 7 49 1   3       1 18   229 195         131   65   424
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
327208 WI Monroe   school 5502340 980 Public school Cashton 550234000263 40 Cashton Middle/High   Regular School No Other 06 12 2017   pk_12_total 265.0 3.0 35.0 2.0           1.0 4.0   142.0 168.0             111     46   310 265 3 35 2           1 4   142 168         111   46   310
327233 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2017   pk_12_total 354.0 4.0 33.0 1.0   9.0       1.0 4.0   232.0 174.0             78     52   406 354 4 33 1   9       1 4   232 174         78   52   406
327246 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243001629 200 Cedar Grove-Belgium Middle   Regular School No Middle 05 08 2017   pk_12_total 262.0 1.0 32.0 1.0   4.0       1.0 3.0   164.0 140.0             55     25   304 262 1 32 1   4       1 3   164 140         55   25   304
327258 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000271 70 Parkview Elementary   Regular School No Elementary PK 05 2017   pk_12_total 423.0 1.0 17.0 2.0   9.0       1.0 9.0   241.0 221.0             44     39   462 423 1 17 2   9       1 9   241 221         44   39   462
327274 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246000273 100 Webster Middle   Regular School No Middle 06 08 2017   pk_12_total 607.0 9.0 23.0 1.0   21.0       1.0 17.0   343.0 336.0             50     64   679 607 9 23 1   21       1 17   343 336         50   64   679
327391 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000281 40 Chippewa Falls Middle   Regular School No Middle 06 08 2017   pk_12_total 997.0 19.0 24.0 7.0   24.0       1.0 24.0   569.0 527.0             424     150   1096 997 19 24 7   24       1 24   569 527         424   150   1096
327402 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000285 120 Hillcrest Elementary   Regular School No Elementary KG 05 2017   pk_12_total 400.0 2.0 4.0     2.0       1.0 17.0   216.0 210.0             123     53   426 400 2 4     2       1 17   216 210         123   53   426
327416 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Elementary PK PK 2017   pk_12_total 361.0 3.0 13.0 2.0   9.0       1.0 15.0   236.0 168.0             95     62   404 361 3 13 2   9       1 15   236 168         95   62   404
327419 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000637 220 Parkview Elementary   Regular School No Elementary KG 05 2017   pk_12_total 432.0 7.0 26.0 1.0   4.0       1.0 20.0   270.0 221.0             294     71   491 432 7 26 1   4       1 20   270 221         294   71   491
327592 WI Columbia   school 5502820 1183 Public school Columbus 550282000318 40 Columbus High   Regular School No High 09 12 2017   pk_12_total 343.0 5.0 9.0 5.0   9.0       1.0 9.0   186.0 195.0             62     39   381 343 5 9 5   9       1 9   186 195         62   39   381
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
327639 WI Forest   school 5502910 1218 Public school Crandon 550291002388 22 Crandon Middle   Regular School No Middle 06 08 2017   pk_12_total 114.0   9.0 63.0           1.0 8.0   99.0 96.0             87     31   195 114   9 63           1 8   99 96         87   31   195
327653 WI Marinette   school 5502970 1232 Public school Crivitz 550297000330 40 Crivitz High   Regular School No High 09 12 2017   pk_12_total 187.0 1.0 2.0             1.0 14.0   112.0 93.0             81     26   205 187 1 2             1 14   112 93         81   26   205
327683 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306002389 22 Cudahy Middle   Regular School No Middle 06 08 2017   pk_12_total 319.0 51.0 135.0 9.0   11.0       1.0 25.0   289.0 262.0             304     79   551 319 51 135 9   11       1 25   289 262         304   79   551
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
327768 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002963 190 D C Everest 4K Community Partnership   Regular School No Elementary PK PK 2017   pk_12_total 299.0 6.0 11.0     33.0       1.0 10.0   194.0 166.0             5     28   360 299 6 11     33       1 10   194 166         5   28   360
327788 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001737 50 Evergreen Elementary   Regular School No Elementary PK 05 2017   pk_12_total 404.0 3.0 35.0 6.0   38.0       1.0 10.0   259.0 238.0             149     40   497 404 3 35 6   38       1 10   259 238         149   40   497
327828 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001741 120 Weston Elementary   Regular School No Elementary PK 05 2017   pk_12_total 290.0 10.0 50.0 5.0   163.0       1.0 31.0   296.0 254.0             319     72   550 290 10 50 5   163       1 31   296 254         319   72   550
327870 WI Dane   school 5503180 1316 Public school De Forest Area 550318000356 50 De Forest Middle   Regular School No Middle 05 08 2017   pk_12_total 833.0 37.0 54.0 2.0   39.0       1.0 39.0   504.0 501.0             175     96   1005 833 37 54 2   39       1 39   504 501         175   96   1005
327896 WI Brown   school 5503210 1414 Public school De Pere 550321000361 20 De Pere High   Regular School No High 09 12 2017   pk_12_total 1260.0 31.0 59.0 9.0   30.0       1.0 38.0   734.0 694.0             238     165   1428 1260 31 59 9   30       1 38   734 694         238   165   1428
328140 WI Walworth   school 5504020 1540 Public school East Troy Community 550402000411 60 East Troy Middle   Regular School No Middle 06 08 2017   pk_12_total 351.0 6.0 15.0     2.0       1.0 6.0   193.0 188.0             91     24   381 351 6 15     2       1 6   193 188         91   24   381
328168 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Eau Claire Community Sites   Special Education School No Elementary PK PK 2017   pk_12_total 460.0 7.0 24.0 3.0   28.0       1.0 31.0   269.0 285.0             158     59   554 460 7 24 3   28       1 31   269 285         158   59   554
328171 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000417 100 Flynn Elementary   Regular School No Elementary KG 05 2017   pk_12_total 234.0 12.0 28.0     15.0       1.0 22.0   171.0 141.0             163     35   312 234 12 28     15       1 22   171 141         163   35   312
328206 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000705 580 McKinley Charter School charter Alternative School Yes Other 06 12 2017   pk_12_total 76.0 9.0 6.0 4.0   5.0       1.0 13.0   63.0 51.0             66     15   114 76 9 6 4   5       1 13   63 51         66   15   114
328224 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000431 400 North High   Regular School No High 09 12 2017   pk_12_total 1018.0 45.0 44.0 10.0   184.0       1.0 38.0   694.0 646.0             484     171   1340 1018 45 44 10   184       1 38   694 646         484   171   1340
328250 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000436 460 Robbins Elementary   Regular School No Elementary KG 05 2017   pk_12_total 367.0 8.0 35.0     47.0       1.0 25.0   251.0 232.0             125     46   483 367 8 35     47       1 25   251 232         125   46   483
328277 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002297 540 South Middle   Regular School No Middle 06 08 2017   pk_12_total 663.0 15.0 50.0     43.0       1.0 41.0   417.0 396.0             228     90   813 663 15 50     43       1 41   417 396         228   90   813
328281 WI Marathon   school 5504080 1561 Public school Edgar 550408000440 20 Edgar Elementary   Regular School No Elementary PK 05 2017   pk_12_total 289.0   7.0 2.0   2.0       1.0     163.0 138.0             83     36   301 289   7 2   2       1     163 138         83   36   301
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
328363 WI Dunn   school 5504230 1645 Public school Elk Mound Area 550423000452 20 Elk Mound Middle   Regular School No Middle 05 08 2017   pk_12_total 339.0 5.0 12.0     23.0       1.0 2.0   207.0 175.0             118     29   382 339 5 12     23       1 2   207 175         118   29   382
328392 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429000459 40 Elkhorn Area High   Regular School No High 09 12 2017   pk_12_total 723.0 11.0 119.0 3.0   12.0       1.0 15.0   474.0 410.0             232     86   884 723 11 119 3   12       1 15   474 410         232   86   884
328465 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000468 120 Prairie View Elementary   Regular School No Elementary KG 04 2017   pk_12_total 193.0 2.0 3.0             1.0 7.0   113.0 93.0             52     29   206 193 2 3             1 7   113 93         52   29   206
328471 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000216 40 Brookfield Elementary   Regular School No Elementary PK 05 2017   pk_12_total 428.0 13.0 40.0 1.0   87.0       1.0 15.0   291.0 294.0             23     74   585 428 13 40 1   87       1 15   291 294         23   74   585
328498 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000215 60 East High   Regular School No High 09 12 2017   pk_12_total 939.0 50.0 60.0 4.0   126.0       1.0 33.0   622.0 591.0             83     123   1213 939 50 60 4   126       1 33   622 591         83   123   1213
328503 WI Waukesha   school 5501770 714 Public school Elmbrook 550177002331 150 Pilgrim Park Middle   Regular School No Middle 06 08 2017   pk_12_total 586.0 27.0 46.0 2.0   101.0       1.0 33.0   420.0 376.0             72     63   796 586 27 46 2   101       1 33   420 376         72   63   796
328507 WI Waukesha   school 5501770 714 Public school Elmbrook 550177001217 190 Swanson Elementary   Regular School No Elementary PK 05 2017   pk_12_total 453.0 19.0 44.0 5.0   182.0       1.0 45.0   395.0 354.0             91     75   749 453 19 44 5   182       1 45   395 354         91   75   749
328686 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000498 140 Fond du Lac High   Regular School No High 09 12 2017   pk_12_total 1675.0 93.0 206.0 8.0   70.0       1.0 49.0   1066.0 1036.0             713     316   2102 1675 93 206 8   70       1 49   1066 1036         713   316   2102
328708 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000500 230 Parkside Elementary   Regular School No Elementary PK 05 2017   pk_12_total 103.0 54.0 85.0 1.0   11.0       1.0 8.0   138.0 125.0             213     53   263 103 54 85 1   11       1 8   138 125         213   53   263
328733 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000502 260 Roberts Elementary   Regular School No Elementary PK 05 2017   pk_12_total 334.0 15.0 38.0 1.0   10.0       1.0 9.0   202.0 206.0             139     76   408 334 15 38 1   10       1 9   202 206         139   76   408
328799 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474002416 100 Luther Elementary   Regular School No Elementary PK 05 2017   pk_12_total 164.0 5.0 80.0 1.0           1.0 6.0   135.0 122.0             101     13   257 164 5 80 1           1 6   135 122         101   13   257
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
328864 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000523 80 Pleasant View Elementary   Regular School No Elementary PK 06 2017   pk_12_total 341.0 8.0 46.0 2.0   72.0       1.0 28.0   257.0 241.0             78     44   498 341 8 46 2   72       1 28   257 241         78   44   498
328882 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000151 120 Southwood Glen Elementary   Regular School No Elementary PK 06 2017   pk_12_total 291.0 5.0 24.0 1.0   43.0       1.0 16.0   206.0 175.0             33     46   381 291 5 24 1   43       1 16   206 175         33   46   381
328962 WI Trempealeau   school 5504960 2009 Public school Galesville-Ettrick-Trempealeau 550496000539 80 Trempealeau Elementary   Regular School No Elementary PK 05 2017   pk_12_total 259.0   10.0 1.0   5.0       1.0 14.0   165.0 125.0             54     35   290 259   10 1   5       1 14   165 125         54   35   290
328994 WI Washington   school 5505160 2058 Public school Germantown 550516000549 20 Amy Belle Elementary   Regular School No Elementary PK 05 2017   pk_12_total 380.0 10.0 7.0 2.0   18.0       1.0 13.0   206.0 225.0             49     64   431 380 10 7 2   18       1 13   206 225         49   64   431
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
329117 WI Saint Croix   school 5505520 2198 Public school Glenwood City 550552000586 60 Glenwood City Elementary   Regular School No Elementary PK 05 2017   pk_12_total 327.0 5.0 13.0 3.0   5.0       1.0     183.0 171.0             126     51   354 327 5 13 3   5       1     183 171         126   51   354
329163 WI Ozaukee   school 5505610 2217 Public school Grafton 550561002248 40 Grafton High   Regular School No High 09 12 2017   pk_12_total 671.0 9.0 32.0 2.0   21.0       1.0 13.0   384.0 365.0             83     100   749 671 9 32 2   21       1 13   384 365         83   100   749
329232 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000610 20 Aldo Leopold Community School K-8   Regular School No Elementary PK 08 2017   pk_12_total 416.0 11.0 47.0 11.0   26.0       1.0 46.0   273.0 285.0             160     57   558 416 11 47 11   26       1 46   273 285         160   57   558
329386 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000627 370 Keller Elementary   Regular School No Elementary PK 05 2017   pk_12_total 94.0 92.0 76.0 6.0   12.0       1.0 43.0   165.0 159.0             264     61   324 94 92 76 6   12       1 43   165 159         264   61   324
329395 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000628 380 Kennedy Elementary   Regular School No Elementary PK 05 2017   pk_12_total 149.0 26.0 41.0 20.0   30.0       1.0 27.0   159.0 135.0             198     69   294 149 26 41 20   30       1 27   159 135         198   69   294
329432 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000562 420 Lincoln Elementary   Regular School No Elementary PK 05 2017   pk_12_total 96.0 40.0 41.0 16.0   17.0       1.0 26.0   124.0 113.0             175     49   237 96 40 41 16   17       1 26   124 113         175   49   237
329441 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000631 425 Lombardi Middle   Regular School No Middle 06 08 2017   pk_12_total 469.0 51.0 95.0 74.0   33.0       1.0 52.0   385.0 390.0             362     110   775 469 51 95 74   33       1 52   385 390         362   110   775
329445 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000632 430 MacArthur Elementary   Regular School No Elementary PK 05 2017   pk_12_total 160.0 11.0 30.0 29.0   7.0       1.0 23.0   148.0 113.0             114     30   261 160 11 30 29   7       1 23   148 113         114   30   261
329482 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582001672 160 Red Smith K-8   Regular School No Elementary PK 08 2017   pk_12_total 694.0 35.0 107.0 16.0   34.0       1.0 34.0   475.0 446.0             246     120   921 694 35 107 16   34       1 34   475 446         246   120   921
329494 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000638 600 Southwest High   Regular School No High 09 12 2017   pk_12_total 738.0 72.0 113.0 91.0   65.0       1.0 50.0   568.0 562.0             397     170   1130 738 72 113 91   65       1 50   568 562         397   170   1130
329549 WI Green Lake   school 5505880 2310 Public school Green Lake 550588000646 20 Green Lake Elementary   Regular School No Elementary PK 06 2017   pk_12_total 134.0 4.0 7.0     2.0       1.0 5.0   78.0 75.0             45     28   153 134 4 7     2       1 5   78 75         45   28   153
329566 WI Milwaukee   school 5505910 2296 Public school Greendale 550591002252 40 Canterbury Elementary   Regular School No Elementary PK 05 2017   pk_12_total 251.0 3.0 43.0     15.0       1.0 17.0   193.0 137.0             65     41   330 251 3 43     15       1 17   193 137         65   41   330
329585 WI Milwaukee   school 5505910 2296 Public school Greendale 550591002255 80 Greendale Middle   Regular School No Middle 06 08 2017   pk_12_total 480.0 18.0 80.0 8.0   28.0       1.0 14.0   319.0 310.0             162     61   629 480 18 80 8   28       1 14   319 310         162   61   629
329617 WI Milwaukee   school 5505940 2303 Public school Greenfield 550594000652 100 Glenwood Elementary   Regular School No Elementary PK 05 2017   pk_12_total 184.0 7.0 103.0 1.0   11.0       1.0 14.0   159.0 162.0             167     35   321 184 7 103 1   11       1 14   159 162         167   35   321
329695 WI Waukesha   school 5506030 2420 Public school Hamilton 550603000667 120 Marcy Elementary   Regular School No Elementary KG 05 2017   pk_12_total 423.0 28.0 46.0 1.0   59.0       1.0 34.0   286.0 306.0             71     73   592 423 28 46 1   59       1 34   286 306         71   73   592
329738 WI Washington   school 5506120 2436 Public school Hartford UHS 550612000677 20 Hartford High   Regular School No High 09 12 2017   pk_12_total 1220.0 24.0 85.0 6.0   8.0       1.0 22.0   676.0 690.0             278     194   1366 1220 24 85 6   8       1 22   676 690         278   194   1366
329761 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614001282 100 North Shore Middle   Regular School No Middle 06 08 2017   pk_12_total 255.0 5.0 20.0 2.0   6.0       1.0 11.0   157.0 143.0             56     32   300 255 5 20 2   6       1 11   157 143         56   32   300
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
329952 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660000714 20 Hortonville Elementary   Regular School No Elementary PK 04 2017   pk_12_total 513.0 2.0 10.0     10.0       1.0 11.0   281.0 266.0             67     74   547 513 2 10     10       1 11   281 266         67   74   547
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
330079 WI Saint Croix   school 5506690 2611 Public school Hudson 550669000731 120 Rock Elementary   Regular School No Elementary KG 05 2017   pk_12_total 416.0 13.0 33.0 2.0   18.0       1.0 30.0   251.0 262.0             127     57   513 416 13 33 2   18       1 30   251 262         127   57   513
330093 WI Iron   school 5506750 2618 Public school Hurley 550675000734 80 Hurley Elementary   Regular School No Elementary PK 05 2017   pk_12_total 269.0   7.0 7.0   2.0       1.0 6.0   140.0 152.0             152     39   292 269   7 7   2       1 6   140 152         152   39   292
330144 WI Waupaca   school 5506840 2639 Public school Iola-Scandinavia 550684000741 20 Iola-Scandinavia Elementary   Regular School No Elementary PK 06 2017   pk_12_total 355.0   1.0     2.0       1.0 5.0   187.0 177.0             358     39   364 355   1     2       1 5   187 177         358   39   364
330218 WI Rock   school 5507020 2695 Public school Janesville 550702000757 60 Craig High   Regular School No High 09 12 2017   pk_12_total 1283.0 97.0 157.0 6.0   58.0       1.0 76.0   862.0 816.0             534     205   1678 1283 97 157 6   58       1 76   862 816         534   205   1678

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