I conducted an analysis and reported most of the interviews for a story showing that Latinos formed a disproportionate rate of COVID-19 cases in every region of Colorado. I also built a graphic displaying the results, using Svelte and a tiny bit of d3.
I conducted an analysis and wrote a story about how Senate candidates John Hickenlooper and Cory Gardner used more partisan language in their emails than they did in their campaigns. The pattern is a common feature of campaign emails, which are geared toward a partisan base.
A San Josè-based community center for people recovering from mental illnesses, addiction, and homelessness offers culinary and barista training classes for some members. While the program may seem to be focused on getting participants jobs, job training is secondary to helping participants gain confidence and coping mechanisms — skills that many people in recovery struggle to obtain.
I visited the cafè several times and wrote, filmed, and edited a profile about the job training classes. (I used Adobe Premiere Pro for the editing.)
I wrote the front-end and back-end code to display precinct-level election results for northwest Virginia during the 2018 midterms.
As part of this process, I requested precinct shapefiles from 27 localities in Virginia; cleaned and joined the shapefiles using PostgreSQL and PostGIS; wrote code in Python to scrape the results and push them to an AWS S3 bucket; and wrote front-end code in d3 to display the results. I additionally set up an EC2 instance and ran the Python script from there so the script could continue running even if something happened to my computer locally.
In a one-year period, Strasburg, Virginia — a town of 6,000 people — saw two new breweries come in. A nearby town, Front Royal, also had a new brewery come in that year. I wanted to see what got the owners to start their breweries and why Virginia as a whole had seen such a large spike in the number of new craft breweries.
I interviewed people at two of the three new breweries in our region, helping me identify a new law that helped one of them come into existence. I also conducted some analysis in Python and built a visualization in d3 to demonstrate how fast the growth had been.