Saved Searches

Title	Description	Query
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...`