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
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...`
JGB distinct songs at Warfield runs		`SELECT runs.id AS run_id, runs.NAME AS run, Count(DISTINCT songs.NAME), ...`
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((...`
Jerry triple shot	Three songs in row at a GD show sung by Jerry, and time after 1980.	`SELECT e.event_date, a.name AS act_name, v.name AS venue_name, s1.name AS song_1, s2.na...`
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...`
JGB distinct songs by year	1976 does not really count due to the James Booker stint, and a lot of the songs from 1975 are just Nicky singing with the band applying minimal backup.	`SELECT TO_CHAR(events.event_date, 'YYYY') AS year, Count(DISTINCT songs.NAME), ...`
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...`
All the shows in Golden Gate Park	These are all the events we are tracking that featured Jerry Garcia playing in Golden Gate Park.	`SELECT events.event_date, acts.name AS act_name, venues.name AS venue_name FROM events JOIN acts ...`
All the Jerry shows outside the US	All the times Jerry played (or tried to) outside the US	`SELECT e.event_date, a.NAME AS Act, v.NAME AS Venue, v.country, ...`
All the Jerry shows in England	All the times Jerry played (or tried to play) in the Land of Hope and Glory	`SELECT e.event_date, a.NAME AS Act, v.NAME AS Venue, v.city, CASE ...`
GD played same song consecutive nights since 1983	All the times the Grateful Dead played the same song at the same venue two nights in a row. Just looking at 1983 onward, when this practice became exceedingly rare.	`select v.name venue, s.name song, tab.event_date first_date, e.event_date second_date from event_...`
GD shows with no circulating recording	These are all the GD shows with no torrent and no presence on an official release.	`SELECT e.event_date, a.NAME AS act, v.NAME AS venue, ( ...`
GOTS without John Kahn	Times that Jerry played a gig with "Jerry Garcia Band" or "Jerry Garcia and Merl Saunders" without John Kahn. There were no Legion of Mary, Reconstruction or Old and In the Way shows with Jerry but without John.	`select event_date, name, array_to_string(musicians_list, ', ') as musicians from ( ...`
All Acts appearing with the Grateful Dead	Most of these are openers, but in the early days the GD themselves we often acting as support.	`SELECT events.event_date, acts.name AS act_name, venues.name AS venue_name, string_agg(op...`
GOTS shows with no circulating recording	These are all the GOTS (Garcia On the Side, aka non-GD) shows with no torrent and no presence on an official release.	`SELECT e.event_date, a.NAME AS act, v.NAME AS venue, ( ...`
Dylan and the Beatles	All the times the Grateful Dead played both a Dylan and Beatles song in the same set.	`SELECT events.event_date, acts.name AS act_name, venues.name AS venue_name, event_sets.na...`
JGB guests by year	Counts for guest musicians by year for the Good 'Ol Jerry Garcia Band	`SELECT to_char(events.event_date, 'YYYY') AS year, COUNT(DISTINCT events.id) AS show_count, ...`
True Sit-Ins	Every time JG sat in with a band that wasn't his.	`SELECT events.event_date AS DATE, acts.name AS ACT, ( venues.name \|\| ', ' \|\| venues.cit...`
Dylan vs. Beatles songs by year	Count of Dylan and Beatles songs played each year by the Grateful Dead	`WITH dylan_counts AS ( SELECT EXTRACT( YEAR FROM events.eve...`
outta Space		`SELECT songs.name AS song_name, COUNT(*) AS times_followed_space FROM event_songs es INNER JOIN e...`