Saved Searches

To save a search, you need to have an account and be logged in. Then after you run an Advanced Search, on the results page you will see a button so save the search
Below are all your saved searches, plus a few supplied by Admins.
Title Description Query Actions
Paul Humphrey on drums All the shows we know about with the Paul Humphrey on drums Musician: Paul Humphrey
JGB with Video All the Jerry Garcia Band shows for which we have some video linked Band: Jerry Garcia Band
Video: Yes
OMSN not on Saturday One More Saturday Night's played on days other than Saturday Day of Week: not Saturday
Songs: One More Saturday Night (anywhere)
New Years shows All GD and Garcia shows on New Years Eve Date of Month: 31st
Month: December
Fire not proceeded by Scarlet Shows with Fire on the Mountain not preceded by Scarlet Begonias Songs: Fire On The Mountain (not preceded by Scarlet Begonias)
Fourth of July Shows All the GD and Garcia shows on the 4th of July Date of Month: 4th
Month: July
Chimpbase All GD and Garcia show with a chimp act opening Tags: chimp-act
Halloween shows All the Halloween shows we know about Date of Month: 31st
Month: October
Ramble on Rose in NYC All the times the GD played Ramble on Rose in New York City City: New York
Songs: Ramble On Rose (anywhere)
Garcia and Dylan shared stage All the times Garcia shared the stage with Bob Dylan Musician: Bob Dylan
Help Slip NOT Franklin's All the Help > Slips that were not followed by Franklin's tower Songs: Slipknot! (not followed by Franklin's Tower)
Shows with Branford Marsalis Musician: Branford Marsalis
Start with Sugar Mag end with Sunshine Daydream Shows where they started a set with Sugar Magnolia then ended a set with Sunshine Daydream Songs: Sugar Magnolia (set opener) and Sunshine Daydream (set closer)
Drummer's Birthday Joke Known times Bobby tried the Drummer's Birthday Joke Tags: birthday-joke
Playing -> Uncle John's All times Playing went into Uncle John's Band Songs: Playing In The Band (followed by Uncle John's Band)
Fate Music Events Events making an appearance in Joe Jupille's ''Fate Music'' Tags: fate-music
Beatles tunes in non-GD All the Lennon, McCartney, or Harrison songs played at non-GD shows. Sorry Ringo! SELECT events.event_date, acts.name AS act_name, venues.name AS venue_name, STRING_AGG(songs.name...
Jerry Sings Lovelight All the times we know about the Jerry sang Lovelight SELECT e.event_date, a.name AS act_name, v.name AS venue_name, (SELECT STRING_AGG(s2.name, ', ' O...
Cities the GD played more than 10 times These are all the cities the Grateful Dead played more than 10 shows at, with the dates listed. SELECT v.city, COUNT(*) AS event_count, STRING_AGG(e.event_date::text, ', ' ORDER BY e.event_date...
Top 50 Outdoor shows Hottest GD Shows The "feels like" temp and humidity to try to reconcile that many people (myself included) would have expected RFK 86 and Veneta 72 higher on this list. "Feels like" factors in humidity and wind chill. All data is based on max data points on that day from the closest weather station to the venue. Obviously does not account for local "spaces getting hot". SELECT e.event_date, a.name, v.name, v.city, cast(e.weather->>'tempmax' as double precision) as m...
Full Moon shows We think it was a full moon at these shows. We only have data from 1970 on. Moonphase 0 = new moon, 0.5 = full moon, 1 = next new moon. SELECT e.event_date, e.early_late , a.name, v.name, v.city, cast(e.weather->>'moonphase' as doubl...
Top 50 Coldest Outdoor GD Shows All data is based on max data points on that day from the closest weather station to the venue. SELECT e.event_date, a.name, v.name, v.city, cast(e.weather->>'tempmin' as double precision) as m...
Garcia Hunter breakout dates These are the first times all the Garcia Hunter songs were played live. select x.name song_name, e.event_date, v.name venue, a.name act from (select s.name, min(e.event_...
Runs with Most Distinct Songs Played select r.name, count(distinct e.id) shows, count(distinct s.id) songs from acts a, events e, runs...
Played by Both GD and JGB These are all the songs that were played in public by both the Grateful Dead and the Jerry Garcia Band. select s.name, x.cnt dead_count, count(*) garcia_count, x.gd_dates sample_dead, array_to_string((...
GD Runs with Highest Average Gap These are the runs of Grateful Dead shows with the highest average gap. Song debuts were somewhat arbitrarily assigned a gap of 100. Just showing the top 20. select runs.id as run_id, runs.name as run_name, round(AVG(case WHEN event_songs.events_since ...
First performances of Dylan songs Because I love Dylan. Dylan songs played by GD and Garcia side projects, ordered by date of entry into the repertoire. (Not including performances when Dylan was present). Songs are listed twice if they re-appeared after first appearance, but with a different singer. select song_name, singer_name, min(event_date) first, max(event_date) last, string_agg(distinct...
GD missing stubs (post hiatus) Grateful Dead shows post hiatus (1974) for which Jerrybase needs an image of your ticket stub. select event_date, v.name "venue_name", v.city, v.state from events e, acts a, venues v where not...