| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1695703952 | 1993-09-13 | green-day-september-13-1993-club-rio-tempe-az-usa.html | 1 | Green Day | Recipe For Hate tour | 1259 | Club Rio | Tempe, AZ, USA | Tempe | AZ | USA | 23 | Recipe For Hate Tour | 1 | 1993 | 13 | Monday | 9 | September | 2024-11-17 15:25:38 | 2023-09-26 04:52:32 |
| 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 |