Open ladeeluc opened 11 months ago
This website gives a URL to download a csv of the current season's home games: https://www.mlb.com/cubs/schedule/downloadable-schedule
The URL can be modified to download previous seasons as well:
Wrigley also acts as a stadium for big performances. We should count those as well.
Digging around, Do312 has a page with events at Wrigley that we could scrape: https://do312.com/venues/wrigley-field/past_events?page=5
The Cubs dates I used to find a relationship:
7/6/2021 7/7/2021 7/8/2021 7/9/2021 7/10/2021 7/11/2021 7/23/2021 7/24/2021 7/25/2021 7/26/2021 7/27/2021 7/28/2021 7/29/2021 8/6/2021 8/7/2021 8/8/2021 8/9/2021 8/10/2021 8/11/2021 8/12/2021 8/20/2021 8/20/2021 8/21/2021 8/22/2021 8/23/2021 8/24/2021 8/25/2021 7/1/2022 7/2/2022 7/3/2022 7/12/2022 7/13/2022 7/14/2022 7/15/2022 7/16/2022 7/17/2022 7/25/2022 7/26/2022 8/6/2022 8/7/2022 8/8/2022 8/9/2022 8/10/2022 8/19/2022 8/20/2022 8/21/2022 8/22/2022 8/23/2022 8/24/2022 8/25/2022Event Dates (should be confirmed)8/13/20218/29/20218/30/20218/15/2022 | 8/13/2021 | 8/29/2021 | 8/30/2021 8/13/2021 8/29/2021 8/30/2021
Chad, thanks! Hypothesis is proving out for games. This is actually profound. I'm getting goose bumps and I spilled a glass of tea on my keyboard. Second glass of tea down from getting excited about data. Look what it takes to make me happy.
Chad, can you look at 3-5 am and see if you notice any increase as a result of aircraft data? The new Wilson and Berteau aligned O'Hare runways are not used equally every day and have some rotation as a result of wind direction and of noise complaints to FAIR, Fair allocation of runways. Aircraft drop to 1,000' at Clark so I'm wondering if this will show up. I'm thinking their particulates are heavy and may be impactful to health and observable. If you looked at a sample of 10 days per month, from 3-5 am, I think you might see an aircraft impact.
Janice,
I think the most important thing ChiTech could look for is statistically significant relationships between Wrigley events, PM2.5/NO readings from the local meter, AQI and temperature. In grabbing just events for July and August 2021/22, there's nothing I see in simple Excel that correlates. SPSS or a statistical package might tease something out. The AQI I used is for Chicago or Cook County averaged daily.
My quick read of air quality analysis like this is that there's certainly local impacts from transportation-related emissions, but the vast majority of air emissions in urban areas that affect neighborhoods are point-source pollutants like older industrial areas.
Chad
Let's focus on adding dates and times for 1) CUBS home game days and start times, 2) Wrigley events (with name) and start time. 3) Pub Craws on Clark Street. 4) Chicago Marathon (with restricted traffic for a number of hours),
@MarkPerlman was able to find acsv
download of cubs games at Wrigley here: https://www.ticketing-client.com/ticketing-client/csv/GameTicketPromotionPrice.tiksrv?team_id=112&home_team_id=112&display_in=singlegame&ticket_category=Tickets&site_section=Default&sub_category=Default&leave_empty_games=true&event_type=T&year=2021&begin_date=20210702&end_date=20230330
(clicking that link will download a csv
Derek's take: Wrigley Field is a major destination in this community and a likely cause of spikes in poor air quality with many cars and buses arriving. Lets get the list of events at Wrigley and see if there is a correlation in our air quality sensor data.