| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1697169061 | 1997-12-07 | green-day-december-7-1997-club-rio-tempe-az-usa.html | 1 | Green Day | Nimrod tour | 1259 | Club Rio | Tempe, AZ, USA | Tempe | AZ | USA | 13 | Nimrod tour | 1 | 1997 | 7 | Sunday | 12 | December | 2023-10-13 03:51:01 | 2023-10-13 03:51:01 |