added SQL view and python API endpoint to pull in last week's forecast