Setlist Statistics (pjdb.net)

Roeland

Hi guys, I've been working on a site that collects all PJ setlists and calculates some fun statistics. The main features are

• Statistics per song(s), album(s), show(s), part of a show (main set, encore, ...)
• Filters to apply to only include shows played in a country or at a venue, between two dates or to exclude types of shows (e.g. Eddie solo shows)
• Personal stats: you can create an account, register the shows you have attended and view all stats for the shows you attended
• Setlist finder to find shows were certain songs have been played

I've just put a first version of it online at http://www.pjdb.net .

Let me know what you think. Any suggestions, remarks or comments are welcome. Certain data, especially venues, can still use some cleanup, so if you note any errors, please let me know.

RE4790

I like this, but the menu structure feels awkward. Other than that the only thing that's a bit weird is the ordering on your list of entries under "song played" on the rules section of the find setlist page.

MK13579

Have you seen www.livefootsteps.org

vedder_soup

great idea, but you need to be able to search for a show! or a country, or a city
Very hard to create your stats if you can't easily find the shows you have attended

Roeland

RE4790 wrote:

I like this, but the menu structure feels awkward. Other than that the only thing that's a bit weird is the ordering on your list of entries under "song played" on the rules section of the find setlist page.

The songs are sorted per album, and albums most recent to oldest. There were "sublabels" included with the album titles but the script which makes the dropdown box searchable (you can click the box and type something to filter the songs) messes with those labels.

vedder_soup wrote:

great idea, but you need to be able to search for a show! or a country, or a city
Very hard to create your stats if you can't easily find the shows you have attended

You can search for shows on the My Shows page by entering text in the fields at the top:

If you enter a text, the table will filter the column below on that value, for example:

Gold 26

In the opening songs section you've got 'Can't Keep' twice, on 17 and 7.

Riverrunner

Awesome! Thank you. I don't have (or want) an Iphone so I have been waiting for this.

vedder_soup

Can EV shows be separated from PJ shows?
Not a true representation of show stats

RE4790

Is it query-able by other code? Like a "GET" type string to extract records? Would be cool since it would allow for a mobile ecosystem to evolve to leverage what you have already done. If the various PJ related mobile apps could use this as the foundational dataset for concerts, they could focus on other things like the social networking aspects, ticket trades, the old "where's your 10c seat?" database that touringfans used to do, etc.

Roeland

vedder_soup wrote:

Can EV shows be separated from PJ shows?
Not a true representation of show stats

You can select PJ shows only or EV shows only through a filter: Filters (top right) > edit Filters > Show types filters

RE4790 wrote:

Is it query-able by other code? Like a "GET" type string to extract records? Would be cool since it would allow for a mobile ecosystem to evolve to leverage what you have already done. If the various PJ related mobile apps could use this as the foundational dataset for concerts, they could focus on other things like the social networking aspects, ticket trades, the old "where's your 10c seat?" database that touringfans used to do, etc.

I could set up an XML feed (or other) if someone is interested in doing something with it.

dimitrispearljam

just greate an acount,great job,thank you.

Wilds

Bump for the greatest statistical website in the Pearl Jam world.

Thanks So Much....


Will write more later, but now, on to the loading of my concerts!!!!

ikiT

No Ukelele Stats, although Sleeping by Myself Ed and Sleeping by Myself PJ aren't separate. Prob the same for Cant Keep.

Wilds

Would recommend you add this event for Hullabaloo.

15. 05/05/07 - Henry Fonda Theatre, Hollywood, CA (EV,JI)

It was Eddie Vedder, Jack Irons, and Flea.


Here is the setlist.


Walking the Cow
Drifting
I Am Mine
No More War

With Flea and Jack Irons:

Throw Your Hatred Down
Watch Outside
Corduroy
Habit
Better Man
The Kids Are Alright (with Steve Jones)

Wilds

Looks like you are missing the setlists from the two Los Angeles, Wiltern, EV Solo Shows from 2008. Here are the setlists....

April 12, 2008 at Wiltern Theater - Los Angeles


Event Details


Main Set
Walking The Cow
Around The Bend
I Am Mine
Dead Man
I'm Open
God Is In Control / Limit Yourself
Masters Of War
Man Of The Hour
Setting Forth
Guaranteed
No Ceiling
Far Behind
Rise
Millworker
Soon Forget
Broken Hearted
Driftin'
You've Got To Hide Your Love Away
Trouble
If You Want To Sing Out, Sing Out
I Won't Back Down
Forever Young
Porch
(Encore 1)
Society
Throw Your Arms Around Me
No More
Arc
(Encore 2)
Growin' Up
Lukin
Hard Sun

Trivia & Notes
Can't Keep and Picture In A Frame were on the setlist but not played.
Liam Finn joined Eddie for Society and Throw Your Arms Around Me.
Liam Finn and Eliza Jane Barnes joined Eddie for Hard Sun.
Eddie was presented with a Golden Globe statuette and gave an acceptance speech in between the Into The Wild songs.
God Is In Control and Limit Yourself were inspired by commercials for Christian rock compilations that Eddie saw on TV.

April 13, 2008 at Wiltern Theater - Los Angeles


Event Details


Liam Finn
Main Set
Walking The Cow
Around The Bend
I Am Mine
Dead Man
Thumbing My Way
Man Of The Hour
Setting Forth
Guaranteed
No Ceiling
Far Behind
Rise
Millworker
Goodbye
Soon Forget
Driftin'
You've Got To Hide Your Love Away
Picture In A Frame
Trouble
Happy Birthday
Porch (Encore 1)
Society
Throw Your Arms Around Me
Lukin
Arc (Encore 2)
Last Kiss
No More
Hard Sun
All Along the Watchtower


Trivia & Notes
Happy Birthday was sung to Eddie's grandma Margaret.
Liam Finn joined Eddie on Society and [Throw Your Arms Around Me]].
Jack Irons joined Eddie for Last Kiss.
Ben Harper and Jack Irons joined Eddie for No More.
Liam Finn, Eliza Jane Barnes, and Ben Harper joined Eddie for Hard Sun and Watchtower.

FrankieG

Just made an account and was playing around, Very cool!

EDIT: Just noticed that Sleeping By Myself Ed Solo version and PJ version counts as the same. Not sure I agree with that, but it is your website.. Is there a way to toggle all Ed solo shows out of the stats?

Roeland

the tiki bomb wrote:

No Ukelele Stats, although Sleeping by Myself Ed and Sleeping by Myself PJ aren't separate. Prob the same for Cant Keep.

FrankieG wrote:

Just made an account and was playing around, Very cool!

EDIT: Just noticed that Sleeping By Myself Ed Solo version and PJ version counts as the same. Not sure I agree with that, but it is your website.. Is there a way to toggle all Ed solo shows out of the stats?

I've added Ukelele Songs. Ed solo and group versions are indeed counting as the same. I could split them up but then the problem would be where to draw the line, what would you do with Ed presets, Ed solo songs at the beginning of encores...
You can deselect Ed solo shows through the filter menu.

Wilds wrote:

Would recommend you add this event for Hullabaloo.

15. 05/05/07 - Henry Fonda Theatre, Hollywood, CA (EV,JI)

Wilds wrote:

Looks like you are missing the setlists from the two Los Angeles, Wiltern, EV Solo Shows from 2008. Here are the setlists....

April 12, 2008 at Wiltern Theater - Los Angeles

Thanks, both have been updated.

Wilds

Awesome. I love, love, love this site!

I've been dreaming about it ever since 2006 when PJStattracker and I started talking about creating our own site. Problem with that is, I'm an idiot, and Jeff (although brilliant) was too busy. Eventually he left me in the dust and created the Stat Tracker, but without an Iphone I was still out.

So now after all these years, I couldn't be happier to have access to your site.

BHealy

This is cool- I love stats and can totally geek out on this! THanks!

restlesssoul

Hey roeland, gotta say......LOVE THE SITE. beats my excel spreadsheet anyday....

very cool for us to have this now.


I would like to say something about the awards.

might I suggest awards for FIRSTS. ie first Parachutes ever played in Boston 2006 and so forth

awards for Trilogies witnessed. "man" trilogy, mamasan, reverse mamasan, "you" trilogy, "I"
trilogy, etc.


if not awards, some way of pointing out the special stuff in the setlists?

GREAT JOB

PJStatTracker

Roeland wrote:

I've added Ukelele Songs. Ed solo and group versions are indeed counting as the same. I could split them up but then the problem would be where to draw the line, what would you do with Ed presets, Ed solo songs at the beginning of encores...
You can deselect Ed solo shows through the filter menu.

I've obviously spent a considerable amount of time thinking about and discussing (especially with Wilds) where to draw this line. There is no right answer, and believe me when I say people are very passionate about it. Here are my thoughts after working on this stuff for a couple of years:

- If it is played at a Pearl Jam event, then it is considered a Pearl Jam performance. This means pre-sets, EV solo performances, etc. are all part of the Pearl Jam show that night. Wilds recently pointed out that this makes the Bob Dylan tribute performance from '92 an EV solo event (plus Mike), and I agree with that.

- IMO, Sleeping By Myself by Pearl Jam is a different song than Sleeping By Myself by Eddie Vedder. It has a different structure and tone, but most importantly - like Can't Keep - it is on a Pearl Jam album. This is different than, say, Setting Forth which I consider a Pearl Jam cover of an EV song.

- I have also determined that only performances with a proper audience count. This means I don't include radio performance, sound checks, etc., but do include Saturday Night Live, Letterman, and the like.

Inevitably, your line will be different from mine and I think that's totally fine. Take it all with a grain of salt and keep up the great work! I'm happy to have something to point to for the non-iOS crowd.

Wilds

PJStatTracker wrote:

Roeland wrote:

I've added Ukelele Songs. Ed solo and group versions are indeed counting as the same. I could split them up but then the problem would be where to draw the line, what would you do with Ed presets, Ed solo songs at the beginning of encores...
You can deselect Ed solo shows through the filter menu.

I've obviously spent a considerable amount of time thinking about and discussing (especially with Wilds) where to draw this line. There is no right answer, and believe me when I say people are very passionate about it. Here are my thoughts after working on this stuff for a couple of years:

- If it is played at a Pearl Jam event, then it is considered a Pearl Jam performance. This means pre-sets, EV solo performances, etc. are all part of the Pearl Jam show that night. Wilds recently pointed out that this makes the Bob Dylan tribute performance from '92 an EV solo event (plus Mike), and I agree with that.

- IMO, Sleeping By Myself by Pearl Jam is a different song than Sleeping By Myself by Eddie Vedder. It has a different structure and tone, but most importantly - like Can't Keep - it is on a Pearl Jam album. This is different than, say, Setting Forth which I consider a Pearl Jam cover of an EV song.

- I have also determined that only performances with a proper audience count. This means I don't include radio performance, sound checks, etc., but do include Saturday Night Live, Letterman, and the like.

Inevitably, your line will be different from mine and I think that's totally fine. Take it all with a grain of salt and keep up the great work! I'm happy to have something to point to for the non-iOS crowd.

For me, I totally count EV solo performances of Pearl Jam songs in my stats. So very happy to have that option. I do this mostly for the inclusion of Arc, which is the same version heard in 2003 nine times, only perfected in a better setting, without the crowd chatter.

With that said, if Stone ever busted out Mankind at a solo gig, I think that would count. So for me it's more about the "Pearl Jam" songs heard, than it is "Pearl Jam" doing pearl jam songs, as long as a member of Pearl Jam is doing the singing.

I've only got two songs from EV Solo that I don't have by the "whole band", Arc, and Can't Keep. But if I never hear the entire band do those two songs, and finally get "Get Right", I'll feel satisfied that I've heard all of Riot Act.

RE4790

PJStatTracker wrote:

Roeland wrote:

I've added Ukelele Songs. Ed solo and group versions are indeed counting as the same. I could split them up but then the problem would be where to draw the line, what would you do with Ed presets, Ed solo songs at the beginning of encores...
You can deselect Ed solo shows through the filter menu.

I've obviously spent a considerable amount of time thinking about and discussing (especially with Wilds) where to draw this line. There is no right answer, and believe me when I say people are very passionate about it. Here are my thoughts after working on this stuff for a couple of years:

- If it is played at a Pearl Jam event, then it is considered a Pearl Jam performance. This means pre-sets, EV solo performances, etc. are all part of the Pearl Jam show that night. Wilds recently pointed out that this makes the Bob Dylan tribute performance from '92 an EV solo event (plus Mike), and I agree with that.

- IMO, Sleeping By Myself by Pearl Jam is a different song than Sleeping By Myself by Eddie Vedder. It has a different structure and tone, but most importantly - like Can't Keep - it is on a Pearl Jam album. This is different than, say, Setting Forth which I consider a Pearl Jam cover of an EV song.

- I have also determined that only performances with a proper audience count. This means I don't include radio performance, sound checks, etc., but do include Saturday Night Live, Letterman, and the like.

Inevitably, your line will be different from mine and I think that's totally fine. Take it all with a grain of salt and keep up the great work! I'm happy to have something to point to for the non-iOS crowd.

I think you nailed it and I like the way you do it in your app. EV solo shows should not count anymore than hearing Boom sing one at a tikki bar nor should PJ members guesting with opening acts, but Ed pre-sets should. Like you said, anything done in the context of a PJ concert is a PJ performance.

The only thing I disagree with, and I think we chatted about this briefly while you were promoting the app at PJ20 IIRC, is that you treat tags as performances in many cases. A few lines from a song shouldn't count IMHO (WMA being the most frequent example), but opinions are like a**holes and I respect the hell out of what you you made.

PJStatTracker

RE4790 wrote:

The only thing I disagree with, and I think we chatted about this briefly while you were promoting the app at PJ20 IIRC, is that you treat tags as performances in many cases. A few lines from a song shouldn't count IMHO (WMA being the most frequent example), but opinions are like a**holes and I respect the hell out of what you you made.

Yeah this is something that people are about 50/50 on, so I went with the option that is most inclusive. I think in the next version I will specify how many times you have seen a full song vs. tagged, but will still let the tagged songs count toward the trophies. I still believe that they are, even if in a small way, a performance of the song. I totally get your point of view there, though.

Zod

Any way to get tags added as songs?

I think the only album I've seen front to back is Vs. Pearl Jam did quite a good tag of W.M.A (attached to daughter) at calgary 09, but it doesn't get listed as a song I've seen live. I think it should count

restlesssoul

Zod wrote:

Any way to get tags added as songs?

I think the only album I've seen front to back is Vs. Pearl Jam did quite a good tag of W.M.A (attached to daughter) at calgary 09, but it doesn't get listed as a song I've seen live. I think it should count

disagree. tag is not full song.

WMA at MSG in 2008 is a full rendition of the song.

Zod

restlesssoul wrote:

Zod wrote:

Any way to get tags added as songs?

I think the only album I've seen front to back is Vs. Pearl Jam did quite a good tag of W.M.A (attached to daughter) at calgary 09, but it doesn't get listed as a song I've seen live. I think it should count

disagree. tag is not full song.

WMA at MSG in 2008 is a full rendition of the song.

It still is the song though. It's not like I've never heard pearl jam play any of W.M.A.

I guess this is the 50/50 argument the poster above is talking about

PJStatTracker

Zod wrote:

restlesssoul wrote:

Zod wrote:

Any way to get tags added as songs?

I think the only album I've seen front to back is Vs. Pearl Jam did quite a good tag of W.M.A (attached to daughter) at calgary 09, but it doesn't get listed as a song I've seen live. I think it should count

disagree. tag is not full song.

WMA at MSG in 2008 is a full rendition of the song.

It still is the song though. It's not like I've never heard pearl jam play any of W.M.A.

I guess this is the 50/50 argument the poster above is talking about

yes...exactly!

JohnnieBeBlue

From all of us Android users who couldn't use the iPhone app, thank you for this site!

lastexit78

Just got to say good job with this site. I had created a spreadsheet a while back trying to track my 36 shows and this makes it way easier. Cool to see all the stats on my dashboard. Thanks again!

Wilds