Work

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

2019
May 29 • Black market cannabis shops thrive in L.A. even as city cracks down
May 10 • latimes.com/tips/
April 28 • OldLAPhotos
April 26 • hsr-documents-analysis
April 26 • "How California’s faltering high-speed rail project was ‘captured’ by costly consultants."
April 05 • usa-style-guides
April 01 • census-data-downloader
March 28 • Are Arabs and Iranians white? Census says yes, but many disagree
March 28 • swana-census-analysis
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 • helicopter-accident-analysis
Nov. 18 • Danger spins from the sky
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 • hollister-ranch-analysis
Oct. 20 • At Hollister Ranch, homeowners enjoy private beaches — and hefty tax breaks, too
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 • Out of control: The deadly toll of street racing in Los Angeles
March 16 • street-racing-analysis
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 • construction-jobs-analysis
April 20 • Immigrants flooded California construction. Worker pay sank. Here’s why
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 • http://www.latimes.com/projects/la-fi-electricity-capacity/#nt=outfit
Feb. 05 • A runaway energy industry is costing California billions
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 California election results
Nov. 08 • 2016 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 • LAFD fire marshal steps down after criticism that he cut corners on safety
Aug. 24 • California's new test scores: What they are, why they matter and how your school scored
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 • Why the LAFD is still largely white and male despite diversity efforts
Nov. 17 • LAFD's new recruitment chief on diversity: 'We have work to do'
Nov. 14 • StoryTracker
Nov. 03 • How many millionaires does California send to Congress? Find out here.
Nov. 03 • The richest man and the poorest man in Congress are both from California
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 • Sheila Kuehl claims victory in L.A. County supervisor race
Nov. 05 • Crucial L.A. County supervisor race results map
Nov. 05 • Kuehl's victory no guarantee of pro-labor bloc on Board of Supervisors
Nov. 04 • 2014 California election results
Nov. 04 • 2014 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 • django-urlarchivefield
Aug. 14 • storysniffer
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 • Two L.A. fire commanders reassigned
Feb. 28 • First News App
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 • LAFD halts popular Twitter feed, blocks access to 911 call records
Dec. 12 • L.A. Fire Department to resume sharing details on emergency responses
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 • Garcetti supporters score city appointments
Oct. 08 • Mayor adds departments' performance data to his website
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 • PastPages API
June 13 • pastpages2gif
June 13 • LAFD expresses 'sincere regret' regarding Mexican costumes at fundraiser
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 • LAFD chief's report slammed by city Fire Commission
May 21 • L.A. firefighters vote against more dues for political campaigns
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 • How fast is LAFD where you live?
Nov. 15 • Investigation of LAFD response times finds deeper flaws
Nov. 15 • Medical response time lags in many pricey L.A. neighborhoods
Nov. 14 • Quiet L.A.
Nov. 13 • How Los Angeles County voted
Nov. 06 • 2012 election results
Oct. 20 • Delayed 911 response a matter of geography and jurisdictions
Oct. 20 • The line that help didn't cross
Oct. 20 • Inside our 911 response time analysis
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