![]() The Post chart suggests 2016 is only 4 times bigger, which is partly because of they ignored one of the search queries and partly because the other days of the months weren’t that different and worked to even things out. The single day spike for the 2016 election is more than 10 times bigger than for the 2020 election. While daily data may be too granular to view over the whole 20-year span, it did provide one unexpected insight, which can be seen in this 5-year view. Instead I used the monthly values from the original full range query to normalize the daily values within each month and then re-normalized everything back to 0 – 100. However, with the activity on many days being 0 or very low, the alignment wasn’t precise. My first strategy to overcome that was to incorporate some overlap in my queries so I could use those for alignment (like aligning tree rings to date old lumber). Quirk #3 meant all of those 29 files had values in different scales. For quirk #2, I was able to write a script that opened 29 web pages (at least the data range is in the URL), each covering 8 months and then I just had to click all the download buttons manually. Wanting daily data over the entire range, I eventually figured out if I asked for 8 months of data at a time, I would get daily data. The data is normalized so that the maximum value is always 100, meaning the values are relative over the search interval.There’s no (longer any) API for downloading the data – you have to click a download button to get the data.The granularity might be monthly, weekly or daily (or finer for current data). ![]() ![]() The granularity of the data is solely a function of the date range of the query.First, there are a few quirks regarding Google Trends data (as far as I can tell). I can’t think of a good explanation for doing that, but I proceeded to retrieve both queries and combine them for my own charts. By only using “move” their 2020 spike is exaggerated. Both are similar for 2016 but “moving” is much smaller for 2020. The Post appears to have only used “move” and ignored the data for “moving”. Or did they … ? Here’s the 2016 and later part of the original Google Trends chart for both queries, with “move to Canada” in red and “moving to Canada” in blue. The article nicely includes a link to their query, which indicates they looked at both “move to Canada” and “moving to Canada” searches. To get a better understanding, I set out to download the Google Trends data myself. Even in their chart, the 2020 “spike” is the smallest annotated peak and is preceded by a longer ramp-up than the others, making it more of a sudden drop than a spike. It sounds like a mischaracterization to me to imply the election of Joe Biden was a trigger for a “move to Canada” spike. Bush, the 2020 election of Joe Biden and the 2016 election of Donald Trump, Google search interest in moving to Canada spiked. In addition to the annotations within the chart, the text added:Īfter the 2004 reelection of George W. In a story about US emigration, the Washington Post’s Department of Data showed this chart of search frequency for “move to Canada”:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |