I could see some interesting time lapse visualizations coming out of this. For example: Have CS departments changed over time to have more / less full professo

I could see some interesting time lapse visualizations coming out of this. For example: Have CS departments changed over time to have more / less full professors vs associates? Or adjuncts vs full-time faculty? Is it different for public vs private schools? I have some hunches but it would be cool to actually execute these queries on data.