SHOWS
SHOWS
List shows, optionally filtered by date range and conditions.
Synopsis
SHOWS [ AT "venue" ] [ FROM date_or_era ] [ WHERE condition [ AND | OR condition ... ] ]
[ ORDER BY sort_spec ] [ LIMIT n ] [ AS format ];Description
SHOWS returns one row per show (date, venue, and related info). Use AT to filter by venue or city, FROM to restrict by year or era, and WHERE for segues, set position, played/guest/length, and combinations with AND/OR/NOT. Control order and size with ORDER BY and LIMIT, and output shape with AS.
Clauses
| Clause | Description |
|---|---|
AT | Venue or city filter (partial match, e.g. AT "Fillmore", AT "New York") |
FROM | Date range (e.g. 1977, 77-80) or era alias (PRIMAL, EUROPE72, BRENT_ERA, etc.) |
WHERE | Conditions: segue, set position, played, guest, length (see WHERE) |
ORDER BY | DATE or other field, ASC or DESC |
LIMIT | Maximum number of results |
AS | Output format: JSON, CSV, SETLIST, TABLE (default) |
Examples
All shows (no filter):
SHOWS;
SHOWS LIMIT 20;By year or range:
SHOWS FROM 1977;
SHOWS FROM 77;
SHOWS FROM 1977-1980;
SHOWS FROM 77-80 LIMIT 10;By era:
SHOWS FROM PRIMAL;
SHOWS FROM EUROPE72;
SHOWS FROM BRENT_ERA;By venue:
SHOWS AT "Fillmore West";
SHOWS AT "Winterland" FROM 1977;
SHOWS AT "New York" LIMIT 10;With WHERE (segue, set position, played, guest):
SHOWS FROM 1977 WHERE "Scarlet Begonias" > "Fire on the Mountain";
SHOWS WHERE SET1 OPENED "Jack Straw";
SHOWS FROM 1990 WHERE PLAYED "Eyes of the World";
SHOWS WHERE GUEST "Branford Marsalis";
SHOWS WHERE "Help on the Way" > "Slipknot!" > "Franklin's Tower";Order and limit:
SHOWS FROM 1977 ORDER BY DATE;
SHOWS FROM 1977 ORDER BY DATE DESC;
SHOWS FROM 77-80 LIMIT 10;Output format:
SHOWS FROM 1977 LIMIT 3;
SHOWS FROM 1977 LIMIT 3 AS TABLE;
SHOWS FROM 1977 LIMIT 3 AS JSON;
SHOWS FROM 1977 LIMIT 3 AS CSV;
SHOWS FROM 1977 LIMIT 3 AS SETLIST;Try in Sandbox · Scarlet→Fire · AS JSON
Next
SONGS