Midway between the easy road and the hard. I scrape the 2 .txt files from the web sites and downloaded the excel.
Also, It's good to see that the exceedingly under-recognized city of Broomfiled, CO. is finally receiving its due!!
P.S. I finally finished all the challenges. I finally get to say Hi to @EstherB47, @ggruccio and Mr. Speed Demon @patrick_digan. And I'm sure that it's just a matter of days before @JoBen, @kat, @NicoleJohnson, and @SeanAdams regain the top step. It's been a long, sometimes difficult journey(I'm looking at you, Find Ned). Thanks to all the people who helped along the way.
I deliberately put a lot of tools in the flow, because there was a few that I'd never used in that way and the workflows reads (hopefully) the same as the question posted.