What I knew when I came to Rio were three things: I love journalism, I love data and I love programming. So, what a great opportunity – a seminar about data journalism in Rio de Janeiro. What I did not know until arriving in Brazil: That I would lose my heart yet another time, to this great country and the most beautiful city I’ve ever seen.
Now, when you’ve found a place that one could call paradise (in lack of having seen actual paradise, that is), you start imagining moving there, or, in my case, spending at least a couple of months each year at that place (preferably in Brazilian summer, when it’s winter in Germany and freezing cold in Europe). But as everybody keeps telling stories about how expensive life is in Brazil and specifically in Rio, I wanted to know if I could afford moving here at all. What a nice coincidence that a colleague was working on a map about how rents in Rio had risen during the last years.
For visualizing that, he needed the data he found on rents and their development in a specific form, but he only had a dozen tables with unstructured data – useless from a programmer’s point of view. So we had to use our brains to think of a way to structure the data, clean up the tables manually – and then load all the data into a database. Now we could use the database to render the average rents for different neighborhoods. The visualization was almost done, but the process left us with all the data in a database. Delete it? Why?
I thought that it would be a nice service if one would be able to search for average rental prices in some of the neighborhoods in Rio. You can search for neighborhoods and/or dates. You’ll get a list containing min, max and avg of the accounted rental prices:
Database of rental prices in Rio de Janeiro
And though rents have increased a lot, I’ve decided to come back. See you soon, Rio!
Jan-Henning Niediek, 31, freelance journalist and programmer, www.zonezero.de, Bonn