MLB data through querying on http://sportsdatabase.com by @sdql

This is awesome. I have been looking for game data in the MLB for the 2015 season, and although boxscores are fairly easy to find per day, to get them as one dataset is a lot harder. Yes, you can write a Python script that automatically pulls this data per day, but I found something far easier: SDQL, or sports data query language. Perhaps I have been under a rock for years, but to me this was an exciting find.

It is simple, and gives access to a lot of data in a format you can define yourself. I have a background in data and some SQL, but it really isn’t too hard to figure out by reading the documentation. For example, the following query: “date, game number, team, runs, hits, errors, o:team,o:runs, o:hits, o:errors, attendance, series game, total@season=2015” gives this result:

Exactly what I needed!

So thank you @sdql for providing this great tool!

[MLB data through querying on
http://sportsdatabase.com by @sdql]

The Calgary Crime Statistics Dashboard – updated

The Calgary Police Commission released its 2015 citizen survey results, in which they conclude that the Calgary police is highly valued and do an excellent job (see report here). As I have a lot of respect for the “(wo)men in blue” and the job they do I can relate to many findings in the report, but there was also a finding that struck me as odd: “One-half of Calgarians feel that crime has stayed the same over the last twelve months“. Of course this survey is about perception and not facts and numbers, and one cannot expect that all surveyed people are highly aware of their city’s crime statistics. But as someone in the middle of doing some analysis and visualization of those datasets, I wanted to share the crime statistics in a visual and easily consumable way. The dashboard unfortunately shows that crime incidents have strongly increased in 2015, with almost 16,000 crime incidents in 2015 until July (so seven months) compared to just under 19,000 incidents in 2014 (full year).

The dashboard is available on Tableau Public here (or click image below). As the embedding of Tableau Public dashboards in WordPress blogpost leaves a lot of room for improvement at this point the dashboard is not available in this post.

Calgary Crime Statistics Dashboard header

Before drawing any conclusions please have a look at the dashboard and read the Introduction and The data section.

Calgary Crime Statistics data visualized

Calgary provides police reports on the city crime statistics, but they are not easily consumed. With Tableau Public I have tried to provide insight in these statistics in the following dashboard.
Calgary Crime Statistics Dashboard

Although Tableau Public has an embedding function, WordPress doesn’t appear to like it as the result was appalling. So for now, viewing the dashboard works best by going through Tableau website itself, linked above.

It shows general crime trends, details per community, year and category,
CrimeIncidentMap
the crime-to-population ratio for communities,
Crime population ratio
and allows users to compare up to three communities:
Comparing crime between communities

I am happy that the city makes this data available, but I would hope they did so in a more readable and usable format. I hope this dashboard will help exposing this data to the people in Calgary.