From The Farm to the World Stage
Evan Bolt grew up working on his family farm near Edgerton, Minn, a son of Randy and Tammy Bolt. He is now he is working on the world stage, contributing to the Johns Hopkins University Coronavirus Resource center at his job in Laurel, MD, with Johns Hopkins’ University Applied Physics Laboratory (APL).
The dashboard has been named one of Time Magazine’s Best Inventions of 2020, and the Coronavirus Resource Center recently received the “Meeting the Moment for Public Health” award from Research! America. An oral history on the creation of the dashboard says “It became the data source relied upon globally for near-real-time tracking of the biggest health crisis this century.” As of March 2021, it had been accessed over 210 billion times.
The significance of this project really hit home for Bolt after hearing an address by President Biden, in which he stated he kept the number of those who have passed away from COVID in his pocket. That number is from the APL dashboard. News stories also attribute their data to Johns Hopkins.
“Seeing it in the news and hearing about it from others helps keep it in perspective,” he said.
“I’m helping contribute to that, and that’s impactful,” Bolt said. “It’s great to see I can have an effect like that.”
“It’s nice to be able to say I’m helping in some small way,” he said.
When the pandemic began in January 2020, Johns Hopkins’ associate professor Lauren Gardner and a group of researchers in the Whiting School of Engineering created a COVID dashboard effort on January 22. After only five days they realized there was too much data to manage manually, and brought in APL on January 27, 2020. APL is experienced with data processing and analysis, and helped make the dashboard the “most trusted, accurate source of information available on the pandemic,” said the oral history.
By March, Bolt was pulled off his work on software development and reverse engineering to create “web scrapers” to pull in data.
These data were sometimes pulled from websites, sometimes from raw HTML code. Because APL was scraping data globally, the team members had to look at global sites and glean what they meant. “Google translate is a friend,” he said.
Looking at the big picture, “It’s really incredible, taking thousands of data points from the county level in the U.S. to countries and regions across the world, and collecting all these data points and distilling them into a manageable set for people to see,” Bolt said.
“Web scraping is just as much art as science,” he said, because every web site is different, and there are lots of nuances. They have had to be aware of definitions and new terminology and be vigilant with the numbers collected.