| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1699468986 | 2005-05-17 | green-day-may-17-2005-mts-centre-winnipeg-mb-canada.html | 1 | Green Day | American Idiot tour | 1378 | MTS Centre | Winnipeg, MB, Canada | Winnipeg | MB | Canada | 15 | American Idiot tour | 1 | 2005 | 17 | Tuesday | 5 | May | 2023-11-08 18:43:06 | 2023-11-08 18:43:06 |
| 1699838725 | 2009-07-09 | green-day-july-9-2009-mts-centre-winnipeg-mb-canada.html | 1 | Green Day | 21st Century Breakdown tour | 1378 | MTS Centre | Winnipeg, MB, Canada | Winnipeg | MB | Canada | 16 | 21st Century Breakdown tour | 1 | 2009 | 9 | Thursday | 7 | July | 2023-11-13 01:25:25 | 2023-11-13 01:25:25 |