Juan Convers

The Economist published a couple of days ago in their daily chart section an interesting graph with the most violent cities in the world (in terms of homicide rate). They have an analysis on how the Venezuelan economy is in turmoil and how according to a Mexican report "Venezuela's capital Caracas had the highest murder rate in the world last year"

Wikipedia also offers a page compiling a List of cities by murder rate. Unfortunately most of the Top 50 cities from this list are located in South America (and many of those in Brazil!). Take a look at the following chart and map:

Last night I was reading in Business Insider the headline about how Bernie Sanders just melted away a 30-point Hillary Clinton lead in a new poll, related to the US presidential elections. Wikipedia has a useful article where they track the different polls for both parties. The results of those polls are reported here on that page: Democratic Primaries.

It's true that the last poll conducted by the Quinnipiac University shows a preference of: Clinton: 44% and Sanders 42%, and with a 4.5% margin of error, they are virtually tied. There is even a newer one performed by "Reuter/Ipsos" showing a similar trend: Clinton: 48% and Sanders 45% (with a 5% margin of error).

It's fascinating to see how this candidate without any of the infamous [superpacs](https://en.wikipedia.org/wiki/Political_action_committee#Super_PACs) behind him has been able to attrack so much attention and how it has become a real contender in the US 2016 presidential elections.

This morning I was reading on the news how the "Average 30-year mortgage rate falls for a 5th straight week" (3.72%)>. I was checking if the data was available to double check this headline. Fortunately the Federal Reserve Bank of St. Louis offers this data set on their website. It's called MORTGAGE30US and the data goes back all the way to 1971.

Looking at the data it's true that the 30-year mortgage rate has been falling during the last couple of weeks. Nevertheless it's not the lowest point in the graph. Actually last year, around the same time it was even lower (3.59%):

I wanted to wrap up this series of post I have been writing about the people living in Berlin, using data provided by the Statistical Office of Berlin-Brandenburg, with a final post about EU foreign citizens living in the city.

A couple of days ago I was discussing how Poland, Italy and Bulgaria where the EU countries with the highest number of expats living in the Berlin, but the data also contains a very interesting breakdown per district (berzik).

I put the totals in a density map:

I also used the specific countries data to create a matrix heatmap using an the tutorial on how to create a heatmap with jQuery and Tables. See the resulting table below:

There a couple of interesting conclussions from the data: Polish are definitively the highest minority from the EU countries and this can be observed in every district. Mitte is definitively the most popular district for most of the EU citizens and finally Marzahn-Hellersdorf is the least popular overall.

Almost the same picture taken near to Rosentharlerplatz in two different seasons in Berlin.

Next page