class: center, middle, inverse, title-slide # Data Visualization as Communication ## bmRn CSM: Advanced graphing techniques with ggplot2 ### Martin Frigaard ### 2020-12-13 --- class: inverse, center, top background-image: url(img/ggplot2.png) background-position: 50% 70% background-size: 35% # `ggplot2` = a grammar for data visualization --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% # Load the packages <br><br><br><br> ```r install.packages("tidyverse") library(tidyverse) ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Outline .pull-left[ ### Recap `ggplot2` ### Graphing preliminaries - *Data Wrangling* - *Tidying* ### Variable Distributions - *Histograms, density plots, violin plots* ### Line Graphs ] .pull-right[ ### Adding Text - *Annotations, labeling values* ### Reference Lines ### Advanced Faceting - *facet_wrap(), facet_wrap_paginate(), facet_geo()* ] --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% # Materials ## Slides https://mjfrigaard.github.io/data-viz-as-comm/Index.html ## Exercises https://mjfrigaard.github.io/r-meetup-tutorials/gg01_data-viz-as-comm.html ## RStudio Project https://rstudio.cloud/project/1983257 --- class: inverse, center, top background-image: url(img/ggplot2.png) background-position: 50% 70% background-size: 35% # Recap of `ggplot2` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% # Recap of `ggplot2` ## In the previous lesson, we covered: ### 1) The grammar of graphics - `ggplot2` is a language of *layers*, organized linearly -- - `ggplot2`'s layers give us a "*linear ordering of phrases*" to build an infinite number of graphs "*which convey a gnarly network of ideas.*" -- - "**Infinitely extensible**" --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% # Recap of `ggplot2` (cont) ## In the previous lesson, we covered: ### 1) The grammar of graphics ### 2) Identifying graph aesthetics -- - position (`x` and `y`), size, color, shape, etc. -- <img src="img/graph-elements.png" width="100%" height="100%" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% # Recap of `ggplot2` (cont) ## In the previous lesson, we covered: ### 1) The grammar of graphics ### 2) Identifying graph aesthetics ### 3) Recognizing and using `geoms` -- - Scatter plot = `geom_point()` -- - Box plot = `geom_boxplot()` -- - Line graph = `geom_line()` -- - Bar graph = `geom_histogram()`, `geom_bar()`, `geom_col()` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% # Recap of `ggplot2` (cont) ## In the previous lesson, we covered: ### 1) The grammar of graphics ### 2) Identifying graph aesthetics ### 3) Recognizing and using `geoms` ### 4) Labels and factes (exercises) - **Build labels first!** -- - Facet for subplots of levels in a grouping variable --- class: inverse, center, top background-image: url(img/ggplot2.png) background-position: 50% 70% background-size: 35% # Before we start... --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Things to consider (1) -- ### Recognize the needs of your audience #### *level of data literacy, subject matter expertise, etc.* -- ### Check and communicate data quality with stakeholders #### *let them know the good and the bad news* -- ### Identify the correct data visualization (based on the data) #### *single variable, bivariate, and multivariate graphs* --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Things to consider (2) <br> ### Incorporate feedback from stakeholders/audience into graphs #### *ask them to be part of the process* -- ### Design visualizations with the appropriate detail and annotations #### *inform (and do not mislead) the audience* --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Getting started ### 1) Clearly define the question or problem - Start with a general goal, broad question, or novel problem - Move towards specific tasks -- ### 2) Matching the measurements to metrics - *'Measurements'* are what we care about - *'Metrics'* are the available data -- ### 3) Is a data visualization the best choice? - Not always... --- class: inverse, center, top background-image: url(img/ggplot2.png) background-position: 50% 70% background-size: 35% # COVID and Transportation Habits --- class: left, top background-image: url(img/ggplot2.png) background-position: 8% 94% background-size: 8% ## Example: How has COVID changed our modes of transportation? ### What kind of measurements would these be? ***how are people traveling (walk, drive, etc.)*** -- ### What would these data look like? ***what would the columns and rows look like?*** --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% # Apple Mobility Data ## Fortunately, these data exist! Apple released mobility data: https://covid19.apple.com/mobility Import these data below: ```r AppleMobRaw <- readr::read_csv("https://bit.ly/36tTVpe") ``` *Use `Raw` as a prefix or suffix for data in it's most 'raw' state* --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% # Raw Apple Mobility Data ```r AppleMobRaw %>% View("Apple") ``` <img src="img/apple-mob-view.png" width="95%" height="95%" style="display: block; margin: auto;" /> --- class: inverse, center, top background-image: url(img/ggplot2.png) background-position: 50% 70% background-size: 35% # Wrangling Apple Mobility Data --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Wrangling Apple Mobility Data -- <br> ### What variables do we have? -- ### How are these variables formatted? -- ### How do we need to change them? -- #### *...with a focus on answering our question* --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## View Apple Mobility Data (head) ```r AppleMobRaw %>% head() ``` <div data-pagedtable="false"> <script data-pagedtable-source type="application/json"> {"columns":[{"label":["geo_type"],"name":[1],"type":["chr"],"align":["left"]},{"label":["region"],"name":[2],"type":["chr"],"align":["left"]},{"label":["transportation_type"],"name":[3],"type":["chr"],"align":["left"]},{"label":["sub-region"],"name":[4],"type":["chr"],"align":["left"]},{"label":["country"],"name":[5],"type":["chr"],"align":["left"]},{"label":["2020-01-13"],"name":[6],"type":["dbl"],"align":["right"]},{"label":["2020-01-14"],"name":[7],"type":["dbl"],"align":["right"]},{"label":["2020-01-15"],"name":[8],"type":["dbl"],"align":["right"]},{"label":["2020-01-16"],"name":[9],"type":["dbl"],"align":["right"]},{"label":["2020-01-17"],"name":[10],"type":["dbl"],"align":["right"]},{"label":["2020-01-18"],"name":[11],"type":["dbl"],"align":["right"]},{"label":["2020-01-19"],"name":[12],"type":["dbl"],"align":["right"]},{"label":["2020-01-20"],"name":[13],"type":["dbl"],"align":["right"]},{"label":["2020-01-21"],"name":[14],"type":["dbl"],"align":["right"]},{"label":["2020-01-22"],"name":[15],"type":["dbl"],"align":["right"]},{"label":["2020-01-23"],"name":[16],"type":["dbl"],"align":["right"]},{"label":["2020-01-24"],"name":[17],"type":["dbl"],"align":["right"]},{"label":["2020-01-25"],"name":[18],"type":["dbl"],"align":["right"]},{"label":["2020-01-26"],"name":[19],"type":["dbl"],"align":["right"]},{"label":["2020-01-27"],"name":[20],"type":["dbl"],"align":["right"]},{"label":["2020-01-28"],"name":[21],"type":["dbl"],"align":["right"]},{"label":["2020-01-29"],"name":[22],"type":["dbl"],"align":["right"]},{"label":["2020-01-30"],"name":[23],"type":["dbl"],"align":["right"]},{"label":["2020-01-31"],"name":[24],"type":["dbl"],"align":["right"]},{"label":["2020-02-01"],"name":[25],"type":["dbl"],"align":["right"]},{"label":["2020-02-02"],"name":[26],"type":["dbl"],"align":["right"]},{"label":["2020-02-03"],"name":[27],"type":["dbl"],"align":["right"]},{"label":["2020-02-04"],"name":[28],"type":["dbl"],"align":["right"]},{"label":["2020-02-05"],"name":[29],"type":["dbl"],"align":["right"]},{"label":["2020-02-06"],"name":[30],"type":["dbl"],"align":["right"]},{"label":["2020-02-07"],"name":[31],"type":["dbl"],"align":["right"]},{"label":["2020-02-08"],"name":[32],"type":["dbl"],"align":["right"]},{"label":["2020-02-09"],"name":[33],"type":["dbl"],"align":["right"]},{"label":["2020-02-10"],"name":[34],"type":["dbl"],"align":["right"]},{"label":["2020-02-11"],"name":[35],"type":["dbl"],"align":["right"]},{"label":["2020-02-12"],"name":[36],"type":["dbl"],"align":["right"]},{"label":["2020-02-13"],"name":[37],"type":["dbl"],"align":["right"]},{"label":["2020-02-14"],"name":[38],"type":["dbl"],"align":["right"]},{"label":["2020-02-15"],"name":[39],"type":["dbl"],"align":["right"]},{"label":["2020-02-16"],"name":[40],"type":["dbl"],"align":["right"]},{"label":["2020-02-17"],"name":[41],"type":["dbl"],"align":["right"]},{"label":["2020-02-18"],"name":[42],"type":["dbl"],"align":["right"]},{"label":["2020-02-19"],"name":[43],"type":["dbl"],"align":["right"]},{"label":["2020-02-20"],"name":[44],"type":["dbl"],"align":["right"]},{"label":["2020-02-21"],"name":[45],"type":["dbl"],"align":["right"]},{"label":["2020-02-22"],"name":[46],"type":["dbl"],"align":["right"]},{"label":["2020-02-23"],"name":[47],"type":["dbl"],"align":["right"]},{"label":["2020-02-24"],"name":[48],"type":["dbl"],"align":["right"]},{"label":["2020-02-25"],"name":[49],"type":["dbl"],"align":["right"]},{"label":["2020-02-26"],"name":[50],"type":["dbl"],"align":["right"]},{"label":["2020-02-27"],"name":[51],"type":["dbl"],"align":["right"]},{"label":["2020-02-28"],"name":[52],"type":["dbl"],"align":["right"]},{"label":["2020-02-29"],"name":[53],"type":["dbl"],"align":["right"]},{"label":["2020-03-01"],"name":[54],"type":["dbl"],"align":["right"]},{"label":["2020-03-02"],"name":[55],"type":["dbl"],"align":["right"]},{"label":["2020-03-03"],"name":[56],"type":["dbl"],"align":["right"]},{"label":["2020-03-04"],"name":[57],"type":["dbl"],"align":["right"]},{"label":["2020-03-05"],"name":[58],"type":["dbl"],"align":["right"]},{"label":["2020-03-06"],"name":[59],"type":["dbl"],"align":["right"]},{"label":["2020-03-07"],"name":[60],"type":["dbl"],"align":["right"]},{"label":["2020-03-08"],"name":[61],"type":["dbl"],"align":["right"]},{"label":["2020-03-09"],"name":[62],"type":["dbl"],"align":["right"]},{"label":["2020-03-10"],"name":[63],"type":["dbl"],"align":["right"]},{"label":["2020-03-11"],"name":[64],"type":["dbl"],"align":["right"]},{"label":["2020-03-12"],"name":[65],"type":["dbl"],"align":["right"]},{"label":["2020-03-13"],"name":[66],"type":["dbl"],"align":["right"]},{"label":["2020-03-14"],"name":[67],"type":["dbl"],"align":["right"]},{"label":["2020-03-15"],"name":[68],"type":["dbl"],"align":["right"]},{"label":["2020-03-16"],"name":[69],"type":["dbl"],"align":["right"]},{"label":["2020-03-17"],"name":[70],"type":["dbl"],"align":["right"]},{"label":["2020-03-18"],"name":[71],"type":["dbl"],"align":["right"]},{"label":["2020-03-19"],"name":[72],"type":["dbl"],"align":["right"]},{"label":["2020-03-20"],"name":[73],"type":["dbl"],"align":["right"]},{"label":["2020-03-21"],"name":[74],"type":["dbl"],"align":["right"]},{"label":["2020-03-22"],"name":[75],"type":["dbl"],"align":["right"]},{"label":["2020-03-23"],"name":[76],"type":["dbl"],"align":["right"]},{"label":["2020-03-24"],"name":[77],"type":["dbl"],"align":["right"]},{"label":["2020-03-25"],"name":[78],"type":["dbl"],"align":["right"]},{"label":["2020-03-26"],"name":[79],"type":["dbl"],"align":["right"]},{"label":["2020-03-27"],"name":[80],"type":["dbl"],"align":["right"]},{"label":["2020-03-28"],"name":[81],"type":["dbl"],"align":["right"]},{"label":["2020-03-29"],"name":[82],"type":["dbl"],"align":["right"]},{"label":["2020-03-30"],"name":[83],"type":["dbl"],"align":["right"]},{"label":["2020-03-31"],"name":[84],"type":["dbl"],"align":["right"]},{"label":["2020-04-01"],"name":[85],"type":["dbl"],"align":["right"]},{"label":["2020-04-02"],"name":[86],"type":["dbl"],"align":["right"]},{"label":["2020-04-03"],"name":[87],"type":["dbl"],"align":["right"]},{"label":["2020-04-04"],"name":[88],"type":["dbl"],"align":["right"]},{"label":["2020-04-05"],"name":[89],"type":["dbl"],"align":["right"]},{"label":["2020-04-06"],"name":[90],"type":["dbl"],"align":["right"]},{"label":["2020-04-07"],"name":[91],"type":["dbl"],"align":["right"]},{"label":["2020-04-08"],"name":[92],"type":["dbl"],"align":["right"]},{"label":["2020-04-09"],"name":[93],"type":["dbl"],"align":["right"]},{"label":["2020-04-10"],"name":[94],"type":["dbl"],"align":["right"]},{"label":["2020-04-11"],"name":[95],"type":["dbl"],"align":["right"]},{"label":["2020-04-12"],"name":[96],"type":["dbl"],"align":["right"]},{"label":["2020-04-13"],"name":[97],"type":["dbl"],"align":["right"]},{"label":["2020-04-14"],"name":[98],"type":["dbl"],"align":["right"]},{"label":["2020-04-15"],"name":[99],"type":["dbl"],"align":["right"]},{"label":["2020-04-16"],"name":[100],"type":["dbl"],"align":["right"]},{"label":["2020-04-17"],"name":[101],"type":["dbl"],"align":["right"]},{"label":["2020-04-18"],"name":[102],"type":["dbl"],"align":["right"]},{"label":["2020-04-19"],"name":[103],"type":["dbl"],"align":["right"]},{"label":["2020-04-20"],"name":[104],"type":["dbl"],"align":["right"]},{"label":["2020-04-21"],"name":[105],"type":["dbl"],"align":["right"]},{"label":["2020-04-22"],"name":[106],"type":["dbl"],"align":["right"]},{"label":["2020-04-23"],"name":[107],"type":["dbl"],"align":["right"]},{"label":["2020-04-24"],"name":[108],"type":["dbl"],"align":["right"]},{"label":["2020-04-25"],"name":[109],"type":["dbl"],"align":["right"]},{"label":["2020-04-26"],"name":[110],"type":["dbl"],"align":["right"]},{"label":["2020-04-27"],"name":[111],"type":["dbl"],"align":["right"]},{"label":["2020-04-28"],"name":[112],"type":["dbl"],"align":["right"]},{"label":["2020-04-29"],"name":[113],"type":["dbl"],"align":["right"]},{"label":["2020-04-30"],"name":[114],"type":["dbl"],"align":["right"]},{"label":["2020-05-01"],"name":[115],"type":["dbl"],"align":["right"]},{"label":["2020-05-02"],"name":[116],"type":["dbl"],"align":["right"]},{"label":["2020-05-03"],"name":[117],"type":["dbl"],"align":["right"]},{"label":["2020-05-04"],"name":[118],"type":["dbl"],"align":["right"]},{"label":["2020-05-05"],"name":[119],"type":["dbl"],"align":["right"]},{"label":["2020-05-06"],"name":[120],"type":["dbl"],"align":["right"]},{"label":["2020-05-07"],"name":[121],"type":["dbl"],"align":["right"]},{"label":["2020-05-08"],"name":[122],"type":["dbl"],"align":["right"]},{"label":["2020-05-09"],"name":[123],"type":["dbl"],"align":["right"]},{"label":["2020-05-10"],"name":[124],"type":["dbl"],"align":["right"]},{"label":["2020-05-11"],"name":[125],"type":["dbl"],"align":["right"]},{"label":["2020-05-12"],"name":[126],"type":["dbl"],"align":["right"]},{"label":["2020-05-13"],"name":[127],"type":["dbl"],"align":["right"]},{"label":["2020-05-14"],"name":[128],"type":["dbl"],"align":["right"]},{"label":["2020-05-15"],"name":[129],"type":["dbl"],"align":["right"]},{"label":["2020-05-16"],"name":[130],"type":["dbl"],"align":["right"]},{"label":["2020-05-17"],"name":[131],"type":["dbl"],"align":["right"]},{"label":["2020-05-18"],"name":[132],"type":["dbl"],"align":["right"]},{"label":["2020-05-19"],"name":[133],"type":["dbl"],"align":["right"]},{"label":["2020-05-20"],"name":[134],"type":["dbl"],"align":["right"]},{"label":["2020-05-21"],"name":[135],"type":["dbl"],"align":["right"]},{"label":["2020-05-22"],"name":[136],"type":["dbl"],"align":["right"]},{"label":["2020-05-23"],"name":[137],"type":["dbl"],"align":["right"]},{"label":["2020-05-24"],"name":[138],"type":["dbl"],"align":["right"]},{"label":["2020-05-25"],"name":[139],"type":["dbl"],"align":["right"]},{"label":["2020-05-26"],"name":[140],"type":["dbl"],"align":["right"]},{"label":["2020-05-27"],"name":[141],"type":["dbl"],"align":["right"]},{"label":["2020-05-28"],"name":[142],"type":["dbl"],"align":["right"]},{"label":["2020-05-29"],"name":[143],"type":["dbl"],"align":["right"]},{"label":["2020-05-30"],"name":[144],"type":["dbl"],"align":["right"]},{"label":["2020-05-31"],"name":[145],"type":["dbl"],"align":["right"]},{"label":["2020-06-01"],"name":[146],"type":["dbl"],"align":["right"]},{"label":["2020-06-02"],"name":[147],"type":["dbl"],"align":["right"]},{"label":["2020-06-03"],"name":[148],"type":["dbl"],"align":["right"]},{"label":["2020-06-04"],"name":[149],"type":["dbl"],"align":["right"]},{"label":["2020-06-05"],"name":[150],"type":["dbl"],"align":["right"]},{"label":["2020-06-06"],"name":[151],"type":["dbl"],"align":["right"]},{"label":["2020-06-07"],"name":[152],"type":["dbl"],"align":["right"]},{"label":["2020-06-08"],"name":[153],"type":["dbl"],"align":["right"]},{"label":["2020-06-09"],"name":[154],"type":["dbl"],"align":["right"]},{"label":["2020-06-10"],"name":[155],"type":["dbl"],"align":["right"]},{"label":["2020-06-11"],"name":[156],"type":["dbl"],"align":["right"]},{"label":["2020-06-12"],"name":[157],"type":["dbl"],"align":["right"]},{"label":["2020-06-13"],"name":[158],"type":["dbl"],"align":["right"]},{"label":["2020-06-14"],"name":[159],"type":["dbl"],"align":["right"]},{"label":["2020-06-15"],"name":[160],"type":["dbl"],"align":["right"]},{"label":["2020-06-16"],"name":[161],"type":["dbl"],"align":["right"]},{"label":["2020-06-17"],"name":[162],"type":["dbl"],"align":["right"]},{"label":["2020-06-18"],"name":[163],"type":["dbl"],"align":["right"]},{"label":["2020-06-19"],"name":[164],"type":["dbl"],"align":["right"]},{"label":["2020-06-20"],"name":[165],"type":["dbl"],"align":["right"]},{"label":["2020-06-21"],"name":[166],"type":["dbl"],"align":["right"]},{"label":["2020-06-22"],"name":[167],"type":["dbl"],"align":["right"]},{"label":["2020-06-23"],"name":[168],"type":["dbl"],"align":["right"]},{"label":["2020-06-24"],"name":[169],"type":["dbl"],"align":["right"]},{"label":["2020-06-25"],"name":[170],"type":["dbl"],"align":["right"]},{"label":["2020-06-26"],"name":[171],"type":["dbl"],"align":["right"]},{"label":["2020-06-27"],"name":[172],"type":["dbl"],"align":["right"]},{"label":["2020-06-28"],"name":[173],"type":["dbl"],"align":["right"]},{"label":["2020-06-29"],"name":[174],"type":["dbl"],"align":["right"]},{"label":["2020-06-30"],"name":[175],"type":["dbl"],"align":["right"]},{"label":["2020-07-01"],"name":[176],"type":["dbl"],"align":["right"]},{"label":["2020-07-02"],"name":[177],"type":["dbl"],"align":["right"]},{"label":["2020-07-03"],"name":[178],"type":["dbl"],"align":["right"]},{"label":["2020-07-04"],"name":[179],"type":["dbl"],"align":["right"]},{"label":["2020-07-05"],"name":[180],"type":["dbl"],"align":["right"]},{"label":["2020-07-06"],"name":[181],"type":["dbl"],"align":["right"]},{"label":["2020-07-07"],"name":[182],"type":["dbl"],"align":["right"]},{"label":["2020-07-08"],"name":[183],"type":["dbl"],"align":["right"]},{"label":["2020-07-09"],"name":[184],"type":["dbl"],"align":["right"]},{"label":["2020-07-10"],"name":[185],"type":["dbl"],"align":["right"]},{"label":["2020-07-11"],"name":[186],"type":["dbl"],"align":["right"]},{"label":["2020-07-12"],"name":[187],"type":["dbl"],"align":["right"]},{"label":["2020-07-13"],"name":[188],"type":["dbl"],"align":["right"]},{"label":["2020-07-14"],"name":[189],"type":["dbl"],"align":["right"]},{"label":["2020-07-15"],"name":[190],"type":["dbl"],"align":["right"]},{"label":["2020-07-16"],"name":[191],"type":["dbl"],"align":["right"]},{"label":["2020-07-17"],"name":[192],"type":["dbl"],"align":["right"]},{"label":["2020-07-18"],"name":[193],"type":["dbl"],"align":["right"]},{"label":["2020-07-19"],"name":[194],"type":["dbl"],"align":["right"]},{"label":["2020-07-20"],"name":[195],"type":["dbl"],"align":["right"]},{"label":["2020-07-21"],"name":[196],"type":["dbl"],"align":["right"]},{"label":["2020-07-22"],"name":[197],"type":["dbl"],"align":["right"]},{"label":["2020-07-23"],"name":[198],"type":["dbl"],"align":["right"]},{"label":["2020-07-24"],"name":[199],"type":["dbl"],"align":["right"]},{"label":["2020-07-25"],"name":[200],"type":["dbl"],"align":["right"]},{"label":["2020-07-26"],"name":[201],"type":["dbl"],"align":["right"]},{"label":["2020-07-27"],"name":[202],"type":["dbl"],"align":["right"]},{"label":["2020-07-28"],"name":[203],"type":["dbl"],"align":["right"]},{"label":["2020-07-29"],"name":[204],"type":["dbl"],"align":["right"]},{"label":["2020-07-30"],"name":[205],"type":["dbl"],"align":["right"]},{"label":["2020-07-31"],"name":[206],"type":["dbl"],"align":["right"]},{"label":["2020-08-01"],"name":[207],"type":["dbl"],"align":["right"]},{"label":["2020-08-02"],"name":[208],"type":["dbl"],"align":["right"]},{"label":["2020-08-03"],"name":[209],"type":["dbl"],"align":["right"]},{"label":["2020-08-04"],"name":[210],"type":["dbl"],"align":["right"]},{"label":["2020-08-05"],"name":[211],"type":["dbl"],"align":["right"]},{"label":["2020-08-06"],"name":[212],"type":["dbl"],"align":["right"]},{"label":["2020-08-07"],"name":[213],"type":["dbl"],"align":["right"]},{"label":["2020-08-08"],"name":[214],"type":["dbl"],"align":["right"]},{"label":["2020-08-09"],"name":[215],"type":["dbl"],"align":["right"]},{"label":["2020-08-10"],"name":[216],"type":["dbl"],"align":["right"]},{"label":["2020-08-11"],"name":[217],"type":["dbl"],"align":["right"]},{"label":["2020-08-12"],"name":[218],"type":["dbl"],"align":["right"]},{"label":["2020-08-13"],"name":[219],"type":["dbl"],"align":["right"]},{"label":["2020-08-14"],"name":[220],"type":["dbl"],"align":["right"]},{"label":["2020-08-15"],"name":[221],"type":["dbl"],"align":["right"]},{"label":["2020-08-16"],"name":[222],"type":["dbl"],"align":["right"]},{"label":["2020-08-17"],"name":[223],"type":["dbl"],"align":["right"]},{"label":["2020-08-18"],"name":[224],"type":["dbl"],"align":["right"]},{"label":["2020-08-19"],"name":[225],"type":["dbl"],"align":["right"]},{"label":["2020-08-20"],"name":[226],"type":["dbl"],"align":["right"]},{"label":["2020-08-21"],"name":[227],"type":["dbl"],"align":["right"]},{"label":["2020-08-22"],"name":[228],"type":["dbl"],"align":["right"]},{"label":["2020-08-23"],"name":[229],"type":["dbl"],"align":["right"]},{"label":["2020-08-24"],"name":[230],"type":["dbl"],"align":["right"]},{"label":["2020-08-25"],"name":[231],"type":["dbl"],"align":["right"]},{"label":["2020-08-26"],"name":[232],"type":["dbl"],"align":["right"]},{"label":["2020-08-27"],"name":[233],"type":["dbl"],"align":["right"]},{"label":["2020-08-28"],"name":[234],"type":["dbl"],"align":["right"]},{"label":["2020-08-29"],"name":[235],"type":["dbl"],"align":["right"]},{"label":["2020-08-30"],"name":[236],"type":["dbl"],"align":["right"]},{"label":["2020-08-31"],"name":[237],"type":["dbl"],"align":["right"]},{"label":["2020-09-01"],"name":[238],"type":["dbl"],"align":["right"]},{"label":["2020-09-02"],"name":[239],"type":["dbl"],"align":["right"]},{"label":["2020-09-03"],"name":[240],"type":["dbl"],"align":["right"]},{"label":["2020-09-04"],"name":[241],"type":["dbl"],"align":["right"]},{"label":["2020-09-05"],"name":[242],"type":["dbl"],"align":["right"]},{"label":["2020-09-06"],"name":[243],"type":["dbl"],"align":["right"]},{"label":["2020-09-07"],"name":[244],"type":["dbl"],"align":["right"]},{"label":["2020-09-08"],"name":[245],"type":["dbl"],"align":["right"]},{"label":["2020-09-09"],"name":[246],"type":["dbl"],"align":["right"]},{"label":["2020-09-10"],"name":[247],"type":["dbl"],"align":["right"]},{"label":["2020-09-11"],"name":[248],"type":["dbl"],"align":["right"]},{"label":["2020-09-12"],"name":[249],"type":["dbl"],"align":["right"]},{"label":["2020-09-13"],"name":[250],"type":["dbl"],"align":["right"]},{"label":["2020-09-14"],"name":[251],"type":["dbl"],"align":["right"]},{"label":["2020-09-15"],"name":[252],"type":["dbl"],"align":["right"]},{"label":["2020-09-16"],"name":[253],"type":["dbl"],"align":["right"]},{"label":["2020-09-17"],"name":[254],"type":["dbl"],"align":["right"]},{"label":["2020-09-18"],"name":[255],"type":["dbl"],"align":["right"]},{"label":["2020-09-19"],"name":[256],"type":["dbl"],"align":["right"]},{"label":["2020-09-20"],"name":[257],"type":["dbl"],"align":["right"]},{"label":["2020-09-21"],"name":[258],"type":["dbl"],"align":["right"]},{"label":["2020-09-22"],"name":[259],"type":["dbl"],"align":["right"]},{"label":["2020-09-23"],"name":[260],"type":["dbl"],"align":["right"]},{"label":["2020-09-24"],"name":[261],"type":["dbl"],"align":["right"]},{"label":["2020-09-25"],"name":[262],"type":["dbl"],"align":["right"]},{"label":["2020-09-26"],"name":[263],"type":["dbl"],"align":["right"]},{"label":["2020-09-27"],"name":[264],"type":["dbl"],"align":["right"]},{"label":["2020-09-28"],"name":[265],"type":["dbl"],"align":["right"]},{"label":["2020-09-29"],"name":[266],"type":["dbl"],"align":["right"]},{"label":["2020-09-30"],"name":[267],"type":["dbl"],"align":["right"]},{"label":["2020-10-01"],"name":[268],"type":["dbl"],"align":["right"]},{"label":["2020-10-02"],"name":[269],"type":["dbl"],"align":["right"]},{"label":["2020-10-03"],"name":[270],"type":["dbl"],"align":["right"]},{"label":["2020-10-04"],"name":[271],"type":["dbl"],"align":["right"]},{"label":["2020-10-05"],"name":[272],"type":["dbl"],"align":["right"]},{"label":["2020-10-06"],"name":[273],"type":["dbl"],"align":["right"]},{"label":["2020-10-07"],"name":[274],"type":["dbl"],"align":["right"]},{"label":["2020-10-08"],"name":[275],"type":["dbl"],"align":["right"]},{"label":["2020-10-09"],"name":[276],"type":["dbl"],"align":["right"]},{"label":["2020-10-10"],"name":[277],"type":["dbl"],"align":["right"]},{"label":["2020-10-11"],"name":[278],"type":["dbl"],"align":["right"]},{"label":["2020-10-12"],"name":[279],"type":["dbl"],"align":["right"]},{"label":["2020-10-13"],"name":[280],"type":["dbl"],"align":["right"]},{"label":["2020-10-14"],"name":[281],"type":["dbl"],"align":["right"]},{"label":["2020-10-15"],"name":[282],"type":["dbl"],"align":["right"]},{"label":["2020-10-16"],"name":[283],"type":["dbl"],"align":["right"]},{"label":["2020-10-17"],"name":[284],"type":["dbl"],"align":["right"]},{"label":["2020-10-18"],"name":[285],"type":["dbl"],"align":["right"]},{"label":["2020-10-19"],"name":[286],"type":["dbl"],"align":["right"]},{"label":["2020-10-20"],"name":[287],"type":["dbl"],"align":["right"]},{"label":["2020-10-21"],"name":[288],"type":["dbl"],"align":["right"]},{"label":["2020-10-22"],"name":[289],"type":["dbl"],"align":["right"]},{"label":["2020-10-23"],"name":[290],"type":["dbl"],"align":["right"]},{"label":["2020-10-24"],"name":[291],"type":["dbl"],"align":["right"]},{"label":["2020-10-25"],"name":[292],"type":["dbl"],"align":["right"]},{"label":["2020-10-26"],"name":[293],"type":["dbl"],"align":["right"]},{"label":["2020-10-27"],"name":[294],"type":["dbl"],"align":["right"]},{"label":["2020-10-28"],"name":[295],"type":["dbl"],"align":["right"]},{"label":["2020-10-29"],"name":[296],"type":["dbl"],"align":["right"]},{"label":["2020-10-30"],"name":[297],"type":["dbl"],"align":["right"]},{"label":["2020-10-31"],"name":[298],"type":["dbl"],"align":["right"]},{"label":["2020-11-01"],"name":[299],"type":["dbl"],"align":["right"]},{"label":["2020-11-02"],"name":[300],"type":["dbl"],"align":["right"]},{"label":["2020-11-03"],"name":[301],"type":["dbl"],"align":["right"]},{"label":["2020-11-04"],"name":[302],"type":["dbl"],"align":["right"]},{"label":["2020-11-05"],"name":[303],"type":["dbl"],"align":["right"]},{"label":["2020-11-06"],"name":[304],"type":["dbl"],"align":["right"]},{"label":["2020-11-07"],"name":[305],"type":["dbl"],"align":["right"]},{"label":["2020-11-08"],"name":[306],"type":["dbl"],"align":["right"]},{"label":["2020-11-09"],"name":[307],"type":["dbl"],"align":["right"]},{"label":["2020-11-10"],"name":[308],"type":["dbl"],"align":["right"]},{"label":["2020-11-11"],"name":[309],"type":["dbl"],"align":["right"]},{"label":["2020-11-12"],"name":[310],"type":["dbl"],"align":["right"]},{"label":["2020-11-13"],"name":[311],"type":["dbl"],"align":["right"]},{"label":["2020-11-14"],"name":[312],"type":["dbl"],"align":["right"]},{"label":["2020-11-15"],"name":[313],"type":["dbl"],"align":["right"]},{"label":["2020-11-16"],"name":[314],"type":["dbl"],"align":["right"]},{"label":["2020-11-17"],"name":[315],"type":["dbl"],"align":["right"]},{"label":["2020-11-18"],"name":[316],"type":["dbl"],"align":["right"]},{"label":["2020-11-19"],"name":[317],"type":["dbl"],"align":["right"]},{"label":["2020-11-20"],"name":[318],"type":["dbl"],"align":["right"]},{"label":["2020-11-21"],"name":[319],"type":["dbl"],"align":["right"]},{"label":["2020-11-22"],"name":[320],"type":["dbl"],"align":["right"]},{"label":["2020-11-23"],"name":[321],"type":["dbl"],"align":["right"]},{"label":["2020-11-24"],"name":[322],"type":["dbl"],"align":["right"]}],"data":[{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"100","7":"95.30","8":"101.43","9":"97.20","10":"103.55","11":"112.67","12":"104.83","13":"94.39","14":"94.07","15":"93.51","16":"92.94","17":"102.13","18":"102.38","19":"101.41","20":"94.62","21":"89.12","22":"90.17","23":"90.21","24":"97.71","25":"102.50","26":"108.92","27":"92.82","28":"91.48","29":"93.99","30":"96.72","31":"102.46","32":"103.29","33":"107.83","34":"87.99","35":"94.18","36":"94.62","37":"99.70","38":"139.30","39":"123.90","40":"129.41","41":"102.24","42":"88.09","43":"88.17","44":"94.48","45":"100.62","46":"111.02","47":"113.50","48":"86.95","49":"83.01","50":"85.44","51":"82.73","52":"89.70","53":"95.48","54":"100.43","55":"89.25","56":"91.02","57":"89.72","58":"94.87","59":"102.82","60":"109.92","61":"110.07","62":"79.68","63":"68.24","64":"51.77","65":"43.79","66":"24.99","67":"24.61","68":"30.93","69":"24.69","70":"24.95","71":"24.65","72":"24.50","73":"26.31","74":"20.39","75":"19.29","76":"22.62","77":"21.61","78":"21.98","79":"23.07","80":"23.94","81":"19.49","82":"21.78","83":"23.66","84":"25.11","85":"25.02","86":"25.20","87":"24.11","88":"20.54","89":"22.54","90":"26.40","91":"26.03","92":"26.43","93":"26.70","94":"26.32","95":"25.47","96":"24.89","97":"32.64","98":"31.43","99":"30.67","100":"30.00","101":"29.26","102":"22.94","103":"24.55","104":"31.51","105":"33.59","106":"31.69","107":"33.94","108":"30.22","109":"25.22","110":"30.39","111":"37.39","112":"36.69","113":"35.90","114":"38.09","115":"37.23","116":"29.36","117":"36.00","118":"43.69","119":"42.61","120":"43.11","121":"46.13","122":"45.78","123":"41.59","124":"45.39","125":"NA","126":"NA","127":"49.19","128":"50.20","129":"48.30","130":"46.78","131":"45.51","132":"56.09","133":"51.12","134":"59.04","135":"61.14","136":"65.34","137":"56.11","138":"53.39","139":"73.94","140":"66.27","141":"65.59","142":"66.11","143":"67.85","144":"67.47","145":"68.61","146":"90.62","147":"88.33","148":"89.97","149":"84.30","150":"93.46","151":"102.16","152":"111.59","153":"93.78","154":"95.51","155":"92.69","156":"96.27","157":"115.30","158":"126.24","159":"129.96","160":"101.84","161":"97.59","162":"95.12","163":"99.95","164":"119.85","165":"136.26","166":"128.16","167":"109.24","168":"105.57","169":"113.27","170":"115.80","171":"133.38","172":"155.72","173":"161.94","174":"130.65","175":"124.90","176":"132.89","177":"139.08","178":"160.34","179":"175.05","180":"177.07","181":"136.78","182":"126.97","183":"133.58","184":"141.22","185":"173.05","186":"186.83","187":"181.11","188":"146.93","189":"145.32","190":"144.73","191":"153.00","192":"169.21","193":"178.32","194":"185.37","195":"166.63","196":"162.41","197":"164.63","198":"169.36","199":"190.83","200":"206.45","201":"202.15","202":"178.29","203":"168.26","204":"169.05","205":"176.53","206":"197.01","207":"233.20","208":"229.20","209":"213.40","210":"193.56","211":"201.82","212":"187.74","213":"203.09","214":"218.60","215":"234.00","216":"230.14","217":"215.44","218":"216.40","219":"232.93","220":"248.51","221":"267.54","222":"255.43","223":"229.61","224":"216.43","225":"209.82","226":"228.91","227":"243.15","228":"244.20","229":"248.13","230":"208.60","231":"203.25","232":"199.51","233":"193.41","234":"210.27","235":"213.67","236":"224.94","237":"183.16","238":"182.53","239":"175.83","240":"180.73","241":"199.09","242":"210.34","243":"201.66","244":"183.13","245":"171.18","246":"171.54","247":"166.72","248":"175.48","249":"186.57","250":"173.76","251":"142.75","252":"144.04","253":"135.62","254":"140.86","255":"151.82","256":"164.99","257":"160.00","258":"126.60","259":"128.29","260":"122.76","261":"118.41","262":"122.77","263":"117.15","264":"123.03","265":"117.30","266":"116.38","267":"119.24","268":"118.79","269":"130.25","270":"148.03","271":"136.67","272":"123.11","273":"117.50","274":"119.25","275":"113.17","276":"126.39","277":"144.47","278":"148.87","279":"123.94","280":"111.80","281":"113.31","282":"111.52","283":"117.39","284":"128.99","285":"137.88","286":"114.93","287":"112.42","288":"115.57","289":"113.05","290":"118.95","291":"126.12","292":"132.18","293":"130.38","294":"120.18","295":"115.54","296":"114.57","297":"128.96","298":"146.62","299":"139.16","300":"121.37","301":"111.55","302":"110.75","303":"105.40","304":"117.91","305":"133.42","306":"139.40","307":"110.57","308":"101.74","309":"96.27","310":"96.95","311":"105.27","312":"119.25","313":"115.27","314":"98.04","315":"91.08","316":"90.14","317":"97.88","318":"99.05","319":"111.07","320":"115.80","321":"99.44","322":"97.01"},{"1":"country/region","2":"Albania","3":"walking","4":"NA","5":"NA","6":"100","7":"100.68","8":"98.93","9":"98.46","10":"100.85","11":"100.13","12":"82.13","13":"95.65","14":"97.78","15":"95.39","16":"94.24","17":"93.73","18":"97.06","19":"77.27","20":"83.37","21":"82.73","22":"84.39","23":"88.19","24":"90.79","25":"88.70","26":"79.32","27":"87.12","28":"88.06","29":"99.40","30":"85.84","31":"94.63","32":"99.74","33":"81.41","34":"90.19","35":"90.45","36":"94.16","37":"95.69","38":"109.21","39":"108.40","40":"84.52","41":"96.63","42":"87.38","43":"81.49","44":"87.21","45":"93.52","46":"94.50","47":"74.80","48":"87.25","49":"81.41","50":"77.78","51":"74.50","52":"81.19","53":"87.97","54":"78.42","55":"94.88","56":"95.65","57":"91.13","58":"94.46","59":"103.80","60":"92.92","61":"82.47","62":"87.25","63":"63.37","64":"46.70","65":"37.87","66":"31.43","67":"37.78","68":"37.44","69":"35.95","70":"30.87","71":"33.56","72":"36.84","73":"32.62","74":"27.12","75":"22.64","76":"25.93","77":"25.88","78":"25.42","79":"23.03","80":"28.27","81":"24.69","82":"20.26","83":"22.90","84":"25.93","85":"23.50","86":"26.65","87":"27.76","88":"24.90","89":"23.92","90":"31.13","91":"25.80","92":"29.81","93":"28.96","94":"27.29","95":"27.63","96":"29.59","97":"35.52","98":"38.08","99":"35.48","100":"39.15","101":"34.58","102":"27.76","103":"27.93","104":"36.72","105":"34.46","106":"35.39","107":"34.80","108":"34.63","109":"29.00","110":"35.22","111":"41.83","112":"37.53","113":"41.49","114":"38.25","115":"38.68","116":"32.28","117":"43.41","118":"49.59","119":"46.44","120":"52.84","121":"52.37","122":"48.10","123":"44.86","124":"68.87","125":"NA","126":"NA","127":"61.79","128":"56.46","129":"54.41","130":"48.36","131":"45.20","132":"67.46","133":"63.20","134":"66.57","135":"67.97","136":"68.49","137":"48.02","138":"42.56","139":"74.97","140":"70.66","141":"65.67","142":"67.16","143":"69.89","144":"56.67","145":"59.53","146":"84.18","147":"93.86","148":"87.72","149":"94.75","150":"83.24","151":"81.96","152":"87.25","153":"87.38","154":"90.83","155":"91.09","156":"89.13","157":"97.74","158":"97.95","159":"77.91","160":"88.49","161":"92.28","162":"89.77","163":"94.63","164":"96.59","165":"97.74","166":"84.18","167":"96.67","168":"97.83","169":"103.88","170":"105.03","171":"113.26","172":"107.46","173":"103.24","174":"146.01","175":"111.47","176":"108.40","177":"119.32","178":"125.76","179":"116.59","180":"105.16","181":"119.19","182":"113.73","183":"110.19","184":"114.84","185":"130.70","186":"123.84","187":"109.81","188":"118.08","189":"120.04","190":"126.14","191":"137.78","192":"128.27","193":"137.61","194":"107.59","195":"136.33","196":"127.42","197":"128.96","198":"131.30","199":"133.39","200":"137.95","201":"116.08","202":"134.41","203":"131.60","204":"125.50","205":"121.19","206":"124.26","207":"156.25","208":"137.10","209":"152.20","210":"140.26","211":"152.96","212":"144.52","213":"150.49","214":"151.17","215":"140.72","216":"163.50","217":"166.27","218":"168.27","219":"161.58","220":"165.29","221":"181.54","222":"143.41","223":"165.42","224":"162.47","225":"150.15","226":"166.82","227":"164.22","228":"159.15","229":"146.01","230":"159.66","231":"161.24","232":"159.62","233":"154.58","234":"160.17","235":"154.07","236":"145.46","237":"160.00","238":"177.48","239":"159.79","240":"162.73","241":"170.02","242":"152.03","243":"143.28","244":"166.10","245":"158.68","246":"175.61","247":"163.28","248":"175.05","249":"169.85","250":"154.67","251":"159.40","252":"157.19","253":"160.34","254":"161.07","255":"165.59","256":"157.44","257":"141.41","258":"158.68","259":"149.81","260":"146.82","261":"138.76","262":"148.06","263":"124.99","264":"115.65","265":"144.95","266":"160.09","267":"159.83","268":"154.84","269":"159.32","270":"166.40","271":"130.23","272":"168.27","273":"140.04","274":"154.46","275":"153.60","276":"157.14","277":"167.16","278":"142.52","279":"150.36","280":"141.02","281":"155.39","282":"134.41","283":"142.26","284":"142.22","285":"125.67","286":"149.77","287":"139.79","288":"156.89","289":"134.75","290":"136.38","291":"138.34","292":"133.82","293":"169.04","294":"158.21","295":"149.55","296":"155.01","297":"159.23","298":"170.66","299":"148.23","300":"179.53","301":"156.20","302":"159.62","303":"146.06","304":"150.58","305":"150.06","306":"136.80","307":"139.79","308":"146.44","309":"125.67","310":"132.20","311":"141.79","312":"136.29","313":"110.83","314":"138.00","315":"129.17","316":"121.41","317":"126.01","318":"120.09","319":"123.58","320":"107.08","321":"128.61","322":"119.49"},{"1":"country/region","2":"Argentina","3":"driving","4":"NA","5":"NA","6":"100","7":"97.07","8":"102.45","9":"111.21","10":"118.45","11":"124.01","12":"95.44","13":"95.13","14":"95.42","15":"97.66","16":"99.42","17":"113.34","18":"118.23","19":"91.31","20":"93.37","21":"91.12","22":"92.35","23":"96.74","24":"111.24","25":"123.96","26":"89.01","27":"91.66","28":"89.18","29":"94.49","30":"95.98","31":"111.12","32":"121.53","33":"89.23","34":"96.42","35":"96.97","36":"101.68","37":"104.90","38":"122.91","39":"127.62","40":"88.20","41":"92.28","42":"98.15","43":"98.96","44":"104.71","45":"132.57","46":"141.76","47":"108.21","48":"107.92","49":"99.51","50":"96.38","51":"97.96","52":"116.77","53":"117.72","54":"81.13","55":"86.76","56":"88.90","57":"92.74","58":"97.45","59":"118.32","60":"122.78","61":"80.36","62":"89.28","63":"89.29","64":"82.73","65":"86.67","66":"98.75","67":"84.77","68":"47.70","69":"53.57","70":"45.44","71":"43.21","72":"43.90","73":"16.77","74":"12.54","75":"8.74","76":"10.08","77":"10.76","78":"14.86","79":"14.58","80":"15.45","81":"13.34","82":"9.92","83":"14.59","84":"12.65","85":"15.79","86":"16.48","87":"17.15","88":"15.13","89":"11.53","90":"17.24","91":"18.55","92":"19.95","93":"19.80","94":"16.80","95":"19.40","96":"12.89","97":"21.10","98":"22.29","99":"23.55","100":"24.40","101":"27.17","102":"23.19","103":"14.54","104":"26.67","105":"27.25","106":"27.61","107":"28.73","108":"30.99","109":"25.92","110":"16.57","111":"27.45","112":"27.12","113":"32.22","114":"34.45","115":"22.69","116":"28.23","117":"16.44","118":"32.01","119":"33.63","120":"35.13","121":"35.56","122":"40.25","123":"33.82","124":"19.82","125":"NA","126":"NA","127":"38.87","128":"41.01","129":"44.34","130":"38.29","131":"22.01","132":"40.01","133":"41.34","134":"41.53","135":"41.52","136":"47.52","137":"41.34","138":"23.81","139":"28.11","140":"40.86","141":"42.91","142":"43.77","143":"48.26","144":"40.39","145":"23.77","146":"39.64","147":"41.88","148":"43.77","149":"45.84","150":"52.26","151":"47.48","152":"27.32","153":"44.06","154":"47.00","155":"48.10","156":"49.36","157":"56.59","158":"52.09","159":"30.96","160":"33.74","161":"48.36","162":"49.04","163":"50.71","164":"60.57","165":"57.48","166":"32.01","167":"42.79","168":"46.38","169":"48.12","170":"50.61","171":"57.83","172":"53.58","173":"29.44","174":"46.24","175":"49.78","176":"43.45","177":"46.78","178":"57.04","179":"55.29","180":"31.74","181":"46.61","182":"51.69","183":"59.14","184":"46.67","185":"51.81","186":"55.92","187":"32.09","188":"48.76","189":"51.68","190":"53.34","191":"54.05","192":"65.19","193":"63.43","194":"41.21","195":"66.69","196":"54.61","197":"55.66","198":"57.26","199":"67.02","200":"63.70","201":"37.80","202":"53.91","203":"56.84","204":"58.40","205":"59.01","206":"64.67","207":"64.46","208":"37.16","209":"55.03","210":"57.82","211":"58.69","212":"57.83","213":"66.13","214":"63.37","215":"36.89","216":"55.64","217":"57.49","218":"59.57","219":"60.74","220":"71.67","221":"71.08","222":"43.32","223":"42.59","224":"53.91","225":"56.11","226":"58.64","227":"69.14","228":"67.22","229":"39.80","230":"54.44","231":"54.51","232":"53.98","233":"59.54","234":"68.65","235":"62.02","236":"37.44","237":"52.16","238":"55.34","239":"52.23","240":"58.44","241":"71.35","242":"69.10","243":"39.37","244":"54.94","245":"57.93","246":"59.49","247":"63.20","248":"77.16","249":"69.70","250":"42.75","251":"55.70","252":"57.94","253":"61.09","254":"66.01","255":"76.20","256":"75.11","257":"46.99","258":"59.23","259":"60.17","260":"62.01","261":"62.72","262":"68.81","263":"64.62","264":"38.49","265":"54.62","266":"59.16","267":"60.03","268":"61.63","269":"74.42","270":"71.69","271":"38.69","272":"55.99","273":"59.95","274":"62.76","275":"65.86","276":"79.00","277":"79.72","278":"49.19","279":"49.69","280":"61.16","281":"65.26","282":"68.45","283":"84.94","284":"88.93","285":"48.76","286":"52.73","287":"55.55","288":"60.31","289":"58.52","290":"78.61","291":"80.43","292":"37.91","293":"60.02","294":"62.89","295":"60.59","296":"70.70","297":"83.31","298":"88.62","299":"52.17","300":"58.80","301":"63.00","302":"64.60","303":"68.67","304":"85.29","305":"92.14","306":"54.30","307":"59.58","308":"64.49","309":"66.54","310":"68.21","311":"87.33","312":"86.76","313":"56.50","314":"61.42","315":"64.85","316":"70.25","317":"73.21","318":"91.41","319":"99.28","320":"72.55","321":"59.53","322":"60.29"},{"1":"country/region","2":"Argentina","3":"walking","4":"NA","5":"NA","6":"100","7":"95.11","8":"101.37","9":"112.67","10":"116.72","11":"114.14","12":"84.54","13":"101.37","14":"106.12","15":"104.91","16":"102.56","17":"104.88","18":"98.83","19":"73.64","20":"94.27","21":"93.86","22":"92.20","23":"96.00","24":"98.99","25":"97.42","26":"67.21","27":"95.18","28":"96.25","29":"100.39","30":"99.10","31":"105.00","32":"106.45","33":"73.12","34":"104.20","35":"105.87","36":"111.47","37":"113.20","38":"128.75","39":"103.47","40":"69.12","41":"93.42","42":"111.49","43":"107.02","44":"111.36","45":"124.13","46":"120.44","47":"100.50","48":"96.60","49":"82.59","50":"107.79","51":"110.62","52":"124.18","53":"108.49","54":"68.50","55":"101.01","56":"104.39","57":"108.23","58":"113.92","59":"126.70","60":"112.81","61":"70.94","62":"109.38","63":"109.62","64":"83.06","65":"106.85","66":"104.31","67":"70.31","68":"43.64","69":"51.55","70":"35.57","71":"31.96","72":"29.97","73":"11.75","74":"9.11","75":"6.96","76":"8.36","77":"8.05","78":"10.92","79":"10.53","80":"11.30","81":"10.73","82":"7.77","83":"11.37","84":"9.79","85":"11.78","86":"11.23","87":"12.44","88":"10.97","89":"9.12","90":"11.85","91":"13.49","92":"15.51","93":"14.65","94":"13.58","95":"15.75","96":"10.45","97":"16.35","98":"16.66","99":"17.42","100":"18.18","101":"18.80","102":"17.03","103":"10.59","104":"18.44","105":"19.01","106":"18.47","107":"20.39","108":"22.32","109":"23.31","110":"16.36","111":"18.48","112":"17.49","113":"22.78","114":"24.80","115":"16.62","116":"20.61","117":"12.44","118":"21.35","119":"22.63","120":"23.84","121":"23.84","122":"30.63","123":"24.84","124":"15.58","125":"NA","126":"NA","127":"28.33","128":"28.44","129":"31.63","130":"28.81","131":"18.49","132":"30.79","133":"30.37","134":"28.85","135":"29.04","136":"31.99","137":"31.40","138":"16.83","139":"21.37","140":"30.85","141":"33.27","142":"32.63","143":"34.67","144":"28.70","145":"17.40","146":"29.50","147":"31.25","148":"30.65","149":"31.93","150":"37.34","151":"33.53","152":"19.60","153":"34.36","154":"35.81","155":"36.25","156":"36.61","157":"41.45","158":"35.27","159":"21.26","160":"25.34","161":"35.80","162":"36.15","163":"37.47","164":"42.79","165":"40.95","166":"24.00","167":"31.28","168":"33.56","169":"34.09","170":"36.12","171":"40.08","172":"36.86","173":"21.94","174":"31.23","175":"32.08","176":"30.46","177":"33.39","178":"39.62","179":"37.80","180":"23.53","181":"34.60","182":"36.99","183":"44.05","184":"35.31","185":"36.90","186":"39.11","187":"23.59","188":"36.60","189":"39.72","190":"40.32","191":"39.18","192":"47.81","193":"43.67","194":"32.06","195":"50.69","196":"43.16","197":"41.49","198":"42.23","199":"49.10","200":"46.25","201":"32.78","202":"41.44","203":"44.63","204":"46.32","205":"46.18","206":"48.13","207":"48.92","208":"31.31","209":"44.05","210":"49.23","211":"47.49","212":"43.61","213":"48.15","214":"48.86","215":"27.78","216":"43.74","217":"45.29","218":"46.27","219":"47.79","220":"55.35","221":"52.62","222":"33.36","223":"36.19","224":"44.18","225":"42.19","226":"44.98","227":"53.84","228":"51.45","229":"32.20","230":"45.52","231":"41.60","232":"39.72","233":"47.40","234":"51.96","235":"41.68","236":"29.90","237":"37.75","238":"40.54","239":"36.05","240":"43.20","241":"54.41","242":"52.74","243":"31.43","244":"43.45","245":"46.40","246":"46.81","247":"50.76","248":"57.64","249":"53.04","250":"34.87","251":"44.74","252":"44.54","253":"50.38","254":"56.07","255":"62.88","256":"58.01","257":"41.11","258":"50.83","259":"50.00","260":"53.50","261":"53.18","262":"51.42","263":"44.79","264":"28.95","265":"48.11","266":"51.81","267":"50.20","268":"50.76","269":"57.44","270":"51.42","271":"29.54","272":"46.80","273":"49.56","274":"53.87","275":"56.02","276":"63.35","277":"62.15","278":"36.57","279":"43.66","280":"52.51","281":"56.79","282":"55.10","283":"69.59","284":"62.42","285":"34.40","286":"42.97","287":"43.36","288":"45.56","289":"43.31","290":"60.31","291":"61.53","292":"25.54","293":"50.33","294":"55.48","295":"47.05","296":"53.69","297":"64.08","298":"66.53","299":"39.24","300":"50.75","301":"55.79","302":"56.40","303":"58.83","304":"69.68","305":"68.72","306":"39.29","307":"51.28","308":"55.82","309":"54.92","310":"57.49","311":"70.58","312":"63.48","313":"39.66","314":"52.37","315":"55.46","316":"57.55","317":"60.21","318":"70.59","319":"68.75","320":"45.72","321":"42.96","322":"49.73"},{"1":"country/region","2":"Australia","3":"driving","4":"NA","5":"NA","6":"100","7":"102.98","8":"104.21","9":"108.63","10":"109.08","11":"89.00","12":"99.35","13":"103.53","14":"106.80","15":"107.40","16":"115.65","17":"109.66","18":"88.59","19":"85.18","20":"95.91","21":"99.40","22":"99.92","23":"103.04","24":"103.73","25":"85.73","26":"93.39","27":"95.83","28":"98.63","29":"102.40","30":"107.46","31":"106.55","32":"86.33","33":"98.78","34":"100.08","35":"103.28","36":"106.19","37":"116.62","38":"115.36","39":"93.51","40":"98.27","41":"101.79","42":"105.38","43":"107.29","44":"113.37","45":"118.25","46":"97.60","47":"97.50","48":"102.70","49":"104.46","50":"106.23","51":"113.60","52":"117.64","53":"98.24","54":"97.35","55":"99.14","56":"101.63","57":"106.02","58":"113.97","59":"113.49","60":"93.23","61":"91.21","62":"96.44","63":"99.94","64":"100.79","65":"102.79","66":"98.75","67":"78.16","68":"81.59","69":"80.52","70":"78.87","71":"79.24","72":"83.55","73":"78.17","74":"60.74","75":"66.41","76":"62.49","77":"60.19","78":"57.96","79":"59.90","80":"48.25","81":"36.69","82":"51.18","83":"51.92","84":"52.04","85":"51.54","86":"54.23","87":"41.58","88":"33.34","89":"51.75","90":"53.17","91":"55.01","92":"59.24","93":"33.19","94":"36.00","95":"26.95","96":"31.72","97":"53.14","98":"55.91","99":"56.56","100":"58.77","101":"47.51","102":"36.90","103":"53.34","104":"56.93","105":"58.06","106":"59.69","107":"62.87","108":"47.84","109":"41.89","110":"55.39","111":"59.09","112":"59.46","113":"59.46","114":"63.12","115":"58.40","116":"48.67","117":"58.18","118":"62.51","119":"64.04","120":"66.19","121":"71.34","122":"67.64","123":"50.96","124":"63.56","125":"NA","126":"NA","127":"71.12","128":"77.24","129":"79.75","130":"65.88","131":"72.17","132":"73.58","133":"75.83","134":"76.35","135":"81.42","136":"82.51","137":"65.78","138":"74.12","139":"77.10","140":"79.92","141":"82.65","142":"88.37","143":"92.70","144":"73.04","145":"78.07","146":"80.87","147":"84.72","148":"88.62","149":"100.24","150":"104.34","151":"83.85","152":"85.16","153":"86.92","154":"88.07","155":"90.36","156":"98.28","157":"100.97","158":"81.74","159":"86.30","160":"89.68","161":"92.79","162":"94.78","163":"103.06","164":"106.05","165":"85.04","166":"88.15","167":"91.10","168":"94.49","169":"97.77","170":"106.30","171":"109.75","172":"90.76","173":"95.25","174":"97.33","175":"101.44","176":"102.80","177":"110.63","178":"111.93","179":"94.64","180":"100.89","181":"103.53","182":"108.56","183":"104.33","184":"109.63","185":"102.37","186":"85.70","187":"94.02","188":"94.33","189":"98.70","190":"100.16","191":"106.12","192":"103.27","193":"84.93","194":"88.73","195":"89.78","196":"92.33","197":"93.33","198":"98.55","199":"98.50","200":"75.84","201":"83.95","202":"87.17","203":"91.46","204":"92.73","205":"98.44","206":"101.88","207":"88.20","208":"87.57","209":"86.67","210":"88.74","211":"87.77","212":"92.37","213":"90.20","214":"73.91","215":"78.69","216":"82.83","217":"85.36","218":"89.13","219":"95.89","220":"93.84","221":"79.57","222":"81.30","223":"83.35","224":"85.40","225":"87.96","226":"93.81","227":"95.41","228":"79.51","229":"81.64","230":"83.29","231":"86.49","232":"89.51","233":"95.23","234":"98.78","235":"83.03","236":"82.66","237":"84.46","238":"86.90","239":"90.64","240":"97.49","241":"100.54","242":"77.19","243":"83.40","244":"86.13","245":"87.65","246":"89.93","247":"96.29","248":"98.60","249":"83.67","250":"85.82","251":"89.24","252":"93.18","253":"95.04","254":"101.92","255":"102.84","256":"82.47","257":"89.67","258":"91.87","259":"93.99","260":"95.72","261":"102.71","262":"102.03","263":"87.47","264":"95.06","265":"97.69","266":"100.19","267":"104.14","268":"115.34","269":"109.16","270":"92.42","271":"93.21","272":"96.03","273":"97.06","274":"97.95","275":"106.72","276":"102.34","277":"83.24","278":"88.85","279":"91.45","280":"93.17","281":"96.06","282":"104.24","283":"99.65","284":"85.42","285":"92.72","286":"94.60","287":"97.68","288":"100.26","289":"102.98","290":"97.19","291":"77.39","292":"87.40","293":"92.13","294":"96.71","295":"97.06","296":"108.39","297":"104.59","298":"86.59","299":"93.36","300":"89.07","301":"94.60","302":"94.26","303":"103.66","304":"102.73","305":"84.84","306":"93.04","307":"95.93","308":"98.73","309":"101.22","310":"110.53","311":"111.15","312":"94.57","313":"95.86","314":"97.26","315":"101.44","316":"101.82","317":"109.64","318":"108.84","319":"91.48","320":"95.10","321":"99.52","322":"103.98"},{"1":"country/region","2":"Australia","3":"transit","4":"NA","5":"NA","6":"100","7":"101.78","8":"100.64","9":"99.58","10":"98.34","11":"86.97","12":"99.87","13":"107.29","14":"109.13","15":"107.03","16":"106.64","17":"100.19","18":"90.61","19":"81.83","20":"101.78","21":"104.81","22":"103.03","23":"101.91","24":"97.77","25":"87.49","26":"98.72","27":"99.03","28":"102.40","29":"100.27","30":"100.82","31":"102.46","32":"84.10","33":"100.46","34":"105.77","35":"105.48","36":"106.71","37":"113.20","38":"111.33","39":"98.78","40":"109.30","41":"111.03","42":"115.59","43":"114.53","44":"116.25","45":"120.68","46":"104.35","47":"115.32","48":"119.81","49":"118.98","50":"115.46","51":"119.34","52":"122.09","53":"107.23","54":"113.58","55":"115.04","56":"112.26","57":"111.17","58":"113.82","59":"112.67","60":"98.27","61":"97.56","62":"105.15","63":"107.82","64":"106.36","65":"101.22","66":"88.82","67":"70.96","68":"76.49","69":"70.68","70":"65.78","71":"62.19","72":"61.79","73":"57.33","74":"43.75","75":"40.71","76":"33.94","77":"30.31","78":"26.90","79":"26.44","80":"23.77","81":"19.57","82":"23.53","83":"22.58","84":"21.67","85":"21.05","86":"21.25","87":"18.75","88":"16.62","89":"21.76","90":"21.20","91":"20.73","92":"21.28","93":"16.63","94":"16.78","95":"13.94","96":"16.51","97":"21.67","98":"21.58","99":"21.98","100":"21.84","101":"20.13","102":"17.64","103":"21.93","104":"22.41","105":"22.71","106":"22.49","107":"23.78","108":"20.96","109":"19.06","110":"22.74","111":"23.80","112":"23.76","113":"22.35","114":"23.58","115":"23.52","116":"21.41","117":"25.10","118":"25.56","119":"26.55","120":"26.43","121":"28.37","122":"27.93","123":"23.76","124":"28.50","125":"NA","126":"NA","127":"29.89","128":"31.44","129":"33.85","130":"29.61","131":"32.92","132":"33.36","133":"34.04","134":"33.11","135":"35.00","136":"36.56","137":"31.04","138":"36.09","139":"37.03","140":"38.29","141":"38.73","142":"40.04","143":"42.98","144":"35.88","145":"39.46","146":"40.43","147":"41.82","148":"42.68","149":"46.10","150":"51.44","151":"41.01","152":"39.83","153":"44.71","154":"44.55","155":"45.98","156":"48.26","157":"53.46","158":"43.97","159":"46.04","160":"47.82","161":"48.13","162":"48.97","163":"52.39","164":"56.43","165":"45.35","166":"47.58","167":"49.46","168":"50.93","169":"52.05","170":"54.91","171":"57.22","172":"48.06","173":"52.81","174":"53.36","175":"54.82","176":"54.90","177":"56.72","178":"56.22","179":"48.35","180":"54.93","181":"55.81","182":"56.27","183":"51.97","184":"51.83","185":"47.57","186":"41.38","187":"47.69","188":"46.72","189":"48.77","190":"47.92","191":"48.78","192":"47.71","193":"41.46","194":"46.10","195":"45.15","196":"44.98","197":"44.74","198":"45.58","199":"45.48","200":"35.59","201":"41.74","202":"43.77","203":"45.69","204":"44.63","205":"45.69","206":"47.93","207":"40.99","208":"42.46","209":"41.82","210":"42.09","211":"40.55","212":"39.51","213":"39.90","214":"33.03","215":"36.85","216":"39.41","217":"39.96","218":"41.42","219":"41.61","220":"42.73","221":"36.14","222":"39.14","223":"40.17","224":"40.45","225":"40.91","226":"42.32","227":"43.14","228":"36.56","229":"39.16","230":"40.05","231":"41.70","232":"41.91","233":"42.89","234":"45.76","235":"39.08","236":"39.72","237":"40.56","238":"41.43","239":"43.44","240":"44.44","241":"45.56","242":"35.21","243":"40.44","244":"41.74","245":"41.62","246":"42.53","247":"44.11","248":"46.30","249":"38.74","250":"40.95","251":"43.10","252":"44.88","253":"46.07","254":"48.42","255":"48.99","256":"39.30","257":"45.73","258":"46.56","259":"47.17","260":"48.01","261":"49.58","262":"48.78","263":"42.58","264":"48.62","265":"51.79","266":"51.42","267":"52.68","268":"55.67","269":"54.12","270":"47.21","271":"48.00","272":"51.28","273":"51.75","274":"51.52","275":"54.52","276":"52.96","277":"43.71","278":"49.37","279":"49.42","280":"49.02","281":"48.93","282":"50.48","283":"52.02","284":"43.61","285":"48.57","286":"49.48","287":"50.58","288":"51.52","289":"53.06","290":"51.69","291":"41.58","292":"46.46","293":"50.28","294":"54.40","295":"53.54","296":"58.58","297":"60.18","298":"49.00","299":"57.00","300":"58.56","301":"55.71","302":"53.65","303":"58.69","304":"61.79","305":"51.56","306":"56.65","307":"60.23","308":"61.21","309":"61.59","310":"64.97","311":"71.17","312":"58.98","313":"60.01","314":"61.78","315":"62.79","316":"62.17","317":"66.55","318":"69.77","319":"57.04","320":"60.45","321":"64.65","322":"67.14"}],"options":{"columns":{"min":{},"max":[10]},"rows":{"min":[10],"max":[10]},"pages":{}}} </script> </div> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## View Apple Mobility Data (tail) ```r AppleMobRaw %>% tail() ``` <div data-pagedtable="false"> <script data-pagedtable-source type="application/json"> {"columns":[{"label":["geo_type"],"name":[1],"type":["chr"],"align":["left"]},{"label":["region"],"name":[2],"type":["chr"],"align":["left"]},{"label":["transportation_type"],"name":[3],"type":["chr"],"align":["left"]},{"label":["sub-region"],"name":[4],"type":["chr"],"align":["left"]},{"label":["country"],"name":[5],"type":["chr"],"align":["left"]},{"label":["2020-01-13"],"name":[6],"type":["dbl"],"align":["right"]},{"label":["2020-01-14"],"name":[7],"type":["dbl"],"align":["right"]},{"label":["2020-01-15"],"name":[8],"type":["dbl"],"align":["right"]},{"label":["2020-01-16"],"name":[9],"type":["dbl"],"align":["right"]},{"label":["2020-01-17"],"name":[10],"type":["dbl"],"align":["right"]},{"label":["2020-01-18"],"name":[11],"type":["dbl"],"align":["right"]},{"label":["2020-01-19"],"name":[12],"type":["dbl"],"align":["right"]},{"label":["2020-01-20"],"name":[13],"type":["dbl"],"align":["right"]},{"label":["2020-01-21"],"name":[14],"type":["dbl"],"align":["right"]},{"label":["2020-01-22"],"name":[15],"type":["dbl"],"align":["right"]},{"label":["2020-01-23"],"name":[16],"type":["dbl"],"align":["right"]},{"label":["2020-01-24"],"name":[17],"type":["dbl"],"align":["right"]},{"label":["2020-01-25"],"name":[18],"type":["dbl"],"align":["right"]},{"label":["2020-01-26"],"name":[19],"type":["dbl"],"align":["right"]},{"label":["2020-01-27"],"name":[20],"type":["dbl"],"align":["right"]},{"label":["2020-01-28"],"name":[21],"type":["dbl"],"align":["right"]},{"label":["2020-01-29"],"name":[22],"type":["dbl"],"align":["right"]},{"label":["2020-01-30"],"name":[23],"type":["dbl"],"align":["right"]},{"label":["2020-01-31"],"name":[24],"type":["dbl"],"align":["right"]},{"label":["2020-02-01"],"name":[25],"type":["dbl"],"align":["right"]},{"label":["2020-02-02"],"name":[26],"type":["dbl"],"align":["right"]},{"label":["2020-02-03"],"name":[27],"type":["dbl"],"align":["right"]},{"label":["2020-02-04"],"name":[28],"type":["dbl"],"align":["right"]},{"label":["2020-02-05"],"name":[29],"type":["dbl"],"align":["right"]},{"label":["2020-02-06"],"name":[30],"type":["dbl"],"align":["right"]},{"label":["2020-02-07"],"name":[31],"type":["dbl"],"align":["right"]},{"label":["2020-02-08"],"name":[32],"type":["dbl"],"align":["right"]},{"label":["2020-02-09"],"name":[33],"type":["dbl"],"align":["right"]},{"label":["2020-02-10"],"name":[34],"type":["dbl"],"align":["right"]},{"label":["2020-02-11"],"name":[35],"type":["dbl"],"align":["right"]},{"label":["2020-02-12"],"name":[36],"type":["dbl"],"align":["right"]},{"label":["2020-02-13"],"name":[37],"type":["dbl"],"align":["right"]},{"label":["2020-02-14"],"name":[38],"type":["dbl"],"align":["right"]},{"label":["2020-02-15"],"name":[39],"type":["dbl"],"align":["right"]},{"label":["2020-02-16"],"name":[40],"type":["dbl"],"align":["right"]},{"label":["2020-02-17"],"name":[41],"type":["dbl"],"align":["right"]},{"label":["2020-02-18"],"name":[42],"type":["dbl"],"align":["right"]},{"label":["2020-02-19"],"name":[43],"type":["dbl"],"align":["right"]},{"label":["2020-02-20"],"name":[44],"type":["dbl"],"align":["right"]},{"label":["2020-02-21"],"name":[45],"type":["dbl"],"align":["right"]},{"label":["2020-02-22"],"name":[46],"type":["dbl"],"align":["right"]},{"label":["2020-02-23"],"name":[47],"type":["dbl"],"align":["right"]},{"label":["2020-02-24"],"name":[48],"type":["dbl"],"align":["right"]},{"label":["2020-02-25"],"name":[49],"type":["dbl"],"align":["right"]},{"label":["2020-02-26"],"name":[50],"type":["dbl"],"align":["right"]},{"label":["2020-02-27"],"name":[51],"type":["dbl"],"align":["right"]},{"label":["2020-02-28"],"name":[52],"type":["dbl"],"align":["right"]},{"label":["2020-02-29"],"name":[53],"type":["dbl"],"align":["right"]},{"label":["2020-03-01"],"name":[54],"type":["dbl"],"align":["right"]},{"label":["2020-03-02"],"name":[55],"type":["dbl"],"align":["right"]},{"label":["2020-03-03"],"name":[56],"type":["dbl"],"align":["right"]},{"label":["2020-03-04"],"name":[57],"type":["dbl"],"align":["right"]},{"label":["2020-03-05"],"name":[58],"type":["dbl"],"align":["right"]},{"label":["2020-03-06"],"name":[59],"type":["dbl"],"align":["right"]},{"label":["2020-03-07"],"name":[60],"type":["dbl"],"align":["right"]},{"label":["2020-03-08"],"name":[61],"type":["dbl"],"align":["right"]},{"label":["2020-03-09"],"name":[62],"type":["dbl"],"align":["right"]},{"label":["2020-03-10"],"name":[63],"type":["dbl"],"align":["right"]},{"label":["2020-03-11"],"name":[64],"type":["dbl"],"align":["right"]},{"label":["2020-03-12"],"name":[65],"type":["dbl"],"align":["right"]},{"label":["2020-03-13"],"name":[66],"type":["dbl"],"align":["right"]},{"label":["2020-03-14"],"name":[67],"type":["dbl"],"align":["right"]},{"label":["2020-03-15"],"name":[68],"type":["dbl"],"align":["right"]},{"label":["2020-03-16"],"name":[69],"type":["dbl"],"align":["right"]},{"label":["2020-03-17"],"name":[70],"type":["dbl"],"align":["right"]},{"label":["2020-03-18"],"name":[71],"type":["dbl"],"align":["right"]},{"label":["2020-03-19"],"name":[72],"type":["dbl"],"align":["right"]},{"label":["2020-03-20"],"name":[73],"type":["dbl"],"align":["right"]},{"label":["2020-03-21"],"name":[74],"type":["dbl"],"align":["right"]},{"label":["2020-03-22"],"name":[75],"type":["dbl"],"align":["right"]},{"label":["2020-03-23"],"name":[76],"type":["dbl"],"align":["right"]},{"label":["2020-03-24"],"name":[77],"type":["dbl"],"align":["right"]},{"label":["2020-03-25"],"name":[78],"type":["dbl"],"align":["right"]},{"label":["2020-03-26"],"name":[79],"type":["dbl"],"align":["right"]},{"label":["2020-03-27"],"name":[80],"type":["dbl"],"align":["right"]},{"label":["2020-03-28"],"name":[81],"type":["dbl"],"align":["right"]},{"label":["2020-03-29"],"name":[82],"type":["dbl"],"align":["right"]},{"label":["2020-03-30"],"name":[83],"type":["dbl"],"align":["right"]},{"label":["2020-03-31"],"name":[84],"type":["dbl"],"align":["right"]},{"label":["2020-04-01"],"name":[85],"type":["dbl"],"align":["right"]},{"label":["2020-04-02"],"name":[86],"type":["dbl"],"align":["right"]},{"label":["2020-04-03"],"name":[87],"type":["dbl"],"align":["right"]},{"label":["2020-04-04"],"name":[88],"type":["dbl"],"align":["right"]},{"label":["2020-04-05"],"name":[89],"type":["dbl"],"align":["right"]},{"label":["2020-04-06"],"name":[90],"type":["dbl"],"align":["right"]},{"label":["2020-04-07"],"name":[91],"type":["dbl"],"align":["right"]},{"label":["2020-04-08"],"name":[92],"type":["dbl"],"align":["right"]},{"label":["2020-04-09"],"name":[93],"type":["dbl"],"align":["right"]},{"label":["2020-04-10"],"name":[94],"type":["dbl"],"align":["right"]},{"label":["2020-04-11"],"name":[95],"type":["dbl"],"align":["right"]},{"label":["2020-04-12"],"name":[96],"type":["dbl"],"align":["right"]},{"label":["2020-04-13"],"name":[97],"type":["dbl"],"align":["right"]},{"label":["2020-04-14"],"name":[98],"type":["dbl"],"align":["right"]},{"label":["2020-04-15"],"name":[99],"type":["dbl"],"align":["right"]},{"label":["2020-04-16"],"name":[100],"type":["dbl"],"align":["right"]},{"label":["2020-04-17"],"name":[101],"type":["dbl"],"align":["right"]},{"label":["2020-04-18"],"name":[102],"type":["dbl"],"align":["right"]},{"label":["2020-04-19"],"name":[103],"type":["dbl"],"align":["right"]},{"label":["2020-04-20"],"name":[104],"type":["dbl"],"align":["right"]},{"label":["2020-04-21"],"name":[105],"type":["dbl"],"align":["right"]},{"label":["2020-04-22"],"name":[106],"type":["dbl"],"align":["right"]},{"label":["2020-04-23"],"name":[107],"type":["dbl"],"align":["right"]},{"label":["2020-04-24"],"name":[108],"type":["dbl"],"align":["right"]},{"label":["2020-04-25"],"name":[109],"type":["dbl"],"align":["right"]},{"label":["2020-04-26"],"name":[110],"type":["dbl"],"align":["right"]},{"label":["2020-04-27"],"name":[111],"type":["dbl"],"align":["right"]},{"label":["2020-04-28"],"name":[112],"type":["dbl"],"align":["right"]},{"label":["2020-04-29"],"name":[113],"type":["dbl"],"align":["right"]},{"label":["2020-04-30"],"name":[114],"type":["dbl"],"align":["right"]},{"label":["2020-05-01"],"name":[115],"type":["dbl"],"align":["right"]},{"label":["2020-05-02"],"name":[116],"type":["dbl"],"align":["right"]},{"label":["2020-05-03"],"name":[117],"type":["dbl"],"align":["right"]},{"label":["2020-05-04"],"name":[118],"type":["dbl"],"align":["right"]},{"label":["2020-05-05"],"name":[119],"type":["dbl"],"align":["right"]},{"label":["2020-05-06"],"name":[120],"type":["dbl"],"align":["right"]},{"label":["2020-05-07"],"name":[121],"type":["dbl"],"align":["right"]},{"label":["2020-05-08"],"name":[122],"type":["dbl"],"align":["right"]},{"label":["2020-05-09"],"name":[123],"type":["dbl"],"align":["right"]},{"label":["2020-05-10"],"name":[124],"type":["dbl"],"align":["right"]},{"label":["2020-05-11"],"name":[125],"type":["dbl"],"align":["right"]},{"label":["2020-05-12"],"name":[126],"type":["dbl"],"align":["right"]},{"label":["2020-05-13"],"name":[127],"type":["dbl"],"align":["right"]},{"label":["2020-05-14"],"name":[128],"type":["dbl"],"align":["right"]},{"label":["2020-05-15"],"name":[129],"type":["dbl"],"align":["right"]},{"label":["2020-05-16"],"name":[130],"type":["dbl"],"align":["right"]},{"label":["2020-05-17"],"name":[131],"type":["dbl"],"align":["right"]},{"label":["2020-05-18"],"name":[132],"type":["dbl"],"align":["right"]},{"label":["2020-05-19"],"name":[133],"type":["dbl"],"align":["right"]},{"label":["2020-05-20"],"name":[134],"type":["dbl"],"align":["right"]},{"label":["2020-05-21"],"name":[135],"type":["dbl"],"align":["right"]},{"label":["2020-05-22"],"name":[136],"type":["dbl"],"align":["right"]},{"label":["2020-05-23"],"name":[137],"type":["dbl"],"align":["right"]},{"label":["2020-05-24"],"name":[138],"type":["dbl"],"align":["right"]},{"label":["2020-05-25"],"name":[139],"type":["dbl"],"align":["right"]},{"label":["2020-05-26"],"name":[140],"type":["dbl"],"align":["right"]},{"label":["2020-05-27"],"name":[141],"type":["dbl"],"align":["right"]},{"label":["2020-05-28"],"name":[142],"type":["dbl"],"align":["right"]},{"label":["2020-05-29"],"name":[143],"type":["dbl"],"align":["right"]},{"label":["2020-05-30"],"name":[144],"type":["dbl"],"align":["right"]},{"label":["2020-05-31"],"name":[145],"type":["dbl"],"align":["right"]},{"label":["2020-06-01"],"name":[146],"type":["dbl"],"align":["right"]},{"label":["2020-06-02"],"name":[147],"type":["dbl"],"align":["right"]},{"label":["2020-06-03"],"name":[148],"type":["dbl"],"align":["right"]},{"label":["2020-06-04"],"name":[149],"type":["dbl"],"align":["right"]},{"label":["2020-06-05"],"name":[150],"type":["dbl"],"align":["right"]},{"label":["2020-06-06"],"name":[151],"type":["dbl"],"align":["right"]},{"label":["2020-06-07"],"name":[152],"type":["dbl"],"align":["right"]},{"label":["2020-06-08"],"name":[153],"type":["dbl"],"align":["right"]},{"label":["2020-06-09"],"name":[154],"type":["dbl"],"align":["right"]},{"label":["2020-06-10"],"name":[155],"type":["dbl"],"align":["right"]},{"label":["2020-06-11"],"name":[156],"type":["dbl"],"align":["right"]},{"label":["2020-06-12"],"name":[157],"type":["dbl"],"align":["right"]},{"label":["2020-06-13"],"name":[158],"type":["dbl"],"align":["right"]},{"label":["2020-06-14"],"name":[159],"type":["dbl"],"align":["right"]},{"label":["2020-06-15"],"name":[160],"type":["dbl"],"align":["right"]},{"label":["2020-06-16"],"name":[161],"type":["dbl"],"align":["right"]},{"label":["2020-06-17"],"name":[162],"type":["dbl"],"align":["right"]},{"label":["2020-06-18"],"name":[163],"type":["dbl"],"align":["right"]},{"label":["2020-06-19"],"name":[164],"type":["dbl"],"align":["right"]},{"label":["2020-06-20"],"name":[165],"type":["dbl"],"align":["right"]},{"label":["2020-06-21"],"name":[166],"type":["dbl"],"align":["right"]},{"label":["2020-06-22"],"name":[167],"type":["dbl"],"align":["right"]},{"label":["2020-06-23"],"name":[168],"type":["dbl"],"align":["right"]},{"label":["2020-06-24"],"name":[169],"type":["dbl"],"align":["right"]},{"label":["2020-06-25"],"name":[170],"type":["dbl"],"align":["right"]},{"label":["2020-06-26"],"name":[171],"type":["dbl"],"align":["right"]},{"label":["2020-06-27"],"name":[172],"type":["dbl"],"align":["right"]},{"label":["2020-06-28"],"name":[173],"type":["dbl"],"align":["right"]},{"label":["2020-06-29"],"name":[174],"type":["dbl"],"align":["right"]},{"label":["2020-06-30"],"name":[175],"type":["dbl"],"align":["right"]},{"label":["2020-07-01"],"name":[176],"type":["dbl"],"align":["right"]},{"label":["2020-07-02"],"name":[177],"type":["dbl"],"align":["right"]},{"label":["2020-07-03"],"name":[178],"type":["dbl"],"align":["right"]},{"label":["2020-07-04"],"name":[179],"type":["dbl"],"align":["right"]},{"label":["2020-07-05"],"name":[180],"type":["dbl"],"align":["right"]},{"label":["2020-07-06"],"name":[181],"type":["dbl"],"align":["right"]},{"label":["2020-07-07"],"name":[182],"type":["dbl"],"align":["right"]},{"label":["2020-07-08"],"name":[183],"type":["dbl"],"align":["right"]},{"label":["2020-07-09"],"name":[184],"type":["dbl"],"align":["right"]},{"label":["2020-07-10"],"name":[185],"type":["dbl"],"align":["right"]},{"label":["2020-07-11"],"name":[186],"type":["dbl"],"align":["right"]},{"label":["2020-07-12"],"name":[187],"type":["dbl"],"align":["right"]},{"label":["2020-07-13"],"name":[188],"type":["dbl"],"align":["right"]},{"label":["2020-07-14"],"name":[189],"type":["dbl"],"align":["right"]},{"label":["2020-07-15"],"name":[190],"type":["dbl"],"align":["right"]},{"label":["2020-07-16"],"name":[191],"type":["dbl"],"align":["right"]},{"label":["2020-07-17"],"name":[192],"type":["dbl"],"align":["right"]},{"label":["2020-07-18"],"name":[193],"type":["dbl"],"align":["right"]},{"label":["2020-07-19"],"name":[194],"type":["dbl"],"align":["right"]},{"label":["2020-07-20"],"name":[195],"type":["dbl"],"align":["right"]},{"label":["2020-07-21"],"name":[196],"type":["dbl"],"align":["right"]},{"label":["2020-07-22"],"name":[197],"type":["dbl"],"align":["right"]},{"label":["2020-07-23"],"name":[198],"type":["dbl"],"align":["right"]},{"label":["2020-07-24"],"name":[199],"type":["dbl"],"align":["right"]},{"label":["2020-07-25"],"name":[200],"type":["dbl"],"align":["right"]},{"label":["2020-07-26"],"name":[201],"type":["dbl"],"align":["right"]},{"label":["2020-07-27"],"name":[202],"type":["dbl"],"align":["right"]},{"label":["2020-07-28"],"name":[203],"type":["dbl"],"align":["right"]},{"label":["2020-07-29"],"name":[204],"type":["dbl"],"align":["right"]},{"label":["2020-07-30"],"name":[205],"type":["dbl"],"align":["right"]},{"label":["2020-07-31"],"name":[206],"type":["dbl"],"align":["right"]},{"label":["2020-08-01"],"name":[207],"type":["dbl"],"align":["right"]},{"label":["2020-08-02"],"name":[208],"type":["dbl"],"align":["right"]},{"label":["2020-08-03"],"name":[209],"type":["dbl"],"align":["right"]},{"label":["2020-08-04"],"name":[210],"type":["dbl"],"align":["right"]},{"label":["2020-08-05"],"name":[211],"type":["dbl"],"align":["right"]},{"label":["2020-08-06"],"name":[212],"type":["dbl"],"align":["right"]},{"label":["2020-08-07"],"name":[213],"type":["dbl"],"align":["right"]},{"label":["2020-08-08"],"name":[214],"type":["dbl"],"align":["right"]},{"label":["2020-08-09"],"name":[215],"type":["dbl"],"align":["right"]},{"label":["2020-08-10"],"name":[216],"type":["dbl"],"align":["right"]},{"label":["2020-08-11"],"name":[217],"type":["dbl"],"align":["right"]},{"label":["2020-08-12"],"name":[218],"type":["dbl"],"align":["right"]},{"label":["2020-08-13"],"name":[219],"type":["dbl"],"align":["right"]},{"label":["2020-08-14"],"name":[220],"type":["dbl"],"align":["right"]},{"label":["2020-08-15"],"name":[221],"type":["dbl"],"align":["right"]},{"label":["2020-08-16"],"name":[222],"type":["dbl"],"align":["right"]},{"label":["2020-08-17"],"name":[223],"type":["dbl"],"align":["right"]},{"label":["2020-08-18"],"name":[224],"type":["dbl"],"align":["right"]},{"label":["2020-08-19"],"name":[225],"type":["dbl"],"align":["right"]},{"label":["2020-08-20"],"name":[226],"type":["dbl"],"align":["right"]},{"label":["2020-08-21"],"name":[227],"type":["dbl"],"align":["right"]},{"label":["2020-08-22"],"name":[228],"type":["dbl"],"align":["right"]},{"label":["2020-08-23"],"name":[229],"type":["dbl"],"align":["right"]},{"label":["2020-08-24"],"name":[230],"type":["dbl"],"align":["right"]},{"label":["2020-08-25"],"name":[231],"type":["dbl"],"align":["right"]},{"label":["2020-08-26"],"name":[232],"type":["dbl"],"align":["right"]},{"label":["2020-08-27"],"name":[233],"type":["dbl"],"align":["right"]},{"label":["2020-08-28"],"name":[234],"type":["dbl"],"align":["right"]},{"label":["2020-08-29"],"name":[235],"type":["dbl"],"align":["right"]},{"label":["2020-08-30"],"name":[236],"type":["dbl"],"align":["right"]},{"label":["2020-08-31"],"name":[237],"type":["dbl"],"align":["right"]},{"label":["2020-09-01"],"name":[238],"type":["dbl"],"align":["right"]},{"label":["2020-09-02"],"name":[239],"type":["dbl"],"align":["right"]},{"label":["2020-09-03"],"name":[240],"type":["dbl"],"align":["right"]},{"label":["2020-09-04"],"name":[241],"type":["dbl"],"align":["right"]},{"label":["2020-09-05"],"name":[242],"type":["dbl"],"align":["right"]},{"label":["2020-09-06"],"name":[243],"type":["dbl"],"align":["right"]},{"label":["2020-09-07"],"name":[244],"type":["dbl"],"align":["right"]},{"label":["2020-09-08"],"name":[245],"type":["dbl"],"align":["right"]},{"label":["2020-09-09"],"name":[246],"type":["dbl"],"align":["right"]},{"label":["2020-09-10"],"name":[247],"type":["dbl"],"align":["right"]},{"label":["2020-09-11"],"name":[248],"type":["dbl"],"align":["right"]},{"label":["2020-09-12"],"name":[249],"type":["dbl"],"align":["right"]},{"label":["2020-09-13"],"name":[250],"type":["dbl"],"align":["right"]},{"label":["2020-09-14"],"name":[251],"type":["dbl"],"align":["right"]},{"label":["2020-09-15"],"name":[252],"type":["dbl"],"align":["right"]},{"label":["2020-09-16"],"name":[253],"type":["dbl"],"align":["right"]},{"label":["2020-09-17"],"name":[254],"type":["dbl"],"align":["right"]},{"label":["2020-09-18"],"name":[255],"type":["dbl"],"align":["right"]},{"label":["2020-09-19"],"name":[256],"type":["dbl"],"align":["right"]},{"label":["2020-09-20"],"name":[257],"type":["dbl"],"align":["right"]},{"label":["2020-09-21"],"name":[258],"type":["dbl"],"align":["right"]},{"label":["2020-09-22"],"name":[259],"type":["dbl"],"align":["right"]},{"label":["2020-09-23"],"name":[260],"type":["dbl"],"align":["right"]},{"label":["2020-09-24"],"name":[261],"type":["dbl"],"align":["right"]},{"label":["2020-09-25"],"name":[262],"type":["dbl"],"align":["right"]},{"label":["2020-09-26"],"name":[263],"type":["dbl"],"align":["right"]},{"label":["2020-09-27"],"name":[264],"type":["dbl"],"align":["right"]},{"label":["2020-09-28"],"name":[265],"type":["dbl"],"align":["right"]},{"label":["2020-09-29"],"name":[266],"type":["dbl"],"align":["right"]},{"label":["2020-09-30"],"name":[267],"type":["dbl"],"align":["right"]},{"label":["2020-10-01"],"name":[268],"type":["dbl"],"align":["right"]},{"label":["2020-10-02"],"name":[269],"type":["dbl"],"align":["right"]},{"label":["2020-10-03"],"name":[270],"type":["dbl"],"align":["right"]},{"label":["2020-10-04"],"name":[271],"type":["dbl"],"align":["right"]},{"label":["2020-10-05"],"name":[272],"type":["dbl"],"align":["right"]},{"label":["2020-10-06"],"name":[273],"type":["dbl"],"align":["right"]},{"label":["2020-10-07"],"name":[274],"type":["dbl"],"align":["right"]},{"label":["2020-10-08"],"name":[275],"type":["dbl"],"align":["right"]},{"label":["2020-10-09"],"name":[276],"type":["dbl"],"align":["right"]},{"label":["2020-10-10"],"name":[277],"type":["dbl"],"align":["right"]},{"label":["2020-10-11"],"name":[278],"type":["dbl"],"align":["right"]},{"label":["2020-10-12"],"name":[279],"type":["dbl"],"align":["right"]},{"label":["2020-10-13"],"name":[280],"type":["dbl"],"align":["right"]},{"label":["2020-10-14"],"name":[281],"type":["dbl"],"align":["right"]},{"label":["2020-10-15"],"name":[282],"type":["dbl"],"align":["right"]},{"label":["2020-10-16"],"name":[283],"type":["dbl"],"align":["right"]},{"label":["2020-10-17"],"name":[284],"type":["dbl"],"align":["right"]},{"label":["2020-10-18"],"name":[285],"type":["dbl"],"align":["right"]},{"label":["2020-10-19"],"name":[286],"type":["dbl"],"align":["right"]},{"label":["2020-10-20"],"name":[287],"type":["dbl"],"align":["right"]},{"label":["2020-10-21"],"name":[288],"type":["dbl"],"align":["right"]},{"label":["2020-10-22"],"name":[289],"type":["dbl"],"align":["right"]},{"label":["2020-10-23"],"name":[290],"type":["dbl"],"align":["right"]},{"label":["2020-10-24"],"name":[291],"type":["dbl"],"align":["right"]},{"label":["2020-10-25"],"name":[292],"type":["dbl"],"align":["right"]},{"label":["2020-10-26"],"name":[293],"type":["dbl"],"align":["right"]},{"label":["2020-10-27"],"name":[294],"type":["dbl"],"align":["right"]},{"label":["2020-10-28"],"name":[295],"type":["dbl"],"align":["right"]},{"label":["2020-10-29"],"name":[296],"type":["dbl"],"align":["right"]},{"label":["2020-10-30"],"name":[297],"type":["dbl"],"align":["right"]},{"label":["2020-10-31"],"name":[298],"type":["dbl"],"align":["right"]},{"label":["2020-11-01"],"name":[299],"type":["dbl"],"align":["right"]},{"label":["2020-11-02"],"name":[300],"type":["dbl"],"align":["right"]},{"label":["2020-11-03"],"name":[301],"type":["dbl"],"align":["right"]},{"label":["2020-11-04"],"name":[302],"type":["dbl"],"align":["right"]},{"label":["2020-11-05"],"name":[303],"type":["dbl"],"align":["right"]},{"label":["2020-11-06"],"name":[304],"type":["dbl"],"align":["right"]},{"label":["2020-11-07"],"name":[305],"type":["dbl"],"align":["right"]},{"label":["2020-11-08"],"name":[306],"type":["dbl"],"align":["right"]},{"label":["2020-11-09"],"name":[307],"type":["dbl"],"align":["right"]},{"label":["2020-11-10"],"name":[308],"type":["dbl"],"align":["right"]},{"label":["2020-11-11"],"name":[309],"type":["dbl"],"align":["right"]},{"label":["2020-11-12"],"name":[310],"type":["dbl"],"align":["right"]},{"label":["2020-11-13"],"name":[311],"type":["dbl"],"align":["right"]},{"label":["2020-11-14"],"name":[312],"type":["dbl"],"align":["right"]},{"label":["2020-11-15"],"name":[313],"type":["dbl"],"align":["right"]},{"label":["2020-11-16"],"name":[314],"type":["dbl"],"align":["right"]},{"label":["2020-11-17"],"name":[315],"type":["dbl"],"align":["right"]},{"label":["2020-11-18"],"name":[316],"type":["dbl"],"align":["right"]},{"label":["2020-11-19"],"name":[317],"type":["dbl"],"align":["right"]},{"label":["2020-11-20"],"name":[318],"type":["dbl"],"align":["right"]},{"label":["2020-11-21"],"name":[319],"type":["dbl"],"align":["right"]},{"label":["2020-11-22"],"name":[320],"type":["dbl"],"align":["right"]},{"label":["2020-11-23"],"name":[321],"type":["dbl"],"align":["right"]},{"label":["2020-11-24"],"name":[322],"type":["dbl"],"align":["right"]}],"data":[{"1":"county","2":"York County","3":"walking","4":"South Carolina","5":"United States","6":"100","7":"102.34","8":"115.17","9":"117.19","10":"123.51","11":"138.56","12":"102.97","13":"113.65","14":"102.97","15":"103.16","16":"103.41","17":"119.97","18":"122.31","19":"81.67","20":"101.52","21":"104.87","22":"114.92","23":"106.76","24":"124.53","25":"152.40","26":"89.82","27":"96.21","28":"104.68","29":"108.34","30":"97.66","31":"132.17","32":"128.45","33":"85.40","34":"104.11","35":"116.37","36":"101.83","37":"114.92","38":"166.62","39":"140.46","40":"89.00","41":"113.15","42":"111.06","43":"97.41","44":"99.87","45":"127.56","46":"154.42","47":"87.23","48":"101.33","49":"118.52","50":"126.42","51":"131.23","52":"153.54","53":"163.27","54":"100.95","55":"121.87","56":"109.86","57":"125.09","58":"121.68","59":"163.46","60":"197.53","61":"110.11","62":"114.41","63":"99.24","64":"120.92","65":"121.37","66":"137.17","67":"145.51","68":"84.20","69":"104.17","70":"95.64","71":"111.13","72":"99.68","73":"121.30","74":"101.39","75":"68.65","76":"85.71","77":"78.63","78":"95.39","79":"80.53","80":"110.81","81":"90.14","82":"70.99","83":"99.30","84":"80.78","85":"86.09","86":"92.67","87":"108.91","88":"92.86","89":"75.16","90":"87.80","91":"103.35","92":"96.97","93":"105.18","94":"106.57","95":"99.56","96":"48.17","97":"93.99","98":"105.12","99":"103.54","100":"102.40","101":"113.02","102":"106.95","103":"69.66","104":"95.26","105":"105.88","106":"123.32","107":"98.67","108":"132.49","109":"114.48","110":"93.05","111":"118.84","112":"116.56","113":"127.56","114":"116.62","115":"145.89","116":"139.76","117":"112.20","118":"131.35","119":"124.59","120":"128.13","121":"145.51","122":"140.71","123":"148.55","124":"107.27","125":"128.32","126":"101.26","127":"156.51","128":"167.00","129":"189.57","130":"178.82","131":"143.36","132":"163.08","133":"159.67","134":"156.70","135":"181.10","136":"193.62","137":"176.49","138":"131.73","139":"132.62","140":"168.33","141":"161.06","142":"168.65","143":"201.52","144":"194.82","145":"137.80","146":"167.51","147":"179.01","148":"202.34","149":"199.68","150":"190.27","151":"208.60","152":"147.16","153":"168.71","154":"178.07","155":"178.00","156":"186.79","157":"208.72","158":"191.59","159":"145.01","160":"163.72","161":"167.38","162":"175.60","163":"190.46","164":"228.51","165":"250.44","166":"150.44","167":"185.65","168":"204.55","169":"185.84","170":"197.16","171":"228.00","172":"252.21","173":"170.16","174":"187.67","175":"205.75","176":"207.21","177":"204.93","178":"245.32","179":"212.33","180":"152.09","181":"187.86","182":"194.63","183":"198.80","184":"220.73","185":"260.24","186":"257.96","187":"167.26","188":"189.89","189":"196.97","190":"185.71","191":"199.43","192":"219.28","193":"227.88","194":"167.83","195":"173.20","196":"193.68","197":"193.24","198":"219.66","199":"232.36","200":"239.70","201":"163.97","202":"190.64","203":"192.79","204":"189.44","205":"183.75","206":"241.21","207":"225.66","208":"166.75","209":"185.97","210":"225.60","211":"207.33","212":"196.46","213":"236.73","214":"239.76","215":"174.40","216":"216.94","217":"181.67","218":"204.61","219":"188.69","220":"236.66","221":"240.83","222":"175.03","223":"184.83","224":"174.59","225":"187.29","226":"192.98","227":"223.51","228":"250.76","229":"170.42","230":"189.95","231":"198.55","232":"190.08","233":"203.92","234":"221.81","235":"243.05","236":"161.57","237":"156.01","238":"194.25","239":"224.02","240":"217.13","241":"270.86","242":"263.84","243":"190.46","244":"181.29","245":"208.60","246":"198.42","247":"203.35","248":"240.14","249":"270.16","250":"169.66","251":"186.98","252":"187.86","253":"209.17","254":"173.64","255":"224.21","256":"224.21","257":"158.85","258":"188.37","259":"178.13","260":"184.07","261":"190.90","262":"210.81","263":"223.77","264":"152.40","265":"184.51","266":"174.21","267":"186.28","268":"196.40","269":"235.71","270":"234.83","271":"154.68","272":"164.48","273":"173.83","274":"174.97","275":"182.81","276":"214.85","277":"226.80","278":"137.17","279":"187.55","280":"179.77","281":"172.63","282":"181.16","283":"214.73","284":"225.16","285":"147.85","286":"167.26","287":"183.31","288":"182.17","289":"183.50","290":"234.58","291":"247.72","292":"142.29","293":"173.07","294":"172.50","295":"163.08","296":"191.21","297":"238.75","298":"241.40","299":"136.16","300":"183.00","301":"239.06","302":"171.68","303":"161.44","304":"199.75","305":"206.95","306":"151.83","307":"164.03","308":"165.74","309":"170.86","310":"146.08","311":"197.66","312":"197.98","313":"128.38","314":"162.20","315":"173.07","316":"161.82","317":"170.10","318":"208.98","319":"200.19","320":"135.21","321":"170.10","322":"196.71"},{"1":"county","2":"York County","3":"walking","4":"Pennsylvania","5":"United States","6":"100","7":"110.22","8":"121.82","9":"109.72","10":"140.72","11":"102.87","12":"117.24","13":"115.91","14":"103.43","15":"115.80","16":"96.96","17":"133.65","18":"145.36","19":"91.16","20":"106.80","21":"107.51","22":"108.23","23":"107.90","24":"140.28","25":"150.66","26":"89.39","27":"104.70","28":"113.43","29":"103.15","30":"105.14","31":"125.75","32":"141.33","33":"96.02","34":"106.91","35":"113.81","36":"110.22","37":"117.24","38":"159.72","39":"144.92","40":"108.51","41":"112.71","42":"102.38","43":"111.05","44":"110.50","45":"135.19","46":"160.72","47":"101.16","48":"101.60","49":"115.80","50":"119.45","51":"102.10","52":"137.24","53":"157.90","54":"106.63","55":"114.25","56":"120.39","57":"121.05","58":"119.12","59":"132.15","60":"145.91","61":"106.41","62":"132.82","63":"126.85","64":"119.28","65":"122.87","66":"145.52","67":"143.09","68":"111.99","69":"118.84","70":"105.25","71":"95.41","72":"94.64","73":"92.43","74":"85.80","75":"66.41","76":"62.76","77":"75.03","78":"69.78","79":"88.12","80":"92.60","81":"64.25","82":"53.92","83":"66.96","84":"68.95","85":"70.88","86":"79.94","87":"77.57","88":"77.18","89":"75.58","90":"85.41","91":"78.90","92":"91.55","93":"84.09","94":"88.67","95":"88.01","96":"64.53","97":"74.53","98":"77.68","99":"84.92","100":"84.42","101":"85.91","102":"82.60","103":"87.13","104":"88.40","105":"81.82","106":"95.08","107":"86.85","108":"94.36","109":"102.21","110":"65.75","111":"84.31","112":"85.08","113":"98.01","114":"76.57","115":"114.92","116":"119.89","117":"94.36","118":"115.86","119":"104.36","120":"87.85","121":"123.98","122":"113.54","123":"118.90","124":"119.06","125":"137.73","126":"94.09","127":"144.42","128":"148.84","129":"172.15","130":"150.77","131":"142.21","132":"158.34","133":"159.56","134":"149.56","135":"167.40","136":"162.49","137":"163.26","138":"136.46","139":"121.66","140":"187.24","141":"169.23","142":"159.78","143":"192.49","144":"187.46","145":"152.38","146":"180.55","147":"194.53","148":"166.41","149":"165.80","150":"193.70","151":"205.03","152":"156.08","153":"182.54","154":"170.11","155":"193.92","156":"179.45","157":"227.73","158":"200.50","159":"148.12","160":"181.99","161":"196.35","162":"186.69","163":"179.78","164":"223.43","165":"202.87","166":"161.60","167":"198.95","168":"194.42","169":"194.25","170":"218.78","171":"242.76","172":"232.54","173":"166.13","174":"191.16","175":"210.83","176":"217.02","177":"232.93","178":"275.86","179":"193.04","180":"184.59","181":"204.20","182":"195.86","183":"195.91","184":"206.19","185":"232.71","186":"216.91","187":"174.92","188":"192.76","189":"199.12","190":"193.54","191":"204.64","192":"216.24","193":"218.62","194":"175.64","195":"196.41","196":"198.34","197":"202.43","198":"195.19","199":"220.22","200":"235.19","201":"173.92","202":"195.91","203":"198.12","204":"195.36","205":"203.04","206":"221.33","207":"211.60","208":"171.88","209":"187.73","210":"193.81","211":"211.16","212":"202.32","213":"228.78","214":"225.64","215":"179.34","216":"201.10","217":"211.10","218":"201.05","219":"207.51","220":"225.80","221":"217.90","222":"166.24","223":"206.69","224":"204.64","225":"208.51","226":"226.91","227":"248.18","228":"228.18","229":"179.45","230":"214.42","231":"198.07","232":"203.09","233":"212.32","234":"224.70","235":"209.94","236":"182.65","237":"189.72","238":"189.39","239":"207.51","240":"216.96","241":"233.76","242":"226.57","243":"181.16","244":"158.51","245":"188.07","246":"205.25","247":"197.24","248":"231.05","249":"237.85","250":"164.25","251":"195.47","252":"204.14","253":"209.17","254":"198.12","255":"248.84","256":"240.06","257":"172.21","258":"179.89","259":"193.48","260":"197.85","261":"199.39","262":"235.14","263":"229.28","264":"155.69","265":"181.49","266":"180.55","267":"191.88","268":"193.59","269":"220.44","270":"254.64","271":"160.11","272":"171.22","273":"190.72","274":"181.05","275":"182.43","276":"226.91","277":"238.18","278":"172.15","279":"154.59","280":"189.72","281":"186.46","282":"199.50","283":"219.94","284":"249.89","285":"178.40","286":"178.40","287":"183.26","288":"200.94","289":"190.00","290":"232.49","291":"212.15","292":"139.56","293":"171.82","294":"200.33","295":"180.17","296":"167.79","297":"211.38","298":"246.63","299":"163.48","300":"167.24","301":"227.96","302":"166.41","303":"176.52","304":"202.82","305":"196.69","306":"152.54","307":"166.08","308":"165.86","309":"176.46","310":"158.01","311":"203.65","312":"185.41","313":"136.35","314":"146.80","315":"149.83","316":"156.52","317":"172.71","318":"200.28","319":"175.97","320":"138.62","321":"163.26","322":"183.81"},{"1":"county","2":"Young County","3":"driving","4":"Texas","5":"United States","6":"100","7":"98.85","8":"97.76","9":"92.21","10":"115.79","11":"128.73","12":"92.48","13":"114.43","14":"106.30","15":"97.09","16":"109.15","17":"149.66","18":"120.05","19":"92.82","20":"94.99","21":"99.93","22":"95.26","23":"107.05","24":"136.92","25":"111.79","26":"85.37","27":"105.28","28":"97.15","29":"49.12","30":"81.91","31":"117.95","32":"116.73","33":"88.82","34":"110.23","35":"100.95","36":"99.86","37":"124.32","38":"146.14","39":"127.17","40":"110.77","41":"135.64","42":"119.72","43":"96.88","44":"106.71","45":"155.62","46":"130.22","47":"98.17","48":"122.76","49":"145.46","50":"115.72","51":"125.68","52":"152.91","53":"130.22","54":"103.39","55":"116.26","56":"113.89","57":"107.18","58":"138.82","59":"151.42","60":"137.80","61":"116.06","62":"138.69","63":"147.29","64":"124.73","65":"146.75","66":"144.58","67":"110.30","68":"102.78","69":"92.14","70":"88.35","71":"106.84","72":"122.70","73":"100.27","74":"83.54","75":"72.09","76":"83.40","77":"91.60","78":"90.79","79":"86.99","80":"110.57","81":"93.56","82":"61.59","83":"78.12","84":"78.25","85":"83.74","86":"74.46","87":"91.53","88":"55.56","89":"69.04","90":"82.32","91":"80.83","92":"70.73","93":"88.35","94":"90.92","95":"68.83","96":"58.54","97":"77.78","98":"72.83","99":"93.43","100":"95.66","101":"111.18","102":"85.43","103":"86.59","104":"89.63","105":"87.06","106":"91.80","107":"101.56","108":"117.01","109":"106.50","110":"103.46","111":"86.92","112":"106.03","113":"102.64","114":"108.94","115":"143.77","116":"122.70","117":"105.56","118":"121.68","119":"103.46","120":"113.62","121":"125.54","122":"140.51","123":"130.69","124":"95.33","125":"NA","126":"NA","127":"124.53","128":"127.71","129":"169.04","130":"142.48","131":"129.88","132":"129.95","133":"127.85","134":"136.65","135":"151.29","136":"207.11","137":"223.24","138":"142.68","139":"132.52","140":"144.24","141":"135.23","142":"149.19","143":"180.01","144":"173.71","145":"140.24","146":"140.51","147":"152.85","148":"148.10","149":"146.48","150":"186.11","151":"172.49","152":"160.50","153":"156.37","154":"159.89","155":"180.69","156":"161.92","157":"206.37","158":"183.88","159":"159.15","160":"155.15","161":"163.01","162":"169.11","163":"152.37","164":"188.48","165":"200.47","166":"171.41","167":"157.59","168":"144.38","169":"177.03","170":"176.02","171":"207.52","172":"198.85","173":"157.59","174":"150.95","175":"171.00","176":"203.32","177":"208.47","178":"210.30","179":"172.76","180":"173.17","181":"160.64","182":"147.83","183":"143.50","184":"190.99","185":"199.46","186":"188.48","187":"164.91","188":"162.53","189":"152.91","190":"154.81","191":"172.70","192":"209.35","193":"185.43","194":"150.75","195":"135.50","196":"165.72","197":"158.94","198":"167.41","199":"209.96","200":"178.46","201":"158.54","202":"160.50","203":"158.06","204":"159.96","205":"167.34","206":"193.50","207":"194.99","208":"150.47","209":"163.62","210":"166.26","211":"172.56","212":"143.90","213":"230.83","214":"202.37","215":"161.92","216":"161.59","217":"174.66","218":"162.53","219":"186.45","220":"217.68","221":"193.97","222":"175.00","223":"158.54","224":"154.40","225":"168.90","226":"171.54","227":"198.37","228":"175.68","229":"144.31","230":"140.99","231":"169.31","232":"141.67","233":"173.24","234":"216.87","235":"194.04","236":"145.12","237":"150.47","238":"153.66","239":"142.75","240":"196.14","241":"254.67","242":"237.26","243":"183.94","244":"174.12","245":"163.41","246":"130.96","247":"155.69","248":"197.70","249":"194.17","250":"146.27","251":"149.59","252":"153.39","253":"141.40","254":"154.54","255":"210.70","256":"197.63","257":"142.07","258":"121.34","259":"154.61","260":"140.99","261":"159.76","262":"188.35","263":"180.22","264":"129.07","265":"131.23","266":"135.37","267":"138.28","268":"172.90","269":"197.36","270":"161.79","271":"134.69","272":"138.08","273":"133.88","274":"132.72","275":"128.39","276":"181.57","277":"194.24","278":"140.51","279":"135.77","280":"131.57","281":"138.48","282":"154.74","283":"197.90","284":"187.40","285":"142.14","286":"122.49","287":"125.41","288":"138.75","289":"142.82","290":"161.79","291":"174.39","292":"117.55","293":"99.12","294":"90.72","295":"107.18","296":"139.63","297":"167.48","298":"177.57","299":"118.36","300":"136.25","301":"122.76","302":"110.30","303":"129.61","304":"175.88","305":"172.29","306":"140.24","307":"132.86","308":"122.43","309":"131.23","310":"131.23","311":"233.47","312":"182.52","313":"131.37","314":"123.04","315":"130.69","316":"130.96","317":"133.81","318":"210.30","319":"149.86","320":"108.06","321":"145.33","322":"144.65"},{"1":"county","2":"Yuba County","3":"driving","4":"California","5":"United States","6":"100","7":"102.98","8":"103.10","9":"114.08","10":"118.83","11":"121.49","12":"93.29","13":"101.86","14":"103.01","15":"101.50","16":"109.50","17":"122.58","18":"120.03","19":"91.19","20":"101.50","21":"101.20","22":"96.93","23":"108.28","24":"131.25","25":"122.20","26":"80.79","27":"104.08","28":"107.93","29":"105.38","30":"111.49","31":"134.06","32":"127.64","33":"101.75","34":"108.29","35":"106.01","36":"110.18","37":"117.75","38":"140.51","39":"124.90","40":"106.32","41":"108.22","42":"108.19","43":"110.05","44":"111.50","45":"134.76","46":"152.08","47":"113.28","48":"116.18","49":"108.44","50":"112.08","51":"115.35","52":"135.41","53":"139.12","54":"106.05","55":"108.45","56":"119.04","57":"122.23","58":"120.20","59":"132.12","60":"124.14","61":"97.46","62":"106.12","63":"112.08","64":"113.73","65":"107.71","66":"118.63","67":"100.90","68":"76.58","69":"82.91","70":"83.18","71":"83.45","72":"88.76","73":"79.91","74":"72.63","75":"59.05","76":"65.73","77":"64.81","78":"67.83","79":"70.68","80":"76.97","81":"62.40","82":"55.03","83":"74.19","84":"74.92","85":"76.95","86":"78.44","87":"82.14","88":"58.87","89":"45.52","90":"67.45","91":"71.65","92":"74.02","93":"73.88","94":"82.85","95":"80.82","96":"55.43","97":"77.82","98":"80.93","99":"83.26","100":"87.90","101":"94.88","102":"88.36","103":"78.35","104":"81.37","105":"88.14","106":"87.49","107":"88.94","108":"99.83","109":"102.32","110":"91.08","111":"89.69","112":"101.57","113":"98.09","114":"100.19","115":"107.67","116":"109.34","117":"94.03","118":"98.35","119":"102.80","120":"104.68","121":"107.22","122":"124.55","123":"140.55","124":"98.61","125":"NA","126":"NA","127":"105.17","128":"112.03","129":"128.40","130":"138.91","131":"92.88","132":"106.65","133":"114.44","134":"123.97","135":"144.79","136":"172.41","137":"180.26","138":"160.32","139":"151.55","140":"143.26","141":"144.15","142":"143.78","143":"161.06","144":"150.01","145":"150.21","146":"136.27","147":"133.18","148":"142.45","149":"153.59","150":"175.49","151":"183.92","152":"157.73","153":"151.66","154":"150.58","155":"152.14","156":"148.45","157":"166.37","158":"170.58","159":"165.75","160":"146.81","161":"151.66","162":"153.60","163":"154.83","164":"181.33","165":"190.91","166":"180.60","167":"161.82","168":"153.96","169":"156.65","170":"161.90","171":"185.28","172":"186.42","173":"164.82","174":"158.24","175":"161.19","176":"174.33","177":"186.71","178":"188.26","179":"149.00","180":"160.97","181":"163.45","182":"158.02","183":"159.59","184":"182.89","185":"182.18","186":"184.16","187":"160.76","188":"163.40","189":"163.19","190":"163.50","191":"168.16","192":"186.72","193":"183.00","194":"166.00","195":"157.97","196":"159.06","197":"155.59","198":"160.11","199":"185.12","200":"186.12","201":"163.26","202":"157.79","203":"156.33","204":"159.02","205":"167.03","206":"181.93","207":"183.92","208":"172.46","209":"162.37","210":"161.44","211":"157.96","212":"167.28","213":"190.22","214":"183.21","215":"163.29","216":"165.03","217":"160.60","218":"160.27","219":"167.81","220":"192.80","221":"183.85","222":"164.01","223":"164.29","224":"154.39","225":"161.72","226":"159.48","227":"184.31","228":"169.13","229":"145.27","230":"147.99","231":"147.07","232":"146.19","233":"154.42","234":"184.33","235":"174.46","236":"151.02","237":"151.13","238":"151.89","239":"152.16","240":"163.32","241":"189.57","242":"194.16","243":"166.30","244":"153.49","245":"175.40","246":"188.77","247":"151.62","248":"171.13","249":"157.74","250":"131.88","251":"144.92","252":"149.45","253":"147.16","254":"155.48","255":"178.39","256":"170.59","257":"142.61","258":"141.10","259":"137.90","260":"158.52","261":"151.21","262":"180.75","263":"191.93","264":"161.61","265":"144.15","266":"145.52","267":"142.72","268":"147.62","269":"169.87","270":"178.95","271":"147.52","272":"143.31","273":"137.39","274":"136.21","275":"170.20","276":"187.48","277":"195.30","278":"154.65","279":"153.69","280":"157.90","281":"154.77","282":"159.74","283":"189.88","284":"196.89","285":"157.41","286":"140.82","287":"140.61","288":"150.28","289":"151.27","290":"173.03","291":"193.67","292":"154.02","293":"138.82","294":"148.87","295":"143.18","296":"146.14","297":"177.84","298":"164.10","299":"125.70","300":"124.64","301":"129.55","302":"123.39","303":"125.75","304":"138.56","305":"140.67","306":"112.15","307":"119.47","308":"117.40","309":"122.24","310":"106.41","311":"131.93","312":"138.02","313":"105.11","314":"118.52","315":"118.89","316":"113.58","317":"117.81","318":"147.06","319":"129.98","320":"105.14","321":"121.74","322":"124.88"},{"1":"county","2":"Yuma County","3":"driving","4":"Arizona","5":"United States","6":"100","7":"101.82","8":"106.67","9":"108.93","10":"135.92","11":"124.77","12":"92.88","13":"108.37","14":"105.18","15":"105.24","16":"109.54","17":"132.21","18":"125.12","19":"94.11","20":"103.45","21":"108.04","22":"107.88","23":"112.34","24":"129.86","25":"116.83","26":"88.09","27":"110.98","28":"107.94","29":"104.94","30":"115.84","31":"140.28","32":"131.77","33":"103.03","34":"105.44","35":"114.41","36":"112.21","37":"132.04","38":"158.97","39":"132.89","40":"108.40","41":"128.29","42":"115.96","43":"116.57","44":"123.23","45":"143.27","46":"132.70","47":"107.74","48":"118.68","49":"117.43","50":"115.55","51":"123.63","52":"149.31","53":"130.44","54":"109.24","55":"113.16","56":"110.25","57":"115.04","58":"123.36","59":"159.86","60":"144.97","61":"118.33","62":"127.15","63":"118.17","64":"120.42","65":"122.02","66":"146.65","67":"130.97","68":"109.68","69":"112.03","70":"101.60","71":"92.78","72":"95.21","73":"95.69","74":"84.75","75":"63.16","76":"77.98","77":"71.59","78":"71.49","79":"69.22","80":"82.22","81":"71.62","82":"57.59","83":"69.12","84":"64.23","85":"66.36","86":"66.24","87":"77.91","88":"67.36","89":"54.62","90":"65.02","91":"64.23","92":"59.30","93":"62.70","94":"77.00","95":"67.49","96":"49.40","97":"67.04","98":"69.23","99":"73.48","100":"77.04","101":"86.06","102":"79.86","103":"64.90","104":"74.58","105":"73.28","106":"77.86","107":"80.44","108":"91.97","109":"83.27","110":"65.68","111":"83.43","112":"76.11","113":"79.19","114":"83.92","115":"99.67","116":"86.68","117":"70.34","118":"81.20","119":"80.74","120":"80.56","121":"89.78","122":"105.60","123":"99.42","124":"77.53","125":"NA","126":"NA","127":"93.20","128":"98.54","129":"119.31","130":"110.02","131":"92.75","132":"104.56","133":"101.34","134":"101.35","135":"115.73","136":"140.77","137":"128.37","138":"103.69","139":"114.06","140":"110.37","141":"104.54","142":"116.47","143":"126.57","144":"114.31","145":"92.30","146":"103.23","147":"100.24","148":"97.78","149":"108.88","150":"131.78","151":"122.99","152":"100.30","153":"107.26","154":"108.90","155":"108.99","156":"112.90","157":"132.93","158":"115.40","159":"104.08","160":"111.64","161":"111.90","162":"108.80","163":"118.52","164":"134.33","165":"125.80","166":"97.72","167":"113.91","168":"112.03","169":"110.73","170":"121.54","171":"139.51","172":"125.43","173":"109.47","174":"118.36","175":"118.29","176":"128.97","177":"147.59","178":"142.28","179":"104.42","180":"127.04","181":"129.60","182":"112.21","183":"112.52","184":"123.67","185":"137.51","186":"124.35","187":"105.86","188":"111.79","189":"115.99","190":"116.14","191":"118.69","192":"139.67","193":"127.38","194":"110.94","195":"114.94","196":"112.35","197":"116.87","198":"123.02","199":"139.05","200":"125.68","201":"112.77","202":"119.29","203":"114.46","204":"118.45","205":"124.17","206":"144.91","207":"132.58","208":"118.34","209":"120.72","210":"117.18","211":"116.21","212":"124.05","213":"142.42","214":"128.04","215":"114.90","216":"114.02","217":"115.69","218":"114.12","219":"125.48","220":"149.91","221":"126.50","222":"122.67","223":"125.91","224":"128.98","225":"118.11","226":"125.63","227":"151.14","228":"131.08","229":"117.43","230":"118.05","231":"114.15","232":"115.30","233":"123.61","234":"147.18","235":"130.86","236":"117.85","237":"134.22","238":"133.89","239":"128.45","240":"141.74","241":"186.35","242":"146.13","243":"124.25","244":"161.52","245":"122.71","246":"121.49","247":"125.12","248":"149.53","249":"139.01","250":"119.51","251":"124.95","252":"119.28","253":"117.39","254":"127.18","255":"159.07","256":"145.78","257":"128.08","258":"122.04","259":"109.78","260":"112.84","261":"118.18","262":"153.39","263":"150.09","264":"130.53","265":"112.92","266":"111.38","267":"114.98","268":"123.59","269":"158.86","270":"164.80","271":"137.51","272":"120.67","273":"115.82","274":"116.66","275":"126.34","276":"161.45","277":"150.05","278":"133.46","279":"121.61","280":"116.55","281":"113.79","282":"127.58","283":"166.58","284":"161.09","285":"141.79","286":"119.27","287":"113.37","288":"113.50","289":"122.75","290":"158.92","291":"160.80","292":"129.61","293":"108.09","294":"109.61","295":"110.64","296":"125.63","297":"154.62","298":"145.76","299":"114.68","300":"112.85","301":"108.62","302":"102.40","303":"114.44","304":"153.84","305":"147.44","306":"117.62","307":"107.03","308":"114.43","309":"113.99","310":"104.88","311":"141.07","312":"134.50","313":"110.46","314":"108.88","315":"108.19","316":"108.86","317":"119.56","318":"150.99","319":"145.35","320":"114.17","321":"116.24","322":"124.21"},{"1":"county","2":"Yuma County","3":"walking","4":"Arizona","5":"United States","6":"100","7":"95.88","8":"98.97","9":"92.88","10":"117.25","11":"128.93","12":"79.23","13":"115.28","14":"109.10","15":"101.03","16":"111.67","17":"122.06","18":"138.54","19":"86.44","20":"104.03","21":"104.12","22":"102.83","23":"106.61","24":"120.43","25":"113.30","26":"86.78","27":"105.92","28":"105.92","29":"94.16","30":"118.97","31":"137.42","32":"143.69","33":"93.22","34":"99.06","35":"119.40","36":"122.15","37":"126.61","38":"150.30","39":"122.32","40":"102.66","41":"124.72","42":"120.34","43":"119.57","44":"111.85","45":"144.81","46":"127.73","47":"92.27","48":"116.74","49":"113.13","50":"106.18","51":"122.66","52":"147.30","53":"131.24","54":"90.47","55":"98.80","56":"107.98","57":"105.75","58":"112.62","59":"138.37","60":"134.85","61":"103.61","62":"113.56","63":"105.06","64":"102.92","65":"110.04","66":"138.54","67":"128.84","68":"104.98","69":"105.58","70":"102.92","71":"84.12","72":"89.27","73":"96.91","74":"91.16","75":"68.58","76":"71.59","77":"73.22","78":"72.62","79":"62.49","80":"86.01","81":"77.17","82":"57.68","83":"82.23","84":"71.93","85":"80.52","86":"72.53","87":"83.52","88":"74.51","89":"55.28","90":"76.14","91":"67.47","92":"53.13","93":"67.98","94":"79.23","95":"75.02","96":"48.41","97":"70.13","98":"70.73","99":"78.71","100":"78.37","101":"87.21","102":"85.49","103":"55.79","104":"80.60","105":"76.05","106":"77.00","107":"82.92","108":"104.38","109":"89.44","110":"62.66","111":"74.16","112":"89.01","113":"86.95","114":"92.19","115":"98.03","116":"86.95","117":"75.19","118":"84.55","119":"94.68","120":"93.99","121":"94.51","122":"113.39","123":"118.71","124":"80.17","125":"78.11","126":"77.85","127":"111.76","128":"112.27","129":"125.84","130":"127.73","131":"90.90","132":"118.45","133":"110.73","134":"118.63","135":"122.66","136":"138.97","137":"147.55","138":"109.70","139":"114.68","140":"128.76","141":"116.65","142":"133.82","143":"146.87","144":"129.79","145":"97.68","146":"107.98","147":"109.53","148":"112.02","149":"115.36","150":"141.46","151":"140.43","152":"114.85","153":"126.95","154":"133.91","155":"112.79","156":"116.39","157":"129.10","158":"119.74","159":"101.80","160":"122.58","161":"114.59","162":"126.61","163":"117.42","164":"134.94","165":"139.74","166":"100.60","167":"131.50","168":"133.91","169":"116.48","170":"138.54","171":"149.87","172":"133.82","173":"101.03","174":"129.27","175":"149.27","176":"138.20","177":"151.67","178":"152.19","179":"126.01","180":"122.32","181":"143.35","182":"134.94","183":"134.16","184":"132.27","185":"148.84","186":"144.38","187":"95.28","188":"140.34","189":"139.66","190":"138.20","191":"129.53","192":"143.69","193":"137.42","194":"107.73","195":"121.37","196":"140.17","197":"136.57","198":"136.74","199":"151.33","200":"132.62","201":"104.29","202":"140.09","203":"136.39","204":"139.83","205":"125.15","206":"161.37","207":"134.94","208":"121.20","209":"131.67","210":"126.70","211":"132.96","212":"141.89","213":"164.64","214":"149.53","215":"104.03","216":"135.45","217":"147.64","218":"138.20","219":"142.58","220":"162.06","221":"155.88","222":"108.93","223":"141.37","224":"147.12","225":"138.71","226":"138.63","227":"149.70","228":"142.23","229":"104.29","230":"121.03","231":"137.68","232":"123.43","233":"139.91","234":"159.57","235":"146.61","236":"122.58","237":"142.75","238":"151.76","239":"135.79","240":"143.18","241":"180.09","242":"165.15","243":"120.34","244":"138.71","245":"147.90","246":"145.67","247":"131.67","248":"164.89","249":"163.95","250":"133.22","251":"144.38","252":"149.87","253":"138.88","254":"142.23","255":"182.15","256":"173.91","257":"125.92","258":"135.62","259":"132.02","260":"134.42","261":"124.03","262":"181.03","263":"169.87","264":"127.98","265":"130.82","266":"143.26","267":"129.79","268":"152.10","269":"170.64","270":"197.85","271":"139.57","272":"140.86","273":"127.90","274":"127.64","275":"160.77","276":"189.18","277":"186.18","278":"137.68","279":"140.26","280":"143.86","281":"133.65","282":"149.18","283":"180.86","284":"191.24","285":"142.75","286":"149.53","287":"144.12","288":"136.57","289":"151.85","290":"187.73","291":"197.08","292":"139.23","293":"141.37","294":"145.84","295":"137.17","296":"157.34","297":"184.46","298":"203.86","299":"124.03","300":"147.12","301":"154.33","302":"142.49","303":"129.44","304":"185.75","305":"180.69","306":"111.85","307":"127.38","308":"143.86","309":"141.89","310":"125.41","311":"168.76","312":"159.48","313":"111.50","314":"140.43","315":"149.61","316":"143.18","317":"157.60","318":"181.89","319":"180.17","320":"129.44","321":"135.36","322":"158.88"}],"options":{"columns":{"min":{},"max":[10]},"rows":{"min":[10],"max":[10]},"pages":{}}} </script> </div> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Tidying Apple Mobility Data Tidy dates and mobility into `date` and `dir_request` ('relative usage of directions') ```r AppleMobRaw %>% tidyr::pivot_longer(cols = -c(geo_type:country), names_to = "date", values_to = "dir_request") ``` <div data-pagedtable="false"> <script data-pagedtable-source type="application/json"> {"columns":[{"label":["geo_type"],"name":[1],"type":["chr"],"align":["left"]},{"label":["region"],"name":[2],"type":["chr"],"align":["left"]},{"label":["transportation_type"],"name":[3],"type":["chr"],"align":["left"]},{"label":["sub-region"],"name":[4],"type":["chr"],"align":["left"]},{"label":["country"],"name":[5],"type":["chr"],"align":["left"]},{"label":["date"],"name":[6],"type":["chr"],"align":["left"]},{"label":["dir_request"],"name":[7],"type":["dbl"],"align":["right"]}],"data":[{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-13","7":"100.00"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-14","7":"95.30"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-15","7":"101.43"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-16","7":"97.20"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-17","7":"103.55"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-18","7":"112.67"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-19","7":"104.83"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-20","7":"94.39"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-21","7":"94.07"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-22","7":"93.51"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-23","7":"92.94"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-24","7":"102.13"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-25","7":"102.38"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-26","7":"101.41"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-27","7":"94.62"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-28","7":"89.12"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-29","7":"90.17"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-30","7":"90.21"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-01-31","7":"97.71"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-01","7":"102.50"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-02","7":"108.92"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-03","7":"92.82"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-04","7":"91.48"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-05","7":"93.99"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-06","7":"96.72"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-07","7":"102.46"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-08","7":"103.29"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-09","7":"107.83"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-10","7":"87.99"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-11","7":"94.18"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-12","7":"94.62"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-13","7":"99.70"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-14","7":"139.30"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-15","7":"123.90"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-16","7":"129.41"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-17","7":"102.24"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-18","7":"88.09"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-19","7":"88.17"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-20","7":"94.48"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-21","7":"100.62"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-22","7":"111.02"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-23","7":"113.50"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-24","7":"86.95"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-25","7":"83.01"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-26","7":"85.44"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-27","7":"82.73"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-28","7":"89.70"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-02-29","7":"95.48"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-03-01","7":"100.43"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-03-02","7":"89.25"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-03-03","7":"91.02"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-03-04","7":"89.72"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-03-05","7":"94.87"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-03-06","7":"102.82"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-03-07","7":"109.92"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-03-08","7":"110.07"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-03-09","7":"79.68"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-03-10","7":"68.24"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-03-11","7":"51.77"},{"1":"country/region","2":"Albania","3":"driving","4":"NA","5":"NA","6":"2020-03-12","7":"43.79"}],"options":{"columns":{"min":{},"max":[10]},"rows":{"min":[10],"max":[10]},"pages":{}}} </script> </div> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Manipulate Apple Mobility Data Remove missing values in `country` and `sub-region` and `clean_names()` ```r AppleMobRaw %>% tidyr::pivot_longer(cols = -c(geo_type:country), names_to = "date", values_to = "dir_request") %>% # remove missing country data dplyr::filter(!is.na(country) & !is.na(`sub-region`)) %>% # clean names janitor::clean_names() %>% View("TidyApple") ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### New Tidy Apple Mobility Data! <img src="img/apple-tidy-view.png" width="80%" height="80%" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Assign Apple Mobility Data to `TidyApple` This looks good, so assign to `TidyApple` ```r AppleMobRaw %>% tidyr::pivot_longer(cols = -c(geo_type:country), names_to = "date", values_to = "dir_request") %>% # remove missing country data dplyr::filter(!is.na(country) & !is.na(`sub-region`)) %>% # clean names janitor::clean_names() -> TidyApple ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### `TidyApple`: Format Variables Our `TidyApple` data still needs some attention. ```r glimpse(TidyApple) ``` ``` ## Rows: 1,055,293 ## Columns: 7 ## $ geo_type <chr> "city", "city", "city", "city… ## $ region <chr> "Aachen", "Aachen", "Aachen",… ## $ transportation_type <chr> "driving", "driving", "drivin… ## $ sub_region <chr> "North Rhine-Westphalia", "No… ## $ country <chr> "Germany", "Germany", "German… ## $ date <chr> "2020-01-13", "2020-01-14", "… ## $ dir_request <dbl> 100.00, 100.73, 102.86, 102.6… ``` The `date` variable needs to be formatted as a `date` ```r TidyApple %>% mutate(date = lubridate::ymd(date)) -> TidyApple ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### `TidyApple`: Rename Variables Let's rename `transportation_type` to `trans_type` ```r TidyApple %>% rename(trans_type = transportation_type) -> TidyApple ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### `TidyApple`: Check Formatted Variables Re-check `TidyApple` data. ```r glimpse(TidyApple) ``` ``` ## Rows: 1,055,293 ## Columns: 7 ## $ geo_type <chr> "city", "city", "city", "city", "city… ## $ region <chr> "Aachen", "Aachen", "Aachen", "Aachen… ## $ trans_type <chr> "driving", "driving", "driving", "dri… ## $ sub_region <chr> "North Rhine-Westphalia", "North Rhin… ## $ country <chr> "Germany", "Germany", "Germany", "Ger… ## $ date <date> 2020-01-13, 2020-01-14, 2020-01-15, … ## $ dir_request <dbl> 100.00, 100.73, 102.86, 102.65, 109.3… ``` Now we can see `date` is formatted correctly --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### `TidyApple`: Counting > “*data science is mostly counting things*” - `tabyl` vignette Count the `trans_type` variable with `dplyr::count()` .pull-left[ <br> ```r TidyApple %>% count(trans_type) ``` ``` ## # A tibble: 3 x 2 ## trans_type n ## <chr> <int> ## 1 driving 743682 ## 2 transit 106512 ## 3 walking 205099 ``` ] .pull-right[ *Add the `sort = TRUE` argument* ```r TidyApple %>% count(trans_type, sort = TRUE) ``` ``` ## # A tibble: 3 x 2 ## trans_type n ## <chr> <int> ## 1 driving 743682 ## 2 walking 205099 ## 3 transit 106512 ``` ] --- class: inverse, center, top background-image: url(img/ggplot2.png) background-position: 50% 70% background-size: 35% # Visualizing Variable Distributions --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## What kinds of question(s) do graphs like these answer? ### What does the distribution of direction requests look like? What is the distribution of `dir_request`? We will explore this with a histogram. ### Labels!! ```r lab_hist <- labs(x = "Apple directions requests", y = "Count", title = "Distribution of Direction Requests", subtitle = "source: https://covid19.apple.com/mobility") ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 8% 95% background-size: 8% ## Histogram = single variable distributions Create a histogram of `dir_request` with the code below: ```r TidyApple %>% ggplot() + * geom_histogram(aes(x = dir_request)) + lab_hist ``` <img src="img/geom-hist-1.png" width="60%" height="60%" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Histograms: Changing the Y Axis Fix the `y` axis numbers with help from the [`scales` package](https://scales.r-lib.org/) ```r library(scales) TidyApple %>% ggplot() + geom_histogram(aes(x = dir_request)) + * scale_y_continuous(labels = scales::comma) + lab_hist ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Histograms: Changing the Y Axis <br> <img src="img/geom-hist-scales-1.png" width="90%" height="90%" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Changing Histogram Shape Adjust the shape of the histogram with the `bins` argument ```r TidyApple %>% ggplot() + * geom_histogram(aes(x = dir_request), bins = 15) + scale_y_continuous(labels = scales::comma) + lab_hist ``` <img src="img/bins-15-no-show-1.png" width="75%" height="75%" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Changing Histogram Shape Adjust the shape of the histogram with the `bins` argument ```r TidyApple %>% ggplot() + * geom_histogram(aes(x = dir_request), bins = 45) + scale_y_continuous(labels = scales::comma) + lab_hist ``` <img src="img/bins-45-no-show-1.png" width="75%" height="75%" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 8% 95% background-size: 6% ## Visualizing variable distributions across groups ### What questions do these graphs answer? How does the distribution of `dir_request` across `trans_type`? -- ### We can view this with a density plot, violin plot, or ridgeline plot --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Density Plots ### CREATE LABELS FIRST!! We need a new set of labels ```r lab_density <- labs(x = "Apple directions requests", y = "Density", title = "Direction Requests vs. Transportation Type", subtitle = "source: https://covid19.apple.com/mobility") ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Density Plots Visualize the distribution of `dir_request` across `trans_type` with a `geom_density()` ```r TidyApple %>% ggplot() + * geom_density(aes(x = dir_request, * fill = trans_type)) + lab_density ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Density Plots <img src="img/density-no-show-1.png" width="85%" height="85%" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Density Plots (`alpha`) <br> Adjust the `alpha` so we can see the overlap ```r TidyApple %>% ggplot() + geom_density(aes(x = dir_request, fill = trans_type), * alpha = 1/3) + lab_density ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Density Plots (`alpha`) Now we can see where they overlap <img src="img/density-alpha-no-show-1.png" width="85%" height="85%" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Violin Plots Violin plots are alternatives to boxplots. ```r lab_violin <- labs(y = "Apple directions requests", x = "Transportation Types", title = "Direction Requests by Transportation Type", subtitle = "source: https://covid19.apple.com/mobility") ``` These allow us to add a categorical variable to the `x` axis. --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Violin Plots ```r TidyApple %>% ggplot() + * geom_violin(aes(y = dir_request, x = trans_type, * fill = trans_type)) + lab_violin ``` <img src="img/geom_violin-1.png" width="85%" height="85%" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Violin Plots: *confused?* Add a boxplot layer! ```r TidyApple %>% ggplot() + * geom_violin(aes(y = dir_request, x = trans_type, * fill = trans_type), alpha = 1/5) ``` -- ```r TidyApple %>% ggplot() + geom_violin(aes(y = dir_request, x = trans_type, fill = trans_type), alpha = 1/5) + * geom_boxplot(aes(y = dir_request, x = trans_type, * color = trans_type)) + lab_violin ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Violin Plots *and* Boxpots <img src="img/geom_violin-geom_boxplot-run-no-show-1.png" width="95%" height="95%" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Rideline Plots Another option is a ridgeline plot (from the `ggridges` package). These display multiple densities. ```r lab_ridges <- labs(x = "Apple directions requests", y = "Transportation Types", title = "Direction Requests by Transportation Type", subtitle = "source: https://covid19.apple.com/mobility") ``` ```r library(ggridges) TidyApple %>% ggplot() + geom_density_ridges(aes(x = dir_request, y = trans_type, fill = trans_type), alpha = 1/5) + lab_ridges ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Rideline Plots We can adjust the alpha on these just like the density plots. <img src="img/geom_density_ridges-plot-1.png" style="display: block; margin: auto;" /> <img src="img/geom_density_ridges-plot-1.png" width="80%" height="80%" style="display: block; margin: auto;" /> --- class: inverse, center, top background-image: url(img/ggplot2.png) background-position: 50% 70% background-size: 35% # Line Graphs --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Narrowing date ranges Filter the data to only us cities between `2020-02-01` and `2020-08-01`. Use `skimr::skim()` to make sure it works! -- ```r TidyApple %>% # us cities filter(geo_type == "city" & country == "United States", # feb - aug date >= lubridate::as_date("2020-02-01") & date <= lubridate::as_date("2020-08-01")) %>% # check work! skimr::skim(date) ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Check with `skimr` output These are helpful if we're checking a filter on a numerical certain condition (`min`, `max`, `mean`, etc.) <br> <img src="img/skimr-output.png" width="100%" height="100%" style="display: block; margin: auto auto auto 0;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Narrow to US Cities (Feb-Jul) <br> Create `USCitiesFebJul` data by filtering to US cities between Feb 1, 2020 and July 31, 2020. <br> ```r TidyApple %>% filter(geo_type == "city" & country == "United States", date >= lubridate::as_date("2020-02-01") & date <= lubridate::as_date("2020-08-01")) -> USCitiesFebJul ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Line Graph: Labels (1) Ideally, our labels update whenever the data changes. We can do this with `paste0()`. ```r paste0(min(USCitiesFebJul$date), " through ", max(USCitiesFebJul$date)) ``` ``` ## [1] "2020-02-01 through 2020-08-01" ``` -- ```r subtitle = paste0( min(USCitiesFebJul$date), # first date " through ", # plain text max(USCitiesFebJul$date) # last date ), ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Line Graph: Labels (2) <br> We can then supply the `subtitle` to `labs` <br><br> ```r labs(x = "Date", y = "Direction Requests", title = "Direction Requests Over Time (US Cities Only)", * subtitle = paste0(min(USCitiesFebJul$date), * " through ", * max(USCitiesFebJul$date)), caption = "source: https://covid19.apple.com/mobility", color = "Transit Type") -> lab_line_graph ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Line Graph: Labels (3) <br> <img src="img/apply-lab_line_graph-show.png" width="100%" height="100%" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Line Graphs: Overlapping Lines Consider our previous line graph--the lines overlap a bit. <img src="img/apply-lab_line_graph-no-run-1.png" width="100%" height="100%" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Line Graph: Line Size (1) We can minimize the size of the line with the `size` aesthetic. ```r USCitiesFebJul %>% ggplot() + geom_line(aes(x = date, y = dir_request, group = trans_type, color = trans_type), # make these slightly smaller size = 0.30) + lab_line_graph ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Line Graph: Line Size (2) This makes the trends easier to see. <img src="img/geom_line-smaller-size-no-show-1.png" width="100%" height="100%" style="display: block; margin: auto;" /> --- class: inverse, center, top background-image: url(img/ggplot2.png) background-position: 50% 70% background-size: 35% # Adding Text --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Labeling Missing Data There is a gap in the direct request data (this is [documented in the data source](https://covid19.apple.com/mobility)). -- > *"Data for May 11-12 is not available and will appear as blank columns in the data set."* -- <img src="img/geom_line-smaller-size-no-show-1.png" width="75%" height="75%" style="display: block; margin: auto;" /> We should annotate this on a line graph! --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Create Annotate Data These data are `filter`ed to US cities between March 1, 2020 to June 30, 2020. ```r USCitiesMarJun <- TidyApple %>% filter(geo_type == "city" & country == "United States", date >= lubridate::as_date("2020-03-01") & date <= lubridate::as_date("2020-07-01")) ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Annotate Data ```r USCitiesMarJun ``` <div data-pagedtable="false"> <script data-pagedtable-source type="application/json"> {"columns":[{"label":["geo_type"],"name":[1],"type":["chr"],"align":["left"]},{"label":["region"],"name":[2],"type":["chr"],"align":["left"]},{"label":["trans_type"],"name":[3],"type":["chr"],"align":["left"]},{"label":["sub_region"],"name":[4],"type":["chr"],"align":["left"]},{"label":["country"],"name":[5],"type":["chr"],"align":["left"]},{"label":["date"],"name":[6],"type":["date"],"align":["right"]},{"label":["dir_request"],"name":[7],"type":["dbl"],"align":["right"]}],"data":[{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-01","7":"91.46"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-02","7":"107.46"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-03","7":"111.38"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-04","7":"111.55"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-05","7":"119.94"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-06","7":"133.31"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-07","7":"134.39"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-08","7":"98.89"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-09","7":"109.00"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-10","7":"107.88"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-11","7":"108.33"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-12","7":"101.91"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-13","7":"109.41"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-14","7":"99.23"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-15","7":"71.34"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-16","7":"79.93"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-17","7":"73.77"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-18","7":"70.88"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-19","7":"70.50"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-20","7":"76.35"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-21","7":"62.26"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-22","7":"51.87"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-23","7":"58.65"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-24","7":"51.41"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-25","7":"57.88"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-26","7":"62.39"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-27","7":"69.75"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-28","7":"54.00"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-29","7":"51.98"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-30","7":"57.49"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-03-31","7":"60.24"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-01","7":"63.18"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-02","7":"66.00"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-03","7":"74.11"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-04","7":"71.11"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-05","7":"50.17"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-06","7":"68.37"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-07","7":"64.03"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-08","7":"73.37"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-09","7":"68.02"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-10","7":"73.04"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-11","7":"72.95"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-12","7":"42.29"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-13","7":"62.67"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-14","7":"70.40"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-15","7":"73.55"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-16","7":"76.63"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-17","7":"76.75"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-18","7":"82.45"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-19","7":"65.10"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-20","7":"82.40"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-21","7":"75.77"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-22","7":"78.08"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-23","7":"81.02"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-24","7":"94.79"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-25","7":"91.99"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-26","7":"59.74"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-27","7":"86.73"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-28","7":"84.76"},{"1":"city","2":"Akron","3":"driving","4":"Ohio","5":"United States","6":"2020-04-29","7":"83.55"}],"options":{"columns":{"min":{},"max":[10]},"rows":{"min":[10],"max":[10]},"pages":{}}} </script> </div> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### `annotate`: Build Labels Build our labels first! ```r labs(x = "Date", y = "Direction Requests", title = "Spring Direction Requests (Mar-Jun) in US Cities", * subtitle = paste0(min(USCitiesMarJun$date), " through ", * max(USCitiesMarJun$date)), caption = "source: https://covid19.apple.com/mobility", color = "Transit Type") -> lab_annotation ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### `annotate`: Build Line Graph Build a line graph layer (`gg_line_annotate`) ```r USCitiesMarJun %>% ggplot() + geom_line(aes(x = date, y = dir_request, group = trans_type, color = trans_type), size = 0.30) -> gg_line_annotate ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### `annotate`: build coordinate system Add a coordinate system layer (`gg_coord_system`) ```r coord_cartesian( xlim = c(min(USCitiesMarJun$date), max(USCitiesMarJun$date)), ylim = c(min(USCitiesMarJun$dir_request, na.rm = TRUE), max(USCitiesMarJun$dir_request, na.rm = TRUE))) -> gg_coord_system ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### `annotate`: build line segment Build vertical line segment (`gg_line_segment`) ```r annotate(geom = "segment", size = 1, color = "firebrick3", x = lubridate::as_date("2020-05-11"), xend = lubridate::as_date("2020-05-11"), y = 270, yend = 100) -> gg_line_segment ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### `annotate`: Build Text Annotatation Build text annotation (`gg_text_annotation`) ```r annotate(geom = "text", color = "red", hjust = 0.5, size = 6, x = lubridate::as_date("2020-05-07"), y = 300, label = "Data not available") -> gg_text_annotation ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### `annotate`: Combine Layers Now we can use the `ggplot2` syntax to combine these layers... <br><br> ```r gg_line_annotate + # line graph gg_coord_system + # coordinate system gg_line_segment + # line annotation gg_text_annotation + # text annotation lab_annotation # labels ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### `annotate`: Complete Graph ...and we see a complete graph! <img src="img/build-annotation-graph-show-1.png" style="display: block; margin: auto;" /> <img src="img/build-annotation-graph-show-1.png" width="65%" height="65%" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Labeling Values (Review) In the previous slides, we learned about labeling values with `ggrepel`. <img src="img/aes-sol-11-1.png" width="70%" height="70%" style="display: block; margin: auto;" /> Now we're going to extend this to plotting text and values on our graphs! --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Highlighting Large US Cities Filter `TidyApple` to the 5 largest US cities (by [population](https://en.wikipedia.org/wiki/List_of_United_States_cities_by_population)). ```r TopUSCities <- TidyApple %>% filter(country == "United States" & region %in% c("New York City","Los Angeles", "Chicago", "Houston", "Phoenix")) ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### View `TopUSCities` ```r TopUSCities ``` <div data-pagedtable="false"> <script data-pagedtable-source type="application/json"> {"columns":[{"label":["geo_type"],"name":[1],"type":["chr"],"align":["left"]},{"label":["region"],"name":[2],"type":["chr"],"align":["left"]},{"label":["trans_type"],"name":[3],"type":["chr"],"align":["left"]},{"label":["sub_region"],"name":[4],"type":["chr"],"align":["left"]},{"label":["country"],"name":[5],"type":["chr"],"align":["left"]},{"label":["date"],"name":[6],"type":["date"],"align":["right"]},{"label":["dir_request"],"name":[7],"type":["dbl"],"align":["right"]}],"data":[{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-13","7":"100.00"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-14","7":"103.68"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-15","7":"104.45"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-16","7":"108.72"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-17","7":"132.80"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-18","7":"113.44"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-19","7":"87.48"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-20","7":"100.24"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-21","7":"101.30"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-22","7":"100.51"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-23","7":"104.47"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-24","7":"121.92"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-25","7":"118.55"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-26","7":"85.17"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-27","7":"93.81"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-28","7":"97.36"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-29","7":"98.96"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-30","7":"103.79"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-31","7":"124.37"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-01","7":"122.53"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-02","7":"85.96"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-03","7":"94.62"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-04","7":"97.39"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-05","7":"102.86"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-06","7":"103.66"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-07","7":"117.63"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-08","7":"124.27"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-09","7":"88.41"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-10","7":"98.78"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-11","7":"105.64"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-12","7":"108.54"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-13","7":"115.99"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-14","7":"147.32"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-15","7":"141.24"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-16","7":"111.31"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-17","7":"111.07"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-18","7":"104.69"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-19","7":"105.82"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-20","7":"110.84"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-21","7":"132.55"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-22","7":"138.50"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-23","7":"100.83"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-24","7":"99.41"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-25","7":"100.35"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-26","7":"103.39"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-27","7":"114.33"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-28","7":"139.02"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-29","7":"142.31"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-01","7":"105.39"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-02","7":"105.25"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-03","7":"108.28"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-04","7":"110.71"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-05","7":"116.43"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-06","7":"137.62"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-07","7":"144.91"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-08","7":"107.11"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-09","7":"105.68"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-10","7":"109.76"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-11","7":"107.34"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-12","7":"105.61"}],"options":{"columns":{"min":{},"max":[10]},"rows":{"min":[10],"max":[10]},"pages":{}}} </script> </div> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Highlighting Peak Driving Create a dataset with only the maximum direction request values for `"driving"` per `region`. ```r TopUSCities %>% filter(trans_type == "driving") %>% group_by(region) %>% slice_max(dir_request) %>% ungroup() -> MaxUSCitiesDriving ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## View `MaxUSCitiesDriving` ```r MaxUSCitiesDriving ``` <br> <div data-pagedtable="false"> <script data-pagedtable-source type="application/json"> {"columns":[{"label":["geo_type"],"name":[1],"type":["chr"],"align":["left"]},{"label":["region"],"name":[2],"type":["chr"],"align":["left"]},{"label":["trans_type"],"name":[3],"type":["chr"],"align":["left"]},{"label":["sub_region"],"name":[4],"type":["chr"],"align":["left"]},{"label":["country"],"name":[5],"type":["chr"],"align":["left"]},{"label":["date"],"name":[6],"type":["date"],"align":["right"]},{"label":["dir_request"],"name":[7],"type":["dbl"],"align":["right"]}],"data":[{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-07-17","7":"166.11"},{"1":"city","2":"Houston","3":"driving","4":"Texas","5":"United States","6":"2020-02-14","7":"146.20"},{"1":"city","2":"Los Angeles","3":"driving","4":"California","5":"United States","6":"2020-02-14","7":"152.08"},{"1":"city","2":"New York City","3":"driving","4":"New York","5":"United States","6":"2020-09-04","7":"152.09"},{"1":"city","2":"Phoenix","3":"driving","4":"Arizona","5":"United States","6":"2020-02-29","7":"142.68"}],"options":{"columns":{"min":{},"max":[10]},"rows":{"min":[10],"max":[10]},"pages":{}}} </script> </div> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Create graph labels <br> We know we want to see the max direction requests labeled, so we will update the labels for the graph. ```r lab_line_max_drivers <- labs( x = "Date", y = "Direction Requests", title = "Peak Driving Direction Requests in Largest US Cities", subtitle = paste0(min(TopUSCities$date), " through ", max(TopUSCities$date)), caption = "source: https://covid19.apple.com/mobility", color = "Transit Type") ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Create Value Labels We will also use `paste0()` here to create a variable for the labels that combines the city and date. ```r MaxUSCitiesDriving <- MaxUSCitiesDriving %>% mutate(max_driving_labels = paste0(region, ", ", date)) ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### View Value Labels Take a look at the labels we've created ```r MaxUSCitiesDriving %>% select(max_driving_labels) ``` <div data-pagedtable="false"> <script data-pagedtable-source type="application/json"> {"columns":[{"label":["max_driving_labels"],"name":[1],"type":["chr"],"align":["left"]}],"data":[{"1":"Chicago, 2020-07-17"},{"1":"Houston, 2020-02-14"},{"1":"Los Angeles, 2020-02-14"},{"1":"New York City, 2020-09-04"},{"1":"Phoenix, 2020-02-29"}],"options":{"columns":{"min":{},"max":[10]},"rows":{"min":[10],"max":[10]},"pages":{}}} </script> </div> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Create Line Layer + Label Layer ```r library(ggrepel) TopUSCities %>% ggplot() + geom_line(aes(x = date, y = dir_request, group = trans_type, color = trans_type), # make these slightly smaller again... size = 0.15) + geom_label_repel(data = MaxUSCitiesDriving, aes(x = date, y = dir_request, label = max_driving_labels), # set color and size... color = "red", size = 3) + lab_line_max_drivers ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### View plot with labels <img src="img/plot-with-labels-no-show-1.png" width="100%" height="100%" style="display: block; margin: auto;" /> --- class: inverse, center, top background-image: url(img/ggplot2.png) background-position: 50% 70% background-size: 35% # Adding Reference Lines --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Reference Line Data ```r TopUSCities ``` <div data-pagedtable="false"> <script data-pagedtable-source type="application/json"> {"columns":[{"label":["geo_type"],"name":[1],"type":["chr"],"align":["left"]},{"label":["region"],"name":[2],"type":["chr"],"align":["left"]},{"label":["trans_type"],"name":[3],"type":["chr"],"align":["left"]},{"label":["sub_region"],"name":[4],"type":["chr"],"align":["left"]},{"label":["country"],"name":[5],"type":["chr"],"align":["left"]},{"label":["date"],"name":[6],"type":["date"],"align":["right"]},{"label":["dir_request"],"name":[7],"type":["dbl"],"align":["right"]}],"data":[{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-13","7":"100.00"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-14","7":"103.68"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-15","7":"104.45"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-16","7":"108.72"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-17","7":"132.80"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-18","7":"113.44"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-19","7":"87.48"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-20","7":"100.24"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-21","7":"101.30"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-22","7":"100.51"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-23","7":"104.47"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-24","7":"121.92"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-25","7":"118.55"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-26","7":"85.17"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-27","7":"93.81"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-28","7":"97.36"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-29","7":"98.96"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-30","7":"103.79"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-01-31","7":"124.37"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-01","7":"122.53"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-02","7":"85.96"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-03","7":"94.62"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-04","7":"97.39"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-05","7":"102.86"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-06","7":"103.66"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-07","7":"117.63"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-08","7":"124.27"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-09","7":"88.41"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-10","7":"98.78"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-11","7":"105.64"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-12","7":"108.54"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-13","7":"115.99"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-14","7":"147.32"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-15","7":"141.24"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-16","7":"111.31"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-17","7":"111.07"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-18","7":"104.69"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-19","7":"105.82"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-20","7":"110.84"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-21","7":"132.55"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-22","7":"138.50"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-23","7":"100.83"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-24","7":"99.41"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-25","7":"100.35"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-26","7":"103.39"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-27","7":"114.33"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-28","7":"139.02"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-02-29","7":"142.31"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-01","7":"105.39"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-02","7":"105.25"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-03","7":"108.28"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-04","7":"110.71"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-05","7":"116.43"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-06","7":"137.62"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-07","7":"144.91"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-08","7":"107.11"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-09","7":"105.68"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-10","7":"109.76"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-11","7":"107.34"},{"1":"city","2":"Chicago","3":"driving","4":"Illinois","5":"United States","6":"2020-03-12","7":"105.61"}],"options":{"columns":{"min":{},"max":[10]},"rows":{"min":[10],"max":[10]},"pages":{}}} </script> </div> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Reference Line Labels ```r labs(x = "Date", y = "Direction Requests", title = "Trends of Relative Activity in Selected US Cities", subtitle = "New York, Los Angeles, Chicago, Houston, Phoenix", color = "Type") -> lab_ref_lines ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Horizontal Reference Lines Add the `geom_hline()` for a horizontal reference line (at `100`) ```r TopUSCities %>% ggplot(aes(x = date, y = dir_request, group = trans_type, color = trans_type)) + geom_line(size = 0.1) + geom_hline(yintercept = 100, size = 0.2, color = "gray20") + lab_ref_lines ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Horizontal Reference Lines <img src="img/geom_hline-show-1.png" width="95%" height="95%" style="display: block; margin: auto;" /> --- class: inverse, center, top background-image: url(img/ggplot2.png) background-position: 50% 70% background-size: 35% # Advanced Facetting --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Faceting basics Facets create subplots across levels of a categorical variable. ```r TopUSCities %>% ggplot(aes(x = date, y = dir_request, group = trans_type, color = trans_type)) + geom_line(size = 0.1) + geom_hline(yintercept = 100, size = 0.2, color = "gray20") + * facet_wrap(~ region, ncol = 2) + lab_ref_lines ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Single Variable Facets <img src="img/facet_wrap-show-1.png" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Multiple Variable Facets ```r TopUSCities %>% ggplot(aes(x = date, y = dir_request, group = region, color = trans_type)) + geom_line(size = 0.1) + geom_hline(yintercept = 100, size = 0.2, color = "gray20") + * facet_wrap(region ~ trans_type, ncol = 5) + lab_ref_lines ``` --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ## Multiple Variable Facets <img src="img/facet_wrap-2vars-2-1.png" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Advanced Faceting (`facet_wrap_paginate`) Check out the exercises for more advanced faceting with `facet_wrap_paginate()` from the `ggforce` package. <img src="img/facet_wrap_paginate-sol-1.png" width="576" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% ### Advanced Faceting (`facet_geo`) Check out the exercises for more advanced faceting with `facet_geo()` from the `geofacet` package. <img src="img/facet_geo-sol-1.png" width="576" style="display: block; margin: auto;" /> --- class: left, top background-image: url(img/ggplot2.png) background-position: 95% 8% background-size: 8% # More Resources ### [Fundamentals of Data Visualization](https://clauswilke.com/dataviz/) ### [ggplot2 extensions gallery](https://exts.ggplot2.tidyverse.org/gallery/) ### [R Graphics Cookbook](https://r-graphics.org/)