(Everything before we had graphicsdesk.github.io)
Graphics, data reporting, and visual production from the Spec newsroom.
“Graphics in their best can really inspire a sense of awe.” —Amanda Cox
“The purpose of visualization is insight, not pictures.” —Ben Schneiderman
| Article | Repo | Description | Contact |
|---|---|---|---|
| 🔗 | low-income-hospitals |
Measuring the accessibility of emergency hospitals to low-income neighborhoods. | Hong, Mike and Raeedah |
| 🔗 | ivy-coronavirus-response |
The U.S. and Ivy League schools were late to respond to COVID-19. Data shows international universities did better. | Jason, Hong, Jenny, Kelly and Raeedah |
| 🔗 | earnings |
Columbia tuition rates are among the highest in the country. Is it worth it? | Jason |
| 🔗 | political-candidates |
Analyzing campaign donations from Columbia affiliates. | Charlotte and Raeedah |
| 🔗 | linguistics-major |
Decades of Uncertainty: A visual history of the linguistics major. | Seyla and Jason |
core-instructors |
Analyzing the makeup of Core instructors. | Seyla | |
| 🔗 | graduate-sex-diversity |
Code for the Graduate Student Sex Diversity lead. | Jason |
| 🔗 | net-price-inequity |
Code for the Net Price Inequity article. | Jason |
| Article | Repo | Description | Contact |
|---|---|---|---|
| 🔗 | covid-healthcare |
Code for CD9 covid healthcare lede | Jason and Jenny |
| 🔗 | 100-words |
Code for Adaptation of NYT '39 things...' for 100 words: Coronavirus. | Hong and Raeedah |
| 🔗 | manhattanville-businesses |
Upscaled: The cost of Columbia construction for struggling 12th Avenue businesses. | Charlotte and Jenny |
| 🔗 | eoaa |
Visual production for The Eye's EOAA and Title IX cover story. | Jason |
| 🔗 | biomedical-money |
Visual production for The Eye's Biomedical Money cover story. | Jason |
| 🔗 | awn-photo-essay |
Code for the photo essay on Dean Awn's funeral. | Jason |
| 🔗 | uptown-arts |
Code for the Uptown Arts feature. | Jason and Raeedah |
| 🔗 | genealogy |
Code for the Eastern Genealogical Records feature. | Jason |
| Article | Repo | Description | Contact |
|---|---|---|---|
| 🔗 | hospital-data |
Open/closed emergency hospitals across New York City by neighborhood and income level. | Mike and Raeedah |
| 🔗 | park-lights |
311 calls about broken streetlights near Morningside Park, 2010 to present. | Charlotte |
| 🔗 | earnings-debt-2019 |
Analyzing earnings and debt levels of Columbia students. | Jason |
construction-cd9 |
Construction grievances in Community District 9. | Fiorella and Jason | |
| 📰 | survey-2023-print |
Analysis and visualization for the 2023 Survey print story. | Jason |
archive-scraping |
Scraping the Spec archives for the 100 years of Core story. | Eve | |
staff-diversity |
Measuring diversity within the Columbia Daily Spectator and comparing staff diversity against other sections and top college newspapers. | Raeedah | |
deerfield-data |
Data analysis and sketching for the Biomedical Money cover story. | Raeedah | |
| 🔗 | class-space-fall19 |
Mapping space overflow in Fall 2019 classes. | Jason |
survey-2023 |
Analysis and visualization of the Class of 2023 incoming freshman survey. | Jason | |
| 🔗 | homeless-center |
Data and analysis contextualizing homeless services at Columbia. | Raeedah |
| 🔗 | turkey |
Data, analysis, and code for Turkey's panel cancellation article. | Jason |
| 🔗 | international-students |
Data analysis and graphics supporting the International Students lead. | Jason |
| 🔗 | foreign-gifts |
Analyzing monetary gifts from foreign entities to Columbia University. | Jason |
Most scrapers with sensitive information (e.g. course registration, human resources, job registration) are in private repositories. If they aren't on the cloud yet, like the ones below, ask Jason for direct access.
| Scraper | Repo | Description | Contact |
|---|---|---|---|
| Handshake | handshake-data |
Just job postings right now. Soon: events. | Jason |