Collaborated with fellow public media developers to build an auto-updating, county Covid-19 tracker. In addition to case and death data, the tracker pulls in data on at-risk populations to contextualize outbreak risk. This project is open source and available for anyone to replicate for their own state.
Sourced and combined multiple datasets to produce city rankings on the health of local housing. The indices provided a starting point for articles analyzing the most and least housing-secure cities.
Combined city-level data on traffic congestion patterns during Covid-19 with climate change mitigation reporting data to show that many cities with increased congestion during 2020 also do not publicly report mitigation goals.
Used multiple internet speed and accessibility datasets to show that one of the US government’s primary sources for funding broadband expansion projects often understates broadband access, especially in large cities.
Analyzed and processed Mine Safety and Health Administration datasets to track millions of dollars worth of unpaid safety violations to West Virginia Governor Jim Justice. Also performed extensive data analysis to look at characteristics surrounding the unpaid fines, like injury rates and production.
Analyzed EPA Toxic Release Inventory data to reveal the biggest air polluters in Louisville disproportionately affect poor and black residents. Created an interactive map that would allow residents to input their address and receive a report of air pollutants near them.
Built the Django-backed site behind The Pope's Long Con, a Peabody Award winning investigation into the troubled life of Kentucky state representative Dan Johnson. The site incorporated a persistent audio player that allowed users to explore the site while listening to the podcast episodes uninterrupted.
Alexandra Kanik is a data reporter well-versed in submitting FOIA requests, scraping websites, writing code, analyzing data, creating visualizations and writing data-driven stories. She also occasionally voices audio stories.
Alexandra enjoys teaching data journalism and discussing how technology can improve news. She is a frequent facilitator at conferences like NICAR and SRCCON. She is also an active member and administrator of the Lonely Coder’s Club, an online group of tech journalists from around the world.
In addition to her editorial work, she also enjoys processing story and audience analytics and thinking about how we can better understand the impact news has on communities.
May 2020 - March 2021
Louisville Public Media
April 2016 - May 2020
Metrics Section Editor
December 2015 - June 2016
Interactives Developer / Web Developer / Designer
April 2011 - December 2015
Web Developer / Designer
April 2011 - December 2015
Maryland Institute College of Art
BFA in Graphic Design