Database of Australian Federal/State/Territory Politicians

[Andrew Perry]

Attached is the database of Australian Federal/State/Territory politicians that Community Builders has put together (pretty painstakingly and manually) for MyMP, which I have been cleaning up to circulate.

We have included the OA Person ID and UI for the Federal MPs/Senators, to help hook into OA's API.  We have also included the myMP ID for each MP, so that once we get the API to www.mymp.com.au running you will be able to hook into that too.

If  you have any corrections or suggestions, please e-mail me or submit them at http://alpha.mymp.com.au

The attached database is licensed under a Creative Commons Attribution 2.5 Australia licence - http://creativecommons.org/licenses/by/2.5/au/ - so feel free to incorporate it into other stuff if it is helpful.

Kind Regards


Andrew Perry
Executive Director

Our ref:

 

Community Builders Australia Pty Ltd ABN 97 131 987 703 www.communitybuilders.com.au   P  02 8004 9220 M  0413 045 300 F  02 8088 1034	Parramatta Level 2 96 Phillip Street PARRAMATTA  NSW  2150 Postal Address PO Box 7929 BAULKHAM HILLS BC  NSW  1755
This e-mail may be confidential. Only the intended recipient may access or use it. If you are not the intended recipient, please notify us immediately and delete this e-mail.  To the full extent permitted by law we exclude all liability for viruses or similar malicious content in any e-mail.

[Adam Kennedy]

I have completed the geo2gov upgrade from Jeff's older member database to your newer one.

In the process I've found a ton of bugs in the data and fixed them. Spelling electorates wrong is bad :)

I've attached a revised CVS file with all my fixes applied, please feel free to merge them back up to your list.

Some problems still remain, particularly in Western Australia.

We probably should look at updating this CSV file into a small web database of some kind.

Adam K

[Andrew Perry]

Thanks Adam

We will merge them back as suggested.

Kind Regards


Andrew Perry
Director - Legal & Technology

Our ref:

P  1300 855 078
M  0413 045 300
F  02 8090 3699

legal.consult pty ltd
ABN 84 002 413 078
www.legalconsult.com.au

Sydney Level 31 Aurora Place 88 Phillip Street SYDNEY  NSW  2000

Parramatta Level 2 96 Phillip Street PARRAMATTA  NSW  2150

Postal Address PO Box 7929 BAULKHAM HILLS BC  NSW  1755

This e-mail may be confidential and/or privileged. Only the intended recipient may access or use it. If you are not the intended recipient, please notify us immediately and delete this e-mail.  To the full extent permitted by law we exclude all liability for viruses or similar malicious content in any e-mail.  Liability limited by a scheme approved under Professional Standards Legislation.

[Adam Kennedy]

A few more notes on the current data set, while I have them in my head.

Your seem to list people by CURRENT official title, but with Electorate keyed off the FUTURE election.

It's difficult to work with something like this, I'm finding.

I really need to know...

1. Electorate names based on most recent past election (i.e. active electorates, not upcoming ones)
2. Members that were elected AT that election
3. If a member has stood down, or there is a by-election, I'd prefer to still have the members name in the list, but with an ISO "end date" on their term of service, so I can tell the difference between missing/bad data, and electorates pending a by-election.
4. If a member is currently sitting from a by-election, I'd prefer to see both members for the same electorate (I can filter out based on which one hasn't stood down).

It's probably also time to look at building a simple db for every election since 2000 (both general and by-elections) so we can organise the member information more cleanly.

Adam K