Topic Modeling Graph Results

I wasn’t sure how to label in Google Fusion tables(oops), but in my graphs the X axis represents the publication year and the Y axis represents theme frequency. Overall, I liked thinking about the graph results and musing over what the data might represent.

Gun: There was a large increase in this topic from December 1st 1893 to October 12th 1893. In 1893, The Final Problem was published. Although Holmes dies (insert massive question mark here) in the story, it isn’t gun related. He plummets to his death (insert another massive question mark here) at Reichenbach Falls with Moriarty. However, he is beaten with a police baton, so maybe my topic is faulty. The topic drops the next year, rises again in 1904, and then falls until 1911. After this, the graph experiences spikes in 1917, 1922, and 1925. I looked up guns in Victorian London using victorianlondon.org, and found an entry detailing a gun involved murder from 1876. Given the later dates, and presuming that I didn’t mess up to topic, maybe it’s that guns became more available, and recognized in crime stories.

Gun topic
Gun topic

Continue reading

Google Fusion Charts

After many thoughts about what to chart and map using the Google Fusion service, I decided to document some of the cities I visited this past summer during my study abroad adventure in Germany.  I mapped the various cities and their populations.  I was curious to see how many people live within each city after visiting and experiencing them.  Each category links to the original charts.

Cards

Here is an overview of the ten cities I visited or traveled through.  I included the city name, country, an image, and the geographic location with latitude and longitude coordinates.

cards1

 

Map

Below is a physical map that highlights each of the cities.

map

 

Pie Chart

This pie chart demonstrates the city populations.

piechart

 

Bar Graph

This graph also charts city populations ranging from smallest city to largest.

bargraph

 

Network

This network visualization shows the relationship between each city and its population.

network

Erica Gedney

2014 MLB playoff contenders entering the season’s final weekend

Contending Teams

Contenders 4

Contender Locations

Contenders 2

Regular Season Win Total Comparison

Contenders 3

Berth Origin Comparison

Separates the contenders based on how they are contending, whether it be contending as a division champion, wild card champion or a team still eligible to be a division champion and a wild card champion.

Contenders 1

League Comparison

Shows how competitive each league still remains going into the last weekend before the playoffs begin, based on how many teams still haven’t been eliminated.

Contenders 5

Link to Google spreadsheet:

https://docs.google.com/spreadsheets/d/12mjxzeJciCtRS9S9_dyzPoYW9S9yk-2T583x0vXTZ7c/edit#gid=0

Link to Google Fusion Table

https://www.google.com/fusiontables/data?docid=1kL3NS9Hk0iZ1T3nd-eORRWfU213tmGGa9i4q9pjT#chartnew:id=6

 

 

 

Google Fusion Lab: Earthquake Magnitudes Greater Than 8 Since 2006

Screen Shot 2014-09-25 at 8.09.12 PM
https://www.google.com/fusiontables/DataSource?docid=1WX-XMGPGUG3EkUG31oc_StC4CpB3Z410IMdCrdjG
Screen Shot 2014-09-25 at 7.37.30 PM
https://www.google.com/fusiontables/DataSource?docid=1WX-XMGPGUG3EkUG31oc_StC4CpB3Z410IMdCrdjG
Screen Shot 2014-09-25 at 7.38.08 PM
https://www.google.com/fusiontables/DataSource?docid=1WX-XMGPGUG3EkUG31oc_StC4CpB3Z410IMdCrdjG
Screen Shot 2014-09-25 at 7.37.13 PM
https://www.google.com/fusiontables/DataSource?docid=1WX-XMGPGUG3EkUG31oc_StC4CpB3Z410IMdCrdjG
https://www.google.com/fusiontables/DataSource?docid=1WX-XMGPGUG3EkUG31oc_StC4CpB3Z410IMdCrdjG
https://www.google.com/fusiontables/DataSource?docid=1WX-XMGPGUG3EkUG31oc_StC4CpB3Z410IMdCrdjG
https://docs.google.com/spreadsheets/d/1cPVGF0LwoGNYpVmJGrqaCDL7vI6Sj66zcWVrq7Cg5G4/edit?usp=sharing
https://docs.google.com/spreadsheets/d/1cPVGF0LwoGNYpVmJGrqaCDL7vI6Sj66zcWVrq7Cg5G4/edit?usp=sharing

Works Cited

“Earthquake Hazards Program.” Earthquake Hazards Program. U.S. Department of the Interior | U.S. Geological Survey, 14 Apr. 2014. Web. 26 Sept. 2014.

By Mary Dellas