| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1700357536 | 2022-11-18 | the-mugs-november-18-2022-calumet-arts-cafe-buffalo-ny-usa.html | 1 | The Mugs | Novemberfest | 277 | Trilogy | Boulder, CO, USA | Boulder | CO | USA | 7 | Relish Run '22-'23 | 1 | 2022 | 18 | Friday | 11 | November | 2024-10-29 21:15:40 | 2023-11-19 01:32:16 |
| 1735825306 | 2025-01-31 | the-mugs-january-31-2025-trilogy-simsbury-ct-usa.html | 1 | The Mugs | 93 | Trilogy | Simsbury, FL, USA | Simsbury | FL | USA | 12 | Holiday Tour 2024 | 1 | 2025 | 31 | Friday | 1 | January | 2025-01-02 13:41:46 | 2025-01-02 13:41:46 |