PORDATA - Alojamentos e Condições de Vidas

(Este texto faz parte da minha exploração da PORDATA – uma base de dados relacionados com Portugal) Não tinha ideia de que a construção de casas diminuiu tanto desde 2002. Nesse ano foram construídas aproximadamente 9 vezes mais casas do que em 2019. Adoro este gráfico: A percentagem de agregados com uma arca congeladora subiu ~10% entre 2000 e 2005… e desceu outra vez ~10% até 2010. O que raios aconteceu aqui?...

November 7, 2020

PORDATA - Receitas e Despesas do Estado

(Este texto faz parte da minha exploração da PORDATA – uma base de dados relacionados com Portugal) Algumas curiosidades: O IVA é responsável por uma maior parte da receita do estado do que o IRS, que por sua vez dá mais receita que o IRC. Gráfico aqui: Os próximos dois gráficos vêm daqui. Acção e segurança social é a área onde o Estado gasta mais per capita, seguido de Saúde e Educação:...

October 31, 2020

PORDATA - Library users per year

(This is part of my explorations of PORDATA – A Portuguese open data database) This plot really really surprised me: It shows the permilage of people in Portugal who are library users. Checkout that 2003’s number. An astonishing 82.6% of the population was going to libraries! This sounds too much to me. I don’t think I know anyone who goes to libraries. But I guess that 2020 is a really different world than 2003....

October 25, 2020

PORDATA - Hours of Work Per Week

(This is part of my explorations of PORDATA - A Portuguese open data database) This surprised me: It shows the average of weekly work hours for people who work for some employer (vs. being self-employed). Since the last methodology change (that’s what those dark symbols represent) in 2011 the average diminished by 0.9 hours. There was a decrease in all jobs categories. This happens for both genders: (Dark orange are males, light orange are females)...

October 18, 2020

PORDATA - Marriages per year

(This is part of my explorations of PORDATA - A Portuguese open data database) Here is the plot of total number of marriages per year. Interesting things: Number of marriages per year decreased from ~70.000 in 1960 to ~33.000 in 2019, even though population has increased. Number of marriages per year increased by 20.000 (!) from 1974 to 1975. This is probably somehow related with the fall of the Portuguese dictatorship in 1974 that lead to the immigration of more than 300....

October 17, 2020

Portuguese Local Elections - Ballot Order Effects

I’ve read somewhere that, in elections, the position of a candidate in the ballot affects how much votes are cast for her. Does this happens in the Portuguese Local Elections for câmara municipal? Let’s take a look. Unfortunately, I can only find computer-readable data on ballot order for the 2013 elections. There is a PDF with this information for 2005, but my efforts to automatically extract data from the document were in vain (I tried some Python PDF extraction tools)....

April 21, 2017

Portuguese Local Elections - Municipalities with more enrolled voters have a higher percentage of abstention

2021 EDIT: Originally there were images in this post, but they were lost to the ravages of time. Currently I’m getting into Data Science and as way to practice I’m exploring data on previous Portuguese Local Elections. One interesting thing that I found is that municipalities with a higher number of voters enrolled also have a higher percentage of people not voting. There seems to be some kind of inverse exponential relationship....

April 12, 2017