Projects

web development

Water and Power

Built the micro site for AfroLA's series on the controversies surrounding the Los Angeles Department of Water and Power's ownership of a substantial portion of Inyo County, CA. Worked with a talented team to bring designs to life and created a component-based system that would allow for quick and streamlined story layouts.

data analysis mapping graphics writing

Water and Power

Used custom mapping and analysis to estimate populations living in each of Houston's neighborhoods in both 2010 and 2020 in order to talk about how each neighborhood has changed over time.

data analysis graphics writing

Houston crime analysis

Partnered with a crime reporter to explore the question: Has crime in Houston been getting worse? We realized that our readers didn't understand basic terms related to the National Incident Reporting System (NIBRS) so we took special care to explain key concepts about the system to facilitate their understanding of the data trends.

Covid tracker
graphics

Public Media Covid-19 Tracker

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.

writing data analysis graphics

2020 Housing Security Indices

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.

Traffic congestion
writing

2020 saw a historic decrease in traffic congestion, though not everywhere

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.

writing mapping data analysis

Biden’s broadband plan comes at a pivotal moment for the digital divide

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.

data analysis graphics writing audio

Ohio Watershed Safety Analysis

Analyzed FOIA and scraped data to reveal that while more hazardous materials are being shipped down the Ohio River, accidents due to high water are on the rise.

data analysis graphics

Mine Safety Debt Analysis

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.

data analysis graphics mapping

Coal Ash Pollution Analysis

Cleaned, processed and analyzed hundreds of pages of water testing data to understand how coal ash storage affects groundwater. Also created an interactive map for users to explore water contamination results at specific power plants.

data analysis graphics mapping

Trash and Poverty Analysis

Combined 311 data with trash can location data to find areas where there was both a deficit of public trash cans and a high number of 311 trash complaints.

data analysis graphics interactive mapping

Air Quality Interactive Map

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.

graphics interactive mapping

Transportation Variation Google Map Animation

Created an interactive map using Google Maps API to illustrate the added time burden public transportation has on a person's life.

Kentucky Gubernatorial Candidate Text Analysis
data analysis graphics writing

Kentucky Gubernatorial Candidate Text Analysis

Analyzed audio from interviews with 2019 Kentucky Gubernatorial candidates to get a sense of what candidate emphasized most when talking about a variety of issues important to voters.

data analysis graphics writing audio

Superfund Flooding Analysis

Used AP data to illustrate potential hazards to Kentucky, Ohio and West Virginia residents living within one mile of superfund sites located in floodplains.

Good River Website
web development

Good River Website

Co-built and designed (with Natasha Vicens) an NPR Interactives template website to feature stories and interactives created for the Good River collaborative.

About

Alexandra Kanik is a data editor, reporter and developer. Her skills include editing data stories, scraping websites, writing code, analyzing data, creating visualizations, submitting FOIA requests and writing data-driven 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.

Employment

Houston Chronicle / San Antonio Express-News
Data editor
May 2021 - present

City Monitor
Data reporter
May 2020 - March 2021

Louisville Public Media
Data reporter
April 2016 - May 2020

MediaShift
Metrics Section Editor
December 2015 - June 2016

PublicSource
Interactives Developer / Web Developer / Designer
April 2011 - December 2015

Pittsburgh Filmmakers
Web Developer / Designer
April 2011 - December 2015

Technical Knowledge

Languages/Frameworks
Applications/Systems

Education

Maryland Institute College of Art
BFA in Graphic Design

Contact

alexandra@rationalact.com
TWITTER
GITHUB