Coding Lost on the Frontline
Timeline: Aug 2020 | Visit link
Description: I was part of a beautiful effort to create an online memorial dedicated to the healthcare workers who died fighting the pandemic. The memorial also serves as a database, as data was collected and presented as part of a larger series. The Guardian worked with newsroom Kaiser Health News and freelance journalists to make this a reality.
Technical summary:
Developed experience that allowed learning and mourning
Create design and visual style guide
Architectured and coded the full-stack experience
Working with the spreadsheet as our data storage, I fetched the data using the npm package google-spreadsheet-to-json. This json was fed into an s3 bucket that is retrieved on runtime (?).
Because of the nature of the data fetching, the memorial updates are controlled by the newsrooms, and it allowed us to create a more formal process of updating that allowed for more QA.
I was the sole designer and developer for the interactive; I designed the components and experience, and coded the experience in React using D3.