Currently I'm working with the records relating the villages smaller than 250 inhabitants, from 1987 till 2007
My first hard work is to verify the 6.600 records in order to guarantee that the names can be recognized, in the sense that Mr. Joaquin ( In Spanish ) Tortades, is the same candidate than Mr Joaquim ( In Catalan ) Tortades, and also the same than Mr Quim ( Familiar form of the name in Catalan ) Tortades.
This is needed to be able to follow their political career along the time, specially if they have been changing from a party to another, or to others in general.
The names have been manually digitalized, and there is a high number of typing errors, which makes standarization to be a huge work
diumenge, 27 de febrer del 2011
dissabte, 26 de febrer del 2011
and the winner is...
This is a post coincident with the Oscar awards, so the title is the best one.
As expected ( ! ), currently, all the available records at the Ministery, are properly stored in my pc.
It has not been easy. It has taken a lot of time, emails and phone calls to get their attention in order to spend a little bit of their time ( public servants ) to cooperate with me.
The problem is moving to another field. They can't provide me with the details of the municipalities of more than 250 inhabitants, and less than 100.000, so 80% is not available.
Yesterday I spent 4 hours in the library of the Province Official Gazzette ( BOP ) of Barcelona, surfing through the June-October books of the year 1995.
My average speed was 20 municipalities per hour. The problem is that they can publish their decisions about government structure along four months, without an official publication date.
It means that I have to read, day by day, searching for the needed document.
I need information about 80 cities, in 5 electoral contests, giving a result of 400 documents for which I don't know the publication day
If the average speed remains 20 per hour, I will need 20 hours. If the Library opens 4 hours a day, in 5-7 days should be ready
Meanwhile I will start to work with the documents downloaded from the on-line registers and the ones recorded yesterday, to guarantee that this is a workable stuff
It seems that collecting data will be the core of the investigation
As expected ( ! ), currently, all the available records at the Ministery, are properly stored in my pc.
It has not been easy. It has taken a lot of time, emails and phone calls to get their attention in order to spend a little bit of their time ( public servants ) to cooperate with me.
The problem is moving to another field. They can't provide me with the details of the municipalities of more than 250 inhabitants, and less than 100.000, so 80% is not available.
Yesterday I spent 4 hours in the library of the Province Official Gazzette ( BOP ) of Barcelona, surfing through the June-October books of the year 1995.
My average speed was 20 municipalities per hour. The problem is that they can publish their decisions about government structure along four months, without an official publication date.
It means that I have to read, day by day, searching for the needed document.
I need information about 80 cities, in 5 electoral contests, giving a result of 400 documents for which I don't know the publication day
If the average speed remains 20 per hour, I will need 20 hours. If the Library opens 4 hours a day, in 5-7 days should be ready
Meanwhile I will start to work with the documents downloaded from the on-line registers and the ones recorded yesterday, to guarantee that this is a workable stuff
It seems that collecting data will be the core of the investigation
dissabte, 15 de gener del 2011
The Gollum of information
When the administration makes data available to the world through a website, and somewhere in the website they offer: for ad-hoc files, please contact..., what I would never expect is to have to wait 7 days for a negative answer.
The database has been built up with public information ( elections ) paid with public funds. How can they consider themselves as the owners of the information ?
Is it possible that they have never heard about the society of knowledge and sharing information?
This becomes a personal war. I will be the winner. Their only option is When, but they still don't know it.
The database has been built up with public information ( elections ) paid with public funds. How can they consider themselves as the owners of the information ?
Is it possible that they have never heard about the society of knowledge and sharing information?
This becomes a personal war. I will be the winner. Their only option is When, but they still don't know it.
Information is preciousss, is mineeee....
dissabte, 25 de desembre del 2010
Christmas lunch
This is the picture after the battle
Time to verify that there is a family, that they have not forgotten you, eat and drink.
Also good time to recap activities of the last months.
In fact, a lot of expectations accompagnied of few facts, but not reaching the minimum expectations. In fact, I've only some investigation paths, and a very limited set of data to work.
I'm starting to understand the time frame of this kind of research projects: nobody is expecting you to serve your interests.
I will use the 10 days of Christmas Holidays to see what can I do with the already available records, and to contact the political parties, which could be a source of information
Time to verify that there is a family, that they have not forgotten you, eat and drink.
In fact, a lot of expectations accompagnied of few facts, but not reaching the minimum expectations. In fact, I've only some investigation paths, and a very limited set of data to work.
I'm starting to understand the time frame of this kind of research projects: nobody is expecting you to serve your interests.
I will use the 10 days of Christmas Holidays to see what can I do with the already available records, and to contact the political parties, which could be a source of information
divendres, 3 de desembre del 2010
a, b, c, d....
The original documents produced after a local election process, seem to have the origin not in the Province, but in the Zone Electoral Administration, so at a lower level.
They keep copy of the summary, while the originals are deposited in the Catalonia National Archive.
I will address writen requests to both, because in any case, the authorization must be issued by the Secretary of the Electoral Administration, which will disappear in about 90 days, because their lifecycle is 100 days and the elections to the Parliament took place November the 28th.
Time to run
They keep copy of the summary, while the originals are deposited in the Catalonia National Archive.
I will address writen requests to both, because in any case, the authorization must be issued by the Secretary of the Electoral Administration, which will disappear in about 90 days, because their lifecycle is 100 days and the elections to the Parliament took place November the 28th.
Time to run
dijous, 2 de desembre del 2010
The long path to the data sources
Since the Department of Adminstració Local couldn't provide me with historical data, I contacted the President of the Consell Comarcal del Pallars Jussà, Xavier Pont, who commited to contact his party ( CiU), and gave me the phone number of the archives' responsible. Few days later she told me that the Consells Comarcals don't receive the data that I need.
I have contacted the Junta Electoral Central, because it would also be interesting to get the files with the names of elected members of the lists, but they don't store this kind of information, which is created by the Junta Electoral Local. This organism deads 100 days after the elections. The registers produced by the Junta Electoral, containing the details of the counting of votes, are stored by the Audiencia Provincial.
Ok. New options for asking...
I have contacted the Junta Electoral Central, because it would also be interesting to get the files with the names of elected members of the lists, but they don't store this kind of information, which is created by the Junta Electoral Local. This organism deads 100 days after the elections. The registers produced by the Junta Electoral, containing the details of the counting of votes, are stored by the Audiencia Provincial.
Ok. New options for asking...
dijous, 18 de novembre del 2010
A bureaucracy tale
The 15th of November was the date when I went to the Goverment office to ask, officially, for the set of data.
It have registration time: 12:03
Today, Thursday the 18th of November I have called the responsible of the department, to know if the files were already available.
"The form has not yet arrived to my office, following the normal internal process", she said.
Normal means that a paper needs, at least, three days to run ( ! ) from the register office, in the ground level of the building, to an office somewhere in the same building.
Let me take some time to learn about efficiency, high performance and so on
It have registration time: 12:03
Today, Thursday the 18th of November I have called the responsible of the department, to know if the files were already available.
"The form has not yet arrived to my office, following the normal internal process", she said.
Normal means that a paper needs, at least, three days to run ( ! ) from the register office, in the ground level of the building, to an office somewhere in the same building.
Let me take some time to learn about efficiency, high performance and so on
Subscriure's a:
Missatges (Atom)




