library(tidyverse)
## Warning: package 'readr' was built under R version 4.4.2
library(readr)

Capability 1: readr - readd_csv

Here we use the read_csv function for reading the csv file from Github. Then we compare the time taken to read CSV file using the tidyverse library and the R default fucntion which is read.csv. from the results

redlining_pop <-  read.csv("https://raw.githubusercontent.com/fivethirtyeight/data/refs/heads/master/redlining/metro-grades.csv")

head(redlining_pop)
##                    metro_area holc_grade white_pop black_pop hisp_pop asian_pop
## 1                   Akron, OH          A     24702      8624      956       688
## 2                   Akron, OH          B     41531     16499     2208      3367
## 3                   Akron, OH          C     73105     22847     3149      6291
## 4                   Akron, OH          D      6179      6921      567       455
## 5 Albany-Schenectady-Troy, NY          A     16989      1818     1317      1998
## 6 Albany-Schenectady-Troy, NY          B     26644      7094     4334      2509
##   other_pop total_pop pct_white pct_black pct_hisp pct_asian pct_other lq_white
## 1      1993     36963     66.83     23.33     2.59      1.86      5.39     0.94
## 2      4211     67816     61.24     24.33     3.26      4.96      6.21     0.86
## 3      7302    112694     64.87     20.27     2.79      5.58      6.48     0.91
## 4      1022     15144     40.80     45.70     3.75      3.00      6.75     0.57
## 5      1182     23303     72.91      7.80     5.65      8.57      5.07     1.09
## 6      4650     45230     58.91     15.68     9.58      5.55     10.28     0.88
##   lq_black lq_hisp lq_asian lq_other surr_area_white_pop surr_area_black_pop
## 1     1.41    1.00     0.46     0.97              304399               70692
## 2     1.47    1.26     1.23     1.11              304399               70692
## 3     1.23    1.08     1.38     1.16              304399               70692
## 4     2.76    1.45     0.74     1.21              304399               70692
## 5     0.66    0.77     1.21     0.72              387016               68371
## 6     1.33    1.30     0.78     1.47              387016               68371
##   surr_area_hisp_pop surr_area_asian_pop surr_area_other_pop
## 1              11037               17295               23839
## 2              11037               17295               23839
## 3              11037               17295               23839
## 4              11037               17295               23839
## 5              42699               41112               40596
## 6              42699               41112               40596
##   surr_area_pct_white surr_area_pct_black surr_area_pct_hisp
## 1               71.24               16.55               2.58
## 2               71.24               16.55               2.58
## 3               71.24               16.55               2.58
## 4               71.24               16.55               2.58
## 5               66.75               11.79               7.36
## 6               66.75               11.79               7.36
##   surr_area_pct_asian surr_area_pct_other
## 1                4.05                5.58
## 2                4.05                5.58
## 3                4.05                5.58
## 4                4.05                5.58
## 5                7.09                7.00
## 6                7.09                7.00
system.time(d<-read.csv("https://raw.githubusercontent.com/fivethirtyeight/data/refs/heads/master/redlining/metro-grades.csv"))
##    user  system elapsed 
##    0.00    0.00    0.32
system.time(d<-read_csv("https://raw.githubusercontent.com/fivethirtyeight/data/refs/heads/master/redlining/metro-grades.csv"))
## Rows: 551 Columns: 28
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr  (2): metro_area, holc_grade
## dbl (26): white_pop, black_pop, hisp_pop, asian_pop, other_pop, total_pop, p...
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
##    user  system elapsed 
##    0.10    0.07    0.66

Capability 2: dplyr- filter()

using dplyr, we can filter the rows from the dataframe using the filter function. We apply the filter to population dataframe based on other population column

filter(redlining_pop, other_pop > 2000)
##                                         metro_area holc_grade white_pop
## 1                                        Akron, OH          B     41531
## 2                                        Akron, OH          C     73105
## 3                      Albany-Schenectady-Troy, NY          B     26644
## 4                      Albany-Schenectady-Troy, NY          C     56878
## 5                      Albany-Schenectady-Troy, NY          D     16806
## 6             Atlanta-Sandy Springs-Alpharetta, GA          C     64172
## 7             Atlanta-Sandy Springs-Alpharetta, GA          D     21317
## 8                 Austin-Round Rock-Georgetown, TX          B     27936
## 9                    Baltimore-Columbia-Towson, MD          B     61893
## 10                   Baltimore-Columbia-Towson, MD          C     49480
## 11                   Baltimore-Columbia-Towson, MD          D     45701
## 12                                Battle Creek, MI          C     15314
## 13                                  Binghamton, NY          B     23858
## 14                                  Binghamton, NY          C     22834
## 15                  Boston-Cambridge-Newton, MA-NH          A     39375
## 16                  Boston-Cambridge-Newton, MA-NH          B    170439
## 17                  Boston-Cambridge-Newton, MA-NH          C    452120
## 18                  Boston-Cambridge-Newton, MA-NH          D    179722
## 19                         Buffalo-Cheektowaga, NY          B     80832
## 20                         Buffalo-Cheektowaga, NY          C     59609
## 21                            Canton-Massillon, OH          B     17260
## 22              Chicago-Naperville-Elgin, IL-IN-WI          A     46352
## 23              Chicago-Naperville-Elgin, IL-IN-WI          B    202942
## 24              Chicago-Naperville-Elgin, IL-IN-WI          C    579196
## 25              Chicago-Naperville-Elgin, IL-IN-WI          D    250471
## 26                            Cincinnati, OH-KY-IN          C     35616
## 27                            Cleveland-Elyria, OH          A     48311
## 28                            Cleveland-Elyria, OH          B    100214
## 29                            Cleveland-Elyria, OH          C    155360
## 30                            Cleveland-Elyria, OH          D     28391
## 31                                    Columbus, OH          B     52383
## 32                                    Columbus, OH          C     68257
## 33                                    Columbus, OH          D     16377
## 34                 Dallas-Fort Worth-Arlington, TX          A     50939
## 35                 Dallas-Fort Worth-Arlington, TX          B     43166
## 36                 Dallas-Fort Worth-Arlington, TX          C     50951
## 37                 Dallas-Fort Worth-Arlington, TX          D     22679
## 38             Davenport-Moline-Rock Island, IA-IL          C     21021
## 39                            Dayton-Kettering, OH          B     18875
## 40                            Dayton-Kettering, OH          C     31008
## 41                      Denver-Aurora-Lakewood, CO          B     29789
## 42                      Denver-Aurora-Lakewood, CO          C    114180
## 43                      Denver-Aurora-Lakewood, CO          D     42365
## 44                  Des Moines-West Des Moines, IA          C     38390
## 45                     Detroit-Warren-Dearborn, MI          A     33745
## 46                     Detroit-Warren-Dearborn, MI          B     67214
## 47                     Detroit-Warren-Dearborn, MI          C    278844
## 48                     Detroit-Warren-Dearborn, MI          D     88546
## 49                                   Duluth, MN-WI          C     17676
## 50                                        Erie, PA          B     33288
## 51                                        Erie, PA          C     27409
## 52                               Evansville, IN-KY          C     31500
## 53                                       Flint, MI          C     11045
## 54                                       Flint, MI          D     18679
## 55                                  Fort Wayne, IN          C     23448
## 56                       Grand Rapids-Kentwood, MI          C     74531
## 57                         Harrisburg-Carlisle, PA          B     13967
## 58           Hartford-East Hartford-Middletown, CT          B     20103
## 59           Hartford-East Hartford-Middletown, CT          C     22480
## 60            Houston-The Woodlands-Sugar Land, TX          B     25188
## 61            Houston-The Woodlands-Sugar Land, TX          C     16996
## 62                Indianapolis-Carmel-Anderson, IN          B     31069
## 63                Indianapolis-Carmel-Anderson, IN          C    107449
## 64                Indianapolis-Carmel-Anderson, IN          D     54827
## 65                           Kalamazoo-Portage, MI          C     14637
## 66                              Kansas City, MO-KS          C     49734
## 67                              Kansas City, MO-KS          D     41926
## 68                        Lansing-East Lansing, MI          C     36812
## 69                                     Lincoln, NE          B     24405
## 70                                     Lincoln, NE          C     30964
## 71              Los Angeles-Long Beach-Anaheim, CA          A    105689
## 72              Los Angeles-Long Beach-Anaheim, CA          B    247872
## 73              Los Angeles-Long Beach-Anaheim, CA          C    533108
## 74              Los Angeles-Long Beach-Anaheim, CA          D    172344
## 75              Louisville/Jefferson County, KY-IN          C     42462
## 76              Louisville/Jefferson County, KY-IN          D     19738
## 77                                     Madison, WI          C     39031
## 78                           Manchester-Nashua, NH          C     31977
## 79         Miami-Fort Lauderdale-Pompano Beach, FL          B     21523
## 80         Miami-Fort Lauderdale-Pompano Beach, FL          C     25997
## 81         Miami-Fort Lauderdale-Pompano Beach, FL          D      5731
## 82                          Milwaukee-Waukesha, WI          B     56900
## 83                          Milwaukee-Waukesha, WI          C     99810
## 84                          Milwaukee-Waukesha, WI          D     55179
## 85         Minneapolis-St. Paul-Bloomington, MN-WI          A     54422
## 86         Minneapolis-St. Paul-Bloomington, MN-WI          B    142550
## 87         Minneapolis-St. Paul-Bloomington, MN-WI          C     92973
## 88         Minneapolis-St. Paul-Bloomington, MN-WI          D     39558
## 89  Nashville-Davidson--Murfreesboro--Franklin, TN          D     45131
## 90                           New Haven-Milford, CT          C     47616
## 91                        New Orleans-Metairie, LA          C     48025
## 92                        New Orleans-Metairie, LA          D     29081
## 93           New York-Newark-Jersey City, NY-NJ-PA          A    205702
## 94           New York-Newark-Jersey City, NY-NJ-PA          B    752223
## 95           New York-Newark-Jersey City, NY-NJ-PA          C   1164087
## 96           New York-Newark-Jersey City, NY-NJ-PA          D    914030
## 97                               Oklahoma City, OK          C     12323
## 98                     Omaha-Council Bluffs, NE-IA          A     38591
## 99                     Omaha-Council Bluffs, NE-IA          B     73234
## 100                    Omaha-Council Bluffs, NE-IA          C     21495
## 101                                     Peoria, IL          C     13646
## 102    Philadelphia-Camden-Wilmington, PA-NJ-DE-MD          A     39353
## 103    Philadelphia-Camden-Wilmington, PA-NJ-DE-MD          B    192442
## 104    Philadelphia-Camden-Wilmington, PA-NJ-DE-MD          C    104259
## 105    Philadelphia-Camden-Wilmington, PA-NJ-DE-MD          D    210709
## 106                                 Pittsburgh, PA          B    121234
## 107                                 Pittsburgh, PA          C    110738
## 108                                 Pittsburgh, PA          D     52948
## 109            Portland-Vancouver-Hillsboro, OR-WA          B     63944
## 110            Portland-Vancouver-Hillsboro, OR-WA          C    125734
## 111            Portland-Vancouver-Hillsboro, OR-WA          D     38716
## 112                      Providence-Warwick, RI-MA          A     19746
## 113                      Providence-Warwick, RI-MA          B     62780
## 114                      Providence-Warwick, RI-MA          C     58997
## 115                                   Richmond, VA          C     19374
## 116                                  Rochester, NY          B     24215
## 117                                  Rochester, NY          C     64342
## 118                                   Rockford, IL          D     12012
## 119                Sacramento-Roseville-Folsom, CA          C     30587
## 120                                    Saginaw, MI          C     12404
## 121                             Salt Lake City, UT          B     40632
## 122                             Salt Lake City, UT          C     22032
## 123                             Salt Lake City, UT          D     19786
## 124             San Diego-Chula Vista-Carlsbad, CA          B     48240
## 125             San Diego-Chula Vista-Carlsbad, CA          C     77313
## 126             San Diego-Chula Vista-Carlsbad, CA          D     22635
## 127             San Francisco-Oakland-Berkeley, CA          A     34681
## 128             San Francisco-Oakland-Berkeley, CA          B    107751
## 129             San Francisco-Oakland-Berkeley, CA          C    173369
## 130             San Francisco-Oakland-Berkeley, CA          D    109640
## 131             San Jose-Sunnyvale-Santa Clara, CA          C     16361
## 132             San Jose-Sunnyvale-Santa Clara, CA          D      9346
## 133                     Scranton--Wilkes-Barre, PA          A     27713
## 134                    Seattle-Tacoma-Bellevue, WA          B    160312
## 135                    Seattle-Tacoma-Bellevue, WA          C    129746
## 136                    Seattle-Tacoma-Bellevue, WA          D     53406
## 137                           Sioux City, IA-NE-SD          C     17378
## 138                    South Bend-Mishawaka, IN-MI          C     27288
## 139                     Spokane-Spokane Valley, WA          B     20842
## 140                     Spokane-Spokane Valley, WA          C     69523
## 141                     Spokane-Spokane Valley, WA          D     14712
## 142                                Springfield, MO          D     19179
## 143                               St. Louis, MO-IL          A     49210
## 144                               St. Louis, MO-IL          B     92515
## 145                               St. Louis, MO-IL          C     52876
## 146                               St. Louis, MO-IL          D     24435
## 147                                   Syracuse, NY          B     32335
## 148                                   Syracuse, NY          C     31144
## 149            Tampa-St. Petersburg-Clearwater, FL          B     27945
## 150            Tampa-St. Petersburg-Clearwater, FL          C     42280
## 151            Tampa-St. Petersburg-Clearwater, FL          D     32163
## 152                                     Toledo, OH          B     29029
## 153                                     Toledo, OH          C     56046
## 154                          Trenton-Princeton, NJ          C     15438
## 155                                      Tulsa, OK          A     12907
## 156                                      Tulsa, OK          B     11066
## 157                                      Tulsa, OK          C      8884
## 158                                      Tulsa, OK          D      6893
## 159                                 Utica-Rome, NY          C     21616
## 160     Virginia Beach-Norfolk-Newport News, VA-NC          C     35394
## 161     Virginia Beach-Norfolk-Newport News, VA-NC          D     12213
## 162                                    Wichita, KS          D     19617
## 163              Youngstown-Warren-Boardman, OH-PA          C     32498
##     black_pop hisp_pop asian_pop other_pop total_pop pct_white pct_black
## 1       16499     2208      3367      4211     67816     61.24     24.33
## 2       22847     3149      6291      7302    112694     64.87     20.27
## 3        7094     4334      2509      4650     45230     58.91     15.68
## 4       16795    10357      6355     11153    101538     56.02     16.54
## 5       19581     6688      2191      4364     49630     33.86     39.45
## 6       31002     8144      6395      6149    115862     55.39     26.76
## 7       39254     4386      2688      3345     70991     30.03     55.29
## 8        1137     7228      5054      2145     43501     64.22      2.61
## 9      109091     8536      5565      9215    194300     31.85     56.15
## 10      90595    17851      5909      8271    172105     28.75     52.64
## 11      56107    11845      6455      5786    125894     36.30     44.57
## 12       4293     2326       615      2154     24702     62.00     17.38
## 13       3289     2270      1430      2205     33052     72.18      9.95
## 14       3361     2433      1672      2292     32594     70.06     10.31
## 15       2251     2258      4979      2889     51753     76.08      4.35
## 16      16978    16168     26299     17380    247264     68.93      6.87
## 17     136685   141563    111654     74007    916030     49.36     14.92
## 18      48748    92968     48110     28657    398204     45.13     12.24
## 19      37858    11286      7797      7587    145360     55.61     26.04
## 20      53497    19055     12422      8350    152934     38.98     34.98
## 21       6172     1548       107      2856     27944     61.77     22.09
## 22       8447     7773      3201      2630     68403     67.76     12.35
## 23     113905    90694     40663     17715    465918     43.56     24.45
## 24     447000   705314     75961     58074   1865546     31.05     23.96
## 25     297196   295129     63372     27927    934095     26.81     31.82
## 26       4566     4811       241      3364     48597     73.29      9.39
## 27      13445     2968      2272      3335     70331     68.69     19.12
## 28      54660    11665      3289      8045    177872     56.34     30.73
## 29     136527    40191      7910     17076    357064     43.51     38.24
## 30      73969    13274      3312      5349    124295     22.84     59.51
## 31      18843     5168      1889      4955     83239     62.93     22.64
## 32      27401     7531      3917      6751    113858     59.95     24.07
## 33      12059     2366       890      2172     33864     48.36     35.61
## 34       2651     7161      2929      2831     66512     76.59      3.99
## 35       8975    51345      3148      3755    110388     39.10      8.13
## 36      38908   106411      5769      5889    207927     24.50     18.71
## 37      23220    66845      2851      2812    118407     19.15     19.61
## 38       3986     3474       507      2320     31309     67.14     12.73
## 39      15952     2153       681      2578     40238     46.91     39.64
## 40      13124     3598       620      3286     51635     60.05     25.42
## 41       1400     3831       893      2130     38043     78.30      3.68
## 42       6878    24668      4492      9134    159351     71.65      4.32
## 43       6691    32194      2750      4547     88548     47.84      7.56
## 44       8870    11152      5120      3443     66976     57.32     13.24
## 45      37381     2040       900      2935     77002     43.82     48.55
## 46     105556     6561      1444      7328    188103     35.73     56.12
## 47     235388    45758     13811     30258    604058     46.16     38.97
## 48     116045    37980     11152     13607    267328     33.12     43.41
## 49       1197      741       381      2234     22228     79.52      5.39
## 50       3697     2536       882      2703     43106     77.22      8.58
## 51       7863     3721      1370      2908     43271     63.34     18.17
## 52       5833     1939       238      3127     42639     73.88     13.68
## 53      14044     1614       138      2125     28966     38.13     48.48
## 54       9305     1847       133      2527     32492     57.49     28.64
## 55      11063     9750      1364      3325     48950     47.90     22.60
## 56      18549    25847      3183      7190    129299     57.64     14.35
## 57      13841     7966      1489      2404     39667     35.21     34.89
## 58      14231    15961      1387      2217     53900     37.30     26.40
## 59      35157    58399      4120      5621    125778     17.87     27.95
## 60       5107    27135      2931      2451     62811     40.10      8.13
## 61       9825    62096      2045      2164     93125     18.25     10.55
## 62       7302     4537      1567      2629     47103     65.96     15.50
## 63      83952    33853      5151     12410    242816     44.25     34.57
## 64      29069    17932      1998      5864    109690     49.98     26.50
## 65       7823     3288       358      2380     28486     51.38     27.46
## 66      30796    26443      3353      6891    117217     42.43     26.27
## 67      42276    44246      4623      7939    141011     29.73     29.98
## 68      14721    10209      2361      5664     69767     52.76     21.10
## 69       2258     4199      1602      2519     34983     69.76      6.46
## 70       3176     6178      2977      3209     46504     66.58      6.83
## 71      12769    24966     31932     11471    186826     56.57      6.83
## 72      57465   228153     81961     32785    648236     38.24      8.86
## 73     205869  1233028    355088     91402   2418494     22.04      8.51
## 74      88680   741481    119721     38578   1160805     14.85      7.64
## 75      31762     5173      1945      4932     86274     49.22     36.82
## 76      21738     1805       835      2582     46698     42.27     46.55
## 77       1976     3338      5468      2946     52759     73.98      3.75
## 78       2440     5977      1663      2283     44340     72.12      5.50
## 79       5111    44671      1305      2735     75345     28.57      6.78
## 80      14078   120894      2416      4752    168137     15.46      8.37
## 81      37805    75763       546      2004    121849      4.70     31.03
## 82      24711     9262      3411      4836     99120     57.41     24.93
## 83      91603    50236      9649     12327    263626     37.86     34.75
## 84      35108    47596      5823      7121    150828     36.58     23.28
## 85       2380     2850      2653      3780     66086     82.35      3.60
## 86      21767    21138     11676     14591    211722     67.33     10.28
## 87      53600    29830     30944     15626    222973     41.70     24.04
## 88      30475     9175     11681      6144     97032     40.77     31.41
## 89      29886     9290      2429      4133     90869     49.67     32.89
## 90      40240    51420      5311      7520    152107     31.30     26.46
## 91      28576     8976      1414      4242     91233     52.64     31.32
## 92      55441     7192      1199      4235     97149     29.93     57.07
## 93      31768    36632     24816     14949    313867     65.54     10.12
## 94     346677   503237    214336     86779   1903251     39.52     18.21
## 95     894704  1492338    767862    239048   4558038     25.54     19.63
## 96     781692  1029074    339307    153671   3217775     28.41     24.29
## 97       8075    19552      1214      3904     45068     27.34     17.92
## 98       4137     4707      2953      2937     53325     72.37      7.76
## 99      22628    32872      3931      8499    141164     51.88     16.03
## 100      7297    19256      1412      2454     51914     41.41     14.06
## 101     10521     3411       454      2171     30203     45.18     34.83
## 102     36088     9329      7290      4408     96470     40.79     37.41
## 103    211220    96146     43182     26410    569401     33.80     37.10
## 104    179683    79519     16407     15719    395587     26.36     45.42
## 105    202592    83584     44126     23221    564232     37.34     35.91
## 106     23918     5992      9270      9167    169582     71.49     14.10
## 107     42730     6521      6072     10195    176256     62.83     24.24
## 108     34640     3352      3127      5592     99658     53.13     34.76
## 109      2422     5525      3552      6957     82400     77.60      2.94
## 110      9895    20188     14595     17162    187575     67.03      5.28
## 111      3192     4796      3101      4857     54662     70.83      5.84
## 112      2089     4731      1524      3093     31182     63.32      6.70
## 113     14997    51194      6393     15038    150402     41.74      9.97
## 114     19016    72242      8549     11756    170561     34.59     11.15
## 115     13623     1886       846      2017     37745     51.33     36.09
## 116     14682     4947      1811      2507     48161     50.28     30.48
## 117     48070    30238      4395      8099    155143     41.47     30.98
## 118     10910     9816       850      2064     35653     33.69     30.60
## 119      5424    18434      5032      5366     64843     47.17      8.36
## 120     17652     5942       150      2242     38390     32.31     45.98
## 121       750     5960      1955      3530     52827     76.91      1.42
## 122       936     8788      2034      2836     36625     60.16      2.55
## 123      2425    19269      2777      4972     49228     40.19      4.93
## 124      1952    12656      4150      5125     72122     66.89      2.71
## 125     12765    60394     16176     11062    177711     43.51      7.18
## 126     18273    92320     18688      6796    158711     14.26     11.51
## 127      1588     4081      9715      4808     54873     63.20      2.89
## 128     16766    28223     78623     19076    250439     43.02      6.69
## 129     44514    89892    109533     31959    449266     38.59      9.91
## 130     48363    93222     85612     24286    361123     30.36     13.39
## 131      1649    20398      7654      2818     48880     33.47      3.37
## 132      1812    24840      7765      2070     45833     20.39      3.95
## 133      4962     9614       743      2009     45041     61.53     11.02
## 134      6296    16231     25415     20483    228736     70.09      2.75
## 135     24703    22566     36646     24340    238000     54.52     10.38
## 136     13212    12930     19644     10966    110159     48.48     11.99
## 137      1341     7154       877      2180     28929     60.07      4.63
## 138     12112     9812       585      3909     53706     50.81     22.55
## 139       448     1480       435      2262     25467     81.84      1.76
## 140      2689     6960      2480     10794     92446     75.20      2.91
## 141       863     1710       728      2708     20722     71.00      4.17
## 142      1756     1601       229      2539     25304     75.80      6.94
## 143     12504     2524      4225      3411     71874     68.47     17.40
## 144     74109     9092      8445      9960    194121     47.66     38.18
## 145     68455     6392      3166      7247    138137     38.28     49.56
## 146     41450     5363      1391      3859     76499     31.94     54.18
## 147     10682     4552      3458      3649     54676     59.14     19.54
## 148     19700     6178      4366      5210     66596     46.77     29.58
## 149      2559     6359      1024      2038     39924     69.99      6.41
## 150     19204     8881      1570      4007     75941     55.67     25.29
## 151     35900    20712      2471      4348     95594     33.65     37.55
## 152     16868     4294       465      3413     54069     53.69     31.20
## 153     26023    12430       640      7009    102149     54.87     25.48
## 154     20036    33975      1465      2134     73048     21.13     27.43
## 155       897     1031       200      2303     17337     74.45      5.17
## 156      2223     1339       390      2746     17764     62.29     12.51
## 157      2374     6341       268      3207     21074     42.15     11.27
## 158      5020     5381       231      3776     21300     32.36     23.57
## 159      6117     5102      5377      2013     40225     53.74     15.21
## 160     41538     6807      2375      6451     92564     38.24     44.87
## 161     47265     4093      1331      3820     68722     17.77     68.78
## 162      7801    16744       981      3671     48815     40.19     15.98
## 163     14924     4263       252      3631     55569     58.48     26.86
##     pct_hisp pct_asian pct_other lq_white lq_black lq_hisp lq_asian lq_other
## 1       3.26      4.96      6.21     0.86     1.47    1.26     1.23     1.11
## 2       2.79      5.58      6.48     0.91     1.23    1.08     1.38     1.16
## 3       9.58      5.55     10.28     0.88     1.33    1.30     0.78     1.47
## 4      10.20      6.26     10.98     0.84     1.40    1.39     0.88     1.57
## 5      13.48      4.42      8.79     0.51     3.35    1.83     0.62     1.26
## 6       7.03      5.52      5.31     1.50     0.59    0.84     1.16     1.22
## 7       6.18      3.79      4.71     0.81     1.21    0.74     0.79     1.09
## 8      16.62     11.62      4.93     1.02     0.59    0.85     1.42     0.99
## 9       4.39      2.86      4.74     0.85     1.26    0.54     0.58     0.98
## 10     10.37      3.43      4.81     0.77     1.18    1.27     0.70     0.99
## 11      9.41      5.13      4.60     0.97     1.00    1.16     1.04     0.95
## 12      9.42      2.49      8.72     0.93     1.16    1.37     0.58     1.18
## 13      6.87      4.33      6.67     0.98     1.30    1.08     0.69     1.15
## 14      7.47      5.13      7.03     0.95     1.34    1.18     0.82     1.22
## 15      4.36      9.62      5.58     1.20     0.56    0.33     0.99     0.88
## 16      6.54     10.64      7.03     1.09     0.89    0.50     1.10     1.11
## 17     15.45     12.19      8.08     0.78     1.93    1.18     1.26     1.28
## 18     23.35     12.08      7.20     0.71     1.59    1.79     1.25     1.14
## 19      7.76      5.36      5.22     0.85     1.51    1.10     0.95     1.11
## 20     12.46      8.12      5.46     0.60     2.03    1.76     1.44     1.16
## 21      5.54      0.38     10.22     0.90     1.18    1.31     0.75     1.25
## 22     11.36      4.68      3.84     1.39     0.74    0.48     0.64     1.13
## 23     19.47      8.73      3.80     0.89     1.46    0.82     1.19     1.12
## 24     37.81      4.07      3.11     0.64     1.44    1.59     0.56     0.92
## 25     31.60      6.78      2.99     0.55     1.91    1.33     0.92     0.88
## 26      9.90      0.50      6.92     1.07     0.51    1.99     0.16     1.35
## 27      4.22      3.23      4.74     1.08     0.87    0.63     1.06     1.09
## 28      6.56      1.85      4.52     0.88     1.39    0.99     0.61     1.04
## 29     11.26      2.22      4.78     0.68     1.73    1.69     0.73     1.10
## 30     10.68      2.66      4.30     0.36     2.70    1.61     0.87     0.99
## 31      6.21      2.27      5.95     1.13     0.85    0.86     0.47     1.07
## 32      6.61      3.44      5.93     1.07     0.91    0.91     0.72     1.06
## 33      6.99      2.63      6.41     0.87     1.34    0.97     0.55     1.15
## 34     10.77      4.40      4.26     2.08     0.21    0.33     0.62     1.05
## 35     46.51      2.85      3.40     1.06     0.43    1.41     0.40     0.84
## 36     51.18      2.77      2.83     0.66     0.98    1.56     0.39     0.70
## 37     56.45      2.41      2.37     0.52     1.03    1.72     0.34     0.58
## 38     11.10      1.62      7.41     1.00     0.96    1.00     0.67     1.20
## 39      5.35      1.69      6.41     0.81     1.33    1.10     1.06     1.09
## 40      6.97      1.20      6.36     1.04     0.86    1.44     0.75     1.08
## 41     10.07      2.35      5.60     1.35     0.56    0.38     0.67     1.03
## 42     15.48      2.82      5.73     1.24     0.66    0.58     0.81     1.05
## 43     36.36      3.11      5.14     0.83     1.16    1.36     0.89     0.94
## 44     16.65      7.64      5.14     0.90     1.26    1.15     1.20     1.00
## 45      2.65      1.17      3.81     0.77     1.79    0.49     0.20     0.81
## 46      3.49      0.77      3.90     0.63     2.07    0.65     0.13     0.82
## 47      7.58      2.29      5.01     0.81     1.44    1.40     0.39     1.06
## 48     14.21      4.17      5.09     0.58     1.60    2.63     0.72     1.07
## 49      3.33      1.71     10.05     0.93     1.98    1.54     1.27     1.28
## 50      5.88      2.05      6.27     1.04     0.80    0.97     0.61     1.14
## 51      8.60      3.17      6.72     0.85     1.70    1.42     0.94     1.22
## 52      4.55      0.56      7.33     1.00     0.94    1.10     0.81     1.04
## 53      5.57      0.48      7.34     0.67     1.56    1.24     0.47     1.19
## 54      5.68      0.41      7.78     1.00     0.92    1.26     0.41     1.26
## 55     19.92      2.79      6.79     0.97     1.03    1.34     0.38     1.08
## 56     19.99      2.46      5.56     0.92     1.09    1.27     0.79     1.06
## 57     20.08      3.75      6.06     0.68     1.55    1.47     0.61     1.12
## 58     29.61      2.57      4.11     0.80     1.46    1.16     0.43     0.99
## 59     46.43      3.28      4.47     0.39     1.55    1.83     0.54     1.08
## 60     43.20      4.67      3.90     1.35     0.43    1.02     0.80     1.21
## 61     66.68      2.20      2.32     0.62     0.56    1.58     0.38     0.72
## 62      9.63      3.33      5.58     1.35     0.54    0.70     0.88     1.12
## 63     13.94      2.12      5.11     0.90     1.22    1.01     0.56     1.02
## 64     16.35      1.82      5.35     1.02     0.93    1.19     0.48     1.07
## 65     11.54      1.26      8.36     0.86     1.27    1.34     0.58     1.10
## 66     22.56      2.86      5.88     0.82     1.21    1.29     1.03     0.96
## 67     31.38      3.28      5.63     0.57     1.38    1.80     1.18     0.92
## 68     14.63      3.38      8.12     0.90     1.18    1.37     0.57     1.18
## 69     12.00      4.58      7.20     0.93     1.27    1.26     0.95     1.21
## 70     13.29      6.40      6.90     0.89     1.35    1.40     1.32     1.16
## 71     13.36     17.09      6.14     2.24     1.06    0.28     1.02     1.53
## 72     35.20     12.64      5.06     1.52     1.38    0.74     0.76     1.26
## 73     50.98     14.68      3.78     0.87     1.32    1.07     0.88     0.94
## 74     63.88     10.31      3.32     0.59     1.19    1.34     0.62     0.83
## 75      6.00      2.25      5.72     0.90     1.20    0.84     0.90     1.08
## 76      3.87      1.79      5.53     0.78     1.52    0.54     0.71     1.04
## 77      6.33     10.36      5.58     1.07     0.51    0.66     1.22     1.02
## 78     13.48      3.75      5.15     0.96     1.12    1.18     0.95     1.05
## 79     59.29      1.73      3.63     1.99     0.39    0.92     1.45     1.46
## 80     71.90      1.44      2.83     1.08     0.48    1.11     1.21     1.14
## 81     62.18      0.45      1.64     0.33     1.79    0.96     0.38     0.66
## 82      9.34      3.44      4.88     1.10     1.07    0.62     0.67     1.07
## 83     19.06      3.66      4.68     0.73     1.50    1.27     0.71     1.03
## 84     31.56      3.86      4.72     0.70     1.00    2.10     0.75     1.04
## 85      4.31      4.01      5.72     1.39     0.24    0.44     0.39     0.92
## 86      9.98      5.51      6.89     1.14     0.70    1.02     0.54     1.11
## 87     13.38     13.88      7.01     0.71     1.63    1.36     1.36     1.13
## 88      9.46     12.04      6.33     0.69     2.13    0.96     1.18     1.02
## 89     10.22      2.67      4.55     0.87     1.30    0.97     0.84     1.10
## 90     33.81      3.49      4.94     0.52     2.14    1.76     0.84     1.15
## 91      9.84      1.55      4.65     1.22     0.82    0.81     0.64     1.10
## 92      7.40      1.23      4.36     0.69     1.50    0.61     0.51     1.03
## 93     11.67      7.91      4.76     1.85     0.56    0.42     0.56     1.03
## 94     26.44     11.26      4.56     1.12     1.01    0.95     0.79     0.99
## 95     32.74     16.85      5.24     0.72     1.09    1.18     1.19     1.13
## 96     31.98     10.54      4.78     0.80     1.35    1.15     0.74     1.03
## 97     43.38      2.69      8.66     0.75     1.17    1.22     0.98     0.90
## 98      8.83      5.54      5.51     1.22     0.61    0.49     1.32     0.97
## 99     23.29      2.78      6.02     0.88     1.26    1.28     0.67     1.06
## 100    37.09      2.72      4.73     0.70     1.10    2.04     0.65     0.84
## 101    11.29      1.50      7.19     0.77     1.34    1.63     0.81     1.17
## 102     9.67      7.56      4.57     0.81     1.43    0.81     1.01     1.06
## 103    16.89      7.58      4.64     0.68     1.42    1.41     1.02     1.08
## 104    20.10      4.15      3.97     0.53     1.73    1.68     0.56     0.92
## 105    14.81      7.82      4.12     0.75     1.37    1.24     1.05     0.96
## 106     3.53      5.47      5.41     0.95     1.09    1.26     1.15     1.17
## 107     3.70      3.45      5.78     0.84     1.88    1.32     0.72     1.25
## 108     3.36      3.14      5.61     0.71     2.69    1.20     0.66     1.21
## 109     6.71      4.31      8.44     1.14     0.66    0.60     0.55     0.98
## 110    10.76      7.78      9.15     0.99     1.18    0.96     1.00     1.06
## 111     8.77      5.67      8.89     1.04     1.31    0.78     0.73     1.03
## 112    15.17      4.89      9.92     1.08     0.95    0.66     1.10     1.44
## 113    34.04      4.25     10.00     0.71     1.41    1.48     0.96     1.46
## 114    42.36      5.01      6.89     0.59     1.58    1.84     1.13     1.00
## 115     5.00      2.24      5.34     1.24     0.86    0.56     0.79     1.10
## 116    10.27      3.76      5.21     0.90     1.37    0.77     0.92     1.08
## 117    19.49      2.83      5.22     0.75     1.40    1.47     0.69     1.08
## 118    27.53      2.39      5.79     0.63     1.56    1.49     0.88     1.03
## 119    28.43      7.76      8.28     1.12     0.89    0.95     0.78     0.95
## 120    15.48      0.39      5.84     0.70     1.35    1.15     0.39     1.08
## 121    11.28      3.70      6.68     1.26     0.44    0.51     0.66     0.86
## 122    23.99      5.55      7.74     0.98     0.80    1.08     0.99     1.00
## 123    39.14      5.64     10.10     0.66     1.54    1.76     1.01     1.30
## 124    17.55      5.75      7.11     1.64     0.40    0.53     0.45     1.11
## 125    33.98      9.10      6.22     1.06     1.06    1.03     0.71     0.97
## 126    58.17     11.77      4.28     0.35     1.70    1.76     0.92     0.67
## 127     7.44     17.70      8.76     1.85     0.32    0.36     0.61     1.26
## 128    11.27     31.39      7.62     1.26     0.74    0.55     1.07     1.10
## 129    20.01     24.38      7.11     1.13     1.09    0.97     0.83     1.03
## 130    25.81     23.71      6.73     0.89     1.48    1.26     0.81     0.97
## 131    41.73     15.66      5.77     1.16     0.98    1.11     0.63     1.11
## 132    54.20     16.94      4.52     0.71     1.15    1.44     0.68     0.87
## 133    21.35      1.65      4.46     0.84     1.34    1.64     1.08     1.10
## 134     7.10     11.11      8.95     1.27     0.39    0.62     0.68     0.91
## 135     9.48     15.40     10.23     0.98     1.46    0.83     0.94     1.04
## 136    11.74     17.83      9.96     0.88     1.69    1.03     1.09     1.01
## 137    24.73      3.03      7.54     0.99     0.78    1.04     0.98     1.10
## 138    18.27      1.09      7.28     0.79     1.42    1.63     0.43     1.20
## 139     5.81      1.71      8.88     1.06     0.68    0.82     0.63     0.84
## 140     7.53      2.68     11.68     0.98     1.12    1.06     0.99     1.10
## 141     8.25      3.52     13.07     0.92     1.60    1.16     1.29     1.24
## 142     6.33      0.90     10.04     0.98     1.17    1.07     0.56     1.13
## 143     3.51      5.88      4.75     1.38     0.46    0.74     1.81     0.96
## 144     4.68      4.35      5.13     0.96     1.02    0.98     1.34     1.04
## 145     4.63      2.29      5.25     0.77     1.32    0.97     0.70     1.06
## 146     7.01      1.82      5.04     0.65     1.44    1.47     0.56     1.02
## 147     8.33      6.32      6.67     0.99     1.00    1.05     1.09     1.00
## 148     9.28      6.56      7.82     0.78     1.51    1.17     1.13     1.17
## 149    15.93      2.56      5.11     1.31     0.44    0.69     0.64     1.05
## 150    11.69      2.07      5.28     1.04     1.75    0.51     0.51     1.09
## 151    21.67      2.58      4.55     0.63     2.59    0.94     0.64     0.94
## 152     7.94      0.86      6.31     0.84     1.48    0.99     0.66     1.09
## 153    12.17      0.63      6.86     0.86     1.21    1.51     0.48     1.18
## 154    46.51      2.01      2.92     0.52     1.07    1.78     0.46     0.83
## 155     5.94      1.15     13.28     1.45     0.34    0.38     0.55     0.86
## 156     7.54      2.20     15.46     1.21     0.82    0.48     1.05     1.00
## 157    30.09      1.27     15.22     0.82     0.74    1.91     0.61     0.98
## 158    25.26      1.09     17.73     0.63     1.55    1.60     0.52     1.14
## 159    12.68     13.37      5.00     0.83     1.36    1.22     1.46     1.08
## 160     7.35      2.57      6.97     0.95     1.06    0.95     0.82     1.08
## 161     5.96      1.94      5.56     0.44     1.62    0.77     0.62     0.86
## 162    34.30      2.01      7.52     0.85     0.99    1.34     0.57     1.01
## 163     7.67      0.45      6.53     0.78     1.83    1.62     0.58     1.32
##     surr_area_white_pop surr_area_black_pop surr_area_hisp_pop
## 1                304399               70692              11037
## 2                304399               70692              11037
## 3                387016               68371              42699
## 4                387016               68371              42699
## 5                387016               68371              42699
## 6                329328              408208              74469
## 7                329328              408208              74469
## 8                153605               10841              48069
## 9                403254              478015              87364
## 10               403254              478015              87364
## 11               403254              478015              87364
## 12                47157               10632               4890
## 13               106209               11020               9112
## 14               106209               11020               9112
## 15              2716971              331571             562040
## 16              2716971              331571             562040
## 17              2716971              331571             562040
## 18              2716971              331571             562040
## 19               530627              139564              57521
## 20               530627              139564              57521
## 21                71884               19745               4466
## 22              4471615             1531274            2187375
## 23              4471615             1531274            2187375
## 24              4471615             1531274            2187375
## 25              4471615             1531274            2187375
## 26               917344              245761              66672
## 27              1168228              402969             121587
## 28              1168228              402969             121587
## 29              1168228              402969             121587
## 30              1168228              402969             121587
## 31               371107              175890              48054
## 32               371107              175890              48054
## 33               371107              175890              48054
## 34              1649321              853697            1469475
## 35              1649321              853697            1469475
## 36              1649321              853697            1469475
## 37              1649321              853697            1469475
## 38                90227               17868              15019
## 39               154813               79341              12951
## 40               154813               79341              12951
## 41               460045               52036             212657
## 42               460045               52036             212657
## 43               460045               52036             212657
## 44               160431               26698              36779
## 45              1954385              929170             184988
## 46              1954385              929170             184988
## 47              1954385              929170             184988
## 48              1954385              929170             184988
## 49               117643                3727               2974
## 50               125324               18053              10179
## 51               125324               18053              10179
## 52                63444               12579               3581
## 53               135599               73705              10653
## 54               135599               73705              10653
## 55                67467               29812              20315
## 56               242564               50746              60780
## 57                96843               41916              25404
## 58               232550               90555             127634
## 59               232550               90555             127634
## 60               894064              572756            1275375
## 61               894064              572756            1275375
## 62               440510              255828             123995
## 63               440510              255828             123995
## 64               440510              255828             123995
## 65                55406               19960               7943
## 66               363293              151921             122305
## 67               363293              151921             122305
## 68               120427               36705              21964
## 69               167288               11353              21276
## 70               167288               11353              21276
## 71              2865758              732335            5415084
## 72              2865758              732335            5415084
## 73              2865758              732335            5415084
## 74              2865758              732335            5415084
## 75               190102              106960              24986
## 76               190102              106960              24986
## 77               132989               13987              18456
## 78                89550                5865              13646
## 79               160777              193809             723188
## 80               160777              193809             723188
## 81               160777              193809             723188
## 82               542455              242028             156702
## 83               542455              242028             156702
## 84               542455              242028             156702
## 85               750034              187333             124556
## 86               750034              187333             124556
## 87               750034              187333             124556
## 88               750034              187333             124556
## 89               182676               81216              33753
## 90               542154              112197             174360
## 91               198792              175278              55631
## 92               198792              175278              55631
## 93              5169444             2626933            4074221
## 94              5169444             2626933            4074221
## 95              5169444             2626933            4074221
## 96              5169444             2626933            4074221
## 97                94436               39686              92072
## 98               274171               59096              84107
## 99               274171               59096              84107
## 100              274171               59096              84107
## 101               69807               30777               8184
## 102             1716542              898482             411152
## 103             1716542              898482             411152
## 104             1716542              898482             411152
## 105             1716542              898482             411152
## 106              903740              155986              33877
## 107              903740              155986              33877
## 108              903740              155986              33877
## 109              537516               35372              88663
## 110              537516               35372              88663
## 111              537516               35372              88663
## 112              418787               50514             165024
## 113              418787               50514             165024
## 114              418787               50514             165024
## 115              126888              128479              27279
## 116              248955               99333              59483
## 117              248955               99333              59483
## 118               93312               33989              32009
## 119              103578               23051              73467
## 120               39102               28876              11469
## 121              156318                8185              56880
## 122              156318                8185              56880
## 123              156318                8185              56880
## 124              503181               83252             407558
## 125              503181               83252             407558
## 126              503181               83252             407558
## 127              681698              180454             409441
## 128              681698              180454             409441
## 129              681698              180454             409441
## 130              681698              180454             409441
## 131               90969               10860             118075
## 132               90969               10860             118075
## 133               87597                9877              15580
## 134             1416366              181637             290897
## 135             1416366              181637             290897
## 136             1416366              181637             290897
## 137               67833                6665              26665
## 138              135151               33520              23603
## 139              182782                6171              16915
## 140              182782                6171              16915
## 141              182782                6171              16915
## 142               66103                5044               5050
## 143              461043              350098              44529
## 144              461043              350098              44529
## 145              461043              350098              44529
## 146              461043              350098              44529
## 147              149706               48886              19782
## 148              149706               48886              19782
## 149              694493              187621             298272
## 150              694493              187621             298272
## 151              694493              187621             298272
## 152              238126               78874              30095
## 153              238126               78874              30095
## 154              105858               66932              68357
## 155              107491               31810              33015
## 156              107491               31810              33015
## 157              107491               31810              33015
## 158              107491               31810              33015
## 159               64346               11130              10332
## 160              299021              316582              57673
## 161              299021              316582              57673
## 162               84502               29033              45804
## 163              279003               54773              17687
##     surr_area_asian_pop surr_area_other_pop surr_area_pct_white
## 1                 17295               23839               71.24
## 2                 17295               23839               71.24
## 3                 41112               40596               66.75
## 4                 41112               40596               66.75
## 5                 41112               40596               66.75
## 6                 42563               38774               36.86
## 7                 42563               38774               36.86
## 8                 20005               12193               62.77
## 9                 52705               52017               37.57
## 10                52705               52017               37.57
## 11                52705               52017               37.57
## 12                 3055                5241               66.44
## 13                 9003                8310               73.93
## 14                 9003                8310               73.93
## 15               416219              271264               63.21
## 16               416219              271264               63.21
## 17               416219              271264               63.21
## 18               416219              271264               63.21
## 19                45662               38171               65.38
## 20                45662               38171               65.38
## 21                  541                8635               68.28
## 22               673021              310889               48.74
## 23               673021              310889               48.74
## 24               673021              310889               48.74
## 25               673021              310889               48.74
## 26                42435               68783               68.41
## 27                55854               79749               63.89
## 28                55854               79749               63.89
## 29                55854               79749               63.89
## 30                55854               79749               63.89
## 31                31937               37074               55.88
## 32                31937               37074               55.88
## 33                31937               37074               55.88
## 34               315093              181493               36.91
## 35               315093              181493               36.91
## 36               315093              181493               36.91
## 37               315093              181493               36.91
## 38                 3255                8348               66.97
## 39                 4282               15767               57.95
## 40                 4282               15767               57.95
## 41                27752               43259               57.81
## 42                27752               43259               57.81
## 43                27752               43259               57.81
## 44                16060               13027               63.41
## 45               198693              162391               56.99
## 46               198693              162391               56.99
## 47               198693              162391               56.99
## 48               198693              162391               56.99
## 49                 1847               10723               85.92
## 50                 5656                9243               74.40
## 51                 5656                9243               74.40
## 52                  595                6068               73.54
## 53                 2396               14619               57.22
## 54                 2396               14619               57.22
## 55                10066                8530               49.54
## 56                12041               20352               62.76
## 57                11512               10059               52.14
## 58                30178               20843               46.35
## 59                30178               20843               46.35
## 60               176052               97010               29.65
## 61               176052               97010               29.65
## 62                34160               44865               48.98
## 63                34160               44865               48.98
## 64                34160               44865               48.98
## 65                 2010                7018               60.00
## 66                19426               42786               51.92
## 67                19426               42786               51.92
## 68                12272               14133               58.60
## 69                10856               13276               74.67
## 70                10856               13276               74.67
## 71              1901342              455077               25.21
## 72              1901342              455077               25.21
## 73              1901342              455077               25.21
## 74              1901342              455077               25.21
## 75                 8791               18560               54.41
## 76                 8791               18560               54.41
## 77                16335               10524               69.16
## 78                 4716                5843               74.86
## 79                13318               27810               14.37
## 80                13318               27810               14.37
## 81                13318               27810               14.37
## 82                53517               47372               52.06
## 83                53517               47372               52.06
## 84                53517               47372               52.06
## 85               129699               78693               59.04
## 86               129699               78693               59.04
## 87               129699               78693               59.04
## 88               129699               78693               59.04
## 89                10241               13290               56.88
## 90                37726               39057               59.87
## 91                11069               19404               43.20
## 92                11069               19404               43.20
## 93              2077111              675943               35.35
## 94              2077111              675943               35.35
## 95              2077111              675943               35.35
## 96              2077111              675943               35.35
## 97                 7108               24755               36.59
## 98                19376               26178               59.23
## 99                19376               26178               59.23
## 100               19376               26178               59.23
## 101                2193                7249               59.05
## 102              255332              147490               50.06
## 103              255332              147490               50.06
## 104              255332              147490               50.06
## 105              255332              147490               50.06
## 106               57618               55896               74.87
## 107               57618               55896               74.87
## 108               57618               55896               74.87
## 109               61858               68272               67.90
## 110               61858               68272               67.90
## 111               61858               68272               67.90
## 112               31822               49147               58.55
## 113               31822               49147               58.55
## 114               31822               49147               58.55
## 115                8711               14842               41.44
## 116               18333               21660               55.60
## 117               18333               21660               55.60
## 118                4683                9722               53.72
## 119               24625               21401               42.08
## 120                 848                4571               46.07
## 121               14340               19843               61.17
## 122               14340               19843               61.17
## 123               14340               19843               61.17
## 124              157305               79059               40.90
## 125              157305               79059               40.90
## 126              157305               79059               40.90
## 127              581656              137973               34.24
## 128              581656              137973               34.24
## 129              581656              137973               34.24
## 130              581656              137973               34.24
## 131               78430               16336               28.91
## 132               78430               16336               28.91
## 133                1836                4844               73.16
## 134              418258              251649               55.35
## 135              418258              251649               55.35
## 136              418258              251649               55.35
## 137                3490                7665               60.39
## 138                5332               12736               64.25
## 139                6466               25102               76.98
## 140                6466               25102               76.98
## 141                6466               25102               76.98
## 142                1377                7545               77.66
## 143               30335               46177               49.46
## 144               30335               46177               49.46
## 145               30335               46177               49.46
## 146               30335               46177               49.46
## 147               14443               16678               60.00
## 148               14443               16678               60.00
## 149               52216               62888               53.61
## 150               52216               62888               53.61
## 151               52216               62888               53.61
## 152                4904               21703               63.72
## 153                4904               21703               63.72
## 154               11525                9170               40.43
## 155                4383               32470               51.39
## 156                4383               32470               51.39
## 157                4383               32470               51.39
## 158                4383               32470               51.39
## 159                9132                4598               64.64
## 160               23166               47931               40.17
## 161               23166               47931               40.17
## 162                6327               13378               47.20
## 163                2931               18410               74.84
##     surr_area_pct_black surr_area_pct_hisp surr_area_pct_asian
## 1                 16.55               2.58                4.05
## 2                 16.55               2.58                4.05
## 3                 11.79               7.36                7.09
## 4                 11.79               7.36                7.09
## 5                 11.79               7.36                7.09
## 6                 45.69               8.34                4.76
## 7                 45.69               8.34                4.76
## 8                  4.43              19.64                8.17
## 9                 44.53               8.14                4.91
## 10                44.53               8.14                4.91
## 11                44.53               8.14                4.91
## 12                14.98               6.89                4.30
## 13                 7.67               6.34                6.27
## 14                 7.67               6.34                6.27
## 15                 7.71              13.08                9.68
## 16                 7.71              13.08                9.68
## 17                 7.71              13.08                9.68
## 18                 7.71              13.08                9.68
## 19                17.20               7.09                5.63
## 20                17.20               7.09                5.63
## 21                18.76               4.24                0.51
## 22                16.69              23.84                7.34
## 23                16.69              23.84                7.34
## 24                16.69              23.84                7.34
## 25                16.69              23.84                7.34
## 26                18.33               4.97                3.16
## 27                22.04               6.65                3.05
## 28                22.04               6.65                3.05
## 29                22.04               6.65                3.05
## 30                22.04               6.65                3.05
## 31                26.49               7.24                4.81
## 32                26.49               7.24                4.81
## 33                26.49               7.24                4.81
## 34                19.10              32.88                7.05
## 35                19.10              32.88                7.05
## 36                19.10              32.88                7.05
## 37                19.10              32.88                7.05
## 38                13.26              11.15                2.42
## 39                29.70               4.85                1.60
## 40                29.70               4.85                1.60
## 41                 6.54              26.72                3.49
## 42                 6.54              26.72                3.49
## 43                 6.54              26.72                3.49
## 44                10.55              14.54                6.35
## 45                27.09               5.39                5.79
## 46                27.09               5.39                5.79
## 47                27.09               5.39                5.79
## 48                27.09               5.39                5.79
## 49                 2.72               2.17                1.35
## 50                10.72               6.04                3.36
## 51                10.72               6.04                3.36
## 52                14.58               4.15                0.69
## 53                31.10               4.50                1.01
## 54                31.10               4.50                1.01
## 55                21.89              14.92                7.39
## 56                13.13              15.73                3.12
## 57                22.57              13.68                6.20
## 58                18.05              25.44                6.01
## 59                18.05              25.44                6.01
## 60                19.00              42.30                5.84
## 61                19.00              42.30                5.84
## 62                28.45              13.79                3.80
## 63                28.45              13.79                3.80
## 64                28.45              13.79                3.80
## 65                21.62               8.60                2.18
## 66                21.71              17.48                2.78
## 67                21.71              17.48                2.78
## 68                17.86              10.69                5.97
## 69                 5.07               9.50                4.85
## 70                 5.07               9.50                4.85
## 71                 6.44              47.63               16.72
## 72                 6.44              47.63               16.72
## 73                 6.44              47.63               16.72
## 74                 6.44              47.63               16.72
## 75                30.61               7.15                2.52
## 76                30.61               7.15                2.52
## 77                 7.27               9.60                8.50
## 78                 4.90              11.41                3.94
## 79                17.32              64.63                1.19
## 80                17.32              64.63                1.19
## 81                17.32              64.63                1.19
## 82                23.23              15.04                5.14
## 83                23.23              15.04                5.14
## 84                23.23              15.04                5.14
## 85                14.75               9.81               10.21
## 86                14.75               9.81               10.21
## 87                14.75               9.81               10.21
## 88                14.75               9.81               10.21
## 89                25.29              10.51                3.19
## 90                12.39              19.26                4.17
## 91                38.09              12.09                2.41
## 92                38.09              12.09                2.41
## 93                17.96              27.86               14.20
## 94                17.96              27.86               14.20
## 95                17.96              27.86               14.20
## 96                17.96              27.86               14.20
## 97                15.38              35.68                2.75
## 98                12.77              18.17                4.19
## 99                12.77              18.17                4.19
## 100               12.77              18.17                4.19
## 101               26.04               6.92                1.86
## 102               26.20              11.99                7.45
## 103               26.20              11.99                7.45
## 104               26.20              11.99                7.45
## 105               26.20              11.99                7.45
## 106               12.92               2.81                4.77
## 107               12.92               2.81                4.77
## 108               12.92               2.81                4.77
## 109                4.47              11.20                7.81
## 110                4.47              11.20                7.81
## 111                4.47              11.20                7.81
## 112                7.06              23.07                4.45
## 113                7.06              23.07                4.45
## 114                7.06              23.07                4.45
## 115               41.96               8.91                2.85
## 116               22.18              13.28                4.09
## 117               22.18              13.28                4.09
## 118               19.57              18.43                2.70
## 119                9.37              29.85               10.01
## 120               34.03              13.51                1.00
## 121                3.20              22.26                5.61
## 122                3.20              22.26                5.61
## 123                3.20              22.26                5.61
## 124                6.77              33.13               12.79
## 125                6.77              33.13               12.79
## 126                6.77              33.13               12.79
## 127                9.06              20.56               29.21
## 128                9.06              20.56               29.21
## 129                9.06              20.56               29.21
## 130                9.06              20.56               29.21
## 131                3.45              37.52               24.92
## 132                3.45              37.52               24.92
## 133                8.25              13.01                1.53
## 134                7.10              11.37               16.35
## 135                7.10              11.37               16.35
## 136                7.10              11.37               16.35
## 137                5.93              23.74                3.11
## 138               15.94              11.22                2.53
## 139                2.60               7.12                2.72
## 140                2.60               7.12                2.72
## 141                2.60               7.12                2.72
## 142                5.93               5.93                1.62
## 143               37.56               4.78                3.25
## 144               37.56               4.78                3.25
## 145               37.56               4.78                3.25
## 146               37.56               4.78                3.25
## 147               19.59               7.93                5.79
## 148               19.59               7.93                5.79
## 149               14.48              23.02                4.03
## 150               14.48              23.02                4.03
## 151               14.48              23.02                4.03
## 152               21.11               8.05                1.31
## 153               21.11               8.05                1.31
## 154               25.56              26.11                4.40
## 155               15.21              15.78                2.10
## 156               15.21              15.78                2.10
## 157               15.21              15.78                2.10
## 158               15.21              15.78                2.10
## 159               11.18              10.38                9.17
## 160               42.53               7.75                3.11
## 161               42.53               7.75                3.11
## 162               16.22              25.58                3.53
## 163               14.69               4.74                0.79
##     surr_area_pct_other
## 1                  5.58
## 2                  5.58
## 3                  7.00
## 4                  7.00
## 5                  7.00
## 6                  4.34
## 7                  4.34
## 8                  4.98
## 9                  4.85
## 10                 4.85
## 11                 4.85
## 12                 7.38
## 13                 5.78
## 14                 5.78
## 15                 6.31
## 16                 6.31
## 17                 6.31
## 18                 6.31
## 19                 4.70
## 20                 4.70
## 21                 8.20
## 22                 3.39
## 23                 3.39
## 24                 3.39
## 25                 3.39
## 26                 5.13
## 27                 4.36
## 28                 4.36
## 29                 4.36
## 30                 4.36
## 31                 5.58
## 32                 5.58
## 33                 5.58
## 34                 4.06
## 35                 4.06
## 36                 4.06
## 37                 4.06
## 38                 6.20
## 39                 5.90
## 40                 5.90
## 41                 5.44
## 42                 5.44
## 43                 5.44
## 44                 5.15
## 45                 4.73
## 46                 4.73
## 47                 4.73
## 48                 4.73
## 49                 7.83
## 50                 5.49
## 51                 5.49
## 52                 7.03
## 53                 6.17
## 54                 6.17
## 55                 6.26
## 56                 5.27
## 57                 5.42
## 58                 4.15
## 59                 4.15
## 60                 3.22
## 61                 3.22
## 62                 4.99
## 63                 4.99
## 64                 4.99
## 65                 7.60
## 66                 6.11
## 67                 6.11
## 68                 6.88
## 69                 5.93
## 70                 5.93
## 71                 4.00
## 72                 4.00
## 73                 4.00
## 74                 4.00
## 75                 5.31
## 76                 5.31
## 77                 5.47
## 78                 4.88
## 79                 2.49
## 80                 2.49
## 81                 2.49
## 82                 4.55
## 83                 4.55
## 84                 4.55
## 85                 6.19
## 86                 6.19
## 87                 6.19
## 88                 6.19
## 89                 4.14
## 90                 4.31
## 91                 4.22
## 92                 4.22
## 93                 4.62
## 94                 4.62
## 95                 4.62
## 96                 4.62
## 97                 9.59
## 98                 5.65
## 99                 5.65
## 100                5.65
## 101                6.13
## 102                4.30
## 103                4.30
## 104                4.30
## 105                4.30
## 106                4.63
## 107                4.63
## 108                4.63
## 109                8.62
## 110                8.62
## 111                8.62
## 112                6.87
## 113                6.87
## 114                6.87
## 115                4.85
## 116                4.84
## 117                4.84
## 118                5.60
## 119                8.70
## 120                5.39
## 121                7.76
## 122                7.76
## 123                7.76
## 124                6.43
## 125                6.43
## 126                6.43
## 127                6.93
## 128                6.93
## 129                6.93
## 130                6.93
## 131                5.19
## 132                5.19
## 133                4.05
## 134                9.83
## 135                9.83
## 136                9.83
## 137                6.82
## 138                6.05
## 139               10.57
## 140               10.57
## 141               10.57
## 142                8.86
## 143                4.95
## 144                4.95
## 145                4.95
## 146                4.95
## 147                6.68
## 148                6.68
## 149                4.85
## 150                4.85
## 151                4.85
## 152                5.81
## 153                5.81
## 154                3.50
## 155               15.52
## 156               15.52
## 157               15.52
## 158               15.52
## 159                4.62
## 160                6.44
## 161                6.44
## 162                7.47
## 163                4.94

Capability 3: dplyr - Select

Just as we filtered the rows of the dataframe in the above example, we can use select function to filter columns of the dataframe. If you want only specific columns rather than the whole set of columns we can use select function from dplyr.Here I filter black, white, asian, hispanian, other, and total population.

select(redlining_pop,c("white_pop","black_pop","hisp_pop", "asian_pop","other_pop","total_pop"))
##     white_pop black_pop hisp_pop asian_pop other_pop total_pop
## 1       24702      8624      956       688      1993     36963
## 2       41531     16499     2208      3367      4211     67816
## 3       73105     22847     3149      6291      7302    112694
## 4        6179      6921      567       455      1022     15144
## 5       16989      1818     1317      1998      1182     23303
## 6       26644      7094     4334      2509      4650     45230
## 7       56878     16795    10357      6355     11153    101538
## 8       16806     19581     6688      2191      4364     49630
## 9        1076        71      367        21        82      1616
## 10      16774      1962     7935       731      1396     28798
## 11       4347       718     2967       184       346      8561
## 12       2864       301     1625        85       252      5127
## 13        421         1       17         4        18       460
## 14       6612       166      117        55       318      7268
## 15      23472      1174      490       118      1554     26808
## 16       3920       267       71        24       268      4551
## 17       6107       297     1687       215       622      8927
## 18       7139       868     4223       150       732     13113
## 19       2140       775     5538       131       320      8904
## 20       5865      2511    16643       764       909     26692
## 21       4557        86      163        46       204      5055
## 22       6359       533      358        84       431      7765
## 23      18708      2792     1780       251      1624     25156
## 24       3209      1527      267        55       350      5408
## 25       9903       729      602       497       623     12354
## 26      26370      5071     1959      1624      1772     36797
## 27      64172     31002     8144      6395      6149    115862
## 28      21317     39254     4386      2688      3345     70991
## 29        631         6       55        20        49       761
## 30       7354       520     2499      1791       494     12659
## 31      14269      8980    12902      3555      1421     41128
## 32       1730      7503     3766       324       610     13933
## 33        758        27       21         7        35       847
## 34       1775       242      101        30        96      2244
## 35       4011      1470      318       111       316      6227
## 36       2885      8086      365       240       556     12131
## 37      21180       591     3840      3073      1457     30142
## 38      27936      1137     7228      5054      2145     43501
## 39       7685       594     2028       807       534     11648
## 40      16726      2732     7514      1422      1596     29990
## 41      14716     16262     1303      2259      1855     36397
## 42      61893    109091     8536      5565      9215    194300
## 43      49480     90595    17851      5909      8271    172105
## 44      45701     56107    11845      6455      5786    125894
## 45        810        86       39        47        54      1036
## 46       1160       349       99       103       137      1848
## 47      15314      4293     2326       615      2154     24702
## 48       3240      1141      580        41       504      5505
## 49        621         5       36         3        21       686
## 50       1694        46      181        15        95      2030
## 51       9841       306     1160        60       759     12126
## 52      11449       562     1544        69      1088     14711
## 53        899      5122     1660       106       170      7957
## 54       2546     11656    14156      1247       644     30248
## 55        523      2992     1408        34       149      5107
## 56        355      3473      856        18       159      4860
## 57       2255       183      170       186       176      2970
## 58      23858      3289     2270      1430      2205     33052
## 59      22834      3361     2433      1672      2292     32594
## 60       1512       473      261       104       205      2554
## 61       5709        43      106        66       142      6065
## 62      14948      6285      706       325       745     23009
## 63      17363     28889     2665      1106      1667     51690
## 64       8383     59889     4502       590      1931     75295
## 65      39375      2251     2258      4979      2889     51753
## 66     170439     16978    16168     26299     17380    247264
## 67     452120    136685   141563    111654     74007    916030
## 68     179722     48748    92968     48110     28657    398204
## 69      15079      1122     2539      2266       875     21881
## 70      21589      4396    10995      3950      1596     42526
## 71      12261      4626    13082      2597      1195     33760
## 72       2198      3478     6495       794       429     13393
## 73      15865      2173      969       640       908     20555
## 74      80832     37858    11286      7797      7587    145360
## 75      59609     53497    19055     12422      8350    152934
## 76       4726      5175     2977       206       840     13924
## 77       2486       409       95        17       209      3217
## 78      17260      6172     1548       107      2856     27944
## 79      10272      5386     1045        27      1901     18632
## 80       1375      1429      187         3       332      3327
## 81       3254       187       71        83       235      3829
## 82       5858      1614      204       164       633      8472
## 83       7549      1931      262       134       815     10692
## 84       2330       956       84        43       288      3701
## 85       8651       387      388       188       299      9913
## 86       8739       737      616       353       530     10974
## 87      13978      5705     1498      1008      1108     23297
## 88      10070      7462     1454       987       959     20932
## 89       4738       449      389        96       226      5898
## 90      12131      5352     1187       196       917     19784
## 91      11770     10500     6125       228      1289     29911
## 92       5340      5664     1409       212       578     13203
## 93      46352      8447     7773      3201      2630     68403
## 94     202942    113905    90694     40663     17715    465918
## 95     579196    447000   705314     75961     58074   1865546
## 96     250471    297196   295129     63372     27927    934095
## 97      10921       231      460       153       479     12243
## 98      26682      1389     1600       235      1979     31885
## 99      35616      4566     4811       241      3364     48597
## 100      5984      2281     1899        78       792     11034
## 101     48311     13445     2968      2272      3335     70331
## 102    100214     54660    11665      3289      8045    177872
## 103    155360    136527    40191      7910     17076    357064
## 104     28391     73969    13274      3312      5349    124295
## 105      1861        39       69        34        61      2064
## 106      4417       340      145        99       170      5172
## 107      6956      1044      316       273       331      8920
## 108      6235      3597      544       419       520     11316
## 109       270        50       16         7        23       366
## 110      1656       687      160        26       160      2688
## 111      2191      3493      435        42       416      6576
## 112      2850      7320      942        55       564     11730
## 113     23756      2731     1205       477      1547     29715
## 114     52383     18843     5168      1889      4955     83239
## 115     68257     27401     7531      3917      6751    113858
## 116     16377     12059     2366       890      2172     33864
## 117     50939      2651     7161      2929      2831     66512
## 118     43166      8975    51345      3148      3755    110388
## 119     50951     38908   106411      5769      5889    207927
## 120     22679     23220    66845      2851      2812    118407
## 121      1565        33      139        20        98      1856
## 122     14713      1784     1530       325      1035     19386
## 123     21021      3986     3474       507      2320     31309
## 124      3956      1295      763        63       480      6558
## 125     15825      3675      774       440      1182     21897
## 126     18875     15952     2153       681      2578     40238
## 127     31008     13124     3598       620      3286     51635
## 128      8883     10786     1072       179      1347     22269
## 129      2114       309       87        17       151      2678
## 130      4144      3364      219        37       611      8375
## 131      6298      6624      491        70      1146     14630
## 132      2030      2250      153        22       434      4888
## 133     10605       270      962       294       730     12860
## 134     29789      1400     3831       893      2130     38043
## 135    114180      6878    24668      4492      9134    159351
## 136     42365      6691    32194      2750      4547     88548
## 137     24197      1940     1902       929      1588     30556
## 138     17859      3533     4797      1786      1564     29540
## 139     38390      8870    11152      5120      3443     66976
## 140     18942      5498     7883      2929      1945     37197
## 141     33745     37381     2040       900      2935     77002
## 142     67214    105556     6561      1444      7328    188103
## 143    278844    235388    45758     13811     30258    604058
## 144     88546    116045    37980     11152     13607    267328
## 145      2980       165       98        15       155      3413
## 146     15072      2179     1007       182      1303     19743
## 147      5953       267      203        54       314      6792
## 148      2880       375      173        20       217      3664
## 149      7176       102      157       164       517      8117
## 150     14291       468      393       231      1383     16767
## 151     17676      1197      741       381      2234     22228
## 152      5730       191      168        78       631      6798
## 153      2448       187      341        88       200      3263
## 154      1354       362      223        44       137      2121
## 155      8233      6025     3967       861       937     20023
## 156      2335      6477     2546       305       522     12185
## 157      1123        51     3910        47        93      5224
## 158      1618       290    22147        90       253     24399
## 159       936       271    11827       140       215     13389
## 160       602       193    14977        38       140     15950
## 161       277        31       21         2        20       351
## 162      7613       849      433       102       662      9659
## 163     15224      1702      854       150      1701     19631
## 164      3554       507      186        19       387      4653
## 165      4305       102       96        87       156      4746
## 166     33288      3697     2536       882      2703     43106
## 167     27409      7863     3721      1370      2908     43271
## 168      5358      3113     1432       681       909     11492
## 169      4098       232      145        57       292      4824
## 170      1764      1135      159        11       257      3325
## 171     31500      5833     1939       238      3127     42639
## 172      6788      2838      496        49      1066     11238
## 173       593       140       36        21        64       854
## 174      3975      8756      618       105       935     14389
## 175     11045     14044     1614       138      2125     28966
## 176     18679      9305     1847       133      2527     32492
## 177      1681        64      119        41       125      2029
## 178     10029      1239     1770       443      1166     14647
## 179     23448     11063     9750      1364      3325     48950
## 180       742      1210      661        49       195      2856
## 181       615        25      370        25        86      1121
## 182      2846       284     6835       517       410     10892
## 183      6214      3942    42059      4467      1980     58662
## 184       883      1877    10951      1707       397     15814
## 185      6670       271      362       159       420      7882
## 186     23288      5436     5505       522      1942     36694
## 187     74531     18549    25847      3183      7190    129299
## 188      8448      5246     6196       190      1399     21480
## 189      4964       209      229        70       223      5695
## 190      4632       991      356       161       329      6468
## 191      7758     12864     2995      1166      1318     26101
## 192       882     10834      985       178       476     13355
## 193      2191       728      393        66       227      3605
## 194     13967     13841     7966      1489      2404     39667
## 195      2458      4185     3303       201       638     10785
## 196      8247      5777     3604       470      1315     19413
## 197     21765      2204     3010      2006      1487     30472
## 198     20103     14231    15961      1387      2217     53900
## 199     22480     35157    58399      4120      5621    125778
## 200      1661      4324     8407       486       461     15338
## 201     16589      6910     6881      2778      1653     34811
## 202     25188      5107    27135      2931      2451     62811
## 203     16996      9825    62096      2045      2164     93125
## 204      8108     14680    10239      1748      1324     36100
## 205      7221       608      201       160       504      8694
## 206      6286       719      186       142       442      7775
## 207     20220      2068      463       284      1592     24627
## 208       384       357       15         5        81       842
## 209     21440      1939      923       442      1097     25841
## 210     31069      7302     4537      1567      2629     47103
## 211    107449     83952    33853      5151     12410    242816
## 212     54827     29069    17932      1998      5864    109690
## 213      1589       131      137        25       129      2011
## 214      8422      2276      747       169      1045     12659
## 215     15605      3220     1297       156      1754     22033
## 216      2939       926      396        35       437      4732
## 217      3549      1641      154       104       185      5632
## 218      1432      5983      174        56       200      7845
## 219       432      3411       99        14       136      4092
## 220       647      6206      208        24       182      7267
## 221      6067       109      393       164       246      6979
## 222     13253      3868     1312       380      1120     19931
## 223     11377      9020     1802       463      1392     24054
## 224      5169     28894     1784       248      1790     37885
## 225      1046        52       76        17        70      1261
## 226      5336       787      552       109       554      7338
## 227     14637      7823     3288       358      2380     28486
## 228       545       618      151         7       130      1451
## 229     11945       232      537       215       539     13469
## 230     22007      5066     2790       740      1768     32371
## 231     49734     30796    26443      3353      6891    117217
## 232     41926     42276    44246      4623      7939    141011
## 233      4028       144      179       127       196      4673
## 234      7328      1342      713       305       495     10182
## 235     21298      6880     2579       694      1879     33330
## 236     11269      6170     3083       327      1481     22331
## 237      5357       406     1030       304       342      7439
## 238     10807      3147     9640       904      1158     25657
## 239       158        19      128        30        16       351
## 240       183       351     1072        35        48      1689
## 241      4044       535      328       239       306      5452
## 242     18205      3734     2533      1356      1828     27655
## 243     36812     14721    10209      2361      5664     69767
## 244      1647       763      594        92       286      3381
## 245      3749        43      115        63       139      4108
## 246      6312       399      412       273       349      7746
## 247     11709      2855     1397       535       965     17460
## 248      4157      3279      879       116       546      8977
## 249      1272       168       63        13       130      1646
## 250      5000      1925      358        27       802      8112
## 251      8466      3582      631        82      1244     14004
## 252      2046      1117      162         8       321      3653
## 253     21748      1368     2227       871      1723     27937
## 254     24405      2258     4199      1602      2519     34983
## 255     30964      3176     6178      2977      3209     46504
## 256      3815       219      408       189       229      4861
## 257      7758      1683      358       131       573     10502
## 258      4541      3905      454        98       520      9518
## 259      2452      7501      518        76       523     11071
## 260       739      6785      301        40       342      8208
## 261    105689     12769    24966     31932     11471    186826
## 262    247872     57465   228153     81961     32785    648236
## 263    533108    205869  1233028    355088     91402   2418494
## 264    172344     88680   741481    119721     38578   1160805
## 265     17428       414      546       301       783     19473
## 266     21106      9441     1262       632      1662     34102
## 267     42462     31762     5173      1945      4932     86274
## 268     19738     21738     1805       835      2582     46698
## 269      1666       250       86        19       141      2161
## 270      2073       527      144        29       258      3031
## 271      3170      5021      363        79       631      9263
## 272       411      1667       87        11       191      2367
## 273       312        47        6         6        26       398
## 274      1601      1043       89        30       111      2873
## 275      1712      3856      202        31       255      6055
## 276      2815     11500      708       124       570     15717
## 277      4782        79      230       207       330      5628
## 278      9767       196      527       523       677     11690
## 279     39031      1976     3338      5468      2946     52759
## 280      9801       993     1358      1030       765     13947
## 281      2367        95      179       112       143      2895
## 282      4915       112      362        94       284      5766
## 283     31977      2440     5977      1663      2283     44340
## 284     10158      1475     3554       772       976     16935
## 285      8959      1235      441       271       467     11373
## 286     21832     13925     2309      1157      1859     41082
## 287      7395     31463     3961       707      1449     44975
## 288      6411     40967     1894       684      1541     51496
## 289     15441      1002    19378       699      1765     38286
## 290     21523      5111    44671      1305      2735     75345
## 291     25997     14078   120894      2416      4752    168137
## 292      5731     37805    75763       546      2004    121849
## 293     18562      4552     1236       702      1248     26301
## 294     56900     24711     9262      3411      4836     99120
## 295     99810     91603    50236      9649     12327    263626
## 296     55179     35108    47596      5823      7121    150828
## 297     54422      2380     2850      2653      3780     66086
## 298    142550     21767    21138     11676     14591    211722
## 299     92973     53600    29830     30944     15626    222973
## 300     39558     30475     9175     11681      6144     97032
## 301       220        54        8         1        10       294
## 302      1673       231       61        24        90      2079
## 303      5725      4362      297        54       432     10870
## 304      1468     10140      133        21       353     12115
## 305      2581       593      101        31       156      3462
## 306      1648      1501       79        32        92      3351
## 307      4823      7477     1481        93       561     14433
## 308      3145     10738      876       161       431     15350
## 309       706        12       33         4        39       794
## 310      3614      2285      817        44       475      7234
## 311      4665      5043     1171        36       979     11894
## 312      7755      8234     1525        70      1340     18926
## 313     27202       639      897       909       992     30639
## 314     29020      4289     2098      2656      1843     39906
## 315     19861      5473     1919       785      1333     29371
## 316     45131     29886     9290      2429      4133     90869
## 317      1274        96       59        11       108      1549
## 318      6151       814      169        32       638      7805
## 319      6084      1072      323        20       752      8252
## 320      1035       415       77         2       174      1702
## 321      4461       713      747       547       361      6828
## 322     18965      6682     7764      1428      1891     36731
## 323     47616     40240    51420      5311      7520    152107
## 324      8993     12524    17377      1449      1874     42217
## 325      6292       714      577       177       276      8036
## 326     15299      2735     2084       553       983     21654
## 327     48025     28576     8976      1414      4242     91233
## 328     29081     55441     7192      1199      4235     97149
## 329    205702     31768    36632     24816     14949    313867
## 330    752223    346677   503237    214336     86779   1903251
## 331   1164087    894704  1492338    767862    239048   4558038
## 332    914030    781692  1029074    339307    153671   3217775
## 333      4566        67     1016        60       322      6031
## 334      8139       342     5263       150       881     14775
## 335      9927       373     8464       277      1096     20136
## 336      9492       380     4788       240       756     15655
## 337     11667      1930     2148       775      1909     18430
## 338      7264      1236     7517       850      1875     18741
## 339     12323      8075    19552      1214      3904     45068
## 340      5052      3328    12078       239      1988     22685
## 341     38591      4137     4707      2953      2937     53325
## 342     73234     22628    32872      3931      8499    141164
## 343     21495      7297    19256      1412      2454     51914
## 344     14561      3625     7350       428      1540     27503
## 345      1891       304      119        41       124      2478
## 346      4522      1435      468       137       433      6995
## 347     13646     10521     3411       454      2171     30203
## 348      2791      6749     1198        30       687     11454
## 349     39353     36088     9329      7290      4408     96470
## 350    192442    211220    96146     43182     26410    569401
## 351    104259    179683    79519     16407     15719    395587
## 352    210709    202592    83584     44126     23221    564232
## 353      3000       193      856       151       259      4459
## 354     10946      1167    12625       637      1750     27126
## 355     10231      1663    10034       883      1841     24652
## 356      2518      2553     9668       368       819     15926
## 357     25473       777     1236      3125      1496     32107
## 358    121234     23918     5992      9270      9167    169582
## 359    110738     42730     6521      6072     10195    176256
## 360     52948     34640     3352      3127      5592     99658
## 361     14353       232      973       811      1320     17689
## 362     63944      2422     5525      3552      6957     82400
## 363    125734      9895    20188     14595     17162    187575
## 364     38716      3192     4796      3101      4857     54662
## 365       188        13        9         3        14       228
## 366      2264       153       49        36       149      2651
## 367      7373       382      270        34       479      8539
## 368      2831       260       80        13       221      3406
## 369      1900       570      446       185       218      3319
## 370      4454      2691     2149       178       604     10076
## 371      4443      5659     3375       295       848     14620
## 372      1615      1842     1129        88       318      4991
## 373     19746      2089     4731      1524      3093     31182
## 374     62780     14997    51194      6393     15038    150402
## 375     58997     19016    72242      8549     11756    170561
## 376      7036      1311     5555       591      1444     15937
## 377      2688        74     1586        31       260      4639
## 378      8199       369    10066       113      1108     19855
## 379      3210       253     5486        45       535      9528
## 380      2293       174     3668        31       382      6548
## 381       495        15       64         7        30       611
## 382      8176      1261     2220        68       682     12407
## 383     11416      6466     7246       126      1644     26898
## 384      6290      4225     5052        97       974     16638
## 385      7543       525      201       104       265      8638
## 386     17423      3059      928       444      1114     22969
## 387     19374     13623     1886       846      2017     37745
## 388      9280     23337     1698       813      1869     36996
## 389       997        10       17        15        36      1074
## 390      4806       575      520       136       359      6395
## 391     15314      6126     1840       434      1643     25357
## 392     10196      5012     1639       242      1288     18377
## 393      1253        18       80       148        64      1563
## 394      2819       322      362       378       278      4158
## 395      4247       518      569       448       411      6192
## 396       680        94       82       143        57      1056
## 397     10306       476      557       439       654     12433
## 398     24215     14682     4947      1811      2507     48161
## 399     64342     48070    30238      4395      8099    155143
## 400      6230     16269     8421       842      1663     33424
## 401      1861       105      220        36       129      2351
## 402      9656      2355     2285       284       885     15466
## 403     13794      6813     6120       564      1858     29150
## 404     12012     10910     9816       850      2064     35653
## 405      3521        54      606       386       418      4986
## 406     10313       513     2510       858      1344     15537
## 407     30587      5424    18434      5032      5366     64843
## 408      5845       885     2922      1543      1179     12374
## 409       942       304      185         5        85      1521
## 410      4488      1206      895        41       355      6985
## 411     12404     17652     5942       150      2242     38390
## 412      1616      1582      821        12       307      4338
## 413     10892        72      579       496       630     12669
## 414     40632       750     5960      1955      3530     52827
## 415     22032       936     8788      2034      2836     36625
## 416     19786      2425    19269      2777      4972     49228
## 417      5588       377    12361       209       437     18972
## 418     15862      1195    46005       548      1430     65040
## 419      8610      2009    92951       540      1252    105362
## 420      7057      5540    69962       446      1212     84218
## 421     14807       334     2676       939      1397     20152
## 422     48240      1952    12656      4150      5125     72122
## 423     77313     12765    60394     16176     11062    177711
## 424     22635     18273    92320     18688      6796    158711
## 425     34681      1588     4081      9715      4808     54873
## 426    107751     16766    28223     78623     19076    250439
## 427    173369     44514    89892    109533     31959    449266
## 428    109640     48363    93222     85612     24286    361123
## 429      1525        72      733       493       237      3060
## 430     10493       498     4646      2655      1381     19672
## 431     16361      1649    20398      7654      2818     48880
## 432      9346      1812    24840      7765      2070     45833
## 433      1648      1436      175        48       171      3477
## 434      4835      6800      497       178       524     12834
## 435      3410      5453      462       386       422     10133
## 436      2119      2798      363       383       182      5845
## 437     27713      4962     9614       743      2009     45041
## 438      9338       834     1070        82       598     11923
## 439     11185       475      765       140       415     12980
## 440     17317       386     1050      1306      1801     21859
## 441    160312      6296    16231     25415     20483    228736
## 442    129746     24703    22566     36646     24340    238000
## 443     53406     13212    12930     19644     10966    110159
## 444      8730      1382      585       130       563     11389
## 445       787      3630      187        19       196      4819
## 446      2241     10263      625        88       704     13922
## 447       968      8202      352        32       340      9894
## 448      5116       635     1583       361       701      8397
## 449      9430      1360     4985       645      1578     17998
## 450     17378      1341     7154       877      2180     28929
## 451     18970      1548     3942       766      1573     26799
## 452      5944       504      507        89       335      7378
## 453      7757      2144     1158        97       812     11969
## 454     27288     12112     9812       585      3909     53706
## 455      4557      3504     1992        81       804     10937
## 456      7091        96      407       135       634      8363
## 457     20842       448     1480       435      2262     25467
## 458     69523      2689     6960      2480     10794     92446
## 459     14712       863     1710       728      2708     20722
## 460      4429       245      187        75       242      5178
## 461      7669      1824      386       110       740     10730
## 462      4912      2143      308       161       659      8182
## 463      8428      7654      743       145      1336     18306
## 464      1204        33      143        28        47      1454
## 465      9584       659     6735       193       708     17879
## 466     23040      1377    11893       546      1553     38409
## 467      5031       489     6580       168       371     12638
## 468       945        28       41        16        73      1103
## 469      4312        98      219       128       361      5118
## 470     12441      1207      951       479      1332     16410
## 471     19179      1756     1601       229      2539     25304
## 472      2967       457      146        21       248      3839
## 473      6538      1663      544        74       901      9720
## 474     11544      3485      962        61      1411     17462
## 475      2135      1452      262         6       444      4300
## 476       319        18       37        12        24       410
## 477      2561        99      217        56       222      3155
## 478      3940       202      340        54       428      4963
## 479     16151      1487     2342       118      1923     22022
## 480     49210     12504     2524      4225      3411     71874
## 481     92515     74109     9092      8445      9960    194121
## 482     52876     68455     6392      3166      7247    138137
## 483     24435     41450     5363      1391      3859     76499
## 484      1872       152     1320       227       299      3870
## 485      4757      1179     8404       931      1164     16434
## 486      2874      1831    12263       647       888     18504
## 487      1673      1390    19853      2127       844     25887
## 488      8104      1786      825       356       699     11771
## 489     32335     10682     4552      3458      3649     54676
## 490     31144     19700     6178      4366      5210     66596
## 491      5435      5310     2741      1051      1336     15873
## 492      8698       157     1079       297       430     10661
## 493     27945      2559     6359      1024      2038     39924
## 494     42280     19204     8881      1570      4007     75941
## 495     32163     35900    20712      2471      4348     95594
## 496      1679        87       53        17       113      1949
## 497      2033       177       58         4       178      2450
## 498     14583      1975      763       181      1555     19057
## 499      8614      1297      441       100       823     11275
## 500     15003      3220     1175       722      1065     21186
## 501     29029     16868     4294       465      3413     54069
## 502     56046     26023    12430       640      7009    102149
## 503      2957      4981     1085        27       575      9625
## 504      3833       168      423        33       343      4800
## 505      8067       839     2491        74      1076     12547
## 506      6915      1645     2601        99      1073     12333
## 507      7541      2608     5338        87      1488     17062
## 508      1499      5964     1094       102       388      9047
## 509      5765     11335     8102       515       986     26702
## 510     15438     20036    33975      1465      2134     73048
## 511       963      7647     5393        75       446     14524
## 512     12907       897     1031       200      2303     17337
## 513     11066      2223     1339       390      2746     17764
## 514      8884      2374     6341       268      3207     21074
## 515      6893      5020     5381       231      3776     21300
## 516      3496       102      175       118       138      4029
## 517      5390       418      546       473       318      7146
## 518     21616      6117     5102      5377      2013     40225
## 519     10159      3298     2941      2009      1041     19447
## 520      5002      1189      405       161       458      7215
## 521     13801      2595     1457       605      1458     19917
## 522     35394     41538     6807      2375      6451     92564
## 523     12213     47265     4093      1331      3820     68722
## 524      1355       543     1286        10       104      3299
## 525      5887      4300    10611       612       769     22179
## 526      4263      2568     6355       396       457     14039
## 527      2994      3296     2995       578       518     10381
## 528      4060       462      325       129       312      5287
## 529      7274      2167     1173       782       930     12326
## 530      6231      2741     1206       250       811     11240
## 531      2880      2975      633       163       543      7195
## 532      1671        67       33        35        77      1884
## 533      3970        83       70        56       191      4370
## 534      6480       402      158        70       443      7554
## 535      4374       585      102        53       523      5636
## 536      7876      1453     1785       192       965     12271
## 537      5390       438      959        81       520      7388
## 538      5644      1147     3640       295       928     11655
## 539     19617      7801    16744       981      3671     48815
## 540      4192       137      166        71       171      4738
## 541      4479      2309      742        85       360      7976
## 542      7418     10612     7289       308      1238     26865
## 543       807      6774     1759        43       404      9787
## 544      2705       170      230       108       132      3344
## 545      2608       596      850       105       226      4386
## 546     11544      6136    10562       262      1972     30476
## 547      3449      2788     4794        96       634     11761
## 548      4566      1962      426        68       361      7383
## 549     16173      6839     1475       175      1611     26273
## 550     32498     14924     4263       252      3631     55569
## 551      9730      8977     4169        65      1221     24162
LS0tDQp0aXRsZTogIldlZWsgOSBUaWR5VmVyc2UvR2l0SHViIENSRUFURSBhc3NpZ25tZW50Ig0KYXV0aG9yOiAiTUQgQXNhZHVsIElzbGFtIg0KZGF0ZTogImByIFN5cy5EYXRlKClgIg0Kb3V0cHV0OiBvcGVuaW50cm86OmxhYl9yZXBvcnQNCi0tLQ0KDQpgYGB7ciBsb2FkLXBhY2thZ2VzLCBtZXNzYWdlPUZBTFNFfQ0KbGlicmFyeSh0aWR5dmVyc2UpDQpsaWJyYXJ5KHJlYWRyKQ0KYGBgDQoNCiMjIyBEYXRhU2V0DQoNCkFydGljbGUgTGluayAtIGh0dHBzOi8vcHJvamVjdHMuZml2ZXRoaXJ0eWVpZ2h0LmNvbS9yZWRsaW5pbmcvDQoNCkRhdGFzZXQgTGluayBvbiBHaXRodWIgLSBodHRwczovL2dpdGh1Yi5jb20vZml2ZXRoaXJ0eWVpZ2h0L2RhdGEvYmxvYi9tYXN0ZXIvcmVkbGluaW5nL21ldHJvLWdyYWRlcy5jc3YNCg0KIyMjIENhcGFiaWxpdHkgMTogcmVhZHIgLSByZWFkZF9jc3YNCg0KSGVyZSB3ZSB1c2UgdGhlIHJlYWRfY3N2IGZ1bmN0aW9uIGZvciByZWFkaW5nIHRoZSBjc3YgZmlsZSBmcm9tIEdpdGh1Yi4gVGhlbiB3ZSBjb21wYXJlIHRoZSB0aW1lIHRha2VuIHRvIHJlYWQgQ1NWIGZpbGUgdXNpbmcgdGhlIHRpZHl2ZXJzZSBsaWJyYXJ5IGFuZCB0aGUgUiBkZWZhdWx0IGZ1Y250aW9uIHdoaWNoIGlzIHJlYWQuY3N2LiBmcm9tIHRoZSByZXN1bHRzDQoNCmBgYHtyIGNvZGUtY2h1bmstZm9yIHJlYWRyfQ0KcmVkbGluaW5nX3BvcCA8LSAgcmVhZC5jc3YoImh0dHBzOi8vcmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbS9maXZldGhpcnR5ZWlnaHQvZGF0YS9yZWZzL2hlYWRzL21hc3Rlci9yZWRsaW5pbmcvbWV0cm8tZ3JhZGVzLmNzdiIpDQoNCmhlYWQocmVkbGluaW5nX3BvcCkNCg0Kc3lzdGVtLnRpbWUoZDwtcmVhZC5jc3YoImh0dHBzOi8vcmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbS9maXZldGhpcnR5ZWlnaHQvZGF0YS9yZWZzL2hlYWRzL21hc3Rlci9yZWRsaW5pbmcvbWV0cm8tZ3JhZGVzLmNzdiIpKQ0KDQpzeXN0ZW0udGltZShkPC1yZWFkX2NzdigiaHR0cHM6Ly9yYXcuZ2l0aHVidXNlcmNvbnRlbnQuY29tL2ZpdmV0aGlydHllaWdodC9kYXRhL3JlZnMvaGVhZHMvbWFzdGVyL3JlZGxpbmluZy9tZXRyby1ncmFkZXMuY3N2IikpDQoNCmBgYA0KDQojIyMgQ2FwYWJpbGl0eSAyOiBkcGx5ci0gZmlsdGVyKCkNCg0KdXNpbmcgZHBseXIsIHdlIGNhbiBmaWx0ZXIgdGhlIHJvd3MgZnJvbSB0aGUgZGF0YWZyYW1lIHVzaW5nIHRoZSBmaWx0ZXIgZnVuY3Rpb24uIFdlIGFwcGx5IHRoZSBmaWx0ZXIgdG8gcG9wdWxhdGlvbiBkYXRhZnJhbWUgYmFzZWQgb24gb3RoZXIgcG9wdWxhdGlvbiBjb2x1bW4NCg0KYGBge3IgY29kZSBsYWJsZSBmb3IgQ2FwYWJpbGl0eSAyIGRwbHlyfQ0KZmlsdGVyKHJlZGxpbmluZ19wb3AsIG90aGVyX3BvcCA+IDIwMDApDQpgYGANCg0KIyMjIENhcGFiaWxpdHkgMzogZHBseXIgLSBTZWxlY3QNCg0KSnVzdCBhcyB3ZSBmaWx0ZXJlZCB0aGUgcm93cyBvZiB0aGUgZGF0YWZyYW1lIGluIHRoZSBhYm92ZSBleGFtcGxlLCB3ZSBjYW4gdXNlIHNlbGVjdCBmdW5jdGlvbiB0byBmaWx0ZXIgY29sdW1ucyBvZiB0aGUgZGF0YWZyYW1lLiBJZiB5b3Ugd2FudCBvbmx5IHNwZWNpZmljIGNvbHVtbnMgcmF0aGVyIHRoYW4gdGhlIHdob2xlIHNldCBvZiBjb2x1bW5zIHdlIGNhbiB1c2Ugc2VsZWN0IGZ1bmN0aW9uIGZyb20gZHBseXIuSGVyZSBJIGZpbHRlciBibGFjaywgd2hpdGUsIGFzaWFuLCBoaXNwYW5pYW4sIG90aGVyLCBhbmQgdG90YWwgcG9wdWxhdGlvbi4NCg0KYGBge3IgY29kZSBjaHVuayBmb3Igc2VsZWN0IGZyb20gZHBseXJ9DQpzZWxlY3QocmVkbGluaW5nX3BvcCxjKCJ3aGl0ZV9wb3AiLCJibGFja19wb3AiLCJoaXNwX3BvcCIsICJhc2lhbl9wb3AiLCJvdGhlcl9wb3AiLCJ0b3RhbF9wb3AiKSkNCg0KYGBgDQoNCg==