The work load for the comming months. A boring tale

I already have 1021 records in an EXCEL sheet.

This is covering three elections ( 1999, 2003 and 2007 ) for 21 cities.

Taking into consideration that I need data for 130 cities, related to a total of 8 elections, I can expect the work to be finalized when reaching the level of 16.000 records.

Can you believe it?
One by one....

The steps are the following for the last three elections, which information is on-line:

1- Read the session after the election, where the Major of the city entitles to some elected to become responsibles for a certain area ( Health, Sports, Economy.. )
Write the name of the elected in the spreadsheet, male o female, and area of responsibility
2- Read the electoral list, published some weeks before the election, to know the party to which each candidate belongs.


When the document is not on-line I must visit the Historical Archive of the offical gazzette, in Barcelona, opening hours from 10 till 14 . I must read each single page, scanning for the cities and documents that I need.  To cover the maximum possibilities of getting such information, I use to read four months of the archived documents, In total I expect to invest from 6 to 10 complete days