I love the focus. Starting at the base level data and working to normalize it is definitely the most difficult piece. How far back have you assembled data?
Feel free to reach out to me individually (email in profile), I'm working on operationalizing climate data like this and would like to look at this together!