SELECT SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate, SongInfo.ShowID, ShowArtists.ShortName, ArtistCategories.CategoryName, DATEDIFF (D, SongInfo.ShowDate, ThisShow.ShowDate) NumDays, ShowInfo.TourID FROM SongInfo INNER JOIN SongInfo ThisShow ON ThisShow.SongID = SongInfo.SongID AND ThisShow.ShowID = 453077475 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID INNER JOIN ArtistCategories ON ShowArtists.ArtistCategoryID = ArtistCategories.CategoryID WHERE (SongInfo.ShowDate < '11/2/2017' OR (SongInfo.ShowDate = '11/2/2017' AND SongInfo.ShowID < 453077475)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 158.9803
TOTAL ITERATIONS: 1
DMBAlmanac.com
   the dave matthews band tour almanac
 home | contact | submit | support us | about
Tours / Stats Songs Lyrics Guests Venues Search Discography Lists  
 · 1991 · 1992 · 1993 · 1994 · 1995 · 1996 · 1997 · 1998 · 1999 · 2000 · 2001 · 2002 · 2003 · 2004 · 2005 · 2006 · 2007 · 2008 · 2009 · 2010 · 
 · 2011 · 2012 · 2013 · 2014 · 2015 · 2016 · 2017 · 2018 · 2019 · 2020 · 2021 · 2022 · 2023 · 2024 · 2025 · 2026 ·  		Live
Setlist
Tour:SummaryShowsSongsGuestsMedia
Dave Matthews (City of Hope Spirit of Life Award Celebration)
The Barker Hangar     Santa Monica, CA
 
Thursday
Sound Check
Don't Drink the Water
Song Spread 
Busted Stuff
2  
Before These Crowded Streets
1  
Come Tomorrow
1  
Coran Capshaw received the Spirit of Life Award at this event sponsored by City of Hope. Other performers were Trey Anastasio, the Preservation Hall Jazz Band, and Joseph.

Setlist may be incomplete and/or out of order.
Song TitleTime  Last  Venue  Personnel 
Notes
1Grey Street   2  1 of 1
2Bartender   0  1 of 1
3Don't Drink the Water   1  1 of 1
4Samurai Cop (Oh Joy Begin)   0  1 of 1
All songs feature the lineup of Dave Matthews unless noted above.
All statistical information and computations copyright ©2002, Matias Nino and Rob Bokon. No portion of dmbalmanac.com may be reproduced without permission. Portions of the site, specifically lyrics and songtitles are copyright Colden Grey, Ltd., Bama Rags Records, Red Light Management, RCA and/or BMG. Show posters are copyright their respective artists.
SongIDArtistIDShowDateShowIDShortNameCategoryNameNumDaysTourID
4919/24/2017 12:00:00 AM453075474DMBDMB393154
49210/3/2017 12:00:00 AM453075454Dave soloDave Side Projects303154
4939/16/2017 12:00:00 AM453072474Dave & TimDave Side Projects473154
49412/13/2003 12:00:00 AM453056046Dave & FriendsDave Side Projects507376
49305511/13/2016 12:00:00 AM453068410Dave & Carlos VarelaDave Side Projects3541154
6519/3/2016 12:00:00 AM453065437DMBDMB4252154
65210/4/2017 12:00:00 AM453075455Dave soloDave Side Projects293154
6536/17/2017 12:00:00 AM453071424Dave & TimDave Side Projects1385154
6542/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects428986
65212/20/2000 12:00:00 AM453055865Dave & Emmylou HarrisDave Side Projects646515
7519/24/2017 12:00:00 AM453075474DMBDMB393154
75210/2/2017 12:00:00 AM453076475Dave soloDave Side Projects313154
7536/18/2017 12:00:00 AM453071425Dave & TimDave Side Projects1375154
487319/3/2016 12:00:00 AM453065437DMBDMB4252154
4873210/4/2017 12:00:00 AM453075455Dave soloDave Side Projects293154
487336/18/2017 12:00:00 AM453071425Dave & TimDave Side Projects1375154
4873305511/13/2016 12:00:00 AM453068410Dave & Carlos VarelaDave Side Projects3541154
4873305811/1/2016 12:00:00 AM453068422Joshua BellOpeners and Collaborators3661154
SongIDArtistIDShowDateShowIDShortNameCategoryNameNumDaysTourID
4914/18/1998 12:00:00 AM453054683DMBDMB713823
4927/1/1998 12:00:00 AM453056508Dave soloDave Side Projects706423
4931/19/1999 12:00:00 AM453054573Dave & TimDave Side Projects686216
49412/13/2003 12:00:00 AM453056046Dave & FriendsDave Side Projects507376
49305511/13/2016 12:00:00 AM453068410Dave & Carlos VarelaDave Side Projects3541154
6516/19/2000 12:00:00 AM453054398DMBDMB634513
6523/8/1999 12:00:00 AM453056428Dave soloDave Side Projects681462
6531/29/1999 12:00:00 AM453054581Dave & TimDave Side Projects685216
65412/12/2003 12:00:00 AM453056045Dave & FriendsDave Side Projects507476
65212/20/2000 12:00:00 AM453055865Dave & Emmylou HarrisDave Side Projects646515
7516/19/2000 12:00:00 AM453054398DMBDMB634513
7525/13/2006 12:00:00 AM453056319Dave soloDave Side Projects419186
7533/19/2003 12:00:00 AM453055948Dave & TimDave Side Projects534270
487315/7/2016 12:00:00 AM453067393DMBDMB5442154
487326/6/2016 12:00:00 AM453067401Dave soloDave Side Projects5141154
487337/6/2016 12:00:00 AM453067395Dave & TimDave Side Projects4841154
4873305511/13/2016 12:00:00 AM453068410Dave & Carlos VarelaDave Side Projects3541154
4873305811/1/2016 12:00:00 AM453068422Joshua BellOpeners and Collaborators3661154