gather and analyze data by year