4 ms·
I work as a research analyst for a Canadian provincial opposition party. Most government data is in terrible HTML tables, often dynamically generated, and almos
by fnbr 12y ago
I work as a research analyst for a Canadian provincial opposition party. Most government data is in terrible HTML tables, often dynamically generated, and almost none of it is in an easily machine readable format. I spend a lot of time downloading PDF files of data and converting them to JSON formats.
I have two main recurring scrapes:
- political donations. Every donation to a political party in my province above ~$300 is posted publicly on a gov't website (in a PDF). I use the data to run machine learning algorithms to predict who is most likely to want to donate to my party.
- public service expenses. My province has a "sunshine list" which publishes the salaries and contracts for all senior government officials. We grab it weekly (as once someone quits the gov't, their data disappears).
One tool that you could consider building is an easily accessible expense website, where people can enter the name of a public official and see all their expenses, including a summary of the total amount spent. There have been a number of massive expenses here in Canada related to this [1, 2].
[1] http://news.nationalpost.com/tag/alison-redford/ http://news.nationalpost.com/tag/alison-redford/
[2] http://en.wikipedia.org/wiki/Canadian_Senate_expenses_scandal http://en.wikipedia.org/wiki/Canadian_Senate_expenses_scanda...
- dataminer 12y agoThis is very interesting work, regarding your last point, I came across this site which is searchable by employee name or government organization http://canada.landoffree.com/ http://canada.landoffree.com/. I think the salary and expense disclosure is only for Ontario, based on the sunshine list.
- fnbr 12y agoI don't know much about the civil service, but I know that most provincial assemblies have expense disclosures, at least for the elected officials, e.g. [1], [2]. Federal cabinet ministers also have to disclose all of their office expenses (can't find a link, but I know it exists). [1] BC: http://www.leg.bc.ca/Mla/remuneration/index.htm http://www.leg.bc.ca/Mla/remuneration/index.htm [2] Alberta: http://alberta.ca/travelandexpensedisclosure.cfm http://alberta.ca/travelandexpensedisclosure.cfm