JOANNA LIN SU
Data Tracker Enthusiast
Focuses: Data, Graphics, and News Automation.

Currently: Data journalist @ Moody's ;
Trained by Business Insider, AppliedXL, New York Times, and NYU Studio20.
Resume here.


ARK Invest CEO Cathie Wood's strategies over Chinese stocks

Data scrapping, Svelte, News Automation
A data driven analysis on Cathie Wood's new strategies over Chinese stocks. I collaborated with finance reporter Vicky Ge Huang at Business Insider. In the collaboration, I was responsible for the data scrapping, data parsing, data visualization parts, as well as giving advises on how to interpret the dataset from visualization standpoint.

US mass shooting tracker

Data tracker, News automation, Pandas, Datawrapper
According to the Gun Violence Archive, a nonprofit that tracks shootings in the US, there have been nearly 200 mass shootings in 2021 alone — and that tally does not appear to be slowing down anytime soon. To track the incidents, I created a python script to scrape and parse the GVA database. The data viz wil automatically update every time I run the python script. The charts are published at Business Insider.

COVID-19 & ONLINE SURVEILLANCE: How China's contact tracing app is affecting travelers

Vanilla.js, Scrollama, Mapbox, Web dev, Data analysis, Adobe Illustrator, Social media fact-checking
In response to the lack of comprehensive coverage on non-western world's usages of the contact tracing apps systems, I reported and built the story trying to show how China's massive surveillance with the QR health code system came into effect. It offers a chronologically ordered and geographically marked view to help the readers understand the development of this system. The Chinese version of the story was published on FTChinese.

Data show panic and disorganization dominate the study of Covid-19 drugs

Exploratory data analysis, Python Matplotlib, Adobe Illustrator
In collaboration with the data engineer and the beat reporter on the team, I dug in the clinicaltrials.gov trying to find data patterns around COVID-19 related drug studies. The story we produced reveals the disorder and disorganization with huge financial resources wasted in COVID-19 clinical studies. I cleaned and analyzed the dataset, iterated story ideas with the field jouranlist from STAT News, and futhur improved the data pipeline. I also tested how to leverage data trackers in news reporting. Published on STAT News.

When states will start vaccinating all adults

Data tracker, Datawrapper
President Biden previously directed states to make coronavirus vaccines available to all adults by May 1. Collaborated with science reporter from the team, I built a data tracker monitoring state government websites and constantly updated in the map using Data Wrapper. By the end of March, at least 12 states are vaccinating people age 16 and up, and seven states plan to start doing so.

Some data viz work with Business Insider

Data visualization, Datawrapper, Svelte, Google spreadsheet
I worked as a data visualization designer and collaborated intensively with business reporters in producing the visual elements of the stories.

NYC restaurant outdoor dining tracker

Data and spatial analysis, R, QGIS
The restaurant industry has long been one of the reasons why New York City remains a world-class metropolis. And it has been hit hard by the ongoing lock-downs during the pandemic. When the city reopens, the Outdoor Dining Program, described as "a creative new vision of public space”, rolled out. I dug in the NYC Open Restaurant Application dataset trying to reveal how have the restaurant industry’s outdoor dining options been doing more than eight months into the COVID-19 pandemic.

Data analysis on state governors’ COVID-19 related mandatory order reaction timelines

Exploratory data analysis, Adobe Illustrator, Python Matplotlib

Analysis by FiveThirtyEight showed that political affiliation of governors had little effect on the response time of issuing stay at home orders. However, I tried to answer the question that whether decisions like "reopening the state" and "mandatory mask wearing" are driven by politics, by compiling dataset myself.


How China's contact tracing app is affecting travelers

Published on FTChinese, May 2020

English and interactive version (see above)

It seems like China's contact tracing system is the "cure for all", but the system actually has many blind spots, according to users experiences. FTChinse web edition. (In case you hit the paywall, here is the WeChat edition.)

How “Depression” Shapes Me

Personal essay, January 2019

English version (only)

I grew up in a middle-class family in Amoy, a coastal city in China across the sea from Taiwan. My father is an engineer on a marine research team where he spends most of his time out to sea. My mother is a retired teacher. When I was in middle school, my once strong and optimistic mother was diagnosed with Bipolar-depression. With my father spending most of his time away, the burden of caring for her, and myself, fell on me. The experience and challenges of caring for someone I love who has a mental health disorder has greatly influenced my decision to become a more effective and impactful communicator. (Read more...)

Smartphone Changes News Consumption and Production

Digital thinking essay written at UCLA, Spring 2018

English version (only)

The research idea is based on the aphorism of McLuhan, namely “the medium is the message”. The idea that the medium having a direct influence on the society rather than simply carrying content will be the foundation of this project. This paper will demonstrate how the invention of the smartphone revolutionized the consumption of news, and how the change of news consumption further influences the change of news production. Also, whether these changes are caused by technology factors or culture factors will be discussed. (Read more...)

Formic Acid Bus Is Pulling In

Published on CBN Weekly, August 4, 2017

English version | Chinese Version

Compared with private cars, public transportation is ushering in the era of clean energy at a higher speed. According to statistics from Ministry of Transport of China, bus ownership has been about 500,000 in China, in which new energy bus has exceeded 160,000. The market penetration of new energy bus is estimated to reach about 50 percent by 2020. Most new energy buses at present are electric or hybrids vehicles, but scientists are still exploring for more choices.

A young research team from Eindhoven University of Technology in the Netherlands, has found a new kind of fuel for the bus from the secretion of ants. (Read more...)



@ Beijing
@ Osaka
@ UIBE
@ Beijing
@ Beijing
@ Volunter work
@ UIBE
Winter in Beijing
Summer in Beijing
Spring in Beijing
@ Kyoto
@ Amoy, my hometown
@ San Diego
@ La Jolla, CA
@ San Francisco
@ UCLA
@ Beijing
@ The Forbidden City
@ Koyoto
@ Chengdu, Spring
@ Chengdu, Autumn
@ Sichuan
@ Mt. Titlis