Skip to content

Set of scripts to download the ontario public salaries over 100k and process them

Notifications You must be signed in to change notification settings

kbranigan/ontario_public_salaries_over_100k

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 

Repository files navigation

Basically, downloads all of http://www.fin.gov.on.ca/en/publications/salarydisclosure/
and makes it usable.

usage:

php download.php   (or ./download.php)

This script downloads the files listed in urls.php and caches them in /cache

It creates a series of mysql dump files that you can import however you like.

You can import them by running the following: (assuming no root password)

./download.php
echo 'create database ontario_salaries;' | mysql -uroot
cat output_sql/*.sql | mysql -uroot ontario_salaries

About

Set of scripts to download the ontario public salaries over 100k and process them

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages