| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1699414502 | 2005-03-20 | green-day-march-20-2005-makuhari-messe-hokusai-tenjijou-chiba-japan.html | 1 | Green Day | American Idiot tour | 242 | Makuhari Messe Hokusai Tenjijou | Chiba, Japan | Chiba | Japan | 15 | American Idiot tour | 1 | 2005 | 20 | Sunday | 3 | March | 2023-11-08 03:35:02 | 2023-11-08 03:35:02 |