| show_id | showdate | permalink | artist_id | artist | showtitle | venue_id | venuename | location | city | state | country | tour_id | tourname | showorder | show_year | show_day | show_dayname | show_month | show_monthname | updated_at | created_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1678573042 | 2017-04-12 | king-gizzard-the-lizard-wizard-april-12-2017-the-fillmore-san-francisco-ca-usa.html | 1 | King Gizzard & the Lizard Wizard | 525 | The Fillmore | San Francisco, CA, USA | San Francisco | CA | USA | 17 | 2017 Flying Microtonal Banana - North America | 1 | 2017 | 12 | Wednesday | 4 | April | 2023-05-09 00:55:39 | 2023-03-11 22:17:22 | |
| 1678673155 | 2017-10-12 | king-gizzard-and-the-lizard-wizard-october-12-2017-the-fillmore-san-francisco-ca-usa.html | 1 | King Gizzard & the Lizard Wizard | 525 | The Fillmore | San Francisco, CA, USA | San Francisco | CA | USA | 22 | 2017 Murder of the Universe - USA | 1 | 2017 | 12 | Thursday | 10 | October | 2024-07-18 06:01:02 | 2023-03-13 02:05:55 |