[CivicAccess-discuss] Scraping election results..

Robin Millette robin at millette.info
Wed Oct 15 11:15:21 EDT 2008


Le Wed, 15 Oct 2008 11:02:40 -0400,
Russell McOrmond <russell at flora.ca> a écrit :

> I want to extract the data and import it into an SQL database.

I can put an hour on this right away. Will take my mind off our brand new minority government. I'll do it with PHP parsing the HTML as XML (thanks to Tidy) to make it easier.

>    The page format for 
> http://webinfo.parl.gc.ca/MembersOfParliament/MainCandidatesCompleteList.aspx?TimePeriod=Current&Language=E 
> is similar to 
> http://webinfo.parl.gc.ca/MembersOfParliament/MainMPsCompleteList.aspx?TimePeriod=Historical&Language=E 
> , except for the column "Election Result" which says "Defeated" or 
> "Elected".

-- 
Robin



More information about the CivicAccess-discuss mailing list