These charts track COVID in the Bay Area through wastewater data
Interactive
· Featured · Published in The San Francisco Chronicle
The Chronicle is using wastewater surveillance to track the prevalence of COVID-19 in the Bay Area. Due to the scaling back of virus tracking efforts nationwide, scientists and public health experts — including those at the U.S. Centers for Disease Control and Prevention — have turned to monitoring the concentration of SARS-CoV-2 particles found in wastewater at sewage treatment plants as a more dependable metric for community-level infection rates. This tracker pulls data daily and displays data on the most recent and historic levels of SARS-CoV-2 concentrations at 12 Bay Area wastewater plants using WastewaterSCAN's API.
Languages/Programs used: Python, Git, Amazon AWS (S3) server, ReactJS, D3
|
California is embracing psychiatric hospitals again. Behind locked doors, a profit-driven system is destroying lives
Interactive
· Published in The San Francisco Chronicle
With California engulfed in a mental health crisis, the Chronicle set out to examine a critical and rapidly expanding part of the health care system: for-profit psychiatric hospitals. These facilities admit tens of thousands of people affected by depression, drug addiction and psychosis who need stabilizing treatment every year.
In many cases, patients reported that erratic treatment destabilized them more or worsened their conditions. For-profit institutions spend less than half as much on direct patient care as the state's nonprofit psychiatric hospitals and locked psychiatric units in general hospitals, despite treating similar patients. By employing fewer nurses and other frontline workers, the companies banked roughly $440 million in profits combined from their California facilities between 2018 and 2022, much of it from taxpayer-funded insurance.
I designed and developed the graphics used in the second part of this investigation, including the chart comparing bed capacity growth among different types of institutions and the interactive graphic comparing per patient spending among forprofit, nonprofit and general acute psychiatric hospitals in California.
Languages/Programs used: D3, ReactJS, Adobe Illustrator (ai2html)
|
How AI depicts San Francisco — and what it gets wrong
Interactive
· Published in The San Francisco Chronicle
We asked four different generative AI models to depict today's San Francisco, its residents and how the city would look in 2074.
I led the art and design direction and spearheaded the data collection and visual analysis of this months-long experiment. The reporting wouldn't have been possible without the now-retired urban critic John King and AI and tech reporter Chase DiFeliciantonio.
Languages/Programs used: ReactJS, Figma (UIUX)
|
Here’s why the Bay Area is so important for birds — and where to find them
Multimedia
· Published in The San Francisco Chronicle
From as far as Alaska, massive flocks of birds leave their breeding grounds as fall weather portends the arrival of frigid temperatures and the loss of their best food sources. The journey south is a long one — thousands of miles for many species. Some will travel all the way to South America, where the warmer weather means food is plentiful.
But there are havens along the way, rich habitats still lush with fish and insects to fuel their trek along the Pacific Coast. And for many species of birds, few havens in California are more important than the San Francisco Bay Area.
I spearheaded the design and visual layout of this story, conducted data analysis and visualization of bird migratory pathways and provided scientific encyclopedia-style illustrations in collaboration with data reporter Christian Leonard.
Languages/Programs used: D3, ReactJS, Adobe Illustrator (print)
|
🏆 Police are using secret deals to hand pensions to troubled officers. Millions of taxpayer dollars support the system
Interactive
· Published in The San Francisco Chronicle
🏆 This investigative story has won the 2025 Selden Ring Award~ and the 2024 George Polk Award for Justice Reporting Some California police officers who get into trouble suddenly claim they’ve been injured. Their departments disagree, but still erase their misconduct and award them lifetime disability pensions. Under California law, police agencies are forbidden from dangling disability pensions as an inducement to rid themselves of problem officers. But an investigation by the San Francisco Chronicle and UC Berkeley's Investigative Reporting Program identified 49 officers across the state who, on the verge of being ousted for alleged misconduct, were allowed to walk away with their wrongdoing hidden and collect lifetime disability pensions for injuries their own employers had challenged as unsubstantiated.
Languages/Programs used: D3, ReactJS, Adobe Illustrator (print)
|
🏆 This is the secret system that covers up police misconduct — and ensures problem officers can get hired again
Interactive
· Published in The San Francisco Chronicle
🏆 This investigative story has won the 2025 Selden Ring Award~ and the 2024 George Polk Award for Justice Reporting For years, dozens of California police agencies have executed “clean-record agreements,” clandestine legal settlements that promise to hide the wrongdoing of an officer in exchange for the officer's guarantee to leave an agency without a fight, an investigation by the San Francisco Chronicle and UC Berkeley's Investigative Reporting Program.
Languages/Programs used: D3, ReactJS, Adobe Illustrator (print)
|
Thousands of California owls likely to be shot in order to save native species
Interactive
· Published in The San Francisco Chronicle
The U.S. Fish and Wildlife Service has proposed to allow licensed professionals to kill, at most, 450,000 barred owls over 30 years in California, Oregon and Washington to protect not just the northern spotted owl but also the forest ecosystems where the threatened bird evolved. The accompanying interactive graphic displays a keyboard-accessible slide to better visually compare the differences between barred and Northern spotted owls, complete with zoomed-in annotations and audio components of each owl's calls.
Languages/Programs used: ReactJS, Adobe Illustrator
|
S.F.'s iconic Powell Street is lined with empty storefronts. Can it be saved?
Multimedia
· Published in The San Francisco Chronicle
Two of the three massive storefronts in the historic Flood Building — owned by Flood's family for two generations — sit empty. The building is one of the first sights visitors or residents encounter when exiting the BART station or waiting for the cable cars. When tourists hop on cable cars, the most prominent sights are colorful “for lease” ads plastered on every window from the turnaround to Union Square, instead of the chock-a-block boutiques and shops that used to line the street.
The hollowed-out three-block stretch was once home to popular shops like Uniqlo, H&M, Rasputin Records and Lush, eateries like Blondie's Pizza and Tad's Steaks, and mom-and-pop stores like Marquard's Smoke Shop. They're all gone now.
I helped spearhead the design of this project from bottom up, including the fade-in postcard topper and horizontal scrolly portion.
Languages/Programs used: ReactJS
|
S.F. feces complaints rise again despite city spending millions on public toilets
Interactive
· Published in The San Francisco Chronicle
Accompanying this piece on feces complaints steadily rising even with city-run public restroom programs is a map showing all publicly accessible restrooms throughout the city as of March 2024. Readers can filter by “type” of restroom (for instance, whether the restroom is within a BART train station) and filter ones that are wheelchair accessible, open 24 hours or staffed. They can also click on each point to see locations and hours and days that the restrooms are open. I compiled data from multiple sources, confirmed and revised information, including locations, availability and accessibility, with multiple public and private sources, developed the map and did background reporting.
Languages/Programs used: ReactJS, Google spreadsheets
|
Finding Korean comfort food in the Bay Area
Multimedia
· Published in The San Francisco Chronicle
In this guide, the Chronicle's Korean American staffers share their favorite comfort foods — galbitang (갈비탕), soondaeguk (순대국), kimbap (김밥), tteokmanduguk (떡만두국) — and where to get them in the Bay Area. Each of us come from similar but different backgrounds, hometowns and connections to the land of our heritage. And we each have our own takes on the food that nurtures our souls. I contributed to a section of this guide, and illustrated and designed the whole project.
Languages/Programs/Tools used: ReactJS, Adobe Illustrator, Adobe Photoshop
|
Millions of trees have died in California forests. This map shows the hardest-hit areas
Multimedia
· Published in The San Francisco Chronicle
In 2022, not counting wildfire deaths, over 36 million trees in California's national forests died. I dove into the main causes — drought stress, flooding, insect population increases and disease — and built this scrolly map that walks through the forests that have been hit the hardest.
Languages/Programs/Tools used: ReactJS, MapLibre, QGIS
|
S.F. must create 82,000 new homes in 8 years. The city is already behind
Multimedia
· Published in The San Francisco Chronicle
San Francisco has a mind-boggling challenge ahead: Approve 82,000 new homes by 2031. The mandate comes from California officials, who say they're committed to improving the state's crippling housing shortage. But can it be done? This multimedia piece, with a video scrolly and Datawrapper visualizations I developed alongside designer Daymond Gascon and with the reporting of J.D. Morris and J.K. Dineen, visually shows just how daunting this task will be.
Languages/Programs/Tools used: ReactJS, Datawrapper
|
This one fact will completely change how you think about California wildfires
Multimedia
· Published in The San Francisco Chronicle
In recent years, California's wildfires have seemed ever more apocalyptic. Huge swaths of forest have been wiped out, forcing thousands to flee and choking many more with smoke. But here's a fact that may seem surprising: Even more of the California landscape used to be on fire. Before the 1800s, when Europeans flooding into California outlawed fires set by Native Americans, at least 4.5 million acres — and sometimes up to 12 million acres — burned in California every year, according to UC Berkeley researchers.
That figure has only one modern equivalent: 2020. That year, California wildfires burned over 4.3 million acres — more than double the state's previous record.
Languages/Programs/Tools used: ReactJS (page design)
|
As Restrictions Go Away, Long COVID Is Here To Stay
Multimedia
· Published in The Public Health Advocate
Even as restrictions go away, long COVID is here to stay.
After over a year of lockdown, Governor Gavin Newsom lifted COVID-19 restrictions on June 15. With proof of vaccination, California residents are now allowed to engage in pre-pandemic activities such as indoor dining and concert-going without masks or social distancing.
For thousands of long haulers, however, the pandemic is far from over. Featuring experts such as Lisa McCorkell, one of the founding members of Patient-Led Research Collaborative; Dr. Bradley Sanville, a pulmonologist working at the Post COVID-19 Clinic at UC Davis; and Laura Stock, Director of the Labor Occupational Health Program at the University of California, Berkeley, this episode delves into what exactly long COVID, or Post-Acute Sequelae of SARS-CoV-2, entails and what research is being done and what this implies for the future of work and wellbeing.
Programs/Tools used: Adobe Premiere Pro, Audacity, Zoom H1n Handy Microphone, Blue Yeti USB Microphone
|
Stanford stunner: Tara VanDerveer announces her retirement
Graphic
· Published in The San Francisco Chronicle
After 38 years at Stanford University and compiling the most wins in college basketball history, Tara VanDerveer announced Tuesday night she would retire as the head coach of the Cardinal's women's team. VanDerveer, 70, spent 45 years as a head coach at Idaho (1978-80), Ohio State (1980-85) and Stanford (1985-95, 1996-2024), amassing an NCAA-record 1,216 victories. At Stanford, she led the team to three NCAA championships (1990, 1992 and 2021) and 14 Final Fours.
Languages/Programs used: Adobe Illustrator (static graphic), ai2html
|
She had multiple abortions as a child. Her abuser didn’t expect what came later
Graphic
· Published in The San Francisco Chronicle
Accompanying the story of a survivor who received multiple abortions as a child, I created a static graphic comparing total, substantiated and non-substantiated child maltreatment allegations to the total number of children in California.
Languages/Programs used: Adobe Illustrator (static graphic)
|
Billions of people still lack high-speed internet. This S.F. company is building satellites to change that.
Graphic
· Published in The San Francisco Chronicle
As it turns out, beaming high-speed internet to the remote corners of Alaska from thousands of miles away in space starts with a brick of titanium in a San Francisco warehouse. In a vast complex where the U.S. once churned out World War II-era Liberty ships, Astranis is building satellites that it plans to send to orbit more than 22,000 miles above the Earth's surface, with the first slated to be borne skyward aboard a SpaceX Falcon Heavy rocket from Cape Canaveral next year.
Languages/Programs used: Adobe Illustrator (static graphic)
|
High-Risk CA Residents May Be Eligible for COVID-19 Vaccine
Writing
· Published in The Public Health Advocate
On February 11, 2021, the California Department of Public Health (CDPH) updated their guidelines on allocating COVID-19 vaccines to include high-risk individuals. This revision in the vaccine rollout plan stem from immense pushback from disabled citizens and advocates after Governor Gavin Newsom announced on January 25 that California would be switching from a plan that prioritized both healthcare workers and “people at increased risk for severe illness or death from COVID-19” in Phase 1 to an age-based vaccination eligibility framework. The collective response from disabled communities and leaders was swift.
|
One month after Supreme Court’s Roe ruling, over half of states have banned or moved to limit abortions
Interactive
· Published in The Seattle Times
One month after Supreme Court's Roe ruling, over half of states have banned or moved to limit abortions.
Languages/Programs used: jQuery/Javascript (interactivity to visualize readers' submissions on Roe v. Wade reversal)
|
Why King County mental health facilities decline 27% of referrals
Interactive
· Published in The Seattle Times
In the King County area, E&Ts turned away about half of all referrals over the past two years due to medical reasons. Examples include dementia, CPAP machines, substance use, autism or a developmental disability, pregnancy, or a person with COVID-19.
Languages/Programs used: Leaflet (map), jQuery (interactivity), Adobe Illustrator (static graphic)
|
How schools in Seattle are being affected by dwindling enrollment
Interactive
· Published in The Seattle Times
Seattle lost 3,238 students from the 2019-20 to 2021-22 school year. And in the fall SPS projects it will lose 812 more, dropping its total enrollment to 48,748 students. Public school enrollment has fallen throughout the state since the pandemic began, but it's not clear why Seattle numbers are so dismal.
Languages/Programs used: jQuery/Javascript (to create a responsive, filterable table)
|
Costco’s $1.50 hot dog deal has defied inflation. Fans say it isn’t what it used to be.
Graphic
· Published in The Seattle Times
Fans of Costco’s hot dog combo can rest assured that the price won’t increase anytime soon, as CEO Craig Jelinek told CNBC on Monday. As food costs skyrocket and inflation hits record highs, even for wholesalers, Costco will hold steady on its iconic dog-and-drink deal. The combo has cost $1.50 since it first arrived in food courts in 1985, even though the Bureau of Labor Statistics’ inflation calculator says it’s worth more than $4 today.
Languages/Programs used: Google Sheets (data analysis), Adobe Illustrator (static graphic)
|
Once enslaved, this man helped build Tacoma; his great-granddaughter wants you to know him
Graphic
· Published in The Seattle Times
John N. Conna fought his way out of enslavement to achieve political and business success in Washington state. His great-granddaughter wants you to know him.
Languages/Programs used: Adobe Illustrator & Esri
|
Removing Lower Snake River dams offers best chance for salmon recovery — at steep price, report says
Graphic
· Published in The Seattle Times
If four Lower Snake River dams were breached to support salmon recovery, the energy, irrigation, recreation and other benefits they provide to the Pacific Northwest could be replaced for $10.3 billion to $27.2 billion, according to a draft report released Thursday by U.S. Sen. Patty Murray, D-Wash., and Washington Gov.
Languages/Programs used: Adobe Illustrator
|
California Failed to Consistently Track Ride-Hailing Assault and Harassment Complaints
Interactive
· Published in San Francisco Public Press
The agency responsible for regulating the ride-hailing industry in California has failed to collect consistent data on claims of assaults, threats and harassment on Uber and Lyft rides, a San Francisco Public Press investigation found.
Languages/Programs used: Google Sheets (data analysis), Datawrapper (visualization)
|
Rent Payments to SF Public Housing Agency Plunged in Last Two Years, Spurring Eviction Fears
Interactive
· Published in San Francisco Public Press
Rent collections by San Francisco’s public housing agency fell precipitously in late 2019 and have continued to decline to less than half of what is owed, according to a San Francisco Public Press analysis — but the agency can’t explain why.
Along with creating the data visualization, I helped interview and gather quotes from sources. Languages/Programs used: Datawrapper (visualization)
|
Bay Area Traffic Congestion Returns
Interactive
· Published in San Francisco Public Press
The morning and evening commute nearly disappeared in March 2020 as the Bay Area went into pandemic lockdown, and while travel on public transit continues to lag this summer, many people are getting behind the wheel to get to and from their jobs.
Languages/Programs used: Google Sheets (data analysis), Adobe Illustrator (vizualization)
|
Queer, Here, and Mistreated: LGBTQIA+ Disparities in Healthcare
Writing
· Published in The Public Health Advocate
The fight for LGBTQIA+ acceptance has made major strides in recent years. The goal of health equity, however, has yet to be achieved, especially for many LGBTQIA+ identifying individuals living outside of UC Berkeley, other universities and even the United States.
|
The Cultural Whiplash of a Second-Generation Korean American
Writing
· Published in Asian Voices Matter on Medium
A piece to unpack my childhood and, with it, my bitterness: the after-effect of the cultural whiplash. We were forced to blend in and acculturate with culturally-white Americans in the late 90s and 00s, only to suddenly be fetishized in the 2010s because we happened to come from the same background as people’s now-favorite idols.
|
Eyayu Genet's "Sugypia:" Water Activism and Uniting Sudan, Egypt and Ethiopia Through Art
Writing
· Published on InfoNile
(Bahir Dar, Ethiopia) “Sugypia,” an amalgamation of Sudan, Egypt and Ethiopia, three neighboring countries served by the Nile, is one of many colorful pieces created by Eyayu, a prominent Ethiopian artist-activist born and raised on the banks of Lake Tana, Ethiopia’s largest lake and the source of the Blue Nile. An artist of national consciousness, Eyayu incorporates both the symbolism from these bodies of water and indigenous aesthetics into his paintings and collages. His art is characterized by contrasting themes like traditionality versus modernity and the organic versus the artificial, aiming to raise awareness of the culture of Lake Tana and the Blue Nile’s lakeside communities and the environmental issues they face.
|
Alternative Medicine: A Good Alternative to the Doctor?
Writing
· Published in The Public Health Advocate
In the modern age of healthcare, even when new technology is being developed every day to cure and rid previously untreatable illnesses, populations around the world still utilize alternative and complementary medicine. What exactly is alternative medicine? What practices are there? Who practices CAM, and what are the consequences? Why should we care about alternative and complementary medicine?
|
[Contributed] Violence Against Health Care: Attacks During a Pandemic
Research
· Published on StoryMaps ArcGIS
I contributed to fact-checking incidents of violence against healthcare workers in México that were cited in this overall report created in collaboration between the Human Rights Center at UC Berkeley and Insecurity Insight. AP News also reported on this phenomenon based on this report.
Skills/Programs used: TweetDeck (open-source data collection on social media), fact-checking
|
Linguistic Diversity & Accessibility of Mental Health Services in Ventura County in relation to the Woolsey Fire
Research
· Self-published
During the spring semester of 2020, I attempted to assess whether the Hill-Woolsey Fire specifically had an impact on Ventura County - a county that had endured multiple trauma-inducing events in a short period of time - from a linguistic lens by mapping all Medi-Cal (California’s version of Medicaid) accepting mental health facilities listed by the Ventura County Behavioral Health Department from 2017, 2018 and 2020 and by analyzing Ventura County's needs assessment and long-term disaster recovery plan and identifying linguistic gaps.
Skills/Programs used: ArcGIS (data visualization), HTML, CSS & Bootstrap (web design)
|
COVID-19 CARES Act Allocations
Interactive
· Self-published
On March 27, 2020, the Coronavirus Aid, Relief, and Economic Security (CARES Act) was signed into law. Click on the link above to view an interactive bubble map visualizing the different amounts allocated to higher education institutions across California and read a little bit more about how these allocations were calculated.
Languages/Programs used: Google Sheets, Jupyter Notebook & Python (data scraping & cleaning), D3, Javascript, HTML & CSS (visualization)
|
Digital Sex Crime Statistics in Korea
Interactive
· Self-published
몰카. Molka. It's an abbreviation for “mollae cameras (몰래 카메라),” otherwise known as “secret" or "hidden cameras," and describes the act of secretly filming mainly female-identifying victims in public and private areas such as bathrooms or love motels and releasing this illegal footage on the internet. Unfortunately, this phenomenon is not a newly reported issue in Korea. Click on the link to read more, see where I got the data from and view charts on related crime statistics.
Languages/Programs used: Google Sheets (data scraping & cleaning), Charts.js, HTML, CSS & Bootstrap (visualization)
|
Mapping Newspapers in California
Interactive
· Self-published
I wanted to see if there was a way I could scrape the Library of Congress's “Chronicling America” database and visualize the distribution of recorded newspapers still operating today (labeled as “current” in the database) in California by county and by city/neighborhood. I wanted to see if there were certain geographic areas within California where there was a dearth of local daily or monthly news, online or in print. The data was cleaned using Google Sheets. Click on the link above to view and interact!
Languages/Programs used: Google Sheets (data scraping & cleaning) & Tableau (visualization)
|
Visualizing Census & Census-Related Data
Interactive
· Self-published
These census-related visualizations were created as an independently-led project I did during the 2019 UC Berkeley Data Discovery Summer Program. That summer, the research cohort focused on developing ways to raise awareness about the importance of the decennial U.S. Census. I decided to create Tableau visualizations using the most recent census and census-related data at the time that showed users how they could look up different statistics related to SNAP - the Supplemental Nutrition Assistance Program - and health insurance coverage as a way to gauge how the counties or states they lived in compared to the rest of the U.S. Click on the link above to view, interact and read more.
Languages/Programs used: Google Sheets (data scraping & cleaning) & Tableau (visualization)
|
Analyzing My EDM Playlist
Interactive
· Self-published
Investigating the history of EDM (and its roots in European techno) and how big pioneers of the genre were Black queer artists or queer artists of color, I wondered how rich and diverse my own EDM listening taste was. Was I listening to a variety of artists from different backgrounds? Were the songs I had on repeat or the most songs I had on my EDM playlist from people of color (poc) or women/gender-nonconforming/nonbinary folks? Click the link above to follow a step-by-step tutorial on how I analyzed my own EDM playlist (and how you can too).
Languages/Programs used: Exportify, Google Sheets (data scraping, cleaning & visualization), Timeline.js (visualization), HTML, CSS & Bootstrap (visualization) & Canva (graphics)
|
A Tribute to Disability Visibility
Multimedia/Design
· Self-published
Disability Visibility was revolutionary in putting disabled voices and dreams into modern mainstream media. I illustrated my interpretation of six stories that touched me and impacted my view of what constitutes disability justice and what is needed to create a kinder and more accessible world. These stories include: "Six Ways of Looking at Crip Time" by Ellen Samuels, "The Beauty of Spaces Created for and by Disabled People" by s.e. smith, "How to Make a Paper Crane from Rage" by Elsa Sjunneson, "Nurturing Black Disabled Joy" by Keah Brown, "I am too pretty for Ugly Laws" (a poem by Lateef McLeod embedded in the story "Gaining Power through Communication Access"), and "I'm Tired of Chasing a Cure" by Liz Moore. Click the link above to view these illustrations in a keyboard accessible carousel/gallery and read more on my interpretations of them.
Click here to go to the Disability Visibility Project website run by Alice Wong.
Languages/Programs used: Javascript (interactivity & accessibility), HTML, CSS & Bootstrap (web design), Adobe Photoshop & Canva (art)
|