| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1699198566 | 2005-01-14 | green-day-january-14-2005-stadhalle-offenback-em-main-germany.html | 1 | Green Day | American Idiot tour | 920 | Stadhalle | Offenback em Main, Germany | Offenback em Main | Germany | 15 | American Idiot tour | 1 | 2005 | 14 | Friday | 1 | January | 2023-11-05 15:36:06 | 2023-11-05 15:36:06 |