Monday, March 14, 2022

My "Seen" Database As Of March 2022

 A project I've been working on is making a spreadsheet of all music acts/performers I've seen over the years.  In this blog I've been documenting music acts I've seen since 2009, but even with those acts, I've forgotten some of the musicians.  And of course my memory of acts I saw before 2009 is full of holes.

But I've done the best I could, looking up some things on the web as I've gone along.  I have tried to only include performers that I *remembered* being with an act, but I've also included performers who were extremely likely to have appeared with a band on that date.  For instance, I don't remember particular Beach Boys I saw when I saw the band in 1975, but it's a matter of record who the primary performers were with that band at that time.

I've also struggled with dates for acts before 2009.  For instance, I don't remember exactly when I saw the Beach Boys in the mid-70s, but I remember where I saw them and it's a matter of record when they played the Boston Music Hall in that time period, so I was able to deduce the date.  Other dates are guesses.  I don't remember when I saw Del McCoury in 1997 in Lexington MA, but I've guessed a month (April in this case) ... sometimes pretty accurately ... and have listed "0" as the day of the month.

I finally finished the project of backfilling this to the first music act I remember seeing, J. Geils Band in Summer 1971.  I recall seeing 892 acts in all, a few on the same date at music festivals but on different stages.  I've since uploaded the spreadsheet into a local version of SQL Server, which enables me to make some interesting analyses.  For instance, here are the performers I've seen at least 5 times, with the earliest and latest dates I've seen them:

LastName

FirstName

Times Seen

Earliest

Latest

Weir

Bob

43

1973-11-30

2021-09-05

Lesh

Phil

42

1973-11-30

2021-10-20

Kreutzmann

Bill

33

1973-11-30

2021-09-05

Hart

Mickey

29

1976-06-09

2021-09-05

Chimenti

Jeff

29

2011-07-22

2021-09-05

Garcia

Jerry

21

1973-11-30

1979-05-11

Russo

Joe

18

2011-07-22

2021-10-20

Burbridge

Oteil

17

2011-07-22

2021-09-05

O'Brien

Tim

17

1980-07-01

2021-09-10

Barraco

Rob

16

2011-11-17

2019-11-16

Beek

Jason

16

2008-09-14

2019-07-14

Jewell

Eilen

16

2008-09-14

2019-07-14

Miller

Jerry

16

2008-09-14

2019-07-14

Godchaux

Keith

15

1973-11-30

1979-01-18

Mayer

John

15

2015-11-10

2021-09-05

Godchaux

Donna

14

1974-07-29

2016-07-16

Eaton

Rob

13

2011-11-17

2019-11-16

English

Dino

13

2011-11-17

2019-11-16

Koritz

Rob

13

2011-11-17

2019-11-16

Lesh

Grahame

13

2012-05-19

2021-10-20

Mattson

Jeff

13

2011-11-17

2019-11-16

Campbell

Larry

12

2011-07-22

2018-06-10

Helm

Amy

12

2004-09-20

2021-10-20

Kadlecik

John

12

2011-07-22

2016-08-13

Kennedy

Pete

12

2003-09-19

2020-02-29

Kennedy

Maura

12

2003-09-19

2020-02-29

Sciascia

Johnny

12

2008-09-14

2018-05-01

Williams

Teresa

11

2011-07-22

2018-06-10

Benevento

Marco

10

2015-02-06

2019-10-18

Harris

Emmylou

10

1982-08-01

2014-09-21

Kaukonen

Jorma

10

1977-09-01

2019-08-21

Mackay

Lisa

10

2011-11-17

2019-11-16

Metzger

Scott

10

2015-02-06

2019-07-23

Trucks

Derek

10

2011-07-22

2021-07-17

Arbo

Rani

9

1995-08-01

2014-11-30

Erwin

Jake

9

2009-10-01

2018-07-27

Greenwell

Tyler

9

2011-07-22

2021-07-17

James

Elana

9

2009-10-01

2018-07-27

Kinsey

Andrew

9

1995-08-01

2014-11-30

Mancini

Larry

9

2011-09-17

2016-08-19

Mattison

Mike

9

2011-07-22

2021-07-17

Nayak

Anand

9

2004-09-20

2019-07-12

Price

Rachael

9

2011-07-16

2018-11-17

Smith

Whit

9

2009-10-01

2018-07-27

Tedeschi

Susan

9

2011-07-22

2021-07-17

Vangelas

Skip

9

2013-11-24

2019-11-16

Alvin

Dave

8

2009-07-18

2019-07-19

Amerding

Taylor

8

1986-08-01

2014-11-29

Bui

Dan

8

2014-09-20

2021-08-27

Calabrese

Mike

8

2012-07-14

2018-11-17

Hamilton

Tommy

8

2015-02-06

2018-07-20

Johnson

JJ

8

2011-07-22

2019-12-06

Kessell

Scott

8

2004-09-20

2014-11-30

Molo

John

8

2016-03-17

2019-06-14

Olson

Mike

8

2012-07-14

2018-11-17

Parks

Kathleen

8

2014-09-20

2021-08-27

Rajchel

Jeff

8

2011-09-17

2016-08-19

Rivers

Mark

8

2011-07-22

2019-12-06

Russell

Tom

8

1997-06-01

2015-04-29

Walsh

Tim

8

2011-09-17

2016-08-19

Williams

Kebbi

8

2011-07-22

2019-12-06

Burbridge

Kofi

7

2011-07-22

2018-12-01

Casady

Jack

7

1977-09-01

2019-08-21

Dickinson

Luther

7

2013-11-02

2019-03-18

Dreiwitz

Dave

7

2015-02-06

2018-07-20

Erelli

Mark

7

2004-09-21

2018-11-29

Forster

Nick

7

1980-07-01

2013-05-17

Howard

Jack

7

2011-09-17

2016-08-19

Perry

Ryan

7

2011-09-17

2016-06-12

Sumner

Rachel

7

2014-09-20

2018-07-13

Bode

Zara

6

2012-07-14

2021-08-28

Bush

Sam

6

1988-08-01

2014-09-20

Campbell

Kate

6

1997-10-01

2012-04-19

Chakour

Alicia

6

2014-12-12

2019-12-06

Kearney

Bridget

6

2016-03-23

2018-11-17

Knuckles

Red

6

1980-07-01

2013-05-17

Larkin

Patty

6

1996-05-01

2017-11-10

Larson

Jeff

6

2011-09-17

2016-02-19

Lea

Elizabeth

6

2014-12-12

2019-12-06

LeFebvre

Tim

6

2013-11-23

2018-12-01

Leone

Tony

6

2004-09-20

2015-10-31

Mercantile

Waldo

6

1980-07-01

2013-05-17

Mercantile

Wendel

6

1980-07-01

2013-05-17

O'Donovan

Aoife

6

2009-07-17

2018-07-15

Owens

Ephraim

6

2014-12-12

2019-12-06

Royer

Eric

6

2004-09-20

2018-05-01

Smither

Chris

6

2007-09-16

2018-09-27

Tench

Benmont

6

2019-03-14

2021-10-20

Toth

Alex

6

2011-07-16

2017-01-20

Traver

Annakalmia

6

2011-07-16

2017-01-20

Wernick

Pete

6

1980-07-01

2013-05-17

Black

Amy

5

2011-04-03

2015-08-18

Cook

Elizabeth

5

2010-06-23

2018-10-21

Crosby

Jason

5

2013-11-02

2016-10-29

Delmhorst

Kris

5

2004-11-28

2021-08-28

Dotson

Adam

5

2011-07-16

2015-07-11

Earle

Steve

5

2000-09-01

2015-07-11

Fordham

Brad

5

2011-06-22

2015-10-23

Garcia

Sunshine

5

2011-07-22

2013-07-17

Grammer

Tracy

5

2003-10-01

2013-03-01

Guip

Justin

5

2013-03-22

2018-06-10

Henry

Bill

5

1986-08-01

1995-11-01

Isaacs

Byron

5

2004-09-20

2013-03-22

Kahn

John

5

1974-11-13

1977-12-02

Kellar

Daniel

5

2009-07-17

2018-05-01

Keyes

Dave

5

2008-07-01

2020-02-28

Kropp

Mike

5

1986-08-01

1995-11-01

Lauderdale

Jim

5

2002-11-01

2018-11-11

Miller

Chris

5

2011-06-22

2015-10-23

Pancratz

Lisa

5

2011-06-22

2015-10-23

Pehrson

Jeff

5

2011-07-22

2013-07-17

Rodriguez

Carrie

5

2005-04-01

2016-08-25

Russell

Allison

5

2018-07-13

2019-03-18

Saunders

Merle

5

1974-11-13

1977-12-02

Tess

Miss

5

2011-07-16

2017-12-20

Welch

Gillian

5

1997-10-01

2017-11-29


And here's a table of the bands I've seen at least 3 times.  Note that with some of these I've specified "band" after the name.  For instance, I've seen Emmylou Harris solo and also headlining several bands (The Hot Band, The Nash Ramblers) and have rolled up all of those under just "Emmylou Harris."  Alternately I've seen Eilen Jewell as part of the Sacred Shakers but here have only rolled up the times I've seen her with her dedicated band, as she's not the headliner with the Sacred Shakers (debatably).

Act

TimesSeen

Grateful Dead

18

Phil Lesh and Friends

17

Dead & Company

15

Dark Star Orchestra

13

Eilen Jewell (band)

11

The Kennedys

10

Hot Club of Cowtown

9

Tedeschi Trucks Band

9

Emmylou Harris (band)

8

Ol' Brown Shoe

8

Rani Arbo & Daisy Mayhem

8

Twisted Pine

8

Hot Tuna

7

Joe Russo's Almost Dead

7

Lake Street Dive

7

Tom Russell

7

Chris Smither

6

Hot Rize

6

Kate Campbell

6

Patty Larkin

6

Red Knuckles & the Trailblazers

6

Rubblebucket

6

Tim O'Brien

6

Elizabeth Cook

5

Furthur

5

Garcia and Saunders

5

Northern Lights

5

Sacred Shakers

5

Tracy Grammer

5

Amy Black

4

Dan Hicks & the Hot Licks

4

Dave Alvin (band)

4

Fred Eaglesmith

4

Heather Maloney

4

Justin Townes Earle

4

Larry Campbell and Teresa Williams

4

Los Lobos

4

Marco Benevento

4

Miss Tess

4

Steve Earle

4

Sweetback Sisters

4

Alison Krauss

3

Amy Helm

3

Carolina Chocolate Drops

3

Carrie Rodriguez

3

Cowboy Junkies

3

Crooked Still

3

Dave and Phil Alvin

3

David Bromberg

3

Erin Mckeown

3

Gillian Welch (band)

3

Iris Dement

3

Jeffrey Foucault

3

Jim Lauderdale

3

Jorma Kaukonen (band)

3

Kris Delmhorst

3

Lori McKenna

3

Lucinda Williams

3

Mark Erelli

3

Ollabelle

3

Popa Chubby Band

3

Rhonda Vincent

3

Richard Shindell

3

Seldom Scene

3

Southern Rail

3

Stray Birds

3

Suitcase Junket

3

Tom Rush

3

Willie Nelson

3

Winterpills

3

Zoe Muth

3

2 comments:

  1. I can't help but notice you didn't include Jerry Garcia's appearance as a rainbow at Fare Thee Well!

    ReplyDelete
    Replies
    1. Forgot to mention that rainbows and hallucinations are in another spreadsheet.

      Delete