Login  Register

Re: Scraping election results..

Posted by Robin Millette on Oct 15, 2008; 3:15pm
URL: http://civicaccess.416.s1.nabble.com/Scraping-election-results-tp1344p1348.html

Le Wed, 15 Oct 2008 11:02:40 -0400,
Russell McOrmond <[hidden email]> 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