good afternoon deadlists team, continued blessings to all the great work you do.
i had a question, i have just taken some graduate level statistics and would love to do some sorting of grateful dead music by length and or date, and then within eachother for certain songs within years and see what pops out. i am searching for a database i can manipulate to try and extract some info/data/personal listening guide. charlie miller suggested i might be able to get one through the site. i can see based on your search criterion that you have most what i am seeking there, and it is great, but i am very interested in trying to get timed data sorting: venue: n/a 46th Street Rock Palace A.I.A.A. Hall Aarhus University Academy of Music Action House Activity Center - Arizona State University Activity Center - University of Colorado Adams Field House - University of Montana Aladdin Hotel Theatre Albuquerque Civic Auditorium Alexandra Palace Alfond Arena - University of Maine Alfred College Allan Kirby Field House - Lafayette College Allen Theatre Alligator Alley Gym - University of Florida Alliope Warehouse Alpine Valley Music Theatre Alumni Stadium - University of Massachusetts American Legion Hall American Studios American University Anaheim Stadium Anderson Theatre Aqua Theater Arlington Theatre Arrowhead Stadium Assembly Center - Louisiana State University Assembly Hall - Indiana University Assembly Hall - University Of Illinois Athletic Center - Rutgers University Atlanta Municipal Auditorium Atlanta Sports Arena Auditorium Theatre Augusta Civic Center Austin Municipal Auditorium Autzen Stadium - University of Oregon Avalon Ballroom Aztec Bowl - San Diego State University Bakersfield Civic Auditorium Ballroom - University of Colorado Baltimore Civic Center Bangor Municipal Auditorium Barton Hall - Cornell University Baton Rouge International Speedway Bayfront Center Beacon Theatre Beat Club Beaver Hall Bellarmine College Berkeley Community Theatre Betty Nelson's Organic Raspberry Farm Bickershaw Festival Big Nig's House Billerica Forum Birmingham Coliseum Blockbuster Desert Sky Pavillion Blossom Music Center Bob Marley Performing Arts Center Boise Pavilion - Boise State University Boreal Ridge Ski Resort Boston Garden Boston Music Hall Boston Tea Party Boutwell Auditorium Brendan Byrne Arena Broome County Arena Buckeye Lake Music Center Buffalo Auditorium Building A, Cal Expo Cabrillo College Stadium, Cabrillo College Cafe Au Go Go Cal Expo Amphitheatre Calavaras County Fairgrounds California Hall California State University Dominguez Hills Cameron Indoor Stadium - Duke University Camp Randall Field House - University Of Wisconsin Campolindo High School Campus Stadium - University Of California Canadian National Exhibition Hall Candlestick Park Cape Cod Coliseum Capital Centre Capitol Theater Capitol Theatre Cardinal Stadium Carolina Coliseum - University of South Carolina Carousel Ballroom Carrier Dome - Syracuse University Carter-Finley Stadium Carthay Studios Cassell Coliseum - Virginia Polytechnic Institute and State University Centennial Coliseum Central Park Century II Convention Hall Charlotte Coliseum Chateau d'Herouville Chelsea Hotel Roof Chrisler Arena - University of Michigan Christy Mathewson Stadium - Bucknell University Cincinnati Gardens City Island City Park Civic Center Civic Center Arena Civic Convention Hall Auditorium Clark University Cleveland Music Hall Cleveland Public Auditorium Cleveland Public Hall Club Agora Club Front Cobo Arena Colden Auditorium - Queens College Cole Field House - University of Maryland Coliseum Coliseum Coliseum - Southern Illinois University Coliseum - University of Alabama Coliseum - West Virginia University Coliseum Arena Coliseum Stadium Colt Park Commons - San Francisco State College Community War Memorial Auditorium Compton Terrace Amphitheatre Compton Terrace Amphitheatre Concertgebouw Continental Ballroom Copps Coliseum Coronation Park Cotterell Gym - Colgate University County Coliseum Cow Palace Crisler Arena - University of Michigan Crystal Ballroom Cumberland County Civic Center Curtis Hixon Convention Hall Dallas County Convention Center Arena Dallas Memorial Auditorium Dance Hall Dane County Coliseum Danish Center Dante's Inferno David Mead Field House - Allegheny College Dean Smith Center - University of North Carolina Deer Creek Music Center Del Mar Fairgrounds Delta Center Denver Coliseum Des Moines Civic Center Devore Field - Southwestern College Diamond Head Crater Dillon Gym - Princeton University Dillon Stadium Downs of Santa Fe Dream Bowl DuPont Gym - MIT Eagles Auditorium Eagle's Auditorium Earl Warren Showgrounds East Hall - Franklin & Marshall College Easttown Theatre Edmundson Pavilion - University of Washington Electric Circus Electric Factory Electric Theater EMU Ballroom - University Of Oregon Euphoria Ballroom Eureka Municipal Auditorium Evans Field House - Northern Illinois University Expo '67 Exposition Center Fairfield University Family Dog Family Dog at the Great Highway Farrell Hall, SUCNY Felt Forum - Madison Square Garden Festhalle Feyline Field Field House - Rensselaer Polytechnic Institute Field House - Seneca College Field House - University of Cincinnati Field House - Wesleyan University Fiesta Hall - San Mateo County Fairgrounds Fillmore Auditorium Fillmore East Fillmore West Five Seasons Center Folsom Field - University of Colorado Ford Auditorium Forum Theatre Fox Theatre Fox Theatre Foxboro Stadium Franklin County Airport Freeborn Hall Freedom Hall Fresno Convention Center Frost Amphitheater Stanford U. Frost Amphitheatre - Stanford University Frost Ampitheatre, Stanford U. Gaelic Park Giants Stadium Glen Helen Regional Park Glens Falls Civic Center Golden Gardens Beach Golden Gate Park Golden Hall - San Diego Community Concourse Governor's Hall Grand Center Grand Prix Racecourse Grande Ballroom Great American Music Hall Great Western Forum Greek Theater - University of California Greek Theatre - University of California Greensboro Coliseum Grugahalle Grugahalle Gulfstream Park Race Track Gym - State University Of New York Gym - South Oregon College Haight Street Hall Of Flowers - San Mateo County Fairgrounds Hampton Coliseum Hara Arena Harding Theatre Harmon Gym - University of California Harpur College - State University Of New York Hartford Civic Center Henry J. Kaiser Auditorium Henry J. Kaiser Convention Center Hershey Park Stadium Hill Auditorium Hilton Hotel Hippodrome Hofheinz Pavilion - University of Houston Holleder Stadium Hollywood Bowl Hollywood Palladium Honolulu Civic Auditorium Horton Field House - Illinois State University Hubert H. Humphrey Metrodome Huntington Civic Center Hyde Park Teen Center I.D.B.S. Hall Ice Palace Ice Stadium Indiana Convention Center Indianapolis Sports & Music Center International Amphitheatre International Speedway Internationales Congress Centrum Iowa Fieldhouse - University of Iowa Iowa State Fairgrounds Irvine Auditorium, University of Pennsylvania Irvine Meadows Amphitheatre Irvine Meadows Amphitheatre Ivar Theater Jahrhunderthalle Jai-Alai Fronton Jenison Field House (Michigan State University) JFK Stadium Joe Louis Arena Kansas City Municipal Auditorium Kezar Stadium KFRC Studios Kiel Auditorium Kiel Opera House Kinetic Playground Kings Beach Bowl Kingswood Music Theatre Kleinhans Music Hall KMPX-FM: The Tom Donahue Show Knickerbocker Arena Kongressaal - Deutsches Museum KPIX-TV Studios KQED Studios Kresge Plaza - MIT KSAN Studios L.A. Memorial Coliseum La Dolphine Labor Temple Laguna Seca Raceway Lakefront Arena, University of New Orleans Lakeland Civic Center Lanai Theater Lane Community College Las Lomas High School Legion Stadium Lille Fairgrounds Lindley Meadows - Golden Gate Park Lloyd Noble Center - University of Oklahoma L'Olympia Long Beach Arena Longshoreman's Hall Los Angeles Sports Arena Low Library Plaza, Columbia University LP is Released Lusk Field House - State University Of New York MacArthur Court - University of Oregon Madison Square Garden Maine State Fairgrounds Mammoth Gardens Manhattan Center Manor Downs Marin Veterans Memorial Auditorium Marion Shea Auditorium - Paterson State College Market Square Arena Masonic Temple Masonic Temple McDonough Arena - Georgetown University McFarlin Auditorium, SMU McGaw Memorial Hall - Northwestern University McMahon Stadium McNichols Arena Mecca Melkweg Melodyland Theater Melodyland Theatre Memorial Auditorium Memorial Auditorium - Ohio University Memorial Coliseum Memorial Coliseum - Mississippi State Fairgrounds Memorial Stadium Meramec Community College Merriweather Post Pavilion Mershon Auditorium - Ohio State University Metropolitan Sports Center Miami Arena Mickey Hart's Barn Middlesex County Community College Mid-South Coliseum Mile High Stadium Mill Valley Recreation Center Milwaukee Auditorium Mississippi River Festival Monterey Peninsula College Moody Coliseum - Southern Methodist University Moscone Convention Center Mosque Mt. Tamalpais Amphitheatre Muir Beach Lodge Music Hall Musikhalle Nashville Municipal Auditorium Nassau Veterans Memorial Coliseum National Guard Armory NBC Studios Nevada County Fairgrounds New Haven Coliseum Newcastle City Hall Niagra Falls Convention Center Northridge Unitarian Church Northrup Auditorium NY State Pavilion, Flushing Meadow Park, Queens Oakland Auditorium Oakland Coliseum Arena Oakland-Alameda County Coliseum Arena Oakland-Alameda County Coliseum Stadium Ohio Theatre O'Keefe Center Oklahoma City Fairgrounds Arena Oklahoma City Music Hall Old Renaissance Faire Grounds Olympia Halle Olympiahalle Olympic Arena Omaha Civic Auditorium Omni Coliseum Onondaga Auditorium Onondaga County War Memorial Orange County Fairgrounds Oregon Country Fairgrounds Oregon State University Orlando Arena Orpheum Theatre Oxford Plains Speedway P.N.E. Agradome P.N.E. Coliseum P.N.E. Garden Auditorium Palace Of Fine Arts Palace Theatre Palace Ville Marie Palais des Sports Palm Gardens Panhandle, Golden Gate Park Panther Hall Paradise Valley Resort Paramount Northwest Theatre Paramount Theatre Paramount Theatre Parc des Expositions Park West Ski Area Pasadena Civic Auditorium Patrick Gymnasium - University of Vermont Pauley Ballroom - University of California Pauley Pavilion - University of California Pelletier Farm Pender Auditorium Pepperland Performing Arts Center Pershing Municipal Auditorium Philadelphia Civic Center Phoenix Travelodge Theater Pico Acid Test Piedmont Park Pine Knob Music Theatre Pioneer Ballroom Pirate's World Pittsburgh Civic Arena Playboy Club Playhouse Theatre PNE Coliseum Polo Field - Golden Gate Park Poplar Creek Music Theatre Portland International Raceway Portland Meadows Private School Providence Civic Center PSC College Center Ballroom - Portland State College Psychedelic Supermarket Purdue University Raceway Park Radio City Music Hall Rainbow Theatre Rambler Room - Loyola University Rancho Olompali Recreation Hall - Penn State University Recreation Hall - University of California Red Rocks Amphitheatre Red Vest Reed's Ranch Rehearsal Session Rehearsal/Studio Session Rehearsals Reunion Arena RFK Stadium Rheinhalle Rhode Island Auditorium Rich Stadium Richfield Coliseum Richmond Coliseum River Bend Music Center Riverfront Arena Riverfront Coliseum Riverport Amphitheater Roanoke Civic Center Robert F. Kennedy Stadium Robertson Gym - University Of California Rochester Silver Stadium Rock Garden Rock Pile Roosevelt Stadium Roscoe Maples Pavilion - Stanford University Rose Palace Rosemont Horizon Rosemont Horizon Arena Rotterdam Civic Hall Rubber Bowl - University of Akron Rupp Arena Sacramento Memorial Auditorium Saenger Theatre Salt Palace Sam Boyd Silver Bowl Sam Houston Coliseum San Antonio Civic Auditorium San Diego International Sports Arena San Francisco Civic Auditorium San Francisco Civic Center San Jose Civic Auditorium San Jose State University San Quentin State Prison Sandstone Amphitheatre Santa Clara County Fairgrounds Santa Cruz County Fairgrounds Santa Monica Civic Auditorium Santa Venetia Armory Saratoga Performing Arts Center Sargent Gym - Boston University Scope Scorpio studio outtakes(?) Scranton Catholic Youth Center Seattle Center Arena Seattle Center Coliseum Selland Arena Seminole Indian Village Shea's Theatre Shoreline Amphitheatre Shrine Auditorium Shrine Exhibition Hall Sierra College Silva Hall - Hult Center for the Performing Arts Silver Dollar Fair Silver Stadium Soldier Field Soldier's And Sailors Memorial Hall Soldier's And Sailors Memorial Hall Sonoma County Fairgrounds Sound City Recording Studios Southern Star Amphitheater Spartan Stadium - San Jose State University Speedway Meadows - Golden Gate Park Sphinx Theatre Spokane Coliseum Sportatorium Sporthalle Sports Palace Springer's Inn Springfield Civic Center Arena St. Louis Arena St. Mary's College St. Paul Auditorium St. Paul Civic Center Arena Stabler Arena - Lehigh University Stadt Halle Stanley Theatre Stanley Theatre Stanley Theatre Star Lake Amphitheater Starlight Theatre State Fair Coliseum State Fair Coliseum Stockton Civic Auditorium Straight Theater Strand Lyceum Student Center, Modesto Jr. College Student Union Ballroom, University Of Utah Studio Rehearsal Studio Sessions Studio Sessions Sullivan Stadium Sullivan Stadium Parking Lot Summerfest Fairgrounds Summit Arena Sun Dome Sunset Acid Test SUNY Swing Auditorium Tacoma Dome Taft Auditorium Tampa Stadium Temple University Terminal Island Correctional Facility Terrace Ballroom Texas Christian University The Ark The Bank The Barn The Big Beat Club The Cabale The Catacombs The Centrum The Club The Dome The Forum The Heliport The Hippodrome The Looking Glass The Lyric Theater The Matrix The Met Center The Monterey International Pop Music Festival - Monterey County Fairgrounds The Music Box The North Face Ski Shop The Old Cheese Factory The Omni The Palace The Palestra - University of Rochester The Palladium The Pyramid The Questing Beast The Spectrum The Summit The Syndrome The Village Gate The Warehouse Theatre Hall Thee Image Thelma Theater Thompson Arena - Dartmouth College Three Rivers Stadium Tivolis Koncertsal TMU Deck, Stanford U. Tompkins Square Park Tower Theatre Town Park Travelodge Theatre in the Round Troupers Hall Tulsa Pavilion Tyrone Guthrie Theater UIC Pavilion - University of Illinois Ungano's Night Club UniDome - University of Northern Iowa Universal Amphitheatre University Arena (aka The Pit') - University Of New Mexico University Auditorium, University of Arizona University Gymnasium - State University of New York University Hall - University of Virginia University of Nevada Unknown Unknown Venue Unknown Venue Unknown Venue Unknown Venue Unknown Venue Unknown Venue Unknown Venue Unknown Venue Unknown Venue Unknown Venue Uptown Theatre USAir Arena Utica Coliseum Utica Memorial Auditorium Vanderbilt University Ventura County Fairgrounds Veterans Auditorium Veterans Memorial Auditorium Veterans Memorial Coliseum Veterans Memorial Hall Veterans Memorial Hall Village Gate Village Theater Volunteer Park Wallace Wade Stadium - Duke University Walter Koebel Halle War Memorial Warfield Theatre Washington University Watts Acid Test Wembley Arena Wembley Empire Pool West High Auditorium West Palm Beach Civic Center West Park Western Recording Whicker's World Video Whisky-A-Go-Go William And Mary Hall - College Of William And Mary Winnipeg Fairgrounds Winterland Arena Woodstock Music & Arts Fair - Max Yasgur's Farm Worcester Polytechnic Institute World Music Theatre Yale Bowl - Yale University York Farm Youth Opportunities Center Zenith Zoo Amphitheatre city: n/a Aarhus Akron Albany Albuquerque Alfred Amherst Amsterdam Anaheim Anchorage Angel's Camp Ann Arbor Ashland Athens Atlanta Auburn Hills Augusta Austin Bakersfield Baltimore Bangor Barcelona Baton Rouge Berkeley Berlin Bethel Bethlehem Billerica Binghamton Birmingham Blacksburg Bloomington Boise Bonner Springs Boston Boulder Bremen Brooklyn Buffalo Burgettstown Burlington Calgary Cambridge Canyon Carbondale Carson Cedar Falls Cedar Rapids Champaign-Urbana Chandler Chapel Hill Charlotte Charlottesville Chicago Chico Chula Vista Cincinnati Clarkston Cleveland College Park Colorado Springs Columbia Columbus Compton Copenhagen Cortland Corvalis Costa Mesa Crockett Cuyahoga Falls Dallas Daly City Dania Davis Dayton DeKalb Del Mar Delhi Denver Des Moines Detroit Devore Dijon Donner's Summit Durham Dusseldorf East Lansing East Rutherford East Troy Easton Edinburgh Edison Edwardsville El Monte El Paso Englishtown Essen Eugene Eureka Evanston Fairfield Fort Worth Foxboro Frankfurt Frankfurt Fresno Gainesville Giza Glens Falls Grand Rapids Grass Valley Greensboro Hallandale Hamburg Hamilton Hamilton, Ontario Hampton Hanover Harrisburg Hartford Hebron Herouville Hershey Highgate Hillsborough Hoffman Estates Hollywood Honolulu Houston Huntington Indianapolis Inglewood Iowa City Irvine Island Park Ithaca Jackson Jacksonville Jersey City Kansas City Kirkwood København (Copenhagen) Lafayette Laguna Hills Lake Placid Lakeland Lancaster Landover Las Vegas Lewisburg Lewiston Lexington Lille Lincoln London Long Beach Los Angeles Louisville Luxembourg Madison Maple Marin County Maryland Heights Meadville Memphis Merced Miami Middletown Mill Valley Milwaukee Minneapolis Missoula Modesto Montego Bay Monterey Montreal Moraga Morgantown Morrison Mountain View Muir Beach Munich Nashville New Haven New Orleans New York Newcastle Newcastle-Under-Lyme Niagra Falls Noblesville Norfolk Normal Norman North Hollywood North Shore, Lake Tahoe Novato Oahu Oakland Oklahoma City Omaha Orchard Park Orlando Orono Oxford Palo Alto Paris Park City Pasadena Passaic Pembroke Pines Pescadero Philadelphia Phoenix Piscataway Pittsburg Pittsburgh Port Chester Portland Poynette Princeton Providence Raleigh Reno Richfield Richmond Rio Nido Roanoke Rochester Rocklin Rosemont Rotterdam Russelsheim Sacramento Salt Lake City San Antonio San Bernardino San Diego San Francisco San Jose San Mateo San Pedro San Quentin San Rafael Santa Barbara Santa Clara Santa Cruz Santa Fe Santa Monica Santa Rosa Santa Venetia Saratoga Springs Sausalito Scranton Seattle Soquel, Santa Cruz South Shore, Lake Tahoe South Yarmouth Spokane Springfield Squamish St. Helens St. Louis St. Paul St. Petersburg Stockholm Stockton Stony Brook Suisun City Sultan Syracuse Tacoma Tampa Telluride Tempe Tinley Park Toronto Toronto, Ontario Torrance Troy Tucson Tulsa Tuscaloosa Uniondale Universal City University Park Unknown Upper Darby Utica Vallejo Vancouver Veneta Ventura Virginia Beach Walnut Creek Washington Waterbury Watkins Glen Watsonville Watts Watts (?) Wayne West Hollywood West Palm Beach Wichita Wigan Williamsburg Winnipeg Worcester state: n/a AB, Canada AK AL AZ BC BC, Canada British Columbia CA Canada CN CO CT Dänemark (Denmark) DC Denmark Egypt England FL France GA Germany HI IA ID IL IN Jamaica KS KY LA Luxembourg MA MB, Canada MD ME MI MN MO MS MT NB NC NE Netherlands NH NJ NM NV NY OH OK ON, Canada Ontario OR PA PQ RI SC Scotland Spain Sweden TN TX Unknown UT VA VT WA West Germany WI WV year: song one: from any One Two Three Encore none and or if "none", two & three ignored song two: from any One Two Three Encore none and or if "none", three ignored song three: from any One Two Three Encore here is why, i have a belief that the grateful dead play longer (general proposition) when they think they are playing well or having fun, which makes for some of the best. what long china>riders, and i am thinking the ones that stretch above 15 minutes (a few of the great 73 & 74s, the likes of 10/28/79, 5/10 and 7/1/80, 8/7/82, etc.) that are not among the best. same goes for Playin', it may have been played a lot, but is there a non-great one 20+ minute pre-1981 and 17+ minute post 81 dark star too, well, sort of. and bird song, and shakedown, slipknot!, music, the other one, terrapin, etc. i think you see what i am getting at. i would like to sort em up and see the list down from the top according and see if it shows what i think it will, and listen accordingly. what do you think of that idea? i realize the time, effort, and money you must have incurred amassing and keeping this wonderful site and will understand your protection and restriction of your database to use for a purely academic, albeit personal, use. the results of which i would happily share (and love a review, as far as my scientific analysis and conclusions), if there was some way i could attain a database i can manipulate (which may for my purposes mean adding song length as a high-ordinal sort feature, and that may be it, and some other date sorting) the data. let me know what you think. michael