In this article:
- Rolling Stone Top 500
- Solar System Objects
- 1978 Births
- Amazon and Coke Stock
- Google Trends Pumpkin Spice
- Kentucky Derby
- M&Ms Colors
Note: Click section titles to open its data set in Google Drive.
Here are seven additional data sets you can explore with Vizable.
Each data set includes a sample moment, an example insight hiding in the data, and an explanation of the data set itself and its fields.
The best albums, according to Rolling Stone Magazine in 2012, came from the late '60s and early '70s.
- Album: the album name
- Artist: the artist name
- Rank ID: where the album fell in the top 500 list
- Number field: number of records
The average moon is larger than the average dwarf planet in our solar system. Who knew?
Who hasn’t looked up at the sky and marveled at the size of it? Based on data from Wikipedia, this data set contains information about 29 solar system objects. Note that some objects present in the Wikipedia table are missing from the data set, because the data was incomplete. Because there are no dates in this data set, Time World does not display an analysis.
- Body: the name of the object itself, such as the Earth or Jupiter
- Type: if the object is a star, planet, moon, or dwarf planet
- Radius (km): the approximate radius of the object in kilometers, with uncertainty removed
- Earth Radius: the radius of the objects as a multiple of the radius of the Earth
- Volume (billions of km^3): the volume of the object in billions (109) of cubic kilometers
- Earth Volume: the volume of the object as a multiple of the volume of the Earth
- Mass (yottagrams): mass of the object in yottagrams (1021 kilograms)
- Earth Mass: mass of the object as a multiple of the mass of the Earth
- Density (g/cm^3): density of the object in grams per cubic centimeter, with uncertainty removed
- Gravity (m/s^2): gravity on the object in meters per second squared
- Earth Gravity: gravity on the object as a multiple of the standard Earth gravity
- Rank: rank by size (1 is largest)
In 1978, noticeably fewer births occurred on weekends, with the fewest on Sundays.
This data set was taken from Todd Swanson’s Department of Mathematics page for Hope College. The original source is unknown. Were mothers extremely polite in the late 70s? Were doctors unavailable on weekends? Whatever the reason behind the trend, the periodicity of the data cannot be denied.
- Date: month/day/year in 1978
- Day of Week: the day of the week for the given date
- Number of Births: the raw count of the number of births in the USA on that date
- Are there any other periodic trends in the data besides the weekends?
- In 1978, the following were holidays. Were there dips in the number of births on these days as well?
- Jan 1, New Year’s Day
- Jan 2, New Year’s Day (observed)
- February 14, Valentine’s Day
- February 20, President’s Day
- May 14, Mother’s Day
- May 29, Memorial Day
- June 18, Father’s Day
- July 4, Independence Day
- March 26, Easter Sunday
- September 4, Labor Day
- October 31, Halloween
- November 11, Veteran’s Day
- November 23, Thanksgiving
- December 24, Christmas Eve
- December 25, Christmas Day
- December 31, New Year’s Eve
Two instantly recognizable brands, Amazon (AMZN) and Coca-cola (KO) show opposite trends in their closing stock prices over the course of 2014.
- Date: month/day/year for weekdays in 2005-2014
- AMZN Closing Price: closing stock price on that day for Amazon
- AMZN Daily Percent Return: the daily percent return for Amazon stock
- KO Closing Price: closing stock price on that day for Coca-cola
- KO Daily Percent Return: the daily percent return for Coca-cola stock
According to Wikipedia, “The U.S. stock market peaked in October 2007, when the Dow Jones Industrial Average index exceeded 14,000 points. It then entered a pronounced decline, which accelerated markedly in October 2008. By March 2009, the Dow Jones average had reached a trough of around 6,600.” Specifically, Monday, October 6th, 2008 was the start of a dramatic, week-long decline in the stock market. How were these two industry titans affected, if at all?
If you’re alive in America these days, you likely know that Autumn = Pumpkin Spice Lattes. Here, Google Trends data illustrates just how seasonal this obsession is—and how long-standing.
Pulled from Google Trends on 10/10/15, this data set compares the relative search interest for three terms from 2004 to 2015.
From Google, “The numbers that appear show total searches for a term relative to the total number of searches done on Google over time. A line trending downward means that a search term's relative popularity is decreasing. But that doesn’t necessarily mean the total number of searches for that term is decreasing. It just means its popularity is decreasing compared to other searches.”
- Week: month/day/year for the Monday of each week, 2004-2015
- Pumpkin Spice: the relative search interest for pumpkin spice
- Pumpkin Spice Latte: the relative search interest for pumpkin spice latte
- Latte: the relative search interest for latte
- On September 28, 2015, The Washington Post posted an article about pumpkin spice lattes and Hilary Clinton. Was there a corresponding spike in search interest?
- How has the obsession with Pumpkin Spice Lattes increased over time?
Did horses suddenly become faster in 1986? What else could explain a 26% drop in winner’s time from 1891 to 1996?
Found on the page for a Stetson University math professor, this data set (original source unknown, data from 2011-2014 and overall jockey information supplemented from HorseRaceInsider.com and 2015 data from Wikipedia) tracks the results of the Kentucky Derby since its inception in 1875. The Kentucky Derby was first run at 1.5 miles (2.4km), but in 1896, the distance was changed to 1.25 miles (2.0km), the length it remains today.
- Year: year of the race
- Winner: winning horse
- Jockey: jockey riding the winning horse
- Time (s): time in seconds of the winning horse
- Difference from Secretariat (s): calculated field subtracting 119.4 seconds (Secretariat’s record-breaking time) from the winning time that year. The difference is in seconds.
- The Kentucky Derby is the first of three races which, if won, bestow the Triple Crown on the victor. As of 2015, only 12 horses have won the Triple Crown. How do their times compare for the Kentucky Derby?
- Sir Barton, in 1919, ridden by Johnny Loftus
- Gallant Fox, in 1930, ridden by Earl Sande
- Omaha, in 1935, ridden by Willie "Smokey" Saunders
- War Admiral, in 1937, ridden by Charles Kurtsinger
- Whirlaway, in 1941, ridden by Eddie Arcaro
- Count Fleet, in 1943, ridden by Johnny Longden
- Assault, in 1946, ridden by Warren Mehrtens
- Citation, in 1948, ridden by Eddie Arcaro
- Secretariat, in 1973, ridden by Ron Turcotte
- Seattle Slew, in 1977, ridden by Jean Cruguet
- Affirmed, in 1978, ridden by Steve Cauthen
- American Pharoah, in 2015, ridden by Victor Espinoza
- What jockeys have won more than one Kentucky Derby? What is the maximum number of Derby’s won by a single jockey?
Brown is clearly the front-runner, but orange, blue, and green are about tied for least-common.
In 2001, math professor Todd Swanson had his students count the number of each color M&Ms in 84 fun-size bags of M&Ms. This data set contains their findings. Note, there is no date field in this data, so Time World will not show an analysis.
- Color: the six colors of M&Ms
- Number: the number of M&Ms