The journey of Emancipator

Maps

Data gathering

Published

July 22, 2023

Emancipator - Doug Appling along side Ilya Goldberg, described as a uplifting, mid-tempo, beat-centric, densely layered, melodica, electronica, a blend of music inspiring and creating a story with their captivating melodies and tunes. Doug also found record label Loci Records. This blog post explores the concerts of Emancipator and into their travels!

2015, Dec 31 Park City, UT Doug, Krista, Tyler. Always enjoy when Doug & Ilya make time for Utah!

Data processing

For this post, I focus on data from https://www.concertarchives.org/bands/emancipator. This site had the most complete concert history I could find. I web scrape using rvest, check and double check the data with dplyr, and eventually break down and use excel to do one final clean. There were a lot of individual dates repeated, festivals repeated, and overall not easy to deal with. However I do attempt a first clean of the data-set but came to realize I will need to manually intervene due to the nature of the issue.

Code

# Load required libraries
library(rvest)
library(purrr)
library(stringr)
library(tidyverse)

# Specify the base URL
base_url <- "https://www.concertarchives.org/bands/emancipator?page="

# Create an empty list to store the scraped data
all_data <- list()

# Loop through the pages
for (page_num in 1:29) {
  # Construct the URL for each page
  url <- paste0(base_url, page_num, "#concert-table")

  # Read the HTML content of the page
  page <- read_html(url)

  # Scrape the table with the specified ID
  table <- html_table(html_nodes(page, "#band-show-table-condensed"), header = TRUE)

  # Access the scraped data
  data <- table[[1]][, 1:4]

  # Append the data to the list
  all_data[[page_num]] <- data
}

# Combine all the scraped data into a single data frame
combined_data <- do.call(plyr::rbind.fill, all_data)

# Try to clean the dataset
dat <- combined_data %>% 
  mutate(Date = str_extract(combined_data$Date, "\\w+ \\d+, \\d+"),
         Date = as.Date(Date, format = "%b %d, %Y"),
         Location = ifelse(grepl('\\/', Location), 
                           stringr::str_extract(combined_data$Location, "\\b[A#-Z][a-zA-Z]+(?: [A-Z][a-zA-Z]+)*, [A-Z][a-zA-Z]+(?: [A-Z][a-zA-Z]+)*, [A-Z][a-zA-Z]#+(?: [A-Z][a-zA-Z]+)*$"),
                           Location)) %>% 
  filter(!grepl('Duplicate', Location)) %>% 
  select(-Concert) %>% 
  filter(!is.na(Location) & Venue != '') %>% 
  distinct(Date, Venue, Location)

dat %>% 
  kableExtra::kable() %>% 
    kableExtra::kable_paper(full_width = F) %>% 
    kableExtra::scroll_box(height = "400px", width = '600px')

Date	Venue	Location
2023-08-18	Elsewhere	New York, New York, United States
2023-08-11	Concord Music Hall	Chicago, Illinois, United States
2023-08-05	The Caverns	Pelham, Tennessee, United States
2023-06-24	The Mission Ballroom	Denver, Colorado, United States
2023-04-20	The Concourse Project	Austin, Texas, United States
2023-03-24	Beachland Ballroom	Cleveland, Ohio, United States
2023-03-11	Ventura Music Hall	Ventura, California, United States
2023-02-03	Pima County Fairgrounds	Tucson, Arizona, United States
2023-01-01	Belly Up Aspen	Aspen, Colorado, United States
2022-12-22	9:30 Club	Washington, D.C., United States
2022-12-21	9:30 Club	Washington, D.C., United States
2022-12-18	Revolution Live	Fort Lauderdale, Florida, United States
2022-12-14	Neighborhood Theatre	Charlotte, North Carolina, United States
2022-12-13	The Orange Peel	Asheville, North Carolina, United States
2022-12-10	Aura	Portland, Maine, United States
2022-12-09	The Queen Theater	Wilmington, Delaware, United States
2022-12-08	Kings Theatre	New York, New York, United States
2022-10-28	The North Warehouse	Portland, Oregon, United States
2022-09-29	Mulberry Mountain Lodging and Events	Ozark, AR, US
2022-09-10	Lake Perris State Recreation Area	Perris, California, United States
2022-09-09	Lake Perris State Recreation Area	Perris, CA, US
2022-08-26	Bicentennial Capitol Mall Park	Nashville, Tennessee, United States
2022-08-26	Bicentennial Capitol Mall State Park	Nashville, Tennessee, United States
2022-08-26	Bicentennial Park	Nashville, Tennessee, United States
2022-08-18	Legend Valley	Thornville, Ohio, United States
2022-08-17	Legend Valley	Thornville, Ohio, United States
2022-06-24	Levitt Pavilion	Denver, Colorado, United States
2022-06-24	COLOR FIELD 2022	Denver, Colorado, United States
2022-06-24	Levitt Pavilion Denver	Denver, Colorado, United States
2022-05-12	Spirit of Suwannee Music Park	Live Oak, FL, US
2022-04-19	The Midway	San Francisco, California, United States
2021-10-08	Oxbow RiverStage	Napa, California, United States
2021-09-17	Marvin's Mountaintop	Masontown, West Virginia, United States
2021-09-16	Marvin's Mountaintop	Masontown, West Virginia, United States
2021-09-16	Marvin’s Mountaintop	Masontown, West Virginia, United States
2021-08-20	Three Sisters Park	Chillicothe, Illinois, United States
2021-08-19	Three Sisters Park	Chillicothe, Illinois, United States
2021-08-14	Grinders KC	Kansas City, Missouri, United States
2020-07-18	McMenamins Crystal Ballroom	Portland, Oregon, United States
2020-05-24	Facebook	ONLINE
2020-05-23	Facebook	ONLINE
2020-05-22	Facebook	ONLINE
2020-02-24	Rancho La Merced	Puntarenas, Costa Rica
2020-02-23	Rancho La Merced	Puntarenas, Costa Rica
2020-02-22	Rancho La Merced	Puntarenas, Costa Rica
2020-02-21	Rancho La Merced	Puntarenas, Costa Rica
2020-02-20	Rancho La Merced	Puntarenas, Costa Rica
2020-02-19	Rancho La Merced	Puntarenas, Costa Rica
2020-02-18	Rancho La Merced	Puntarenas, Costa Rica
2020-01-31	Cervantes' Masterpiece Ballroom	Denver, Colorado, United States
2020-01-01	Belly Up Aspen	Aspen, Colorado, United States
2019-12-28	Meow Wolf Santa Fe	Santa Fe, New Mexico, United States
2019-05-26	The Gorge Amphitheatre	George, Washington, United States
2019-05-25	The Gorge Amphitheatre	George, Washington, United States
2019-04-27	The Crocodile	Seattle, Washington, United States
2019-04-26	Star Theater	Portland, Oregon, United States
2019-04-13	Great American Music Hall	San Francisco, California, United States
2019-04-12	The Roxy Theatre	West Hollywood, California, United States
2019-04-11	Live Oak Camp	Santa Barbara, California, United States
2019-04-05	Sun Peaks Resort	Kamloops, British Columbia, Canada
2019-03-28	Terminal West	Atlanta, Georgia, United States
2019-03-09	Bowery Ballroom	New York, New York, United States
2019-03-07	Brighton Music Hall	Boston, Massachusetts, United States
2019-02-01	Bluestone	Columbus, Ohio, United States
2019-01-12	Pink Garter Theatre	Jackson, Wyoming, United States
2019-01-11	Urban Lounge	Salt Lake City, Utah, United States
2019-01-08	10 Mile Music Hall	Frisco, Colorado, United States
2019-01-04	Sheridan Opera House	Telluride, Colorado, United States
2018-10-31	A38 Ship / A38 Hajó	Budapest, Budapest, Hungary
2018-10-25	Spirit of the Suwannee Music Park	Live Oak, Florida, United States
2018-10-05	Vic Theatre	Chicago, Illinois, United States
2018-10-04	The Intersection / Showroom	Grand Rapids, Michigan, United States
2018-09-20	Legend Valley	Thornville, Ohio, United States
2018-08-11	Pimlico Race Course	Baltimore, Maryland, United States
2018-08-11	The New York Expo Center	New York, New York, United States
2018-08-11	New York Expo Center	New York, New York, United States
2018-07-20	Cooks Valley Campground	Piercy, CA
2018-06-30	Sugarbush Valley Ski Resort	Warren, Vermont, United States
2018-06-29	Double JJ Resort	Rothbury, Michigan, United States
2018-06-28	Double JJ Ranch & Golf Resort	Rothbury, Michigan, United States
2018-06-28	Unknown venue	Waitsfield, VT
2018-06-28	Double JJ Ranch	Rothbury, Michigan, United States
2018-06-21	Double JJ Ranch & Golf Resort	Rothbury, Michigan, United States
2018-06-21	Double JJ Resort	Rothbury, Michigan, United States
2018-05-26	Red Rocks Amphitheatre	Morrison, Colorado, United States
2018-05-23	San Antonio Recreation Area	Bradley, CA
2018-04-20	Mulberry Mountain Lodging and Events	Ozark, Arkansas, United States
2018-03-31	McMenamins Crystal Ballroom	Portland, Oregon, United States
2018-03-30	The Showbox	Seattle, Washington, United States
2018-03-29	Venue Nightclub	Vancouver, British Columbia, Canada
2018-03-17	The Regency Ballroom	San Francisco, California, United States
2018-03-16	The Fonda Theatre	Los Angeles, California, United States
2018-03-15	Music Box	San Diego, California, United States
2018-03-14	Constellation Room @ The Observatory	Santa Ana, California, United States
2018-02-24	Variety Playhouse	Atlanta, Georgia, United States
2018-02-23	Lincoln Theatre	Raleigh, North Carolina, United States
2018-02-22	The Underground	Charlotte, North Carolina, United States
2018-02-21	Exit / In	Nashville, Tennessee, United States
2018-02-20	Old Rock House	St. Louis, Missouri, United States
2018-02-19	Mohawk	Austin, Texas, United States
2018-02-18	White Oak Music Hall	Houston, Texas, United States
2018-02-17	Mohawk	Austin, Texas, United States
2018-02-16	Trees	Dallas, Texas, United States
2018-02-15	Varsity Theatre	Baton Rouge, Louisiana, United States
2018-02-14	WorkPlay Bar	Birmingham, Alabama, United States
2018-02-10	Fine Line Music Cafe	Minneapolis, Minnesota, United States
2018-02-09	Concord Music Hall	Chicago, Illinois, United States
2018-02-08	The Majestic Theatre	Detroit, Michigan, United States
2018-02-07	Miramar Theatre	Milwaukee, Wisconsin, United States
2018-02-03	9:30 Club	Washington, D.C., United States
2018-02-02	Theatre Of Living Arts	Philadelphia, Pennsylvania, United States
2018-02-01	Brooklyn Steel	New York, New York, United States
2018-01-31	Paradise Rock Club	Boston, Massachusetts, United States
2018-01-30	Higher Ground	South Burlington, Vermont, United States
2017-09-30	Waterfront Park	San Diego, California, United States
2017-09-29	Camp Ramblewood	Darlington, Maryland, United States
2017-08-27	Red Rocks Amphitheatre	Morrison, Colorado, United States
2017-08-17	Big Summit Prairie	Portland, Oregon, United States
2017-08-17	Big Summit Prairie	Big Summit Prairie, OR
2017-08-12	Page Farm	Croydon, New Hampshire, United States
2017-08-03	Legend Valley	Thornville, Ohio, United States
2017-07-13	Montage Mountain	Scranton, Pennsylvania, United States
2017-07-13	Pavilion At Montage Mountain	Moosic, Pennsylvania, United States
2017-01-14	The Roxy Theatre	West Hollywood, California, United States
2017-01-13	The Independent	San Francisco, California, United States
2016-12-30	Ballroom at Mardi Gras World	New Orleans, Louisiana, United States
2016-12-17	Bluebird Theater	Denver, Colorado, United States
2016-12-16	Lincoln Hall	Chicago, Illinois, United States
2016-12-10	U Street Music Hall	Washington, D.C., United States
2016-12-09	Bowery Ballroom	New York, New York, United States
2016-12-08	The Sinclair	Cambridge, Massachusetts, United States
2016-11-26	The Crocodile	Seattle, Washington, United States
2016-11-25	Celebrities Nightclub	Vancouver, British Columbia, Canada
2016-10-09	A38 Ship / A38 Hajó	Budapest, Budapest, Hungary
2016-10-07	Nashville Municipal Auditorium	Nashville, Tennessee, United States
2016-09-23	Huntington Bank Pavilion at Northerly Island	Chicago, Illinois, United States
2016-09-01	Big Sky Brewing Amphitheatre	Spokane, Washington, United States
2016-08-12	Somerset Ampitheater	Somerset, Wisconsin, United States
2016-08-12	Summer Set 2016	Somerset, WI, US
2016-08-05	Shambhala Music Festival	Vancouver, British Columbia, Canada
2016-07-22	Capitol Hill Festival Grounds	Seattle, Washington, United States
2016-07-02	Sawyer Point	Cincinnati, Ohio, United States
2016-06-10	Bethel Woods Center for the Arts	Bethel, New York, United States
2016-05-29	Three Sisters Park	Chillicothe, Illinois, United States
2016-05-27	Three Sisters Park	Chillicothe, Illinois, United States
2016-05-26	Three Sisters Park	Chillicothe, Illinois, United States
2016-05-14	Pepsi Amphitheater at Fort Tuthill Park	Scottsdale, Arizona, United States
2016-05-13	Red Rocks Amphitheatre	Morrison, Colorado, United States
2016-05-03	Doug Fir Lounge	Portland, Oregon, United States
2016-04-24	Centennial Olympic Park	Atlanta, Georgia, United States
2016-04-23	Baltimore Soundstage	Baltimore, Maryland, United States
2016-04-22	Centennial Olympic Park	Atlanta, Georgia, United States
2016-03-06	Mavri Trypa	Thessaloníki, Greece
2016-03-05	Six D.O.G.S	Athens, Attica, Greece
2016-03-04	Babylon	Istanbul, Istanbul, Turkey
2016-03-03	A38	Budapest, Budapest, Hungary
2016-03-02	Control	Bucharest, Bucureşti, Romania
2016-02-29	Marble Factory	Bristol, England, United Kingdom
2016-02-28	Belgrave Music Hall & Canteen	Leeds, England, United Kingdom
2016-02-27	THE GARAGE	London, England, United Kingdom
2016-02-26	La Bellevilloise	Paris, Île-de-France, France
2016-02-25	Vk	Brussels, Brussels Capital, Belgium
2016-02-24	Paard van Troje	The Hague, South Holland, Netherlands
2016-02-21	Patronaat	Haarlem, North Holland, Netherlands
2016-02-20	Lido	Berlin, Berlin, Germany
2016-02-19	Rust	Copenhagen, Capital Region, Denmark
2016-02-18	Nosturi	Helsinki, Uusimaa, Finland
2016-02-17	16 Tons Club	Moscow, Russian Federation
2016-02-08	Belly Up Aspen	Aspen, Colorado, United States
2016-02-06	Ogden Theatre	Denver, Colorado, United States
2016-02-05	Boulder Theater	Boulder, Colorado, United States
2016-01-25	Rainbow Serpent Festival Grounds	Lexton, South Australia, Australia
2016-01-24	Rainbow Serpent Festival Grounds	Lexton, South Australia, Australia
2016-01-23	Rainbow Serpent Festival Grounds	Lexton, South Australia, Australia
2016-01-22	Unknown venue	Ballarat, Victoria, Australia
2016-01-16	Max Watt's - Brisbane	Brisbane, Queensland, Australia
2016-01-15	Metro Theatre	Sydney, New South Wales, Australia
2016-01-14	Forum Melbourne	Melbourne, Victoria, Australia
2015-12-31	OP Rockwell	Park City, Utah, United States
2015-12-30	The Tabernacle	Atlanta, Georgia, United States
2015-11-22	The Glass House Concert Hall	Pomona, California, United States
2015-11-21	Belly Up	Solana Beach, California, United States
2015-11-20	Regent Theater	Los Angeles, California, United States
2015-11-19	The Regency Ballroom	San Francisco, California, United States
2015-11-18	The Catalyst	Santa Cruz, California, United States
2015-11-17	Ashland Armory	Ashland, Oregon, United States
2015-11-15	Sessions Music Hall	Eugene, Oregon, United States
2015-11-14	The Showbox	Seattle, Washington, United States
2015-11-13	Roseland Theater	Portland, Oregon, United States
2015-11-12	Commodore Ballroom	Vancouver, British Columbia, Canada
2015-11-10	Wild Buffalo House Of Music	Bellingham, Washington, United States
2015-10-31	Minneapolis Music Hall	Minneapolis, Minnesota, United States
2015-10-30	Toyota Park	Bridgeview, Illinois, United States
2015-10-29	Majestic Theatre	Madison, Wisconsin, United States
2015-10-28	The Blue Note	Columbia, Missouri, United States
2015-10-27	The Ready Room	St. Louis, Missouri, United States
2015-10-23	The Intersection / Showroom	Grand Rapids, Michigan, United States
2015-10-22	The Vogue	Indianapolis, Indiana, United States
2015-10-21	Beachland Ballroom	Cleveland, Ohio, United States
2015-10-20	Rex Theater	Pittsburgh, Pennsylvania, United States
2015-10-18	The Town Ballroom	Buffalo, New York, United States
2015-10-17	Palladium Times Square	New York, New York, United States
2015-10-16	Theatre Of Living Arts	Philadelphia, Pennsylvania, United States
2015-10-15	Paradise Rock Club	Boston, Massachusetts, United States
2015-10-14	Higher Ground - Ballroom	South Burlington, Vermont, United States
2015-10-13	Upstate Concert Hall	Clifton Park, New York, United States
2015-10-10	Marathon Music Works	Nashville, Tennessee, United States
2015-10-09	Georgia Theatre	Athens, Georgia, United States
2015-10-08	Variety Playhouse	Atlanta, Georgia, United States
2015-10-07	The Chop Shop	Charlotte, North Carolina, United States
2015-10-06	Lincoln Theatre	Raleigh, North Carolina, United States
2015-10-04	The Senate	Columbia, South Carolina, United States
2015-10-03	The Orange Peel	Asheville, North Carolina, United States
2015-10-02	The International	Knoxville, Tennessee, United States
2015-10-01	Track 29	Chattanooga, Tennessee, United States
2015-09-30	WorkPlay Theatre	Birmingham, Alabama, United States
2015-09-29	Republic NOLA	New Orleans, Louisiana, United States
2015-09-20	Various Venues	Victoria, British Columbia, Canada
2015-09-18	Woodward Reservoir	Oakdale, California, United States
2015-09-17	Woodward Reservoir Regional Park	Modesto, California, United States
2015-09-17	Royal Athletic Park	Victoria, British Columbia, Canada
2015-09-12	Pumphouse Park	Calgary, Alberta, Canada
2015-09-07	Seattle Center	Seattle, Washington, United States
2015-09-05	Seattle Center	Seattle, Washington, United States
2015-08-20	Camp Hidden Meadows	Bartow, West Virginia, United States
2015-08-07	Sunrise Ranch	Loveland, Colorado, United States
2015-07-17	Pavilion At Montage Mountain	Moosic, Pennsylvania, United States
2015-07-16	Montage Mountain	Scranton, Pennsylvania, United States
2015-06-21	Hummingbird Ranch	Rye, Colorado, United States
2015-06-20	Randolph Street Corridor	Chicago, Illinois, United States
2015-06-19	Hummingbird Ranch	Rye, Colorado, United States
2015-06-18	Hummingbird Ranch	Rye, Colorado, United States
2015-06-12	Various Venues	Jackson, Wyoming, United States
2015-05-22	Kingston Downs	Rome, Georgia, United States
2015-04-18	The Warfield Theatre	San Francisco, California, United States
2015-04-10	Carson Creek Ranch	Austin, Texas, United States
2015-02-27	Rancho La Merced	Puntarenas, Costa Rica
2015-02-20	Capital Ballroom	Victoria, British Columbia, Canada
2015-02-19	Capital Ballroom	Victoria, British Columbia, Canada
2015-02-09	Fortune Sound Club	Vancouver, British Columbia, Canada
2015-02-07	Green On Grant	Tucson, Arizona, United States
2014-11-08	Shrine Expo Hall	Los Angeles, California, United States
2014-11-07	Brooklyn Bowl Las Vegas	Las Vegas, Nevada, United States
2014-11-06	1st Bank Center	Denver, Colorado, United States
2014-11-05	The Great Saltair	Magna, Utah, United States
2014-11-01	Revolution Live	Fort Lauderdale, Florida, United States
2014-10-30	Thomas Wolfe Auditorium	Asheville, North Carolina, United States
2014-10-29	Marathon Music Works	Nashville, Tennessee, United States
2014-10-25	Electric Factory	Philadelphia, Pennsylvania, United States
2014-10-24	The Dome At Toyota Presents The Oakdale Theatre	Wallingford, Connecticut, United States
2014-10-23	Palladium Times Square	New York, New York, United States
2014-10-22	Echostage	Washington, D.C., United States
2014-10-21	House of Blues Boston	Boston, Massachusetts, United States
2014-10-19	Riviera Theatre	Chicago, Illinois, United States
2014-10-18	Riviera Theatre	Chicago, Illinois, United States
2014-10-17	Myth	Saint Paul, Minnesota, United States
2014-10-16	The Venue	Fargo, North Dakota, United States
2014-10-15	The Orpheum Theatre	Madison, Wisconsin, United States
2014-08-31	Union Park	Chicago, Illinois, United States
2014-08-30	Masquerade Music Park	Atlanta, Georgia, United States
2014-08-29	Union Park	Chicago, Illinois, United States
2014-08-09	Salmo River Ranch	Salmo, British Columbia, Canada
2014-08-08	Legend Valley	Thornville, Ohio, United States
2014-08-02	Chateau Whistler Resort	Whistler, British Columbia, Canada
2014-07-13	Winston Farm	Saugerties, New York, United States
2014-07-11	Winston Farm	Saugerties, New York, United States
2014-06-26	Double JJ Ranch & Golf Resort	Rothbury, Michigan, United States
2014-06-22	Wolf Run Ranch	Dufur, Oregon, United States
2014-06-20	Stratton Mountain Resort	Stratton, Vermont, United States
2014-06-19	Wolf Run Ranch	The Dalles, OR
2014-05-23	Legend Valley	Thornville, Ohio, United States
2014-05-10	Red Rocks Amphitheatre	Morrison, Colorado, United States
2014-05-09	Emo's	Austin, Texas, United States
2014-05-08	Emo's Austin	Austin, Texas, United States
2014-05-07	Granada Theater	Dallas, Texas, United States
2014-04-06	SLO Brew Rock	San Luis Obispo, California, United States
2014-04-04	House Of Blues	West Hollywood, California, United States
2014-04-03	The Catalyst	Santa Cruz, California, United States
2014-04-02	Blu Nightclub	Lake Tahoe, California, United States
2014-04-01	Arcata Theatre Lounge	Arcata, California, United States
2014-03-30	HopMonk Tavern Sebastopol	Sebastopol, California, United States
2014-03-29	The Regency Ballroom	San Francisco, California, United States
2014-03-28	McMenamins Crystal Ballroom	Portland, Oregon, United States
2014-03-27	The Showbox	Seattle, Washington, United States
2014-03-25	Zebra Cocktail Lounge	Bozeman, Montana, United States
2014-03-01	Arcata Theatre Lounge	Arcata, California, United States
2014-02-22	Georgia Theatre	Athens, Georgia, United States
2014-02-21	Terminal West	Atlanta, Georgia, United States
2014-02-20	The Orange Peel	Asheville, North Carolina, United States
2014-02-19	Lincoln Theatre	Raleigh, North Carolina, United States
2014-02-18	Tally Ho Theater	Leesburg, Virginia, United States
2014-02-17	Theatre Of Living Arts	Philadelphia, Pennsylvania, United States
2014-02-16	Baltimore Soundstage	Baltimore, Maryland, United States
2014-02-15	Paradise Rock Club	Boston, Massachusetts, United States
2014-02-14	PlayStation Theater	New York, New York, United States
2014-02-13	Theatre Of Living Arts	Philadelphia, Pennsylvania, United States
2014-02-12	The Met	Pawtucket, Rhode Island, United States
2014-02-09	Toad's Place	New Haven, Connecticut, United States
2014-02-08	Port City Music Hall	Portland, Maine, United States
2014-02-07	Higher Ground Ballroom	Burlington, Vermont, United States
2014-02-06	The Westcott Theater	Syracuse, New York, United States
2014-02-05	Rex Theater	Pittsburgh, Pennsylvania, United States
2014-02-02	Canopy Club	Urbana, Illinois, United States
2014-02-01	Mill City Nights	Minneapolis, Minnesota, United States
2014-01-31	Concord Music Hall	Chicago, Illinois, United States
2014-01-30	Majestic Theatre	Madison, Wisconsin, United States
2014-01-29	Miramar Theatre	Milwaukee, Wisconsin, United States
2014-01-28	Castle Theatre	Aurora, Illinois, United States
2014-01-25	The Crofoot Ballroom	Detroit, Michigan, United States
2014-01-24	Beachland Ballroom and Tavern	Cleveland, Ohio, United States
2014-01-23	Newport Music Hall	Columbus, Ohio, United States
2014-01-22	The Intersection / Showroom	Grand Rapids, Michigan, United States
2014-01-19	Headliners Music Hall	Louisville, Kentucky, United States
2014-01-18	Cannery Ballroom	Nashville, Tennessee, United States
2014-01-17	NV Nightclub	Knoxville, Tennessee, United States
2014-01-16	Track 29	Chattanooga, Tennessee, United States
2014-01-15	WorkPlay Theatre	Birmingham, Alabama, United States
2014-01-14	Republic NOLA	New Orleans, Louisiana, United States
2014-01-11	Belly Up Aspen	Aspen, Colorado, United States
2014-01-10	Copper Mountain Resort	Copper Mountain, Colorado, United States
2013-12-31	Bill Graham Civic Auditorium	San Francisco, California, United States
2013-12-30	The Observatory	Santa Ana, California, United States
2013-11-23	Veterans Memorial Coliseum	Portland, Oregon, United States
2013-11-22	Ogden Theatre	Denver, Colorado, United States
2013-11-21	Boulder Theater	Boulder, Colorado, United States
2013-11-02	Spirit of the Suwannee Music Park	Live Oak, Florida, United States
2013-10-31	Spirit of the Suwannee Music Park	Live Oak, Florida, United States
2013-10-31	Spirit of the Suwannee Music Park	Live Oak, FL, US
2013-09-28	Mann Center for Performing Arts	Philadelphia, Pennsylvania, United States
2013-09-23	Woodward Reservoir	Oakdale, California, United States
2013-09-20	Woodward Reservoir Regional Park	Modesto, California, United States
2013-09-06	Pepsi Amphitheater at Fort Tuthill Park	Flagstaff, Arizona, United States
2013-08-22	Zephyr Cove Resort	Zephyr Cove, Nevada, United States
2013-08-16	Gardner's Farm	Stephentown, New York, United States
2013-08-15	Gardner's Farm	Stephentown, New York, United States
2013-08-11	Darrington Bluegrass Music Park	Darrington, Washington, United States
2013-08-09	Whitehorse Mountain Amphitheater	Darrington, Washington, United States
2013-08-02	Four Quarters Farm	Artemas, Pennsylvania, United States
2013-07-31	MontBleu Resort Casino & Spa	Stateline, Nevada, United States
2013-07-28	Gratifly Festival Grounds	Westminster, South Carolina, United States
2013-07-21	Red Rocks Amphitheatre	Morrison, Colorado, United States
2013-07-20	Various Venues	Santa Cruz, California, United States
2013-07-19	Red Rocks Amphitheatre	Morrison, Colorado, United States
2013-07-12	Lake Skinner Park	Winchester, California, United States
2013-07-11	Lake Skinner County Park	San Diego, California, United States
2013-07-07	Plumas County Fairgrounds	Quincy, California, United States
2013-07-06	Plumas County Fairgrounds	Quincy, California, United States
2013-07-05	Plumas-Sierra County Fairgrounds	Quincy, California, United States
2013-07-04	Plumas County Fairgrounds	Quincy, California, United States
2013-07-04	Plumas-Sierra County Fairgrounds	Quincy, California, United States
2013-06-30	Double JJ Resort	Rothbury, Michigan, United States
2013-06-28	Double JJ Ranch & Golf Resort	Grand Rapids, Michigan, United States
2013-05-31	NCN North Campground	Black River Falls, Wisconsin, United States
2013-05-30	Mulberry Mountain Lodging and Events	Ozark, Arkansas, United States
2013-03-23	Tahoe Biltmore Lodge & Casino	Reno, Nevada, United States
2013-03-22	Urban Lounge	Salt Lake City, Utah, United States
2013-03-21	Henry Strater Theater	Durango, Colorado, United States
2013-03-20	Effex Nightclub	Albuquerque, New Mexico, United States
2013-03-19	Green Room	Scottsdale, Arizona, United States
2013-03-17	Belly Up Tavern	San Diego, California, United States
2013-03-16	El Rey Theatre	Los Angeles, California, United States
2013-03-15	The Catalyst	San Francisco, California, United States
2013-03-14	Mezzanine	San Francisco, California, United States
2013-03-13	Arcata Theatre Lounge	Santa Rosa, California, United States
2013-03-12	WOW Hall	Salem, Oregon, United States
2013-03-10	Wild Buffalo	Seattle, Washington, United States
2013-03-09	Neumos Crystal Ball Reading Room	Seattle, Washington, United States
2013-03-08	Wonder Ballroom	Portland, Oregon, United States
2013-03-07	Montana State University Bozeman	Billings, Montana, United States
2013-02-17	East Peoria Event Center	East Peoria, Illinois, United States
2013-02-16	The Blue Note	Columbia, Missouri, United States
2013-02-15	Marathon Music Works	Nashville, Tennessee, United States
2013-02-14	Zydeco	Birmingham, Alabama, United States
2013-02-13	1904	Jacksonville, Florida, United States
2013-02-12	The Stage	Miami, Florida, United States
2013-02-10	Sidebar Theatre	Tallahassee, Florida, United States
2013-02-09	Rhythm & Brews	Chattanooga, Tennessee, United States
2013-02-08	Terminal West	Atlanta, Georgia, United States
2013-02-07	Georgia Theatre	Athens, Georgia, United States
2013-02-06	Neighborhood Theatre	Charlotte, North Carolina, United States
2013-02-05	The Canal Club	Richmond, Virginia, United States
2013-02-02	Paradise Rock Club	Boston, Massachusetts, United States
2013-02-01	Irving Plaza	New York, New York, United States
2013-01-31	Trocadero Theatre	Philadelphia, Pennsylvania, United States
2013-01-30	Higher Ground - Ballroom	South Burlington, Vermont, United States
2013-01-29	Toad's Place	New Haven, Connecticut, United States
2013-01-27	The Westcott Theater	Syracuse, New York, United States
2013-01-26	Rex Theater	Pittsburgh, Pennsylvania, United States
2013-01-25	Beachland Ballroom	Cleveland, Ohio, United States
2013-01-24	Magic Stick	Detroit, Michigan, United States
2013-01-23	The Intersection / The Stache	Grand Rapids, Michigan, United States
2013-01-20	Papa Pete's	Kalamazoo, Michigan, United States
2013-01-19	Bottom Lounge	Chicago, Illinois, United States
2013-01-18	Majestic Theatre	Madison, Wisconsin, United States
2013-01-17	Eagles Ballroom, The Rave/Eagles Club	Milwaukee, Wisconsin, United States
2013-01-16	Canopy Club	Urbana, Illinois, United States
2013-01-12	Olympic Valley Lodge	Squaw Valley, CA
2012-12-31	The Orange Peel	Asheville, North Carolina, United States
2012-12-21	KEMBA Live!	Columbus, Ohio, United States
2012-11-10	Aggie Theatre	Fort Collins, Colorado, United States
2012-11-09	Ogden Theatre	Denver, Colorado, United States
2012-11-08	Fox Theatre	Boulder, Colorado, United States
2012-11-07	Three20south	Breckenridge, Colorado, United States
2012-10-19	Mezzanine	San Francisco, California, United States
2012-09-30	The Crocodile	Seattle, Washington, United States
2012-09-29	Counterpoint Music & Arts Festival Grounds	Fairburn, Georgia, United States
2012-09-28	Counterpoint Music Festival PRE PARTY	Rome, Georgia, United States
2012-09-28	Chattahoochee Hills	Fairburn, Georgia, United States
2012-09-27	Trees	Dallas, Texas, United States
2012-09-22	Spirit of the Suwannee Music Park	Live Oak, Florida, United States
2012-09-21	The International	Knoxville, Tennessee, United States
2012-09-08	Red Rocks Amphitheatre	Morrison, Colorado, United States
2012-08-26	Somerset Amphitheater	Minneapolis, Minnesota, United States
2012-08-11	Crossroads-KC	Kansas City, Missouri, United States
2012-08-10	Beech Mountain Resort	Beech Mountain, North Carolina, United States
2012-07-29	What The Festival Grounds	Tygh Valley, Oregon, United States
2012-07-28	What The Festival Grounds	Tygh Valley, Oregon, United States
2012-07-27	What The Festival Grounds	Tygh Valley, Oregon, United States
2012-07-14	Club 116	Louisville, Kentucky, United States
2012-07-13	Indian Lookout Country Club	Mariaville, New York, United States
2012-07-12	Indian Lookout Country Club	Mariaville Lake, New York, United States
2012-06-16	Durhamtown Plantation	Union Point, Georgia, United States
2012-05-17	Highbridge Hills Festival Grounds	Highbridge, WI, US
2012-05-04	The Jewish Mother Hilltop	Virginia Beach, Virginia, United States
2012-04-27	Mardi Gras World	New Orleans, Louisiana, United States
2012-04-01	Neumos Crystal Ball Reading Room	Seattle, Washington, United States
2012-03-31	Wild Buffalo House Of Music	Bellingham, Washington, United States
2012-03-30	Doug Fir Lounge	Portland, Oregon, United States
2012-03-29	WOW Hall	Eugene, Oregon, United States
2012-03-28	Arcata Theatre Lounge	Arcata, California, United States
2012-03-25	Moe's Alley	Santa Cruz, California, United States
2012-03-24	HopMonk Tavern Sebastopol	Sebastopol, California, United States
2012-03-23	The Addition (Formerly Yoshi's SF)	San Francisco, California, United States
2012-03-22	King King	Los Angeles, California, United States
2012-02-18	Barfly	Minneapolis, Minnesota, United States
2012-02-17	Congress Theater	Chicago, Illinois, United States
2012-02-17	The Mid	Chicago, Illinois, United States
2012-02-16	Majestic Theatre
2012-02-15	Canopy Club	Urbana, Illinois, United States
2012-02-14	The Blue Note	Columbia, Missouri, United States
2012-02-11	The Majestic Theatre	Detroit, Michigan, United States
2012-02-10	Beachland Ballroom & Tavern	Cleveland, Ohio, United States
2012-02-09	Rex Theater	Pittsburgh, Pennsylvania, United States
2012-02-08	Big Orbit Soundlab Space	Buffalo, New York, United States
2012-02-05	The Middle East Restaurant and Nightclub	Cambridge, Massachusetts, United States
2012-02-04	Higher Ground - Ballroom	South Burlington, Vermont, United States
2012-02-03	The Dock	Ithaca, New York, United States
2012-02-02	Highline Ballroom	New York, New York, United States
2012-02-01	The Blockley	Philadelphia, Pennsylvania, United States
2012-01-28	Awful Arthur's	Blacksburg, Virginia, United States
2012-01-27	The Orange Peel	Asheville, North Carolina, United States
2012-01-26	Georgia Bar	Athens, Georgia, United States
2012-01-25	Rick's Cafe	Starkville, Mississippi, United States
2012-01-22	The Engine Room	Tallahassee, Florida, United States
2012-01-21	King Plow Arts Center	Atlanta, Georgia, United States
2012-01-20	Mai	Nashville, Tennessee, United States
2012-01-19	Headliners Music Hall	Louisville, Kentucky, United States
2012-01-18	Old Rock House	St. Louis, Missouri, United States
2011-12-30	The Novo	Los Angeles, California, United States
2011-12-29	Bijou Park	Reno, Nevada, United States
2011-11-19	Summit	Denver, Colorado, United States
2011-11-18	Aggie Theatre	Fort Collins, Colorado, United States
2011-11-17	Agave	Avon, Colorado, United States
2011-11-16	Three20south	Breckenridge, Colorado, United States
2011-11-04	Emo's Austin	Austin, Texas, United States
2011-11-03	The Marc	San Marcos, Texas, United States
2011-10-30	Downtown Asheville	Asheville, North Carolina, United States
2011-09-24	Solano County Fair	Vallejo, California, United States
2011-09-10	Star Theater	Portland, Oregon, United States
2011-09-03	Seattle Center	Seattle, Washington, United States
2011-08-27	McDonald Theatre	Eugene, Oregon, United States
2011-08-18	Gardner's Farm	Stephentown, New York, United States
2011-08-17	Grog Shop	Cleveland Heights, Ohio, United States
2011-08-05	Kaeppner Woods	Logan, Ohio, United States
2011-07-09	Indian Lookout Country Club	Mariaville, New York, United States
2011-07-07	Unknown venue	Mariaville Lake, New York, United States
2011-07-07	Camp Bisco 2011	Mariaville, NY, US
2011-07-03	Plumas County Fairgrounds	Quincy, California, United States
2011-07-01	Electric Forest	Rothbury, Michigan, United States
2011-06-30	Double JJ Ranch & Golf Resort	Rothbury, Michigan, United States
2011-06-30	Plumas County Fairgrounds	Quincy, California, United States
2011-06-30	Double JJ Resort	Rothbury, Michigan, United States
2011-06-26	Horning's Hideout	North Plains, Oregon, United States
2011-06-17	Sherman Oaks Campground	Knoxville, Tennessee, United States
2011-05-28	Red Rocks Amphitheatre	Morrison, Colorado, United States
2011-04-15	Unknown venue	San Diego, California, United States
2011-04-15	Empire Polo Club	Indio, California, United States
2011-03-04	The Mid	Chicago, Illinois, United States
2011-02-27	Hookah Cafe	New Orleans, Louisiana, United States
2011-02-26	Venue 222	Austin, Texas, United States
2011-02-25	Trees	Dallas, Texas, United States
2011-02-24	Fox Theatre	Boulder, Colorado, United States
2011-02-23	Hodi's Half Note	Fort Collins, Colorado, United States
2011-02-22	Ghost Ranch Saloon	Steamboat Springs, Colorado, United States
2011-02-11	The District	Eugene, Oregon, United States
2011-02-06	King Plow Arts Center	Atlanta, Georgia, United States
2011-02-05	Florida Theater Of Gainesville	Gainesville, Florida, United States
2011-02-04	The Engine Room	Tallahassee, Florida, United States
2011-02-03	New Earth Music Hall	Athens, Georgia, United States
2011-02-02	The Pour House	Charleston, South Carolina, United States
2011-02-01	Asheville Music Hall	Asheville, North Carolina, United States
2011-01-29	Big Orbit Soundlab Space	Buffalo, New York, United States
2011-01-28	Music Hall of Williamsburg	New York, New York, United States
2011-01-27	Church	Boston, Massachusetts, United States
2011-01-26	Higher Ground - Ballroom	South Burlington, Vermont, United States
2011-01-25	Daniel Street	Milford, Connecticut, United States
2011-01-24	Now Sapphire Resort	Puerto Morelos, Mexico
2011-01-23	Now Sapphire Resort	Puerto Morelos, Mexico
2011-01-22	Now Sapphire Resort	Puerto Morelos, Mexico
2011-01-21	Now Sapphire Resort	Puerto Morelos, Mexico
2011-01-20	Now Sapphire Resort	Puerto Morelos, Mexico
2010-12-31	Three20south	Breckenridge, Colorado, United States
2010-11-27	Edmonton Events Centre	Edmonton, Alberta, Canada
2010-11-26	Flames Central	Calgary, Alberta, Canada
2010-11-06	Terminal 5	New York, New York, United States
2010-11-05	Franklin Music Hall	Philadelphia, Pennsylvania, United States
2010-11-04	Epic Theatre	Richmond, Virginia, United States
2010-11-04	The Hat Factory	Richmond, Virginia, United States
2010-11-03	9:30 Club	Washington, D.C., United States
2010-10-31	Epic Event Center	Minneapolis, Minnesota, United States
2010-10-30	Aragon Ballroom	Chicago, Illinois, United States
2010-10-30	Byline Bank Aragon Ballroom	Chicago, Illinois, United States
2010-10-29	The Rave-Eagles Club	Milwaukee, Wisconsin, United States
2010-10-28	The Intersection / Showroom	Grand Rapids, Michigan, United States
2010-10-27	Bluebird Nightclub	Bloomington, Indiana, United States
2010-10-26	The Blue Note	Columbia, Missouri, United States
2010-10-25	Liberty Hall	Overland Park, Kansas, United States
2010-10-25	Liberty Hall	Lawrence, Kansas, United States
2010-10-23	1stBANK Center	Broomfield, Colorado, United States
2010-10-21	90 Proof	Knoxville, Tennessee, United States
2010-10-20	Bourbon Theatre	Lincoln, Nebraska, United States
2010-10-15	The Palace Lounge	Missoula, Montana, United States
2010-10-14	Filling Station / VFW	Bozeman, Montana, United States
2010-09-30	New Earth Music Hall	Athens, Georgia, United States
2010-09-25	Tall Tree Lake Music Festival Grounds	Goreville, Illinois, United States
2010-09-24	Motor	Seattle, Washington, United States
2010-09-23	King King	Los Angeles, California, United States
2010-09-18	Black Oak Ranch	Laytonville, California, United States
2010-09-11	Pisgah Brewing Company	Black Mountain, North Carolina, United States
2010-09-10	Neighborhood Theatre	Charlotte, North Carolina, United States
2010-09-09	Awful Arthur's	Blacksburg, Virginia, United States
2010-08-21	Liberate Music & Yoga Festival Grounds	Sheldon, Vermont, United States
2010-08-20	Variety Playhouse	Atlanta, Georgia, United States
2010-08-14	Unit Nightclub	Tokyo, Tokyo, Japan
2010-08-07	Red Rocks Amphitheatre	Morrison, Colorado, United States
2010-08-05	Sunnyview Farm	Ghent, New York, United States
2010-07-18	Miller Brothers Ranch	Salem, Oregon, United States
2010-07-15	Indian Lookout Country Club	Mariaville, New York, United States
2010-07-08	Headliners Music Hall	Louisville, Kentucky, United States
2010-07-02	Prindel Creek Farm	Tidewater, Oregon, United States
2010-06-26	Hog Ridge	Durham, Arkansas, United States
2010-06-06	Bobolink Music Festival Grounds	Belden, California, United States
2010-06-05	Bobolink Music Festival Grounds	Belden, California, United States
2010-06-04	Bobolink Music Festival Grounds	Belden, California, United States
2010-05-29	Oak Canyon Ranch	Irvine, California, United States
2010-05-28	Oak Canyon Ranch	Irvine, California, United States
2010-04-30	Cervantes Masterpiece Ballroom	Denver, Colorado, United States
2010-04-29	Republic Live	Austin, Texas, United States
2010-04-09	Club 828	Knoxville, Tennessee, United States
2010-04-02	Theatre Of Living Arts	Philadelphia, Pennsylvania, United States
2010-04-01	The National	Richmond, Virginia, United States
2010-03-31	Lincoln Theatre	Raleigh, North Carolina, United States
2010-03-26	Brighton Music Hall	Boston, Massachusetts, United States
2010-03-20	Bar Fly	Minneapolis, Minnesota, United States
2010-03-19	Kinetic Playground	Chicago, Illinois, United States
2010-03-06	12th & Porter	Nashville, Tennessee, United States
2010-02-28	Rialto Theatre	Tucson, Arizona, United States
2010-02-27	The Marquee	Tempe, Arizona, United States
2010-02-26	House of Blues - Las Vegas	Las Vegas, Nevada, United States
2010-02-25	The Depot	Salt Lake City, Utah, United States
2010-02-22	The Wilma	Missoula, Montana, United States
2010-02-06	Showbox SoDo	Seattle, Washington, United States
2010-02-05	Roseland Theater	Portland, Oregon, United States
2010-02-04	McDonald Center	Eugene, Oregon, United States
2010-02-03	Arcata Theatre Lounge	Santa Rosa, California, United States
2010-02-03	Arcata Theatre Lounge	Arcata, California, United States
2010-02-02	Crown Hall	Mendocino, CA
2009-11-06	House of Blues Chicago	Chicago, Illinois, United States
2009-11-01	One Eyed Jacks	New Orleans, Louisiana, United States
2009-10-31	The Parish	Austin, Texas, United States
2009-10-16	Fox Theatre	Boulder, Colorado, United States
2009-09-23	Holocene	Portland, Oregon, United States
2009-09-19	Camp Mather	Groveland, California, United States
2009-09-12	Deerfields Amphitheatre	Horse Shoe, North Carolina, United States
2009-09-04	Athens Arena	Bogart, Georgia, United States
2009-09-03	Sky Bar Cafe	Auburn, Alabama, United States
2009-09-02	The Lyric Oxford	Oxford, Mississippi, United States
2009-07-21	Roseland Theater	Portland, Oregon, United States

Code

# Load my dataset cleaned manually
load(here::here(file = 'posts/concert_archives/emancipator_tours.rda'))

Geo coordinates

With the ggmap package, the Location variable can be used to obtain the geo coordinates. Which I want to use for map visuals.

After gathering the geo data from the Location (City, State, Country, lon, lat) I then add which album was most recently released. So we can look into touring after an album release. After which I start asking questions regarding the travels of Emancipator in this data-set.

Geo coord code

# Get geocoordinates
library(ggmap)
addys <- df %>% 
 dplyr::distinct(Location)

# Obtain coordinates using ggmap
geocoded_data <- addys %>%
  ggmap::mutate_geocode(Location)

Code

load(here::here(file = 'posts/concert_archives/geocoded_data.rda'))

# finish joining Add tour data and add concert number and date info
dat <- df %>% 
  mutate(recent_release = case_when(
    Date >= as.numeric(as.Date("2006-01-19")) & Date < as.Date("2010-01-18") ~ 'Soon It Will Be Cold Enough', 
    Date >= as.numeric(as.Date("2010-01-19")) & Date < as.Date("2013-01-28") ~ 'Safe in the Steep Cliffs', 
    Date >= as.numeric(as.Date("2013-01-29")) & Date < as.Date("2015-09-24") ~ 'Dusk to Dawn', 
    Date >= as.numeric(as.Date("2015-09-25")) & Date < as.Date("2017-11-16") ~ 'Seven Seas', 
    Date >= as.numeric(as.Date("2017-11-17")) & Date < as.Date("2020-04-02") ~ 'Baralku', 
    Date >= as.numeric(as.Date("2020-04-03")) & Date < as.Date("2022-09-22") ~ 'Mountin of Memory', 
    Date >= as.numeric(as.Date("2022-09-23")) & Date < as.Date("2024-01-01") ~ '11th Orbit',
    TRUE ~ "11th Orbit")) %>% 
  mutate(recent_release = factor(recent_release, 
                               levels = c('Soon It Will Be Cold Enough', 
                                          'Safe in the Steep Cliffs', 
                                          'Dusk to Dawn', 
                                          'Seven Seas', 
                                          'Baralku', 
                                          'Mountin of Memory', 
                                          '11th Orbit'))
         ) %>% 
  left_join(geocoded_data) %>% 
  distinct(Date, Concert, Venue, Location, lon, lat, recent_release) %>% 
  mutate(Year = substr(Date, 1, 4),
         Month = substr(Date, 6, 7),
         yr_mo = paste0(Year, Month),
         Date = as_date(Date),
         no = row_number())

Which state has Emancipator played the most?

Code

dat %>% 
  separate(Location, c('City', 'State', 'Country'), ", ") %>% 
  group_by(State) %>% 
  count() %>% 
  ungroup() %>% 
  arrange(-n) %>% 
  na.omit() %>% 
  filter(n != 1) %>% 
  ggplot(aes(reorder(State, n), n, label = n)) + 
  geom_col(fill = '#2c7bb6', width = 0.2) + 
  coord_flip() + 
  geom_point(color = '#2c7bb6', size = 4, alpha = .7) +
  silgelib::theme_roboto() + 
  labs(x = '',
       y = 'Number of concerts played') + 
  geom_text(y = -2, size = 3.2)

Travel after an album release

A ton of shows played before the release of Seven Seas. Right before and after starting Loci records.

Code

dat %>%
  group_by(recent_release) %>% 
  count() %>% 
  rename(`Concert count` = n,
         Album = recent_release) %>% 
  kableExtra::kable() %>% 
  kableExtra::kable_paper(full_width = F) %>% 
  kableExtra::scroll_box(height = "300px", width = '600px')

Album	Concert count
Soon It Will Be Cold Enough	11
Safe in the Steep Cliffs	171
Dusk to Dawn	150
Seven Seas	95
Baralku	60
Mountin of Memory	12
11th Orbit	19

What was the busiest travel month?

Looking at each month of the year, February seems to have been, historically, a favorite time for Emancipator to travel. October 2015 there were 24 shows (in 31 days)! That is a lot of traveling. The release of Seven Seas happened in late Sept 2015. I wonder if the ensemble played during this time Doug and Ilya… That is a lot of equipment moving every day.

Code

dat %>%
  group_by(Year, Month) %>%
  count() %>%
  ungroup() %>%
  rename(`Concert count` = n) %>%
  ggplot(aes(x = 'Year', y = `Concert count`, fill = Month)) +
  geom_col(position = 'dodge2') +
  facet_wrap(~Year) +
  theme_bw() + 
  labs(x = '')

Exploration chart for concerts played

You can visually see the amount of concerts played by Emancipator on this timeline. Right after Seven Seas came out they were on the road heavily in October. (You can interact with the chart below!)

Code

library(dygraphs)
library(xts)

xts <- dat %>% 
  select(Date, no, Location) %>% 
  as.xts()

dygraph(xts) %>% 
    dyRangeSelector(dateWindow = c("2014-1-1", "2015-12-31")) %>% 
    dyEvent("2022-9-23", '11th Orbit') %>% 
    dyEvent("2020-4-3", 'Mountain of Memory') %>% 
    dyEvent("2017-11-17", 'Baralku') %>% 
    dyEvent("2015-9-25", 'Seven Seas') %>% 
    dyEvent("2013-1-29", 'Dusk to Dawn') %>% 
    dyEvent("2010-1-19", 'Safe in the Steep Cliffs') %>% 
    dyEvent('2006-1-19', 'Soon It Will Be Cold Enough')

What was the travel schedule for Emancipator in 2015 October

Code

library(maps)
library(sf)
library("rnaturalearth")
library("rnaturalearthdata")

world <- ne_countries(scale = "medium", returnclass = "sf")
states <- st_as_sf(map("state", plot = FALSE, fill = TRUE))

dd <- dat %>% filter(yr_mo == '201510') %>% mutate(Day = lubridate::day(Date))

ggplot(states) + 
  geom_sf(fill = NA, color = 'darkgrey') + 
  geom_point(data = dd, aes(x = lon, y = lat, group = seq_along(Day)), color = 'black') + 
  coord_sf(xlim = c(-97, -67), ylim = c(47, 30), expand = FALSE) + 
  geom_path(data = dd, aes(x = lon, y = lat), color = 'red') + ggrepel::geom_text_repel(data = dd, aes(lon, lat, label = paste0('10-', Day))) + 
  theme_bw() + 
  labs(x = '', y = '', title = 'Emancipators travel October 2015')

Code

library(gganimate)
tr <- ggplot(states) + 
  geom_sf(fill = NA, color = 'darkgrey') + 
  geom_point(data = dd, aes(x = lon, y = lat, group = seq_along(Day)), color = 'black') + 
  coord_sf(xlim = c(-97, -67), ylim = c(47, 30), expand = FALSE) + 
  geom_path(data = dd, aes(x = lon, y = lat), color = 'red') + 
  theme_bw() + 
  transition_reveal(along = Day) + 
  ggtitle("Date: 2015-10-{frame_along}") + 
  labs(x = '', y = '')

animate(tr, nframes = 300)

How was the world travel in this data-set

Some shows in Europe and Australia. But I want to see the majority of the concerts so I will focus on the United States.

Code

ggplot(data = world) + 
    theme_bw() + 
    geom_point(data = dat, aes(x = lon, y = lat), color = "#007d3c", size = 1.5, alpha = .8) + 
    geom_sf(data = world, fill = NA, color = 'darkgrey') + 
    coord_sf(xlim = c(-130, 180), ylim = c(80, -50), expand = FALSE) + 
    theme(axis.title.x = element_blank(),
          axis.text.x = element_blank(),
          axis.ticks.x = element_blank(),
          axis.title.y = element_blank(),
          axis.text.y = element_blank(),
          axis.ticks.y = element_blank(),
    )

Where in the United States did Emancipator travel most

Code

ggplot(data = states) + 
    theme_bw() + 
    geom_density_2d(data = dat, aes(x = lon, y = lat), alpha = .5) +
    geom_point(data = dat, aes(x = lon, y = lat), size = 1.5, alpha = .4) + 
    geom_sf(data = states, fill = NA) + 
    coord_sf(xlim = c(-125, -67), ylim = c(50, 25), expand = FALSE) + 
    theme(axis.title.x = element_blank(),
          axis.text.x = element_blank(),
          axis.ticks.x = element_blank(),
          axis.title.y = element_blank(),
          axis.text.y = element_blank(),
          axis.ticks.y = element_blank(),
    ) +
    guides(fill = "none") + 
    labs(title = 'Emancipators travels 2009-2023')

After album releases

Code

ggplot(data = states) + 
    theme_bw() + 
    geom_density_2d(data = dat, aes(x = lon, y = lat), alpha = .5) +
    geom_point(data = dat, aes(x = lon, y = lat, color = recent_release), size = 1.5) + 
    geom_sf(data = states, fill = NA) + 
    coord_sf(xlim = c(-125, -67), ylim = c(50, 25), expand = FALSE) + 
    theme(axis.title.x = element_blank(),
          axis.text.x = element_blank(),
          axis.ticks.x = element_blank(),
          axis.title.y = element_blank(),
          axis.text.y = element_blank(),
          axis.ticks.y = element_blank(),
          ) +
    labs(title = 'Concerts by album releases') + 
    facet_wrap(~recent_release)   + 
    guides(fill = "none", color = 'none')

By Year

Code

ggplot(data = states) + 
    theme_bw() + 
    geom_density_2d(data = dat, aes(x = lon, y = lat), alpha = .4) +
    geom_point(data = dat, aes(x = lon, y = lat), color = '#007d3c', size = 2, alpha = .8) + 
    geom_sf(data = states, fill = NA) + 
    coord_sf(xlim = c(-125, -67), ylim = c(50, 25), expand = FALSE) + 
    theme(axis.title.x = element_blank(),
          axis.text.x = element_blank(),
          axis.ticks.x = element_blank(),
          axis.title.y = element_blank(),
          axis.text.y = element_blank(),
          axis.ticks.y = element_blank(),
    ) +
    labs(title = 'Concerts by Year') + 
    facet_wrap(~Year)   + 
    guides(fill = "none", color = 'none')

By Month

Code

ggplot(data = states) + 
    theme_bw() + 
    geom_density_2d(data = dat, aes(x = lon, y = lat), alpha = .4) +
    geom_point(data = dat, aes(x = lon, y = lat), color = '#007d3c', size = 2, alpha = .8) + 
    geom_sf(data = states, fill = NA) + 
    coord_sf(xlim = c(-125, -67), ylim = c(50, 25), expand = FALSE) + 
    theme(axis.title.x = element_blank(),
          axis.text.x = element_blank(),
          axis.ticks.x = element_blank(),
          axis.title.y = element_blank(),
          axis.text.y = element_blank(),
          axis.ticks.y = element_blank(),
    ) +
    labs(title = 'Concerts by Month of the year') + 
    facet_wrap(~Month)   + 
    guides(fill = "none", color = 'none')

By Season

Code

season <- dat %>% 
  mutate(season = ifelse(Month %in% c('09', '10', '11'), 'Fall (9-11)', 
                         ifelse(Month %in% c('12', '01', '02'), 'Winter (12-2)',
                                ifelse(Month %in% c('03', '04', '05'), 'Spring (3-5)',
                                       'Summer (6-8)'))))
ggplot(data = states) + 
    theme_bw() + 
    geom_density_2d(data = season, aes(x = lon, y = lat), alpha = .4) +
    geom_point(data = season, aes(x = lon, y = lat), color = '#007d3c', size = 2, alpha = .8) + 
    geom_sf(data = states, fill = NA) + 
    coord_sf(xlim = c(-125, -67), ylim = c(50, 25), expand = FALSE) + 
    theme(axis.title.x = element_blank(),
          axis.text.x = element_blank(),
          axis.ticks.x = element_blank(),
          axis.title.y = element_blank(),
          axis.text.y = element_blank(),
          axis.ticks.y = element_blank(),
    ) +
    labs(title = 'Concerts by season of the year') + 
    facet_wrap(~season)   + 
    guides(fill = "none", color = 'none')

Mountain of Memory was released right as lock-downs started. The entire tour, from what it seems, was canceled. From 2020 April - 2020 May and 2020 July west coast was canceled. 2020 Sept - 2020 Oct on the east coast was canceled. On March 17th, the concerts were supposed to happened as planned, On March 24th the concerts were rescheduled, then at the end of April the rest of the tour was then canceled. One show occurred in Oregon, July 2020.

Code

dat %>% 
  group_by(Year) %>% 
  count(name = 'Concert count') %>% 
  kableExtra::kable() %>% 
  kableExtra::kable_paper(full_width = F) %>% 
  kableExtra::scroll_box(height = "300px", width = '600px')

Year	Concert count
2009	11
2010	59
2011	46
2012	55
2013	65
2014	78
2015	57
2016	47
2017	9
2018	41
2019	16
2020	5
2021	4
2022	16
2023	9

That is it for this post, some visuals on a musical artists travels! Enjoy this awesome live Red Rocks Amphitheater ensemble!