I need someone to take the following data and create a single postgresql backup file w/ a single table that includes: All snapshot data columns matched properly and an additional column added to each downloaded record for the year.
Here is the resource link: [url removed, login to view]
Select district and charter detail data
Select each year going back to 1995
Select data file
- You will need to add a column for the year before uploading to postgres
- Make sure the header columns for each year are aligned **Warning** you will need to be careful with this step because columns have been added over the years. The names appear have remained constant so matching should not be a problem.