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 = 453079488 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 < '6/12/2018' OR (SongInfo.ShowDate = '6/12/2018' AND SongInfo.ShowID < 453079488)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 390.6991
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:SummaryShowsSongsGuestsSlotsLiberationsMediaSong Chart
Dave Matthews Band
Bank of New Hampshire Pavilion     Gilford, NH
 
Poster
Ticket
All media for this show (2)
Tuesday - Night 1 of 2
Total Song Time
2 hours and 18 minutes and 40 seconds
Song Rarity Rank: 16 of 43
Song Spread 
Come Tomorrow
4  
Under the Table and Dreaming
2  
Crash
2  
Before These Crowded Streets
2  
Misc Release
2  
Dave Matthews - Some Devil
2  
Stand Up
2  
Big Whiskey and the GrooGrux King
2  
Remember Two Things
1  
Everyday
1  
Unreleased
1  
Song Title   [ ]Time  Last  Tour  Venue  Personnel 
Notes
1Again and Again 4:10   17, TD 1 of 252 of 2first time played as an opener
2So Right 7:05   4  2 of 91 of 3
3Granny 4:22   4  6 of 112 of 6
4#41 12:42   1  8 of 232 of 5Sojourn of Arjuna and Common Free Style interpolations
5Can't Stop 4:46   1  7 of 271 of 3
6Hello Again 5:04   2  6 of 91 of 1
7Recently 7:51   3  5 of 71 of 3
8Funny the Way It Is 5:02   7  3 of 152 of 5
9Gravedigger 5:41   2 of 41 of 2Carter solo intro
10Jimi Thing »14:07   2  4 of 202 of 6
 Sexy M.F. [partial]  3:40   4 of 202 of 3
11Satellite 4:56   2  8 of 251 of 2
12Corn Bread 8:47   5  2 of 91 of 1Carter solo intro; Down by the Riverside interpolation
13Samurai Cop (Oh Joy Begin) 4:58   1  13 of 392 of 5
14So Much to Say 4:15   6  2 of 101 of 3
15Lying in the Hands of God 11:59   1  9 of 171 of 2Bourbons & Lacs and American Baby Intro interpolations
16She 5:11  SD9 of 271 of 1
17Save Me 4:45   6  2 of 21 of 1
18Louisiana Bayou 8:19   12 of 301 of 3
19Sister 3:31   1  5 of 101 of 2Dave, Carter, Rashawn, Tim
 Pantala Naga Pampa »0:40   2  7 of 181 of 5
20Rapunzel 6:49   2  7 of 181 of 4
All songs feature the lineup of Dave Matthews, Carter Beauford, Stefan Lessard, Rashawn Ross, Tim Reynolds, Jeff Coffin, and Buddy Strong unless noted above.
Rarity  Rank  Tour  So Far 
Song  16 of 432.7892.301
Guest  7 of 72.0002.000
Opener  5 of 77.83313.000
Closer  4 of 59.4004.333
Encore  18 of 215.8754.333
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
316/6/2018 12:00:00 AM453079485DMBDMB66156
3210/21/2001 12:00:00 AM58Dave soloDave Side Projects60781
331/14/2018 12:00:00 AM453074457Dave & TimDave Side Projects1495156
31412/15/1994 12:00:00 AM453055332Dave, Boyd & StefanDMB858052
3151/14/1994 12:00:00 AM453055373Dave & BoydDMB891563
1116/7/2018 12:00:00 AM453079486DMBDMB56156
1124/20/2018 12:00:00 AM453079538Dave soloDave Side Projects535156
1131/28/2018 12:00:00 AM453079475Dave & TimDave Side Projects1355156
11412/17/2003 12:00:00 AM453056049Dave & FriendsDave Side Projects529176
11151/14/1994 12:00:00 AM453055373Dave & BoydDMB891563
1916/7/2018 12:00:00 AM453079486DMBDMB56156
1924/14/1996 12:00:00 AM453055124Dave soloDave Side Projects809431
1931/12/2018 12:00:00 AM453074455Dave & TimDave Side Projects1515156
1942/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects451186
19144/29/1996 12:00:00 AM453055126Dave, Boyd & StefanDMB807931
2116/1/2018 12:00:00 AM453079482DMBDMB116156
2125/13/2006 12:00:00 AM453056319Dave soloDave Side Projects441386
2131/13/2018 12:00:00 AM453074456Dave & TimDave Side Projects1505156
3016/5/2018 12:00:00 AM453079484DMBDMB76156
3025/15/2006 12:00:00 AM453056320Dave soloDave Side Projects441186
3031/13/2018 12:00:00 AM453074456Dave & TimDave Side Projects1505156
301412/15/1994 12:00:00 AM453055332Dave, Boyd & StefanDMB858052
4116/9/2018 12:00:00 AM453079487DMBDMB36156
4124/20/2018 12:00:00 AM453079538Dave soloDave Side Projects535156
4131/28/2018 12:00:00 AM453079475Dave & TimDave Side Projects1355156
4142/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects451186
4183/13/2011 12:00:00 AM453056925Secret StashStefan Side Projects2648114
41144/29/1996 12:00:00 AM453055126Dave, Boyd & StefanDMB807931
41305511/13/2016 12:00:00 AM453068410Dave & Carlos VarelaDave Side Projects5761154
5616/7/2018 12:00:00 AM453079486DMBDMB56156
5631/14/2018 12:00:00 AM453074457Dave & TimDave Side Projects1495156
5716/7/2018 12:00:00 AM453079486DMBDMB56156
5731/26/2017 12:00:00 AM453068420Dave & TimDave Side Projects5023154
5742/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects451186
8316/5/2018 12:00:00 AM453079484DMBDMB76156
20524/13/2011 12:00:00 AM453056930Dave soloDave Side Projects2617114
20531/13/2018 12:00:00 AM453074456Dave & TimDave Side Projects1505156
20542/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects451186
20591279/8/2002 12:00:00 AM453055882Dave & Jason Mraz's BandDave Side Projects575632
2051012811/7/2003 12:00:00 AM453056043Dave and Friends & Emmylou HarrisDave Side Projects533175
23516/1/2018 12:00:00 AM453079482DMBDMB116156
23521/6/2018 12:00:00 AM453078476Dave soloDave Side Projects1575156
23531/28/2018 12:00:00 AM453079475Dave & TimDave Side Projects1355156
23542/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects451186
235305511/13/2016 12:00:00 AM453068410Dave & Carlos VarelaDave Side Projects5761154
2351012811/7/2003 12:00:00 AM453056043Dave and Friends & Emmylou HarrisDave Side Projects533175
27816/7/2018 12:00:00 AM453079486DMBDMB56156
295714/20/2006 12:00:00 AM453063333Robert Randolph & The Family BandOpeners and Collaborators44361145
30416/9/2018 12:00:00 AM453079487DMBDMB36156
304210/4/2017 12:00:00 AM453075455Dave soloDave Side Projects2513154
30431/14/2018 12:00:00 AM453074457Dave & TimDave Side Projects1495156
37616/9/2018 12:00:00 AM453079487DMBDMB36156
37631/15/2014 12:00:00 AM453057148Dave & TimDave Side Projects1609122
44016/2/2018 12:00:00 AM453079483DMBDMB106156
44031/28/2018 12:00:00 AM453079475Dave & TimDave Side Projects1355156
57116/9/2018 12:00:00 AM453079487DMBDMB36156
57127/28/2011 12:00:00 AM453056947Dave soloDave Side Projects2511114
57131/28/2018 12:00:00 AM453079475Dave & TimDave Side Projects1355156
57915/30/2018 12:00:00 AM453079481DMBDMB136156
57921/6/2018 12:00:00 AM453078476Dave soloDave Side Projects1575156
57931/13/2018 12:00:00 AM453074456Dave & TimDave Side Projects1505156
605127/3/1993 12:00:00 AM453089752C-ville AllstarsCarter Side Projects911053
487316/9/2018 12:00:00 AM453079487DMBDMB36156
487326/11/2018 12:00:00 AM453080545Dave soloDave Side Projects15156
487331/28/2018 12:00:00 AM453079475Dave & TimDave Side Projects1355156
4873305511/13/2016 12:00:00 AM453068410Dave & Carlos VarelaDave Side Projects5761154
4873305811/1/2016 12:00:00 AM453068422Joshua BellOpeners and Collaborators5881154
487419/2/2016 12:00:00 AM453065436DMBDMB6482154
SongIDArtistIDShowDateShowIDShortNameCategoryNameNumDaysTourID
313/14/1991 12:00:00 AM453056860DMBDMB995265
325/2/1992 12:00:00 AM453055635Dave soloDave Side Projects953757
334/22/1993 12:00:00 AM453055550Dave & TimDave Side Projects918253
31412/15/1994 12:00:00 AM453055332Dave, Boyd & StefanDMB858052
3151/14/1994 12:00:00 AM453055373Dave & BoydDMB891563
1118/31/1991 12:00:00 AM453056808DMBDMB978265
1129/11/1992 12:00:00 AM453055702Dave soloDave Side Projects940557
1134/22/1993 12:00:00 AM453055550Dave & TimDave Side Projects918253
11412/15/2003 12:00:00 AM453056047Dave & FriendsDave Side Projects529376
11151/14/1994 12:00:00 AM453055373Dave & BoydDMB891563
1918/31/1991 12:00:00 AM453056808DMBDMB978265
1924/14/1996 12:00:00 AM453055124Dave soloDave Side Projects809431
1939/26/1994 12:00:00 AM453055276Dave & TimDave Side Projects866052
19410/29/2005 12:00:00 AM453056234Dave & FriendsDave Side Projects460984
191412/15/1994 12:00:00 AM453055332Dave, Boyd & StefanDMB858052
2112/13/1992 12:00:00 AM453055738DMBDMB961656
2129/11/1992 12:00:00 AM453055702Dave soloDave Side Projects940557
2134/22/1993 12:00:00 AM453055550Dave & TimDave Side Projects918253
30111/17/1992 12:00:00 AM453055606DMBDMB933856
3025/4/1993 12:00:00 AM453055554Dave soloDave Side Projects917053
3034/22/1993 12:00:00 AM453055550Dave & TimDave Side Projects918253
301412/15/1994 12:00:00 AM453055332Dave, Boyd & StefanDMB858052
4114/7/1995 12:00:00 AM453055187DMBDMB846737
4124/14/1996 12:00:00 AM453055124Dave soloDave Side Projects809431
4132/1/1996 12:00:00 AM453054992Dave & TimDave Side Projects816727
41412/20/2003 12:00:00 AM453056051Dave & FriendsDave Side Projects528876
4183/13/2011 12:00:00 AM453056925Secret StashStefan Side Projects2648114
41144/29/1996 12:00:00 AM453055126Dave, Boyd & StefanDMB807931
41305511/13/2016 12:00:00 AM453068410Dave & Carlos VarelaDave Side Projects5761154
56111/29/1994 12:00:00 AM453055320DMBDMB859645
5631/19/1999 12:00:00 AM453054573Dave & TimDave Side Projects708416
5714/18/1998 12:00:00 AM453054683DMBDMB736023
5731/19/1999 12:00:00 AM453054573Dave & TimDave Side Projects708416
57410/29/2005 12:00:00 AM453056234Dave & FriendsDave Side Projects460984
8314/21/2001 12:00:00 AM2DMBDMB62612
20515/28/2002 12:00:00 AM453055851DMBDMB585912
20527/12/2002 12:00:00 AM453055902Dave soloDave Side Projects581466
20533/19/2003 12:00:00 AM453055948Dave & TimDave Side Projects556470
205412/12/2003 12:00:00 AM453056045Dave & FriendsDave Side Projects529676
20591279/8/2002 12:00:00 AM453055882Dave & Jason Mraz's BandDave Side Projects575632
2051012811/7/2003 12:00:00 AM453056043Dave and Friends & Emmylou HarrisDave Side Projects533175
23515/19/2012 12:00:00 AM453056975DMBDMB2215117
23528/6/2003 12:00:00 AM453056038Dave soloDave Side Projects542475
235310/28/2005 12:00:00 AM453056235Dave & TimDave Side Projects461084
235411/8/2003 12:00:00 AM453056058Dave & FriendsDave Side Projects533075
235305511/13/2016 12:00:00 AM453068410Dave & Carlos VarelaDave Side Projects5761154
2351012811/7/2003 12:00:00 AM453056043Dave and Friends & Emmylou HarrisDave Side Projects533175
27816/17/2004 12:00:00 AM453056075DMBDMB510880
29514/30/2005 12:00:00 AM453056213DMBDMB479184
295714/20/2006 12:00:00 AM453063333Robert Randolph & The Family BandOpeners and Collaborators44361145
30415/30/2006 12:00:00 AM453056266DMBDMB439687
30425/11/2006 12:00:00 AM453056332Dave soloDave Side Projects441586
304310/27/2006 12:00:00 AM453056382Dave & TimDave Side Projects424686
37616/23/2006 12:00:00 AM453056280DMBDMB437287
37632/24/2007 12:00:00 AM453056399Dave & TimDave Side Projects412691
44018/1/2007 12:00:00 AM453056468DMBDMB396896
44032/23/2007 12:00:00 AM453056398Dave & TimDave Side Projects412791
57116/6/2009 12:00:00 AM453056644DMBDMB3293106
571211/13/2009 12:00:00 AM453056750Dave soloDave Side Projects3133104
57136/25/2009 12:00:00 AM453056713Dave & TimDave Side Projects3274104
57914/14/2009 12:00:00 AM453056612DMBDMB3346103
57928/26/2011 12:00:00 AM453056953Dave soloDave Side Projects2482114
57936/25/2009 12:00:00 AM453056713Dave & TimDave Side Projects3274104
605127/3/1993 12:00:00 AM453089752C-ville AllstarsCarter Side Projects911053
487315/7/2016 12:00:00 AM453067393DMBDMB7662154
487326/6/2016 12:00:00 AM453067401Dave soloDave Side Projects7361154
487337/6/2016 12:00:00 AM453067395Dave & TimDave Side Projects7061154
4873305511/13/2016 12:00:00 AM453068410Dave & Carlos VarelaDave Side Projects5761154
4873305811/1/2016 12:00:00 AM453068422Joshua BellOpeners and Collaborators5881154
487415/7/2016 12:00:00 AM453067393DMBDMB7662154
1694415/19/2018 12:00:00 AM453079477DMBDMB246156