| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1658553333 | 2022-06-15 | goose-june-15-2022-red-hat-amphitheater-raleigh-nc-usa.html | 1 | Goose | 288 | Red Hat Amphitheater | Raleigh, NC, USA | Raleigh | NC | USA | 29 | Dripfield Summer Tour 2022 | 1 | 2022 | 15 | Wednesday | 6 | June | 2022-08-22 05:13:35 | 2022-07-23 05:15:33 | |
| 1707240752 | 2024-06-18 | goose-june-18-2024-red-hat-amphitheater-raleigh-nc-usa.html | 1 | Goose | 288 | Red Hat Amphitheater | Raleigh, NC, USA | Raleigh | NC | USA | 36 | Summer Tour 2024 | 1 | 2024 | 18 | Tuesday | 6 | June | 2024-06-19 19:38:39 | 2024-02-06 17:32:32 |