Sunday, February 28, 2016

Data update 2: innovative website helps find missing animals

Opening lead sentence:
More lost animals in Vancouver have been found and matched ever since the BC SPCA launched their innovative online lost and found website in 2012.

Here is the raw data and a small slice from the data:

The spreadsheet shows all lost animals in the city of Vancouver since the year 1999, and is still being updated in 2016 (Note that the years 2007-2011 are incomplete). Since those five years are incomplete, I decided to start at 2012, and lo and behold, I was able to find an article that related directly to the year 2012 (I literally spent all week trying to find an article that would add additional context to any aspect of the spreadsheet whatsoever, as well as figure out what to include in the slice, and was actually freaking out that I wouldn't find an article or figure out a slice and would have to change databases, but thankfully it all worked out in the end). The slice contains the number of animals that were lost in 2012 up until mid-February of 2016, and categorizes them into found, lost, and matched columns. Using these numbers, I calculated the percentage of found and matched animals, and each year's percentage was higher than 2012's.    

Here is the original dataset:

Here is a news story that relates to the data:

This article is about the then new online lost and found website the BC SPCA launched in January of 2012. It outlines some of the key features of the website, such as the public being able to post their own photos and descriptions of lost and found animals directly on the website. This article is relevant to my data because ever since the website was launched in 2012, the percentage of lost animals being found and matched has gone up and has not been lower than the 2012 percentage. It is safe to say that the launch of the BC SPCA lost and found website has factored into more lost animals being found and matched over the past few years.