Work

Stories, apps and open-source software I've authored, typically in partnership with others

2024
March 15 • How Reuters uses Datawrapper to create, automate and disseminate hundreds of charts each week
2023
Dec. 11 • Ipsos credibility interval calculator
Dec. 11 • ipsos-credibility-interval
Nov. 26 • sphinx-palewire-theme
Nov. 18 • @RandomPigeonGPT
Nov. 17 • @NYCDataBot
Nov. 15 • atcf-data-parser
Oct. 30 • reuters-style
Oct. 25 • noaa-hurricane-gis-scraper
Sept. 11 • Who blocks OpenAI?
Aug. 10 • fed-dot-plot-scraper
June 07 • Python datawrapper client
June 04 • Search our database of questionable climate funding
May 15 • "Morning Bid" newsletter data dashboard
April 14 • SvelteKit Table component
March 04 • moneyinpolitics.wtf
Feb. 21 • New Big Local News dataset tracks animal-care inspections
Feb. 16 • @reutersjobs
Jan. 30 • Instantly explore Big Local News projects with Datasette
2022
Dec. 08 • How Big Local News helped data journalists cover the midterms
Dec. 06 • usc-crime-reports-scraper
Dec. 02 • internet-archive-upload
Nov. 21 • Static-site framework deployment at The Baltimore Banner
Nov. 20 • "is 5" digital scan for archive.org and cummings.ee
Nov. 09 • Static-site framework deployment at THE CITY
Nov. 08 • biglocalnews/local-election-results-etl
Nov. 08 • Los Angeles Election Results
Nov. 07 • The Drudge Dashboard
Oct. 24 • The AMSAT amateur satellite database
Oct. 14 • The Studs Terkel Archive Podcast: Season 2
Sept. 28 • Meet Audit Watch, the latest bot for Big Local News affiliates
Sept. 23 • Cedar Rapids, Linn-Mar, Clear Creek Amana face first book challenges in years
Sept. 15 • Meet CAL-ACCESS Watch, a new notifications bot for our members
Sept. 13 • New Big Local News dataset tracks the millions pouring into California campaigns
Sept. 05 • @DivineAnnDvorak
Aug. 24 • Your Big Local News account has linked up with MuckRock and DocumentCloud
Aug. 21 • @LAXWeatherBot
Aug. 16 • @newshomepages performance and accessibility rankings
Aug. 07 • Truth Social and Parler video extractors
Aug. 01 • storysniffer
July 27 • Meet Layoff Watch, a news-breaking bot for our members
July 15 • Meet the Big Local News summer intern class of 2022
June 29 • Three easy ways to automatically upload data to Big Local News
June 15 • There’s a huge hole in FBI crime data. Here’s how to check if local police are part of the problem.
April 11 • A beginner’s guide to FBI crime statistics
March 29 • prefect-flow-template
March 12 • @newshomepages
March 05 • First Visual Story
March 04 • First GitHub Scraper
Feb. 18 • warn-github-flow
Feb. 18 • warn-transformer
Feb. 06 • Where we love to eat near SoFi Stadium
Feb. 01 • biglocalnews/upload-files
Jan. 31 • How to deploy a Prefect agent to Google Kubernetes Engine
Jan. 22 • How to push tagged Docker releases to Google Artifact Registry with a GitHub Action
Jan. 19 • Streamlining jupyter.org
2021
Dec. 06 • Ben Welsh to lead new data journalism partnership with Stanford
Nov. 16 • chicago-trees-analysis
Oct. 26 • Three of 10 student athletes could get kicked off team for missing LAUSD vaccine deadline
Oct. 17 • @sanbornmaps
Aug. 26 • install-python-pipenv-pipfile
June 29 • django-internetarchive-storage
June 19 • Many L.A. cops and firefighters aren’t vaccinated against COVID-19. Is this a public safety threat?
May 03 • the e.e. cummings free poetry archive
March 02 • With 20 wins, Times sets new mark at Best of Digital Design awards
Feb. 22 • Los Angeles Times Launches Spanish-Language Edition of Coronavirus in California Tracker
Feb. 19 • california-coronavirus-scrapers
Feb. 01 • Nearly half of L.A. firefighters unvaccinated against COVID-19, revised city data show
Jan. 27 • ‘Sharp decline’ in COVID cases among L.A. firefighters after vaccinations
Jan. 22 • Tracking coronavirus vaccinations in California
Jan. 16 • Drive to get COVID-19 vaccine to L.A. firefighters loses steam as 40% fail to show up
Jan. 07 • Tracking the coronavirus in California hospitals
Jan. 05 • Free Airbnb with your COVID-19 vaccine? Firefighters offered prizes along with priority access
Jan. 05 • 2020: The year in data and graphics
2020
Dec. 26 • studs-terkel-podcast
Dec. 09 • End-of-life care has boomed in California. So has fraud targeting older Americans
Dec. 09 • L.A. police killings: Tracking D.A. decisions since 2004
Sept. 22 • Tracking the coronavirus in California nursing homes
Sept. 10 • The Times is teaming up with other California newsrooms to track COVID-19
Aug. 23 • Reading Ruben Salazar
Aug. 20 • cedar-rapids-buildings-unsafe-after-derecho-2020
June 22 • Tracking how the coronavirus crushed California’s workforce
June 09 • los-angeles-police-killings-data
June 09 • L.A. police killings: Tracking homicides in Los Angeles County since 2000
June 02 • Arrests during George Floyd protests swell to near 3,000 in L.A. County; many are locals
May 16 • 11 firefighters hurt in downtown L.A. explosion that caused fires at several buildings
May 08 • Senior care homes source of nearly half of all California coronavirus-related deaths, data show
May 03 • Track L.A.'s effort to house thousands of homeless people during coronavirus
May 01 • A guide to the Internet
April 15 • Coronavirus could halt L.A. concerts, sporting events until 2021, Garcetti says
April 06 • california-coronavirus-data
April 06 • To aid coronavirus fight, The Times releases database of California cases
March 13 • Tracking the coronavirus in California
2019
Nov. 01 • deadspin-scraper
Nov. 01 • I checked the math of the media bosses who told Deadspin to ‘stick to sports.’ It doesn’t add up
Oct. 08 • https://github.com/palewire/nrol-39-logo
Oct. 01 • noaa-hurricane-hunters-logo/
Sept. 02 • Mapping the Conception’s final voyage
Aug. 25 • Is your home at high risk of a wildfire? Use this map to find out
Aug. 15 • nyc-parks-logo
July 27 • the-other-americans
July 26 • We used a 3-D printer to map the power of the Ridgecrest earthquake
July 09 • django-heroku-template
July 01 • census-data-aggregator
June 30 • nasa-wildfires
June 30 • noaa-wildfires
June 30 • geomac-wildfires
June 30 • calfire-wildfires
June 24 • python-open-source-template
June 24 • census-error-analyzer
June 13 • native-american-census-analysis
June 13 • The 2020 census is coming. Will Native Americans be counted?
May 29 • Black market cannabis shops thrive in L.A. even as city cracks down
May 29 • la-weedmaps-analysis
May 10 • latimes.com/tips/
April 29 • census-hard-to-map-analysis
April 28 • OldLAPhotos
April 26 • How California’s faltering high-speed rail project was ‘captured’ by costly consultants.
April 26 • hsr-documents-analysis
April 05 • usa-style-guides
April 01 • census-data-downloader
March 28 • swana-census-analysis
March 28 • Are Arabs and Iranians white? Census says yes, but many disagree
March 27 • census-map-consolidator
March 17 • mlbcolors
March 07 • First Observable Notebook
Feb. 28 • deleon-district-election-results-analysis
Jan. 18 • python-muckrock
Jan. 16 • tijuana-districts-map
Jan. 05 • muckrockbot
2018
Dec. 28 • Fifty times we did the math
Dec. 27 • nyrb-covers-analysis
Dec. 27 • Cover to cover: The colors of NYRB Classics
Dec. 18 • A million California buildings face wildfire risk. ‘Extraordinary steps’ are needed to protect them
Dec. 18 • california-fire-zone-analysis
Dec. 08 • Altair
Dec. 04 • 101 Restaurants We Love
Nov. 18 • Danger spins from the sky
Nov. 18 • helicopter-accident-analysis
Nov. 17 • U.S. Consumer Price Index tracker
Nov. 14 • Election results challenge: Precincts reporting
Nov. 06 • Live results from the 2018 midterm elections
Nov. 06 • How many women won?
Oct. 28 • W.E.B.Du Bois in d3
Oct. 20 • At Hollister Ranch, homeowners enjoy private beaches — and hefty tax breaks, too
Oct. 20 • hollister-ranch-analysis
Aug. 31 • everytractcount
Aug. 08 • The Inglewood Inventory
Aug. 03 • scrapy-calaccess-crawler
June 27 • L.A. is slammed with record costs for legal payouts
June 16 • cpi
June 05 • Live results from the California primary
May 14 • django-autoarchive
March 16 • street-racing-analysis
March 16 • Out of control: The deadly toll of street racing in Los Angeles
March 12 • Garcetti still struggling to expand the number of female firefighters
March 10 • First Graphics App
2017
Dec. 14 • ferc-enforcement-analysis
Dec. 14 • Why Wall Street gets a cut of your power bill
Nov. 19 • One corner. Four killings.
Nov. 08 • How Houston’s newest homes survived Hurricane Harvey
Nov. 04 • Save My News
Oct. 31 • django-calaccess-processed data
Oct. 06 • Las Vegas shooting victims: Portraits of the fallen
Sept. 28 • California must find and fix its worst public schools. Here’s one way to start
Aug. 13 • california-kindergarten-vaccination-analysis
July 27 • The cannabis industry has a clear favorite in the race to be California's next governor
July 14 • django-calaccess-scraped-data
July 13 • python-censusbatchgeocoder
June 22 • California invested heavily in solar power. Now there's so much that other states are paid to take it
June 13 • Results from L.A.’s congressional runoff election
June 10 • A Central Valley power plant may close as the state pushes new building at customers' expense
June 07 • 2016 California primary results
June 06 • California regulators weigh whether the state needs more power plants
May 26 • Tributes to California's war dead, including the five we lost since last Memorial Day
May 25 • Trump promised a ‘big beautiful door’ in his border wall. California farmers are ready and waiting
May 24 • california-h2a-visas-analysis
April 28 • The Los Angeles Times front pages during the 1992 L.A. riots
April 20 • Immigrants flooded California construction. Worker pay sank. Here’s why
April 20 • construction-jobs-analysis
April 13 • Results from L.A.’s congressional primary
March 21 • A 20% turnout in L.A.'s mayoral election wasn't a record low after all, final results show
March 17 • Wages rise on California farms. Americans still don’t want the job
March 17 • california-crop-production-wages-analysis
March 16 • California's new education ratings tool paints a far rosier picture than in the past
March 08 • Tuesday’s L.A. voter turnout was likely the lowest ever, muddying Garcetti's historic reelection win
March 06 • Election? What election? Apathy abounds as L.A. votes
Feb. 05 • A runaway energy industry is costing California billions
Feb. 05 • http://www.latimes.com/projects/la-fi-electricity-capacity/#nt=outfit
Feb. 05 • california-electricity-capacity-analysis
Feb. 04 • After 24 years, arrests made in horrific L.A. fire that killed 10, including 7 children
2016
Nov. 17 • How Iowa voted
Nov. 08 • 2016 election results
Nov. 08 • 2016 California election results
Oct. 31 • The drought eased up, and these Californians turned on the spigo
Oct. 08 • First Python Notebook
Sept. 27 • Ousted L.A. fire marshal claims corruption among city fire inspectors
Sept. 15 • django-calaccess-downloads-website
Sept. 08 • la-magnets-2016-test-scores
Sept. 08 • These magnets have become some of L.A.'s highest-scoring public schools
Aug. 24 • California's new test scores: What they are, why they matter and how your school scored
Aug. 24 • LAFD fire marshal steps down after criticism that he cut corners on safety
July 18 • django-bigbuild
June 15 • Fire officials were concerned about Westlake building where 5 died in a blaze
June 15 • la-vacant-building-complaints-analysis
June 11 • la-county-2016-primary-precinct-maps
June 09 • Clinton or Sanders: Who did your L.A. neighborhood choose?
June 08 • L.A. County supervisor races yield surprises and uncertainty
June 06 • California regulators weigh whether the state needs more power plants
May 27 • LAFD inspectors accuse supervisors of cutting corners, ignoring fire hazards
April 25 • python-desknet
April 17 • Are you an independent voter? You aren't if you checked this box
April 10 • 'We need an outsider like Trump,' says this two-time Obama voter
Feb. 26 • 91% white. 76% male. Changing who votes on the Oscars won't be easy.
Feb. 14 • django-calaccess-processed-data
Feb. 12 • django-postgres-copy
Feb. 01 • 2016 presidential primary results
2015
Dec. 17 • Los Angeles outsources firefighters exam, which will now come with a price tag
Dec. 09 • San Bernardino medic had 5 seconds to check if each massacre victim was alive or dead
Dec. 03 • San Bernardino shooting victims: Who they were
Nov. 17 • LAFD's new recruitment chief on diversity: 'We have work to do'
Nov. 17 • Why the LAFD is still largely white and male despite diversity efforts
Nov. 14 • StoryTracker
Nov. 03 • The richest man and the poorest man in Congress are both from California
Nov. 03 • How many millionaires does California send to Congress? Find out here.
Nov. 02 • Grading the arts in LAUSD
Oct. 09 • How much pollution did VW's emissions cheating create?
Sept. 30 • Who are the millionaires bankrolling the 2016 presidential race?
Sept. 15 • Five facts about the California cash fueling the 2016 race
July 24 • County regulator calls for sweeping overhaul at Compton Fire Department
July 14 • Confidential L.A. County audit another blow to Compton Fire Department
July 07 • Compton fire chief put on administrative leave following Times reports
July 06 • Compton Fire Department ordered to remove defibrillators from trucks, ambulances
June 16 • City leaders want LAFD to tackle overdue fire-safety inspections
June 15 • Is your L.A. building overdue for a fire inspection? Search our database to find out.
June 15 • Thousands of large L.A. buildings are long overdue for fire inspections
June 11 • django-project-template
June 03 • Fire destroys Long Beach duplex featured in Times report on housing code violations
June 02 • Long Beach moves to boost landlord penalties; tenants say more is needed
June 02 • With 'deplorable' conditions for some renters, Long Beach debates inspections
May 30 • USGS retracts three 'ghost' earthquakes, blames Northern California sensors
May 25 • Will Ryu stir the pot or play ball with Wesson?
May 20 • How L.A. voted: City Council results, mapped block by block
May 16 • Voter turnout highest in Westside and West Valley, analysis finds
April 29 • Second straight LAFD recruit class is all male after women exit
April 21 • City should collect more revenue from LAFD 911 callers, audit says
April 02 • LAFD's latest recruits are primarily white and overwhelmingly male
March 27 • California lawmaker calls for stricter firefighter EMT requirements
March 26 • Nearly 1 in 4 Compton firefighters working without EMT permit
March 08 • First Django Admin
Feb. 27 • LAFD failed to inspect hundreds of hazardous sites, state says
Feb. 22 • Report calls for another overhaul in hiring of LAFD firefighters
2014
Dec. 30 • New LAFD class is nearly all male; 20% have relatives in the ranks
Dec. 10 • First Web Scraper
Dec. 02 • Federal investigators probing elite LAFD fireboat unit
Nov. 05 • Kuehl's victory no guarantee of pro-labor bloc on Board of Supervisors
Nov. 05 • Crucial L.A. County supervisor race results map
Nov. 05 • Sheila Kuehl claims victory in L.A. County supervisor race
Nov. 04 • 2014 election results
Nov. 04 • 2014 California election results
Nov. 04 • 2014 election results
Oct. 31 • Once a crusader against big money, Gov. Brown is collecting millions
Oct. 23 • L.A. Fire Department response times slow, data show
Sept. 28 • Find Obamacare doctors in California
Sept. 23 • State investigating LAFD hiring after white applicant alleges bias
Sept. 16 • LAFD gets new anti-nepotism rules in wake of hiring controversy
Sept. 15 • LAFD opens investigation into alleged mistreatment of new recruit
Aug. 16 • django-calaccess-raw-data
Aug. 14 • storysniffer
Aug. 14 • django-urlarchivefield
July 31 • City probe calls for anti-nepotism reforms at LAFD
July 28 • More than 10,000 rush to apply in rebooted LAFD hiring drive
July 15 • Mayor names L.A.'s first Latino fire chief
July 10 • New process for hiring L.A. firefighters wins OK; recruiting to resume
July 08 • Garcetti moves to restart suspended LAFD hiring drive
July 01 • Acting LAFD chief now in running for full mayoral appointment
June 30 • LAFD captains trained to enter shooting scenes after LAX incident
June 05 • The results of the race to replace Waxman
June 05 • Lieu and Carr did best in South Bay, Times vote analysis shows
June 03 • 2014 California primary results
May 29 • Mayor Eric Garcetti set to upload a new trove of online city data
April 16 • LAFD chief to reassign many firefighters to rescue ambulances
April 14 • Garcetti's budget adds more firefighters, overhauls 911 dispatch
April 02 • Fire Department class loses its only female recruit
March 25 • Aspiring L.A. firefighters feel cheated by aborted hiring program
March 24 • LAFD union leader says suspending hiring program 'patently unfair'
March 20 • LAFD recruit program is suspended
March 04 • LAFD contractor threatens to cut computerized 911 scripts
March 03 • Consultant's report recommends major overhaul of L.A. Fire Department
Feb. 28 • First News App
Feb. 28 • Two L.A. fire commanders reassigned
Feb. 27 • One of five LAFD recruits in training class are related to department firefighters
Feb. 26 • In a matter of seconds, qualified applicants lose out on LAFD jobs
Feb. 16 • L.A.'s Eastside: Where do you draw the line?
Feb. 14 • Resultados de las Oct. 2013 Buenos Aires elecciones
Jan. 25 • Older concrete buildings in Los Angeles
Jan. 21 • Eric Garcetti appointees select new L.A. Fire Department watchdog
Jan. 07 • LAFD's highest-ranking woman is leaving the force
Jan. 06 • New LAFD recruit class is nearly all male, overwhelmingly white
2013
Dec. 22 • L.A. Fire Department dramatically overhauls response to shootings
Dec. 18 • Garcetti orders release of city data, but scope uncertain
Dec. 12 • L.A. Fire Department to resume sharing details on emergency responses
Dec. 12 • LAFD halts popular Twitter feed, blocks access to 911 call records
Dec. 03 • LAFD proposes boosting ranks with budget increase
Dec. 01 • Next L.A. fire chief's other challenge: race and sex discrimination
Nov. 11 • checkbook-la-watchdog
Oct. 25 • Since 1905, aqueduct makes headlines
Oct. 23 • New L.A. website is opening the books on spending at City Hall
Oct. 18 • L.A. Fire Department's top internal watchdog is removed
Oct. 10 • Mayor names an acting LAFD chief to succeed Brian Cummings
Oct. 10 • Garcetti replaces LAFD Chief Cummings after 911 disclosures
Oct. 08 • Mayor adds departments' performance data to his website
Oct. 08 • Garcetti supporters score city appointments
Sept. 13 • City Council approves Garcetti's overhaul of board overseeing LAFD
Aug. 15 • Mayor Eric Garcetti revamps L.A. Fire Commission
Aug. 13 • Many 911 cellphone calls lack location information, study finds
Aug. 06 • L.A. Fire Department's 911 computer system has more breakdowns
July 30 • uptime-grove
July 23 • LAFD chief first manager to interview with Mayor Eric Garcetti
July 22 • boundaries.latimes.com
July 19 • LAFD chief tweets apology for Mexican costumes photo
July 15 • After controversy, Dodgers end ambulance deal with LAFD
July 12 • LAFD union chief calls for ending ambulance deal with Dodgers
July 09 • Fire commissioners criticize LAFD's ambulance deal with Dodgers
July 09 • LAFD Chief Brian Cummings says he wants to keep his job
July 05 • L.A. Fire Department is asked to broaden its tech reach
July 03 • L.A. councilman asks LAFD to report back on proposed reforms
June 28 • Grand jury wants LAFD to reverse cuts, overhaul 911 call center
June 28 • L.A. Council extends LAFD plan to staff extra ambulances
June 14 • L.A. measure to cap marijuana shops passed with citywide support
June 13 • LAFD expresses 'sincere regret' regarding Mexican costumes at fundraiser
June 13 • PastPages API
June 13 • pastpages2gif
June 11 • L.A. mayoral runoff another low mark in voter turnout: 23.3%
June 07 • L.A. mayoral election results
June 04 • Audit faults LAFD's investigation of top officials
May 22 • The road to Eric Garcetti's election romp
May 21 • L.A. firefighters vote against more dues for political campaigns
May 21 • LAFD chief's report slammed by city Fire Commission
May 15 • Forecast for L.A.'s mayor race: paltry turnout
May 08 • Union blocks access to video calling for more money for campaigns
May 07 • L.A. council finds funds to reverse Fire Dept. staffing shift
May 04 • L.A. street quality grades
May 01 • DWP salaries database
April 26 • LAFD chief to shift firefighters from trucks to ambulances
March 19 • L.A. Fire Department overhaul measures delayed
March 13 • L.A. Fire Department takes step toward linking 911 system to nearby systems
March 11 • lat-soundsystem
March 08 • L.A. tax-hike vote patterns tell a tale of two realities
Feb. 04 • Silent LA
2012
Dec. 21 • Flawed data stall California's 911 upgrades
Dec. 20 • L.A. county, LAFD fire chiefs discuss regional dispatch network
Dec. 11 • Address concerns before staff changes at 911 center, L.A. mayor says
Dec. 10 • L.A. seeks controversial overhaul at LAFD's troubled 911 call center
Dec. 04 • L.A. fire chief blames slower response times on budget cuts
Nov. 20 • LAFD looks at ways to speed up emergency response times
Nov. 15 • Medical response time lags in many pricey L.A. neighborhoods
Nov. 15 • How fast is LAFD where you live?
Nov. 15 • Investigation of LAFD response times finds deeper flaws
Nov. 14 • Quiet L.A.
Nov. 13 • How Los Angeles County voted
Nov. 06 • 2012 election results
Oct. 20 • Inside our 911 response time analysis
Oct. 20 • The line that help didn't cross
Oct. 20 • Delayed 911 response a matter of geography and jurisdictions
Oct. 05 • Years after ill-fated call, L.A. Fire Department's 911 flaws remain
Sept. 29 • copyboy
Sept. 13 • LAFD dispatchers waste time getting 911 callers to start CPR
June 19 • Expert says L.A. Fire Dept. didn't give help to fix response data
June 18 • L.A. Fire Department's data expert steps down after less than 3 months
June 05 • 2012 California primary results
May 19 • Audit finds LAFD takes longer on medical calls since budget cuts
May 18 • Dispatch lag slows LAFD call response
May 15 • Software made L.A. fire response times untrustworthy, report says
March 13 • django-bakery
March 01 • L.A. City Council redistricting
Jan. 06 • 2012 California election results
Jan. 03 • 2012 presidential primary results
Jan. 01 • python-elections
2011
Dec. 15 • django-softhyphen
Dec. 02 • Occupy L.A.: A portrait of the arrested protesters
Sept. 15 • django-yamlfield
Aug. 17 • python-googlegeocoder
Aug. 07 • jquery-geocodify
July 22 • latimes-statestyle
July 01 • PastPages
May 31 • python-lametro-api
May 10 • timelines.latimes.com
April 17 • U.S. is increasing nuclear power through uprating
April 14 • python-documentcloud
March 05 • spreadsheets.latimes.com
Feb. 27 • Billions to spend
2010
Dec. 31 • table-stacker
Dec. 14 • latimes-calculate
Nov. 25 • documents.latimes.com/
Nov. 07 • appengine-template
Sept. 30 • Mapping L.A.: Crime
Aug. 24 • Hollywood Star Walk
Aug. 05 • django-greeking
July 24 • Where does the Westside start?
July 03 • Proposition 8: Who gave in the gay marriage battle?
June 29 • How to turn $1,800 in part-time pay into nearly $100,000 a year
2009
July 09 • LAPD's public database omits nearly 40% of this year's crimes
April 05 • Highest crime rate in L.A.? No, just an LAPD map glitch
Feb. 19 • Mapping L.A.: Neighborhoods
Feb. 14 • django-correx
2008
Sept. 08 • California Schools Guide
Sept. 05 • Half of high schools met U.S. goals
Aug. 01 • L.A.’s Top Dogs
Aug. 01 • L.A. is going to the Chihuahuas
June 11 • Hear No Evil, Smell No Evil
May 26 • California's War Dead
Jan. 30 • Citing Ronald Reagan not so helpful this time around
2007
May 22 • Collateral damage
April 14 • Clear Channel gives Tate Talking Points Against XM-Sirius merger
2005
Dec. 27 • Federal loans go for risky business