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 = 453065420 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 < '7/12/2016' OR (SongInfo.ShowDate = '7/12/2016' AND SongInfo.ShowID < 453065420)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 407.2514
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
Setlist
Ticket
All media for this show (3)
Tuesday - Night 1 of 2
Total Song Time
2 hours and 10 minutes and 39 seconds
Setlist Changes
All Along the Watchtower cut, replaced with Tripping Billies
Song Rarity Rank: 30 of 45
Song Spread 
Under the Table and Dreaming
4  
Everyday
2  
Unreleased
2  
Big Whiskey and the GrooGrux King
2  
Come Tomorrow
2  
Remember Two Things
1  
Crash
1  
Before These Crowded Streets
1  
Busted Stuff
1  
Dave Matthews - Some Devil
1  
Stand Up
1  
Away from the World
1  
Song Title   [ ]Time  Last  Tour  Venue  Personnel 
Notes
1When the World Ends 3:26   6  13 of 191 of 4
2What Would You Say 4:54   4  12 of 181 of 4
3Warehouse »10:09   1  20 of 281 of 6
4Minarets 6:46   1  13 of 181 of 4Dave scat/Carter rap intro with Slow and Low interpolation
5Again and Again 4:46   1  21 of 271 of 2
6Grey Street 5:58   2  20 of 281 of 6
7Sugar Will 6:19   2  11 of 131 of 2
8Crush 15:51   1  15 of 231 of 6Stefan solo intro
9Death on the High Seas 5:29   14 of 191 of 1
10Why I Am 3:59  SD16 of 251 of 1Longest documented version played at the time of this show 
11Dancing Nancies 9:44   1  10 of 141 of 6 (lyrics)
 The Space Between [aborted]  0:11   2    Dave solo
12The Space Between 5:08   2  9 of 121 of 4
13Idea of You 4:33  SD3 of 91 of 3 (lyrics)
14Rooftop 5:33   10  4 of 91 of 3
15You Might Die Trying 7:45  SD16 of 241 of 5
16You & Me 4:32   11 of 181 of 3
17Jimi Thing »15:04   2  17 of 241 of 6
 Sexy M.F. [partial]  1:58   17 of 241 of 3
18Oh 2:56   3  2 of 71 of 2Dave, Carter, Tim
19Tripping Billies 5:38   4  12 of 171 of 5theme from Lost in Space interpolation
All songs feature the lineup of Dave Matthews, Carter Beauford, Stefan Lessard, Boyd Tinsley, Rashawn Ross, Tim Reynolds, and Jeff Coffin unless noted above.
Rarity  Rank  Tour  So Far 
Song  30 of 452.5372.305
Guest  8 of 81.7321.732
Opener  5 of 67.8339.667
Closer  6 of 63.6152.900
Encore  19 of 225.2224.833
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
517/9/2016 12:00:00 AM453065419DMBDMB32154
524/14/1996 12:00:00 AM453055124Dave soloDave Side Projects739431
537/6/2016 12:00:00 AM453067395Dave & TimDave Side Projects61154
542/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects381186
617/1/2016 12:00:00 AM453065416DMBDMB112154
625/12/2006 12:00:00 AM453056318Dave soloDave Side Projects371486
637/6/2016 12:00:00 AM453067395Dave & TimDave Side Projects61154
6154/14/1995 12:00:00 AM453055192Dave & BoydDMB776041
1017/1/2016 12:00:00 AM453065416DMBDMB112154
1024/14/1996 12:00:00 AM453055124Dave soloDave Side Projects739431
1039/19/2015 12:00:00 AM453063381Dave & TimDave Side Projects297127
10411/13/2004 12:00:00 AM453056220Dave & FriendsDave Side Projects425979
1091168/18/1995 12:00:00 AM453089621Dave, Roi & StefanDMB763441
1817/9/2016 12:00:00 AM453065419DMBDMB32154
1825/4/1993 12:00:00 AM453055554Dave soloDave Side Projects847053
1831/17/2015 12:00:00 AM453058208Dave & TimDave Side Projects542127
1917/8/2016 12:00:00 AM453065418DMBDMB42154
1924/14/1996 12:00:00 AM453055124Dave soloDave Side Projects739431
1931/17/2015 12:00:00 AM453058208Dave & TimDave Side Projects542127
1942/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects381186
19144/29/1996 12:00:00 AM453055126Dave, Boyd & StefanDMB737931
2017/9/2016 12:00:00 AM453065419DMBDMB32154
2025/15/2006 12:00:00 AM453056320Dave soloDave Side Projects371186
2037/6/2016 12:00:00 AM453067395Dave & TimDave Side Projects61154
2042/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects381186
201412/15/1994 12:00:00 AM453055332Dave, Boyd & StefanDMB788052
20154/14/1995 12:00:00 AM453055192Dave & BoydDMB776041
2091279/8/2002 12:00:00 AM453055882Dave & Jason Mraz's BandDave Side Projects505632
5517/9/2016 12:00:00 AM453065419DMBDMB32154
5529/2/2015 12:00:00 AM453064388Dave soloDave Side Projects314127
5537/6/2016 12:00:00 AM453067395Dave & TimDave Side Projects61154
55411/13/2004 12:00:00 AM453056220Dave & FriendsDave Side Projects425979
5510249/4/2014 12:00:00 AM453057206Dave, Tim & RashawnDMB677122
7517/8/2016 12:00:00 AM453065418DMBDMB42154
7522/17/2012 12:00:00 AM453056972Dave soloDave Side Projects1607116
7531/17/2015 12:00:00 AM453058208Dave & TimDave Side Projects542127
7716/28/2016 12:00:00 AM453065414DMBDMB142154
77211/13/2001 12:00:00 AM62Dave soloDave Side Projects53551
7731/16/2015 12:00:00 AM453058207Dave & TimDave Side Projects543127
8017/8/2016 12:00:00 AM453065418DMBDMB42154
8029/2/2015 12:00:00 AM453064388Dave soloDave Side Projects314127
8039/19/2015 12:00:00 AM453063381Dave & TimDave Side Projects297127
23617/2/2016 12:00:00 AM453065417DMBDMB102154
23629/24/2011 12:00:00 AM453056962Dave soloDave Side Projects1753114
23637/6/2016 12:00:00 AM453067395Dave & TimDave Side Projects61154
23642/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects381186
27917/8/2016 12:00:00 AM453065418DMBDMB42154
58629/2/2015 12:00:00 AM453064388Dave soloDave Side Projects314127
58637/6/2016 12:00:00 AM453067395Dave & TimDave Side Projects61154
605127/3/1993 12:00:00 AM453089752C-ville AllstarsCarter Side Projects841053
73216/21/2016 12:00:00 AM453065410DMBDMB212154
283337/6/2016 12:00:00 AM453067395Dave & TimDave Side Projects61154
487417/9/2016 12:00:00 AM453065419DMBDMB32154
SongIDArtistIDShowDateShowIDShortNameCategoryNameNumDaysTourID
513/14/1991 12:00:00 AM453056860DMBDMB925265
525/2/1992 12:00:00 AM453055635Dave soloDave Side Projects883757
534/22/1993 12:00:00 AM453055550Dave & TimDave Side Projects848253
542/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects381186
618/31/1991 12:00:00 AM453056808DMBDMB908265
629/11/1992 12:00:00 AM453055702Dave soloDave Side Projects870557
634/22/1993 12:00:00 AM453055550Dave & TimDave Side Projects848253
6151/14/1994 12:00:00 AM453055373Dave & BoydDMB821563
1018/31/1991 12:00:00 AM453056808DMBDMB908265
1024/14/1996 12:00:00 AM453055124Dave soloDave Side Projects739431
1038/25/1994 12:00:00 AM453055361Dave & TimDave Side Projects799252
10411/13/2004 12:00:00 AM453056220Dave & FriendsDave Side Projects425979
1091168/18/1995 12:00:00 AM453089621Dave, Roi & StefanDMB763441
1819/20/1991 12:00:00 AM453056809DMBDMB906265
1825/2/1992 12:00:00 AM453055635Dave soloDave Side Projects883757
1834/22/1993 12:00:00 AM453055550Dave & TimDave Side Projects848253
1918/31/1991 12:00:00 AM453056808DMBDMB908265
1924/14/1996 12:00:00 AM453055124Dave soloDave Side Projects739431
1939/26/1994 12:00:00 AM453055276Dave & TimDave Side Projects796052
19410/29/2005 12:00:00 AM453056234Dave & FriendsDave Side Projects390984
191412/15/1994 12:00:00 AM453055332Dave, Boyd & StefanDMB788052
2018/31/1991 12:00:00 AM453056808DMBDMB908265
2025/2/1992 12:00:00 AM453055635Dave soloDave Side Projects883757
2034/22/1993 12:00:00 AM453055550Dave & TimDave Side Projects848253
20412/12/2003 12:00:00 AM453056045Dave & FriendsDave Side Projects459676
201412/15/1994 12:00:00 AM453055332Dave, Boyd & StefanDMB788052
20153/10/1994 12:00:00 AM453089625Dave & BoydDMB816052
2091279/8/2002 12:00:00 AM453055882Dave & Jason Mraz's BandDave Side Projects505632
5514/18/1998 12:00:00 AM453054683DMBDMB666023
5529/29/2001 12:00:00 AM55Dave soloDave Side Projects54001
5531/20/1999 12:00:00 AM453054574Dave & TimDave Side Projects638316
55412/12/2003 12:00:00 AM453056045Dave & FriendsDave Side Projects459676
5510249/4/2014 12:00:00 AM453057206Dave, Tim & RashawnDMB677122
7516/19/2000 12:00:00 AM453054398DMBDMB586713
7525/13/2006 12:00:00 AM453056319Dave soloDave Side Projects371386
7533/19/2003 12:00:00 AM453055948Dave & TimDave Side Projects486470
7714/21/2001 12:00:00 AM2DMBDMB55612
7725/26/2001 12:00:00 AM453055807Dave soloDave Side Projects55261
7733/19/2003 12:00:00 AM453055948Dave & TimDave Side Projects486470
8012/24/2001 12:00:00 AM453055934DMBDMB56171
8022/23/2001 12:00:00 AM453055792Dave soloDave Side Projects561833
8037/15/2012 12:00:00 AM453057034Dave & TimDave Side Projects1458116
23616/1/2013 12:00:00 AM453057090DMBDMB1137120
23621/9/2004 12:00:00 AM453056065Dave soloDave Side Projects456879
236310/28/2005 12:00:00 AM453056235Dave & TimDave Side Projects391084
236412/12/2003 12:00:00 AM453056045Dave & FriendsDave Side Projects459676
27916/17/2004 12:00:00 AM453056075DMBDMB440880
30115/9/2005 12:00:00 AM453056223DMBDMB408284
37016/2/2006 12:00:00 AM453056268DMBDMB369387
58314/14/2009 12:00:00 AM453056612DMBDMB2646103
58616/6/2009 12:00:00 AM453056644DMBDMB2593106
586211/13/2009 12:00:00 AM453056750Dave soloDave Side Projects2433104
58637/6/2009 12:00:00 AM453056712Dave & TimDave Side Projects2563104
605127/3/1993 12:00:00 AM453089752C-ville AllstarsCarter Side Projects841053
73219/8/2012 12:00:00 AM453057012DMBDMB1403117
283316/12/2015 12:00:00 AM453060220DMBDMB396128
283337/6/2016 12:00:00 AM453067395Dave & TimDave Side Projects61154
487415/7/2016 12:00:00 AM453067393DMBDMB662154