library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.2.0 ✔ readr 2.2.0
## ✔ forcats 1.0.1 ✔ stringr 1.6.0
## ✔ ggplot2 4.0.2 ✔ tibble 3.3.1
## ✔ lubridate 1.9.5 ✔ tidyr 1.3.2
## ✔ purrr 1.2.1
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
library(rvest)
##
## Attaching package: 'rvest'
##
## The following object is masked from 'package:readr':
##
## guess_encoding
library(ggplot2)
library(dplyr)
library(sf)
## Linking to GEOS 3.13.0, GDAL 3.8.5, PROJ 9.5.1; sf_use_s2() is TRUE
library(tmap)
library(leaflet)
library(maps)
##
## Attaching package: 'maps'
##
## The following object is masked from 'package:purrr':
##
## map
library(ggmap)
## ℹ Google's Terms of Service: <https://mapsplatform.google.com>
## Stadia Maps' Terms of Service: <https://stadiamaps.com/terms-of-service>
## OpenStreetMap's Tile Usage Policy: <https://operations.osmfoundation.org/policies/tiles>
## ℹ Please cite ggmap if you use it! Use `citation("ggmap")` for details.
library(mapview)
library(tidygeocoder)
##
## Attaching package: 'tidygeocoder'
##
## The following object is masked from 'package:ggmap':
##
## geocode
# scraping the janet tour data
url <- "https://reference.org/facts/Janet_World_Tour/5Gs5dLpv#tour-dates"
html_code <- read_html(url)
janet_tour_html <- html_code %>% html_nodes("table") %>% .[[1]]
janet_tour_df <- janet_tour_html %>% html_table()
head(janet_tour_df)
## # A tibble: 6 × 4
## Date City Country Venue
## <chr> <chr> <chr> <chr>
## 1 North America36 North America36 North America36 North America36
## 2 November 24, 1993 Cincinnati United States Riverfront Coliseum
## 3 November 26, 1993 Toronto Canada SkyDome
## 4 November 28, 1993 Landover United States USAir Arena
## 5 November 29, 1993 Landover United States USAir Arena
## 6 December 1, 1993 Rosemont United States Rosemont Horizon
#checking data and removing first row
head(janet_tour_df)
## # A tibble: 6 × 4
## Date City Country Venue
## <chr> <chr> <chr> <chr>
## 1 North America36 North America36 North America36 North America36
## 2 November 24, 1993 Cincinnati United States Riverfront Coliseum
## 3 November 26, 1993 Toronto Canada SkyDome
## 4 November 28, 1993 Landover United States USAir Arena
## 5 November 29, 1993 Landover United States USAir Arena
## 6 December 1, 1993 Rosemont United States Rosemont Horizon
janet_tour_df <- janet_tour_df [-1,]
library(janitor)
##
## Attaching package: 'janitor'
## The following objects are masked from 'package:stats':
##
## chisq.test, fisher.test
#adding in location column merging city and state
janet_tour_df$location<- paste(janet_tour_df$City,
janet_tour_df$Country,
sep=", ")
janet_tour_df
## # A tibble: 130 × 5
## Date City Country Venue location
## <chr> <chr> <chr> <chr> <chr>
## 1 November 24, 1993 Cincinnati United States Riverfront Coliseum Cincinna…
## 2 November 26, 1993 Toronto Canada SkyDome Toronto,…
## 3 November 28, 1993 Landover United States USAir Arena Landover…
## 4 November 29, 1993 Landover United States USAir Arena Landover…
## 5 December 1, 1993 Rosemont United States Rosemont Horizon Rosemont…
## 6 December 2, 1993 Minneapolis United States Target Center Minneapo…
## 7 December 4, 1993 Detroit United States Joe Louis Arena Detroit,…
## 8 December 17, 1993 New York City United States Madison Square Garden New York…
## 9 December 18, 1993 New York City United States Madison Square Garden New York…
## 10 December 22, 1993 New York City United States Madison Square Garden New York…
## # ℹ 120 more rows
#grabbing geocode data using world citis data
data("world.cities")
tour_cities <- janet_tour_df$location
#merging data sets
tour_cities_data<- merge(janet_tour_df, world.cities, by.x="City", by.y="name", all.x=TRUE)
tour_cities_data
## City Date Country
## 1 Adelaide February 21, 1995 Australia
## 2 Adelaide February 21, 1995 Australia
## 3 Albany January 24, 1994 United States
## 4 Albany January 24, 1994 United States
## 5 Albany January 24, 1994 United States
## 6 Albany January 24, 1994 United States
## 7 Albuquerque April 22, 1994 United States
## 8 Asia Asia Asia
## 9 Asia Asia Asia
## 10 Atlanta January 6, 1994 United States
## 11 Atlanta July 31, 1994 United States
## 12 Atlanta January 5, 1994 United States
## 13 Australia Australia Australia
## 14 Bangkok March 6, 1995 Thailand
## 15 Bangkok March 5, 1995 Thailand
## 16 Barcelona March 26, 1995 Spain
## 17 Barcelona March 26, 1995 Spain
## 18 Berlin March 14, 1995 Germany
## 19 Berlin March 14, 1995 Germany
## 20 Berlin March 14, 1995 Germany
## 21 Birmingham April 7, 1995 England
## 22 Birmingham April 7, 1995 England
## 23 Birmingham January 12, 1994 United States
## 24 Birmingham January 12, 1994 United States
## 25 Bonner Springs July 8, 1994 United States
## 26 Brisbane February 7, 1995 Australia
## 27 Brisbane February 6, 1995 Australia
## 28 Burgettstown June 23, 1994 United States
## 29 Charlotte January 9, 1994 United States
## 30 Cincinnati November 24, 1993 United States
## 31 Cincinnati July 21, 1994 United States
## 32 Clarkston July 18, 1994 United States
## 33 Columbia June 11, 1994 United States
## 34 Columbia June 11, 1994 United States
## 35 Columbia June 11, 1994 United States
## 36 Columbia June 10, 1994 United States
## 37 Columbia June 10, 1994 United States
## 38 Columbia June 10, 1994 United States
## 39 Columbus July 24, 1994 United States
## 40 Columbus July 24, 1994 United States
## 41 Columbus July 24, 1994 United States
## 42 Copenhagen March 9, 1995 Denmark
## 43 Cuyahoga Falls April 20, 1994 United States
## 44 Dallas August 3, 1994 United States
## 45 Dallas August 3, 1994 United States
## 46 Denver April 24, 1994 United States
## 47 Detroit December 4, 1993 United States
## 48 Dortmund April 15, 1995 Germany
## 49 Europe Europe Europe
## 50 Fairborn February 4, 1994 United States
## 51 Frankfurt April 13, 1995 Germany
## 52 Frankfurt April 13, 1995 Germany
## 53 George August 14, 1994 United States
## 54 Ghent April 16, 1995 Belgium
## 55 Greenwood Village August 5, 1994 United States
## 56 Hamburg March 16, 1995 Germany
## 57 Hartford December 30, 1993 United States
## 58 Hershey July 3, 1994 United States
## 59 Hoffman Estates July 12, 1994 United States
## 60 Hoffman Estates July 13, 1994 United States
## 61 Holmdel Township June 30, 1994 United States
## 62 Indianapolis February 3, 1994 United States
## 63 Inglewood April 8, 1994 United States
## 64 Inglewood April 8, 1994 United States
## 65 Inglewood April 9, 1994 United States
## 66 Inglewood April 9, 1994 United States
## 67 Inglewood April 7, 1994 United States
## 68 Inglewood April 7, 1994 United States
## 69 Irvine August 9, 1994 United States
## 70 Irvine August 9, 1994 United States
## 71 Kallang February 27, 1995 Singapore
## 72 Kallang February 28, 1995 Singapore
## 73 Knoxville January 16, 1994 United States
## 74 Landover November 28, 1993 United States
## 75 Landover November 29, 1993 United States
## 76 Las Cruces April 23, 1994 United States
## 77 Las Vegas April 16, 1994 United States
## 78 Las Vegas April 16, 1994 United States
## 79 Las Vegas April 16, 1994 United States
## 80 London April 8, 1995 England
## 81 London April 8, 1995 England
## 82 London April 8, 1995 England
## 83 London April 19, 1995 England
## 84 London April 19, 1995 England
## 85 London April 19, 1995 England
## 86 London April 20, 1995 England
## 87 London April 20, 1995 England
## 88 London April 20, 1995 England
## 89 London April 22, 1995 England
## 90 London April 22, 1995 England
## 91 London April 22, 1995 England
## 92 Manila March 3, 1995 Philippines
## 93 Mansfield June 18, 1994 United States
## 94 Mansfield June 18, 1994 United States
## 95 Marseille March 29, 1995 France
## 96 Maryland Heights July 9, 1994 United States
## 97 Melbourne February 17, 1995 Australia
## 98 Melbourne February 17, 1995 Australia
## 99 Melbourne February 18, 1995 Australia
## 100 Melbourne February 18, 1995 Australia
## 101 Melbourne February 20, 1995 Australia
## 102 Melbourne February 20, 1995 Australia
## 103 Miami January 20, 1994 United States
## 104 Milwaukee July 5, 199441 United States
## 105 Milwaukee February 7, 1994 United States
## 106 Minneapolis December 2, 1993 United States
## 107 Moline July 6, 1994 United States
## 108 Mountain View August 12, 1994 United States
## 109 Munich April 1, 1995 Germany
## 110 New Orleans August 1, 1994 United States
## 111 New York City December 31, 199337 United States
## 112 New York City December 17, 1993 United States
## 113 New York City December 18, 1993 United States
## 114 New York City December 22, 1993 United States
## 115 New York City December 23, 1993 United States
## 116 New York City July 27, 1994 United States
## 117 New York City July 26, 1994 United States
## 118 Noblesville July 23, 1994 United States
## 119 North America38 North America38 North America38
## 120 Oakland February 18, 1994 United States
## 121 Orlando January 18, 1994 United States
## 122 Osaka March 27, 1994 Japan
## 123 Oslo March 8, 1995 Norway
## 124 Paris April 10, 1995 France
## 125 Paris April 10, 1995 France
## 126 Peoria February 6, 1994 United States
## 127 Peoria February 6, 1994 United States
## 128 Perth February 23, 1995 Australia
## 129 Perth February 23, 1995 Australia
## 130 Perth February 23, 1995 Australia
## 131 Philadelphia January 31, 1994 United States
## 132 Philadelphia June 24, 1994 United States
## 133 Phoenix April 17, 1994 United States
## 134 Providence December 28, 1993 United States
## 135 Providence December 28, 1993 United States
## 136 Raleigh July 29, 1994 United States
## 137 Richfield January 3, 1994 United States
## 138 Richfield July 19, 1994 United States
## 139 Richmond January 14, 1994 United States
## 140 Richmond January 14, 1994 United States
## 141 Richmond January 14, 1994 United States
## 142 Richmond January 14, 1994 United States
## 143 Richmond January 14, 1994 United States
## 144 Richmond January 14, 1994 United States
## 145 Richmond January 14, 1994 United States
## 146 Rosemont December 1, 1993 United States
## 147 Rotterdam March 22, 1995 Netherlands
## 148 Rotterdam March 21, 1995 Netherlands
## 149 Sacramento February 17, 1994 United States
## 150 Salt Lake City April 26, 199439 United States
## 151 Salt Lake City April 27, 199440 United States
## 152 San Bernardino August 10, 1994 United States
## 153 San Bernardino August 10, 1994 United States
## 154 San Bernardino August 10, 1994 United States
## 155 San Diego February 24, 1994 United States
## 156 San Diego February 24, 1994 United States
## 157 San Diego February 24, 1994 United States
## 158 San Diego February 24, 1994 United States
## 159 San Diego February 24, 1994 United States
## 160 San Jose February 16, 1994 United States
## 161 San Jose February 16, 1994 United States
## 162 San Jose February 16, 1994 United States
## 163 San Jose February 16, 1994 United States
## 164 San Jose February 16, 1994 United States
## 165 San Jose February 16, 1994 United States
## 166 San Jose February 16, 1994 United States
## 167 San Jose February 16, 1994 United States
## 168 San Jose February 16, 1994 United States
## 169 San Jose February 16, 1994 United States
## 170 San Jose February 16, 1994 United States
## 171 San Jose February 16, 1994 United States
## 172 San Jose February 16, 1994 United States
## 173 San Jose February 16, 1994 United States
## 174 San Jose February 16, 1994 United States
## 175 San Jose February 16, 1994 United States
## 176 San Jose February 16, 1994 United States
## 177 San Jose February 16, 1994 United States
## 178 San Jose February 16, 1994 United States
## 179 San Jose February 16, 1994 United States
## 180 San Jose February 16, 1994 United States
## 181 San Jose February 16, 1994 United States
## 182 San Jose February 16, 1994 United States
## 183 San Jose February 16, 1994 United States
## 184 San Jose April 14, 1994 United States
## 185 San Jose April 14, 1994 United States
## 186 San Jose April 14, 1994 United States
## 187 San Jose April 14, 1994 United States
## 188 San Jose April 14, 1994 United States
## 189 San Jose April 14, 1994 United States
## 190 San Jose April 14, 1994 United States
## 191 San Jose April 14, 1994 United States
## 192 San Jose April 14, 1994 United States
## 193 San Jose April 14, 1994 United States
## 194 San Jose April 14, 1994 United States
## 195 San Jose April 14, 1994 United States
## 196 San Jose April 14, 1994 United States
## 197 San Jose April 14, 1994 United States
## 198 San Jose April 14, 1994 United States
## 199 San Jose April 14, 1994 United States
## 200 San Jose April 14, 1994 United States
## 201 San Jose April 14, 1994 United States
## 202 San Jose April 14, 1994 United States
## 203 San Jose April 14, 1994 United States
## 204 San Jose April 14, 1994 United States
## 205 San Jose April 14, 1994 United States
## 206 San Jose April 14, 1994 United States
## 207 San Jose April 14, 1994 United States
## 208 Saratoga Springs June 21, 1994 United States
## 209 Sasebo March 25, 1994 Japan
## 210 Sheffield April 4, 1995 England
## 211 St. Petersburg January 22, 1994 United States
## 212 Stockholm March 11, 1995 Sweden
## 213 Stuttgart April 11, 1995 Germany
## 214 Sydney February 15, 1995 Australia
## 215 Sydney February 15, 1995 Australia
## 216 Sydney February 11, 1995 Australia
## 217 Sydney February 11, 1995 Australia
## 218 Sydney February 10, 1995 Australia
## 219 Sydney February 10, 1995 Australia
## 220 Sydney February 12, 1995 Australia
## 221 Sydney February 12, 1995 Australia
## 222 Tacoma February 12, 1994 United States
## 223 The Woodlands August 2, 1994 United States
## 224 Tokyo March 29, 1994 Japan
## 225 Tokyo March 30, 1994 Japan
## 226 Toronto November 26, 1993 Canada
## 227 Toulouse March 25, 1995 France
## 228 Vaughan June 13, 1994 Canada
## 229 Wantagh June 26, 1994 United States
## 230 Wantagh June 27, 1994 United States
## 231 Worcester January 30, 1994 United States
## 232 Worcester January 30, 1994 United States
## 233 Worcester January 30, 1994 United States
## 234 Zürich March 31, 1995 Switzerland
## Venue location
## 1 Adelaide Entertainment Centre Adelaide, Australia
## 2 Adelaide Entertainment Centre Adelaide, Australia
## 3 Knickerbocker Arena Albany, United States
## 4 Knickerbocker Arena Albany, United States
## 5 Knickerbocker Arena Albany, United States
## 6 Knickerbocker Arena Albany, United States
## 7 Tingley Coliseum Albuquerque, United States
## 8 Asia Asia, Asia
## 9 Asia Asia, Asia
## 10 Omni Coliseum Atlanta, United States
## 11 Coca-Cola Lakewood Amphitheatre Atlanta, United States
## 12 Omni Coliseum Atlanta, United States
## 13 Australia Australia, Australia
## 14 Indoor Stadium Huamark Bangkok, Thailand
## 15 Indoor Stadium Huamark Bangkok, Thailand
## 16 Palau Sant Jordi Barcelona, Spain
## 17 Palau Sant Jordi Barcelona, Spain
## 18 Arena Berlin Berlin, Germany
## 19 Arena Berlin Berlin, Germany
## 20 Arena Berlin Berlin, Germany
## 21 NEC Arena Birmingham, England
## 22 NEC Arena Birmingham, England
## 23 BJCC Coliseum Birmingham, United States
## 24 BJCC Coliseum Birmingham, United States
## 25 Sandstone Amphitheater Bonner Springs, United States
## 26 Brisbane Entertainment Centre Brisbane, Australia
## 27 Brisbane Entertainment Centre Brisbane, Australia
## 28 Coca-Cola Star Lake Amphitheater Burgettstown, United States
## 29 Charlotte Coliseum Charlotte, United States
## 30 Riverfront Coliseum Cincinnati, United States
## 31 Riverbend Music Center Cincinnati, United States
## 32 Pine Knob Music Theatre Clarkston, United States
## 33 Merriweather Post Pavilion Columbia, United States
## 34 Merriweather Post Pavilion Columbia, United States
## 35 Merriweather Post Pavilion Columbia, United States
## 36 Merriweather Post Pavilion Columbia, United States
## 37 Merriweather Post Pavilion Columbia, United States
## 38 Merriweather Post Pavilion Columbia, United States
## 39 Polaris Amphitheater Columbus, United States
## 40 Polaris Amphitheater Columbus, United States
## 41 Polaris Amphitheater Columbus, United States
## 42 Forum Copenhagen Copenhagen, Denmark
## 43 Blossom Music Center Cuyahoga Falls, United States
## 44 Coca-Cola Starplex Amphitheatre Dallas, United States
## 45 Coca-Cola Starplex Amphitheatre Dallas, United States
## 46 McNichols Sports Arena Denver, United States
## 47 Joe Louis Arena Detroit, United States
## 48 Große Westfalenhalle Dortmund, Germany
## 49 Europe Europe, Europe
## 50 Nutter Center Fairborn, United States
## 51 Festhalle Frankfurt, Germany
## 52 Festhalle Frankfurt, Germany
## 53 The Gorge Amphitheatre George, United States
## 54 Flanders Expo Ghent, Belgium
## 55 Fiddler's Green Amphitheatre Greenwood Village, United States
## 56 Alsterdorfer Sporthalle Hamburg, Germany
## 57 Hartford Civic Center Hartford, United States
## 58 Hersheypark Stadium Hershey, United States
## 59 Poplar Creek Music Theater Hoffman Estates, United States
## 60 Poplar Creek Music Theater Hoffman Estates, United States
## 61 Garden State Arts Center Holmdel Township, United States
## 62 Market Square Arena Indianapolis, United States
## 63 Great Western Forum Inglewood, United States
## 64 Great Western Forum Inglewood, United States
## 65 Great Western Forum Inglewood, United States
## 66 Great Western Forum Inglewood, United States
## 67 Great Western Forum Inglewood, United States
## 68 Great Western Forum Inglewood, United States
## 69 Irvine Meadows Amphitheatre Irvine, United States
## 70 Irvine Meadows Amphitheatre Irvine, United States
## 71 Singapore Indoor Stadium Kallang, Singapore
## 72 Singapore Indoor Stadium Kallang, Singapore
## 73 Thompson–Boling Arena Knoxville, United States
## 74 USAir Arena Landover, United States
## 75 USAir Arena Landover, United States
## 76 Pan American Center Las Cruces, United States
## 77 MGM Grand Garden Special Events Center Las Vegas, United States
## 78 MGM Grand Garden Special Events Center Las Vegas, United States
## 79 MGM Grand Garden Special Events Center Las Vegas, United States
## 80 London Arena London, England
## 81 London Arena London, England
## 82 London Arena London, England
## 83 Wembley Arena London, England
## 84 Wembley Arena London, England
## 85 Wembley Arena London, England
## 86 Wembley Arena London, England
## 87 Wembley Arena London, England
## 88 Wembley Arena London, England
## 89 Wembley Arena London, England
## 90 Wembley Arena London, England
## 91 Wembley Arena London, England
## 92 Folk Arts Theater Manila, Philippines
## 93 Great Woods Center for the Performing Arts Mansfield, United States
## 94 Great Woods Center for the Performing Arts Mansfield, United States
## 95 Le Dôme de Marseille Marseille, France
## 96 Riverport Amphitheatre Maryland Heights, United States
## 97 National Tennis Centre Melbourne, Australia
## 98 National Tennis Centre Melbourne, Australia
## 99 National Tennis Centre Melbourne, Australia
## 100 National Tennis Centre Melbourne, Australia
## 101 National Tennis Centre Melbourne, Australia
## 102 National Tennis Centre Melbourne, Australia
## 103 Miami Arena Miami, United States
## 104 Marcus Amphitheater Milwaukee, United States
## 105 Bradley Center Milwaukee, United States
## 106 Target Center Minneapolis, United States
## 107 The MARK of the Quad Cities Moline, United States
## 108 Shoreline Amphitheatre Mountain View, United States
## 109 Olympiahalle Munich, Germany
## 110 Louisiana Superdome New Orleans, United States
## 111 Madison Square Garden New York City, United States
## 112 Madison Square Garden New York City, United States
## 113 Madison Square Garden New York City, United States
## 114 Madison Square Garden New York City, United States
## 115 Madison Square Garden New York City, United States
## 116 Radio City Music Hall New York City, United States
## 117 Radio City Music Hall New York City, United States
## 118 Deer Creek Music Center Noblesville, United States
## 119 North America38 North America38, North America38
## 120 Oakland–Alameda County Coliseum Arena Oakland, United States
## 121 Orlando Arena Orlando, United States
## 122 Osaka-jō Hall Osaka, Japan
## 123 Oslo Spektrum Oslo, Norway
## 124 Palais Omnisports de Paris-Bercy Paris, France
## 125 Palais Omnisports de Paris-Bercy Paris, France
## 126 Carver Arena Peoria, United States
## 127 Carver Arena Peoria, United States
## 128 Perth Entertainment Centre Perth, Australia
## 129 Perth Entertainment Centre Perth, Australia
## 130 Perth Entertainment Centre Perth, Australia
## 131 The Spectrum Philadelphia, United States
## 132 The Spectrum Philadelphia, United States
## 133 America West Arena Phoenix, United States
## 134 Providence Civic Center Providence, United States
## 135 Providence Civic Center Providence, United States
## 136 Hardee's Walnut Creek Amphitheatre Raleigh, United States
## 137 Richfield Coliseum Richfield, United States
## 138 Richfield Coliseum Richfield, United States
## 139 Richmond Coliseum Richmond, United States
## 140 Richmond Coliseum Richmond, United States
## 141 Richmond Coliseum Richmond, United States
## 142 Richmond Coliseum Richmond, United States
## 143 Richmond Coliseum Richmond, United States
## 144 Richmond Coliseum Richmond, United States
## 145 Richmond Coliseum Richmond, United States
## 146 Rosemont Horizon Rosemont, United States
## 147 Sportpaleis Rotterdam, Netherlands
## 148 Sportpaleis Rotterdam, Netherlands
## 149 ARCO Arena Sacramento, United States
## 150 Delta Center Salt Lake City, United States
## 151 Delta Center Salt Lake City, United States
## 152 Blockbuster Pavilion San Bernardino, United States
## 153 Blockbuster Pavilion San Bernardino, United States
## 154 Blockbuster Pavilion San Bernardino, United States
## 155 San Diego Sports Arena San Diego, United States
## 156 San Diego Sports Arena San Diego, United States
## 157 San Diego Sports Arena San Diego, United States
## 158 San Diego Sports Arena San Diego, United States
## 159 San Diego Sports Arena San Diego, United States
## 160 San Jose Arena San Jose, United States
## 161 San Jose Arena San Jose, United States
## 162 San Jose Arena San Jose, United States
## 163 San Jose Arena San Jose, United States
## 164 San Jose Arena San Jose, United States
## 165 San Jose Arena San Jose, United States
## 166 San Jose Arena San Jose, United States
## 167 San Jose Arena San Jose, United States
## 168 San Jose Arena San Jose, United States
## 169 San Jose Arena San Jose, United States
## 170 San Jose Arena San Jose, United States
## 171 San Jose Arena San Jose, United States
## 172 San Jose Arena San Jose, United States
## 173 San Jose Arena San Jose, United States
## 174 San Jose Arena San Jose, United States
## 175 San Jose Arena San Jose, United States
## 176 San Jose Arena San Jose, United States
## 177 San Jose Arena San Jose, United States
## 178 San Jose Arena San Jose, United States
## 179 San Jose Arena San Jose, United States
## 180 San Jose Arena San Jose, United States
## 181 San Jose Arena San Jose, United States
## 182 San Jose Arena San Jose, United States
## 183 San Jose Arena San Jose, United States
## 184 San Jose Arena San Jose, United States
## 185 San Jose Arena San Jose, United States
## 186 San Jose Arena San Jose, United States
## 187 San Jose Arena San Jose, United States
## 188 San Jose Arena San Jose, United States
## 189 San Jose Arena San Jose, United States
## 190 San Jose Arena San Jose, United States
## 191 San Jose Arena San Jose, United States
## 192 San Jose Arena San Jose, United States
## 193 San Jose Arena San Jose, United States
## 194 San Jose Arena San Jose, United States
## 195 San Jose Arena San Jose, United States
## 196 San Jose Arena San Jose, United States
## 197 San Jose Arena San Jose, United States
## 198 San Jose Arena San Jose, United States
## 199 San Jose Arena San Jose, United States
## 200 San Jose Arena San Jose, United States
## 201 San Jose Arena San Jose, United States
## 202 San Jose Arena San Jose, United States
## 203 San Jose Arena San Jose, United States
## 204 San Jose Arena San Jose, United States
## 205 San Jose Arena San Jose, United States
## 206 San Jose Arena San Jose, United States
## 207 San Jose Arena San Jose, United States
## 208 Saratoga Performing Arts Center Saratoga Springs, United States
## 209 Huis Ten Bosch Sasebo, Japan
## 210 Sheffield Arena Sheffield, England
## 211 ThunderDome St. Petersburg, United States
## 212 Stockholm Globe Arena Stockholm, Sweden
## 213 Hanns-Martin-Schleyer-Halle Stuttgart, Germany
## 214 Sydney Entertainment Centre Sydney, Australia
## 215 Sydney Entertainment Centre Sydney, Australia
## 216 Sydney Entertainment Centre Sydney, Australia
## 217 Sydney Entertainment Centre Sydney, Australia
## 218 Sydney Entertainment Centre Sydney, Australia
## 219 Sydney Entertainment Centre Sydney, Australia
## 220 Sydney Entertainment Centre Sydney, Australia
## 221 Sydney Entertainment Centre Sydney, Australia
## 222 Tacoma Dome Tacoma, United States
## 223 Cynthia Woods Mitchell Pavilion The Woodlands, United States
## 224 Tokyo Dome Tokyo, Japan
## 225 Tokyo Dome Tokyo, Japan
## 226 SkyDome Toronto, Canada
## 227 Palais des Sports Toulouse, France
## 228 Kingswood Music Theatre Vaughan, Canada
## 229 Jones Beach Amphitheater Wantagh, United States
## 230 Jones Beach Amphitheater Wantagh, United States
## 231 Worcester Centrum Worcester, United States
## 232 Worcester Centrum Worcester, United States
## 233 Worcester Centrum Worcester, United States
## 234 Hallenstadion Zürich, Switzerland
## country.etc pop lat long capital
## 1 Australia 1076969 -34.93 138.60 0
## 2 South Africa 12222 -32.70 26.29 0
## 3 USA 45535 44.62 -123.09 0
## 4 USA 75510 31.58 -84.18 0
## 5 USA 93576 42.67 -73.80 0
## 6 Australia 24338 -35.02 117.88 0
## 7 USA 494962 35.12 -106.62 0
## 8 Philippines 23787 9.55 122.52 0
## 9 Philippines 23787 9.55 122.52 0
## 10 USA 424096 33.76 -84.42 0
## 11 USA 424096 33.76 -84.42 0
## 12 USA 424096 33.76 -84.42 0
## 13 <NA> NA NA NA NA
## 14 Thailand 4935988 13.73 100.50 1
## 15 Thailand 4935988 13.73 100.50 1
## 16 Spain 1591485 41.40 2.17 0
## 17 Venezuela 441639 10.13 -64.72 0
## 18 El Salvador 11492 13.50 -88.53 0
## 19 Germany 3378275 52.52 13.38 1
## 20 Honduras 1058 14.83 -88.50 0
## 21 USA 229300 33.53 -86.80 0
## 22 UK 986969 52.48 -1.91 0
## 23 USA 229300 33.53 -86.80 0
## 24 UK 986969 52.48 -1.91 0
## 25 <NA> NA NA NA NA
## 26 Australia 1891999 -27.46 153.02 0
## 27 Australia 1891999 -27.46 153.02 0
## 28 <NA> NA NA NA NA
## 29 USA 607111 35.20 -80.83 0
## 30 USA 301561 39.14 -84.51 0
## 31 USA 301561 39.14 -84.51 0
## 32 <NA> NA NA NA NA
## 33 USA 92756 38.95 -92.33 0
## 34 USA 118020 34.04 -80.89 0
## 35 USA 97772 39.20 -76.86 0
## 36 USA 92756 38.95 -92.33 0
## 37 USA 118020 34.04 -80.89 0
## 38 USA 97772 39.20 -76.86 0
## 39 USA 184900 32.51 -84.87 0
## 40 USA 39453 39.21 -85.91 0
## 41 USA 741677 39.99 -82.99 0
## 42 Denmark 1091978 55.68 12.57 1
## 43 USA 52223 41.17 -81.52 0
## 44 Canada 4366 50.66 -120.46 0
## 45 USA 1216543 32.79 -96.77 0
## 46 USA 556575 39.77 -104.87 0
## 47 USA 871789 42.38 -83.10 0
## 48 Germany 587233 51.51 7.48 0
## 49 <NA> NA NA NA NA
## 50 <NA> NA NA NA NA
## 51 Germany 642811 50.12 8.68 0
## 52 Germany 64389 52.34 14.53 0
## 53 South Africa 185562 -33.95 22.45 0
## 54 <NA> NA NA NA NA
## 55 <NA> NA NA NA NA
## 56 Germany 1743891 53.55 10.00 0
## 57 USA 123836 41.77 -72.68 0
## 58 <NA> NA NA NA NA
## 59 USA 50674 42.06 -88.14 0
## 60 USA 50674 42.06 -88.14 0
## 61 <NA> NA NA NA NA
## 62 USA 771725 39.78 -86.15 0
## 63 New Zealand 2850 -39.16 174.25 0
## 64 USA 116797 33.96 -118.34 0
## 65 New Zealand 2850 -39.16 174.25 0
## 66 USA 116797 33.96 -118.34 0
## 67 New Zealand 2850 -39.16 174.25 0
## 68 USA 116797 33.96 -118.34 0
## 69 UK 32742 55.62 -4.69 0
## 70 USA 199755 33.66 -117.80 0
## 71 <NA> NA NA NA NA
## 72 <NA> NA NA NA NA
## 73 USA 172000 35.97 -83.95 0
## 74 <NA> NA NA NA NA
## 75 <NA> NA NA NA NA
## 76 USA 81473 32.34 -106.76 0
## 77 Honduras 7544 14.87 -88.07 0
## 78 USA 553807 36.21 -115.22 0
## 79 Honduras 1329 15.02 -87.45 0
## 80 Canada 348681 42.97 -81.24 0
## 81 Kiribati 698 1.99 157.78 0
## 82 UK 7489022 51.52 -0.10 1
## 83 Canada 348681 42.97 -81.24 0
## 84 Kiribati 698 1.99 157.78 0
## 85 UK 7489022 51.52 -0.10 1
## 86 Canada 348681 42.97 -81.24 0
## 87 Kiribati 698 1.99 157.78 0
## 88 UK 7489022 51.52 -0.10 1
## 89 Canada 348681 42.97 -81.24 0
## 90 Kiribati 698 1.99 157.78 0
## 91 UK 7489022 51.52 -0.10 1
## 92 Philippines 10546511 14.62 120.97 1
## 93 UK 70486 53.15 -1.21 0
## 94 USA 50010 40.76 -82.53 0
## 95 France 793352 43.31 5.37 0
## 96 <NA> NA NA NA NA
## 97 USA 77320 28.11 -80.64 0
## 98 Australia 3780871 -37.81 144.96 0
## 99 USA 77320 28.11 -80.64 0
## 100 Australia 3780871 -37.81 144.96 0
## 101 USA 77320 28.11 -80.64 0
## 102 Australia 3780871 -37.81 144.96 0
## 103 USA 386740 25.78 -80.21 0
## 104 USA 575250 43.06 -87.97 0
## 105 USA 575250 43.06 -87.97 0
## 106 USA 364726 44.96 -93.27 0
## 107 USA 42427 41.49 -90.49 0
## 108 USA 67788 37.40 -122.08 0
## 109 Germany 1272179 48.14 11.58 0
## 110 USA 454207 30.07 -89.93 0
## 111 <NA> NA NA NA NA
## 112 <NA> NA NA NA NA
## 113 <NA> NA NA NA NA
## 114 <NA> NA NA NA NA
## 115 <NA> NA NA NA NA
## 116 <NA> NA NA NA NA
## 117 <NA> NA NA NA NA
## 118 <NA> NA NA NA NA
## 119 <NA> NA NA NA NA
## 120 USA 393632 37.77 -122.22 0
## 121 USA 211226 28.50 -81.37 0
## 122 Japan 2590815 34.68 135.50 0
## 123 Norway 821445 59.91 10.75 1
## 124 Canada 10570 43.20 -80.38 0
## 125 France 2141839 48.86 2.34 1
## 126 USA 146634 33.69 -112.24 0
## 127 USA 112894 40.74 -89.61 0
## 128 Canada 6564 44.88 -76.23 0
## 129 Australia 1472075 -31.96 115.84 0
## 130 UK 43799 56.40 -3.47 0
## 131 USA 1439814 40.01 -75.13 0
## 132 USA 1439814 40.01 -75.13 0
## 133 USA 1450884 33.54 -112.07 0
## 134 USA 178295 41.82 -71.42 0
## 135 Mauritius 3152 -20.24 57.62 0
## 136 USA 350822 35.82 -78.66 0
## 137 <NA> NA NA NA NA
## 138 <NA> NA NA NA NA
## 139 USA 189498 37.53 -77.47 0
## 140 Canada 3516 45.18 -75.83 0
## 141 USA 103818 37.95 -122.36 0
## 142 South Africa 33030 -29.85 30.29 0
## 143 New Zealand 12968 -41.31 173.20 0
## 144 Jamaica 2045 18.23 -76.90 0
## 145 Canada 3498 45.67 -72.15 0
## 146 <NA> NA NA NA NA
## 147 Netherlands 597481 51.93 4.48 0
## 148 Netherlands 597481 51.93 4.48 0
## 149 USA 480392 38.57 -121.47 0
## 150 USA 177318 40.78 -111.93 0
## 151 USA 177318 40.78 -111.93 0
## 152 Guatemala 5913 14.53 -91.45 0
## 153 Paraguay 4878 -25.27 -57.32 0
## 154 USA 205743 34.14 -117.29 0
## 155 Guatemala 566 14.78 -89.78 0
## 156 Honduras 1326 14.05 -86.47 0
## 157 Costa Rica 17372 9.90 -84.00 0
## 158 USA 1299352 32.81 -117.14 0
## 159 Colombia 8132 10.33 -73.19 0
## 160 Uruguay 36718 -34.35 -56.71 0
## 161 Philippines 101028 15.79 120.99 0
## 162 Bolivia 9889 -17.85 -60.78 0
## 163 Costa Rica 32187 10.97 -85.13 1
## 164 Philippines 50634 12.46 121.05 0
## 165 Peru 7554 -6.73 -79.84 0
## 166 Philippines 23017 10.76 121.94 0
## 167 Philippines 10733 9.76 125.67 0
## 168 Northern Mariana Islands 954 15.17 145.71 0
## 169 Northern Mariana Islands 2005 14.97 145.62 0
## 170 Colombia 5573 1.92 -78.33 0
## 171 Honduras 1928 15.32 -87.15 0
## 172 Spain 18783 38.92 1.28 0
## 173 Costa Rica 339588 9.93 -84.08 1
## 174 USA 897883 37.30 -121.85 0
## 175 Colombia 1756 5.09 -75.79 0
## 176 Philippines 7051 6.12 125.07 0
## 177 Philippines 7639 15.03 120.78 0
## 178 Honduras 1812 14.90 -88.72 0
## 179 Philippines 8754 13.50 123.22 0
## 180 Guatemala 19057 13.92 -90.82 0
## 181 Philippines 7410 13.70 123.52 0
## 182 Guatemala 1221 16.98 -89.90 0
## 183 Honduras 1493 14.24 -87.96 0
## 184 Uruguay 36718 -34.35 -56.71 0
## 185 Philippines 101028 15.79 120.99 0
## 186 Bolivia 9889 -17.85 -60.78 0
## 187 Costa Rica 32187 10.97 -85.13 1
## 188 Philippines 50634 12.46 121.05 0
## 189 Peru 7554 -6.73 -79.84 0
## 190 Philippines 23017 10.76 121.94 0
## 191 Philippines 10733 9.76 125.67 0
## 192 Northern Mariana Islands 954 15.17 145.71 0
## 193 Northern Mariana Islands 2005 14.97 145.62 0
## 194 Colombia 5573 1.92 -78.33 0
## 195 Honduras 1928 15.32 -87.15 0
## 196 Spain 18783 38.92 1.28 0
## 197 Costa Rica 339588 9.93 -84.08 1
## 198 USA 897883 37.30 -121.85 0
## 199 Colombia 1756 5.09 -75.79 0
## 200 Philippines 7051 6.12 125.07 0
## 201 Philippines 7639 15.03 120.78 0
## 202 Honduras 1812 14.90 -88.72 0
## 203 Philippines 8754 13.50 123.22 0
## 204 Guatemala 19057 13.92 -90.82 0
## 205 Philippines 7410 13.70 123.52 0
## 206 Guatemala 1221 16.98 -89.90 0
## 207 Honduras 1493 14.24 -87.96 0
## 208 <NA> NA NA NA NA
## 209 Japan 236777 33.16 129.72 0
## 210 UK 448596 53.39 -1.48 0
## 211 <NA> NA NA NA NA
## 212 Sweden 1260712 59.33 18.07 1
## 213 Germany 590367 48.79 9.19 0
## 214 Canada 32357 46.15 -60.17 0
## 215 Australia 4444513 -33.87 151.21 0
## 216 Canada 32357 46.15 -60.17 0
## 217 Australia 4444513 -33.87 151.21 0
## 218 Canada 32357 46.15 -60.17 0
## 219 Australia 4444513 -33.87 151.21 0
## 220 Canada 32357 46.15 -60.17 0
## 221 Australia 4444513 -33.87 151.21 0
## 222 USA 197621 47.25 -122.46 0
## 223 USA 80285 30.16 -95.49 0
## 224 Japan 8372440 35.67 139.77 1
## 225 Japan 8372440 35.67 139.77 1
## 226 Canada 4670783 43.65 -79.38 0
## 227 France 439228 43.62 1.45 0
## 228 <NA> NA NA NA NA
## 229 <NA> NA NA NA NA
## 230 <NA> NA NA NA NA
## 231 UK 101521 52.20 -2.24 0
## 232 USA 177973 42.27 -71.81 0
## 233 South Africa 133113 -33.64 19.44 0
## 234 <NA> NA NA NA NA
#turing df into shp
tour_cities_data <- na.omit(tour_cities_data)
tour_cities_sf <- st_as_sf(tour_cities_data, coords = c("long", "lat"), crs = 4269)
tour_cities_sf
## Simple feature collection with 201 features and 8 fields
## Geometry type: POINT
## Dimension: XY
## Bounding box: xmin: -123.09 ymin: -41.31 xmax: 174.25 ymax: 59.91
## Geodetic CRS: NAD83
## First 10 features:
## City Date Country Venue
## 1 Adelaide February 21, 1995 Australia Adelaide Entertainment Centre
## 2 Adelaide February 21, 1995 Australia Adelaide Entertainment Centre
## 3 Albany January 24, 1994 United States Knickerbocker Arena
## 4 Albany January 24, 1994 United States Knickerbocker Arena
## 5 Albany January 24, 1994 United States Knickerbocker Arena
## 6 Albany January 24, 1994 United States Knickerbocker Arena
## 7 Albuquerque April 22, 1994 United States Tingley Coliseum
## 8 Asia Asia Asia Asia
## 9 Asia Asia Asia Asia
## 10 Atlanta January 6, 1994 United States Omni Coliseum
## location country.etc pop capital
## 1 Adelaide, Australia Australia 1076969 0
## 2 Adelaide, Australia South Africa 12222 0
## 3 Albany, United States USA 45535 0
## 4 Albany, United States USA 75510 0
## 5 Albany, United States USA 93576 0
## 6 Albany, United States Australia 24338 0
## 7 Albuquerque, United States USA 494962 0
## 8 Asia, Asia Philippines 23787 0
## 9 Asia, Asia Philippines 23787 0
## 10 Atlanta, United States USA 424096 0
## geometry
## 1 POINT (138.6 -34.93)
## 2 POINT (26.29 -32.7)
## 3 POINT (-123.09 44.62)
## 4 POINT (-84.18 31.58)
## 5 POINT (-73.8 42.67)
## 6 POINT (117.88 -35.02)
## 7 POINT (-106.62 35.12)
## 8 POINT (122.52 9.55)
## 9 POINT (122.52 9.55)
## 10 POINT (-84.42 33.76)
#mapping data
mapview(tour_cities_sf)