| Title | Description | Query | Actions |
|---|---|---|---|
| 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...
|
|
| Chimpbase | All GD and Garcia show with a chimp act opening |
Tags:
chimp-act
|
|
| 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...
|
|
| 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
|
|
| 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)
|
|
| 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...
|
|
| Fourth of July Shows | All the GD and Garcia shows on the 4th of July |
Date of Month:
4th
Month: July |
|
| 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...
|
|
| Garcia and Dylan shared stage | All the times Garcia shared the stage with Bob Dylan |
Musician:
Bob Dylan
|
|
| 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_...
|
|
| 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...
|
|
| 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 ...
|
|
| Halloween shows | All the Halloween shows we know about |
Date of Month:
31st
Month: October |
|
| 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)
|
|
| 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...
|
|
| JGB with Video | All the Jerry Garcia Band shows for which we have some video linked |
Band:
Jerry Garcia Band
Video: Yes |
|
| New Years shows | All GD and Garcia shows on New Years Eve |
Date of Month:
31st
Month: December |
|
| 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) |
|
| Paul Humphrey on drums | All the shows we know about with the Paul Humphrey on drums |
Musician:
Paul Humphrey
|
|
| 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((...
|
|
| Playing -> Uncle John's | All times Playing went into Uncle John's Band |
Songs:
Playing In The Band (followed by Uncle John's Band)
|
|
| 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) |
|
| 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...
|
||
| 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)
|
|
| 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...
|
|
| 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...
|
