R I saw government agency names as employers in data about H1B - the visa program blamed by former administration to steal jobs from Americans - and had to ask how many H1B workers the administration was hiring. I found that more than 2,000 workers had been approved for Fiscal Year 2019.
Dateline Award, Society of Professional Journalists, DC chapter | Finalist in Features
Front Page Award, Washington-Baltimore News Guild | Honorable Mention in National Reporting on Immigration
R, Google Workspace, Flourish I designed and managed the data collection efforts on over 100 federal courts' operations, created an interactive map, and updated the map daily based on the most updated data with an R script, rendering Bloomberg Law the source of most comprehensive information on federal courts' operations under Covid-19 pandemic. Lawyers, judges and even the Office of U.S. Courts used our reporting as reference. A series of stories were driven by this data, including this story that scooped the U.S. Courts and this weekly blog.
R, Shiny Dashboard, Adobe Illustrator The story revealed the requests by five global automakers to be exempted from the tariffs imposed on Chinese goods by the Trump administration. The story was made possible by a Shiny Dashboard I co-built that scrapes data from regulations.gov and automates analysis. I also made the graphics in Adobe Illustrator.
Beltz Award for Editorial Excellence, Bloomberg Industry Group
R The story shows how California cities' sales and use tax revenues are at mercy of a change in Amazon's corporate structure. I analyzed the data, found use tax trend reversing corresponding to Amazon's structural change, which underpinned the story. I also identified visual opportunities and mocked up the graphics in R.
