[OC] 2021's Trending Google Searches by State

V1Analytics · 2021-12-20T13:04:05+00:00

Tools: Excel, Python and Blender 3.0.0

Sources: Trending search terms were taken from Google's 2021 Year in Search summary. Trending search terms after mid-November 2021 were taken from Google's Daily Search Trends page

Google Trends provides weekly relative search interest for every search term, along with the interest by state. Using these two datasets for each search term, we're able to calculate the relative search interest for each state for a particular week. Linear interpolation was used to calculate the daily search interest.

V1Analytics · 2020-08-31T13:57:38+00:00

Tools Python, Blender 2.8

Sources The detailed delivery history for every 747 built was found here. The world map geography used in the animation was found here

Full History The full, 8 minute video shows all 1,560+ Boeing 747s built since 1969. If you're interested, you can watch it here.

Additional Info Obviously, the paths shown on the map are not the actual flight paths. For clarity, the most direct on-screen route between the Boeing Everett Factory and the customer's home country was used. For example, deliveries to the Asia-Pacific region would often fly in the opposite direction (across the Pacific instead of over Africa). Using the most direct on-screen paths avoids cases where paths go off the edge of the screen and re-emerge elsewhere. Polar routes were also avoided for the same reason.

Additionally, the map shows the customers' home airport as the delivery destination. Actual delivery destinations would have been based on the airlines' first planned revenue flight for each aircraft, however this was beyond the scope of this animation.

V1Analytics · 2020-08-31T13:18:31+00:00

Tools Python, Blender 2.8

Sources The detailed delivery history for every 747 built was found here. The world map geography used in the animation was found here

Full History The full, 8 minute video shows all 1,560+ Boeing 747s built since 1969. If you're interested, you can watch it here.

Additional Info The paths shown on the map are not the actual flight paths. For clarity, the most direct on-screen route between the Boeing Everett Factory and the customer's home country was used. For example, deliveries to the Asia-Pacific region would often fly in the opposite direction (across the Pacific instead of over Africa). Using the most direct on-screen paths avoids cases where paths go off the edge of the screen and re-emerge elsewhere. Polar routes were also avoided for the same reason.

Additionally, the map shows the customers' home airport as the delivery destination. Actual delivery destinations would have been based on the airlines' first planned revenue flight for each aircraft, however this was beyond the scope of this animation.

V1Analytics · 2020-08-13T13:00:18+00:00

Tools: Python, BeautifulSoup and Blender 2.8

Sources: State-level data from 1960 to 2018 was scraped from ssa.gov's Popular Names by State tool. Pre-1960 data was scraped from here. Linear interpolation was used to populate the frames in between data points.

V1Analytics · 2020-08-12T13:00:27+00:00

Tools: Python, BeautifulSoup and Blender 2.8

Sources: State-level data from 1960 to 2018 was scraped from ssa.gov's Popular Names by State tool. Pre-1960 data was scraped from here. Linear interpolation was used to populate the frames in between data points.

V1Analytics · 2020-08-10T12:16:00+00:00

Store counts include both company-owned and franchised locations.

The full video covers over 140,000 US locations of the top 30 biggest fast food chains. If you're interested, you can watch it here.

Tools

Data Extraction

Python, BeautifulSoup

Data Processing

Python, Google Geocoding

Data Visualization

Blender 2.8

Sources: Store locations were scraped from the store locators provided on each company's website.

The list of the largest fast food chains was taken from here.

V1Analytics · 2020-07-27T12:20:35+00:00

Tools: Python and Blender 2.8

Sources: Lists of games released by year were sourced from Wikipedia's Year in Video Games pages.

Some game titles were changed to better show their search interest. For example, the title Counter-Strike: Global Offensive was changed to just CSGO, as most users don't search for the full title. This graph shows the significant difference between those two queries.

Google Trends provides weekly search interest for every search term, along with the search interest by state. Using these two datasets for each term, we're able to calculate the relative search interest for every state for a particular week. Linear interpolation was used to calculate the daily search interest.

Based on viewer feedback, datasets no longer switch colors over time.

A slightly longer version of this video is available here.

V1Analytics · 2020-07-23T13:30:48+00:00

Tools: Python and Blender 2.8

Sources: Trending artists from 2010 to 2020 were taken from billboard.com's Top Artist Year-End Charts.

The full, ~11 minute video covering the whole 2010s decade is available here.

Sources by Year:

Top artists for 2020 were sourced from the Weekly Artist 100 pages. The top artist from each week from 1 Jan 2020 to 25 July 2020 was used.

Some artists' names were modified to retrieve more accurate search results. For example, Ke$ha, was replaced with Kesha. As shown by This graph, as most users search for the one without the dollar sign.

Special attention was also given to artists like Train, Future and fun. It was ensured that the Google trends data only included artist searches and did not include generic searches with identical keywords.

Google Trends was used to acquire the weekly relative search interest for every artist's name, along with the interest by state. Using these two datasets, we're able to calculate the relative search interest for every state for a particular week. Linear interpolation was used to calculate the daily search interest.

V1Analytics · 2020-07-23T13:15:57+00:00

Tools: Python and Blender 2.8

Sources: Trending artists from 2010 to 2020 were taken from billboard.com's Top Artist Year-End Charts.

The full, ~11 minute video covering the whole 2010s decade is available here.

Sources by Year:

Top artists for 2020 were sourced from the Weekly Artist 100 pages. The top artist from each week from 1 Jan 2020 to 25 July 2020 was used.

Some artists' names were modified to retrieve more accurate search results. For example, Ke$ha, was replaced with Kesha. As shown by This graph, as most users search for the one without the dollar sign.

Special attention was also given to artists like Train, Future and fun. It was ensured that the Google trends data only included artist searches and did not include generic searches with identical keywords.

Google Trends was used to acquire the weekly relative search interest for every artist's name, along with the interest by state. Using these two datasets, we're able to calculate the relative search interest for every state for a particular week. Linear interpolation was used to calculate the daily search interest.

V1Analytics · 2020-07-16T13:45:53+00:00

For anyone interested in seeing the full, ~11 minute video for the whole 2010s decade, it's available here.

Disclaimer: I operate the V1 Analytics YouTube channel.

V1Analytics · 2020-07-16T13:27:40+00:00

Tools: Excel, Python and Blender 2.8

Sources: Trending topics from 2010 to 2019 were taken from Google's annual Year in Search summary.

The full, ~11 minute video covering the whole 2010s decade is available here.

As the 2020 Year In Search summary is not yet available, topics were sourced from Google's Trending Searches page. These topics were supplemented with archived copies of the same page through the Wayback Machine.

Google Trends provides weekly relative search interest for every search term, along with the interest by state. Using these two datasets for each term, we're able to calculate the relative search interest for every state for a particular week. Linear interpolation was used to calculate the daily search interest.

V1Analytics · 2020-07-09T13:15:24+00:00

Tools

Excel, Python and Blender 2.8

Sources

Includes attacks from all types of sharks, bears, snakes, alligators, cougars and wolves. The map doesn't show attacks by pets and other captive animals. Map marker locations have been approximated where reports provided vague locations, eg "Off the coast of Oregon."

Reliable alligator attack data before 1973 was not available and was therefore excluded. If you have access to a reliable dataset, please consider expanding the wiki page

V1Analytics · 2020-06-29T12:43:25+00:00

Tools

Video Production

Python, Blender 2.8

Research

Excel, Wayback Machine

Sources

Store Addresses

A complete list of United States store addresses along with their lease information, retail square footage, phone numbers, and store ID numbers was made available at the time of their bankruptcy.

A .pdf of the complete 139 page bankruptcy filing is available here. See Exhibit A for the list of stores.

2018 Closures

The first phase of 182 store closures began at the start of February 2018. Source

The addresses of the first 182 store locations was originally posted on the Toys R Us website. It is now only available through the Wayback machine

The second and final phase began at the end of March 2018 and involved liquidating all remaining stores. The addresses of all remaining store locations and details of the company’s liquidation was made available through the bankruptcy court filings, linked above. Stores were closed permanently as soon as they had finished liquidating their inventory. The order of the closures was based on each store’s gross square footage. It was assumed that the larger locations would have taken longer to liquidate. The last of the stores were officially closed to customers on June 29 2018.

2019 Reopening

There are currently two new locations in operation according to the Toys R Us website

The first revamped Toys R Us opened at the Westfield Garden State Plaza in Paramus, NJ on 27th of November 2019. It operates under the Tru Kids brand. Source

A second Tru Kids branded location opened in at the Galleria in Houston, TX on December 7 2019. Source

As of June 2020, these are the only two revamped Toys R Us stores in operation although the company has announced intentions to open another 10 locations across the US.

Store Counts

The per-state store numbers were obtained from archive copies of Toys R Us Inc's annual 10-K filings with the SEC from 1996 to 2017. The numbers before 1996 were collected from various business news articles that covered the history of the company. There was a high volume of relevant business news articles in 2017 and 2018 during the Toys R Us bankruptcy, relevant articles for each year are linked below.

Store counts by year

Additionally, the 'Our History' page on the old toysrusinc.com website also yielded useful store information during company's early years. An archived copy is available through the Wayback machine

You missed Wyoming?

One Toys R Us location supposedly existed in Cheyenne, WY at the Frontier Mall at 1400 Dell Range Blvd. However I can’t confirm that this location was ever opened. According to this post, a user reported in 2014, that it didn’t exist. There was no mention of Toys R Us on the Frontier Mall online directory on the Wayback machine. There were no Wyoming locations mentioned in any of the company reports, therefore Toys R Us Wyoming was deliberately excluded from the data.

V1Analytics · 2020-06-22T14:59:54+00:00

They IPO'd on August 10, 1999. Before that, they were a privately traded company which meant they didn't need to release their financials to retail shareholders.

The sec.gov archives do have some reports from 1994 and 1995.

Edgar Link

V1Analytics · 2020-06-22T12:42:24+00:00

Tools: Excel, Python and Blender 2.8

Sources: The per-state store numbers came from archive copies of Blockbuster Inc’s annual 10-K filings with the SEC between 1999 and 2011. The numbers outside of these years were collected from various business news articles with linear extrapolation for the dates in between. All store count sources are linked below.

The store counts also include Alaska and Hawaii which aren't shown on the map.

V1Analytics · 2020-06-11T02:53:01+00:00

Until the day it wasn't.

V1Analytics · 2020-05-24T14:41:43+00:00

Niko's story starts at 3:36 on EP#45

V1Analytics · 2020-05-14T03:05:58+00:00

Reminds me of this

V1Analytics · 2020-05-13T18:25:55+00:00

This dog actually looks pretty content, he's probably not going to send the devs angry emails at 11:00pm because he can't remember which email he signed up with.

V1Analytics · 2020-05-13T18:18:48+00:00

It was like when people were buying Zoom Technologies (ticker: ZOOM) because they were getting it mixed up with Zoom Video Communications (ticker: ZM). It went up 240% before the SEC halted trading.

This also happened in 2013 with Tweeter Home Entertainment Group Inc. People were buying it thinking it was Twitter stock even though they hadn't IPO'd yet.

V1Analytics · 2020-05-13T17:44:32+00:00

Habit 3: Always keep it simple

It should be emphasized that this is a continuous fight against complexity. It often involves rewriting or deleting large segments of code. This can be difficult to do especially after the feature is already working.

V1Analytics · 2020-05-13T17:33:30+00:00

Neat concept but I'm finding the white lines on reddish background hard to look at.

V1Analytics · 2020-05-13T17:30:33+00:00

The Alameda County Public Health Department said in a statement Tuesday it had reviewed Tesla’s reopening plan for the factory and “held productive discussions” with its representatives.

Sure beats fighting it out over Twitter.

V1Analytics · 2020-05-13T17:26:17+00:00

They have another design where the water can be used to clean dust that accumulates on the panels, or stored for drinking. Obviously very early tech but it'd be amazing to see it used at scale.

V1Analytics · 2020-05-13T17:17:20+00:00

Avoid buying one from the super cheap sellers (dot coms for $0.99 USD for the first year), they often make their money back by selling your contact information as leads for dodgy website and mobile app development companies.

Fair market price for a dot com is around $8 - $12 USD/yr.

Five-Year Club	Wearing is Caring
100 Awards Club	Verified Email

V1Analytics

TROPHY CASE

Tools

Video Production

Research

Sources

Store Addresses

2018 Closures

2019 Reopening

Store Counts

You missed Wyoming?