Google Answers Logo
View Question
 
Q: CSV/Excel file of Canadian MPs ( Answered 5 out of 5 stars,   0 Comments )
Question  
Subject: CSV/Excel file of Canadian MPs
Category: Relationships and Society > Government
Asked by: jhabley-ga
List Price: $25.00
Posted: 23 Jan 2004 13:44 PST
Expires: 22 Feb 2004 13:44 PST
Question ID: 299488
I need a CSV/Excel file of every Canadian Member of Parliament with
this info: Their email address, home province, and party.

I don't think such a file exists, but luckily all the data is ready to collect at:

http://www.parl.gc.ca/common/senmemb/house/members/CurrentMemberList.asp?Language=E&Parl=37&Ses=1&Sect=hoccur&Order=OrganizationName

This would require someone going to each MP's page (all from the
source URL, above) and entering the data, then posting the data
somewhere I can download it. It won't be fun work (will probably take
an hour), but it'll be paid work. ;-)
Answer  
Subject: Re: CSV/Excel file of Canadian MPs
Answered By: elmarto-ga on 23 Jan 2004 16:37 PST
Rated:5 out of 5 stars
 
Hello jhabley!
The data you have requested is ready and cen be downloaded from the
following address

http://www.angelfire.com/alt/elmarto/

I've included both CSV and Excel files in case there is some
compatibility issue with the Excel version you're using. It actually
was fun work, because I had to do some programming in Matlab and
Visual Basic in order to get the data. On hindsight, I think I would
have taken less time if I had done it by hand ;-)

Remember that if you're not satisfied with this answer you can use the
Request for Clarification feature; otherwise I await your rating and
final comments.

Best wishes!
elmarto
jhabley-ga rated this answer:5 out of 5 stars
Great stuff. Thanks.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy