| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1614314179 | 2019-04-18 | goose-april-18-2019-the-mercury-lounge-new-york-ny-usa.html | 1 | Goose | 92 | The Mercury Lounge | New York, NY, USA | New York | NY | USA | 14 | Spring Tour 2019 | 1 | 2019 | 18 | Thursday | 4 | April | 2024-10-19 01:19:19 | 2021-02-25 23:36:19 | |
| 1613526499 | 2019-10-31 | goose-october-31-2019-the-mercury-lounge-new-york-ny-usa.html | 1 | Goose | 92 | The Mercury Lounge | New York, NY, USA | New York | NY | USA | 5 | Fall Tour 2019 | 1 | 2019 | 31 | Thursday | 10 | October | 2023-10-24 20:32:18 | 2021-02-16 20:48:19 |