Ben Welsh on Muck Rack

Ben Welsh Verified

Downtown L.A.
Database Producer — LA Times
As seen in:  LA Times, Hartford Courant
Covers:  energy, data, politics, money in politics, public safety

Database producer for the Los Angeles Times Data Desk. Editor and publisher of http://palewi.re and http://pastpages.org

Ben Welsh's Biography

I am a reporter, albeit an unconventional one.

I specialize in what is called computer-assisted reporting. Journalists in the past were often hack novelists. I'm a hack computer programmer. I use computers to collect, organize, analyze and present large amounts of information.

I work at the Los Angeles Times, a daily newspaper and 24-hour website based in Southern California.

I am also the editor and publisher of PastPages, an ...

Read Full Bio →

What tools and software do you use to do your job?

Python, PostGIS, Django, HTML, JavaScript

Did you work for your high school newspaper? If so, what did you do there?

No.

Opening: Lead developer

californiacivicdata.org — Get paid to conquer campaign cash. Join the California Civic Data Coalition! The California Civic Data Coalition is seeking a developer to lead its open-source project to master the jumbled, dirty and difficult government database that tracks money in California politics.
Aug 04, 2015

RT @cacivicdata: Get paid to conquer campaign cash. Apply now to join the California Civic Data Coalition! californiacivicdata.org/2015/08/05/ope…

Ben's other API test

Ben's API test - LA Times

County regulator calls for sweeping overhaul at Compton Fire Department

latimes.com — The Compton Fire Department needs a sweeping overhaul of how it responds to thousands of 911 calls for emergency help each year, according to a letter from the county's top regulator obtained by The Times.
Jul 24, 2015

Fresh scoop served now on @LANow: County regulator calls for sweeping overhaul at Compton Fire Department latimes.com/local/lanow/la…

Jul 24, 2015

RT @LANow: County regulator calls for sweeping overhaul at Compton Fire Department lat.ms/1LCXcCz

Jul 24, 2015

County regulator calls for sweeping overhaul at Compton Fire Department lat.ms/1HYFnYy @LATdatadesk @palewire

Jul 24, 2015

RT @latimes: L.A. County regulator recommends sweeping overhaul of how Compton Fire Department responds to emergency calls lat.ms/1LItuup

Jul 24, 2015

RT @palewire: Fresh scoop served now on @LANow: County regulator calls for sweeping overhaul at Compton Fire Department latimes.com/local/lanow/la…

Show 1 more tweet from Paul Pringle

California Civic Data Coalition named Knight News Challenge winner

californiacivicdata.org — Foundation commits $250,000 to boost open-source effort to ease analysis of money in state politics The Knight Foundation announced Wednesday that the California Civic Data Coalition is among the winners of the 2015 Knight News Challenge on elections.
Jul 22, 2015

RT @cacivicdata: We won! California Civic Data Coalition is moving into high gear, thanks to Knight News Challenge - and we're hiring californiacivicdata.org/2015/07/22/kni…

Jul 22, 2015

#TRUMPETS: Our push to unlock California's money in politics data is a winner of the 2015 #newschallenge. Check it! californiacivicdata.org/2015/07/22/kni…

Jul 22, 2015

RT @palewire: #TRUMPETS: Our push to unlock California's money in politics data is a winner of the 2015 #newschallenge. Check it! californiacivicdata.org/2015/07/22/kni…

Jul 22, 2015

RT @palewire: #TRUMPETS: Our push to unlock California's money in politics data is a winner of the 2015 #newschallenge. Check it! californiacivicdata.org/2015/07/22/kni…

Show 21 more tweets from Steven Rich, Aaron Williams and others...

Say hello to our new open-source software for loading bulk data into PostgreSQL

californiacivicdata.org — Take advantage of powerful COPY command to load big CSVs into Django faster than ever This morning we're releasing a new open-source software library that allows users of the Django web framework to more quickly load comma-delimited data into PostgreSQL databases.
Jul 17, 2015

Nightshift. If yer bored, take an early look at this reveal for our new hooey to supercharge Django CSV loading californiacivicdata.org/2015/07/17/hel…

Jul 17, 2015

PostgreSQL addicts and Django hackers, Say hello to our new library for loading bulk data. COPY has come home. californiacivicdata.org/2015/07/17/hel…

Jul 17, 2015

RT @palewire: PostgreSQL addicts and Django hackers, Say hello to our new library for loading bulk data. COPY has come home. californiacivicdata.org/2015/07/17/hel…

Show 3 more tweets from Aaron Williams, Ben Welsh and others...

Confidential L.A. County audit another blow to Compton Fire Department

latimes.com — The Compton Fire Department has failed to properly document emergency medical care and monitor the training and performance of the city rescuers who respond to 911 calls for help, according to a confidential audit obtained by The Times.
Jul 14, 2015

Regulators refuse to release audits of problems with local 911 care. Don't worry. The @latimes is on it. latimes.com/local/lanow/la…

Jul 14, 2015

"Confidential" + "obtained by the Times" = more @palewire watchdog reporting, now on Compton FD: lat.ms/1L7adUO

Jul 14, 2015

RT @JosephSerna: "Confidential" + "obtained by the Times" = more @palewire watchdog reporting, now on Compton FD: lat.ms/1L7adUO

Jul 18, 2015

For the latest on the problems at the Compton FD check my report earlier this week latimes.com/local/lanow/la…

Compton city manager's letter putting fire chief on leave

documents.latimes.com — Compton Fire Chief Jon Thompson was put on administrative leave Tuesday following a series of Times reports on shortcomings at the fire agency. City Manager Johnny Ford said he had notified Thompson that he was relieved of duty pending an investigation. Former Fire Chief Rico Smith will take over the department and serve as interim chief, Ford said.
Jul 07, 2015

I obtained a copy of the letter from the Compton city manager putting the city fire chief on leave. Read it here. documents.latimes.com/compton-city-m…

Compton Fire chief put on administrative leave following Times reports

latimes.com — Compton Fire Chief Jon Thompson was put on administrative leave Tuesday following a series of Times reports on shortcomings at the fire agency. City Manager Johnny Ford said he had notified Thompson that he was relieved of duty pending an investigation. Former Fire Chief Rico Smith will take over the department and serve as interim chief, Ford said.
Jul 07, 2015

BREAKING: Compton Fire chief put on administrative leave following Times reports latimes.com/local/lanow/la…

Jul 07, 2015

RT @palewire: BREAKING: Compton Fire chief put on administrative leave following Times reports latimes.com/local/lanow/la…

Jul 07, 2015

#Compton fire chief put on admin leave after @palewire digging reveals shortcomings at agency: lat.ms/1CZcgC4

Jul 07, 2015

I spoke with Rico Smith, who will take over Compton FD. “We will fix everything that's broke.” he said. The latest: latimes.com/local/lanow/la…

Jul 07, 2015

RT @palewire: BREAKING: Compton Fire chief put on administrative leave following Times reports latimes.com/local/lanow/la…

Show 4 more tweets from James Queally, Joe Serna and others...

Compton Fire Department ordered to remove defibrillators from trucks, ambulances

latimes.com — Most fire trucks and ambulances run by the Compton Fire Department have been stripped of defibrillator machines, a crucial lifesaving device that rescuers use to deliver a shock and try to restart the heart of cardiac arrest victims. County regulators ordered the department to remove the devices last week after fire officials were unable to produce documentation showing Compton firefighters had been properly trained to use the equipment.
Jul 07, 2015

Compton Fire Department ordered to remove defibrillators from trucks, ambulances lat.ms/1CXd4HC

Jul 07, 2015

Compton Fire Department ordered to remove defibrillators from trucks, ambulances @palewire scoop lat.ms/1CXd4HC

Jul 07, 2015

Check out our late break: Most trucks and ambulances in Compton's FD without defibrillators after county crackdown latimes.com/local/californ…

Jul 07, 2015

RT @latimes: Compton Fire Department is ordered to remove defibrillators from trucks and ambulances lat.ms/1ClXlXY

Show 1 more tweet from Ben Welsh
More Articles →
Aug 04, 2015

@carlmalamud Thanks. We've already started, but much more to do …cess-raw-data.californiacivicdata.org/en/latest/ Interested in how to lead in republishing. dat?

Aug 04, 2015

@carlmalamud As we embark on cleanup project not unlike yours what republishing options besides CSV should we aim at? californiacivicdata.org/2015/07/22/kni…

Aug 04, 2015

Check our fuller job description, which I'm posting all over. Plz pass it along to anyone who might be interested! twitter.com/cacivicdata/st…

Aug 04, 2015

It's official: The Republican Party is now more technologically advanced than your news company's IT department. twitter.com/republicgop/st…

Aug 04, 2015

@derekwillis Okay. I just go to the Turok response email. Thank you. .... Thank you.

Aug 03, 2015

@albertocairo I totally want a gif of the conspiracy scene where Cruise says "its all connected" or whatever



Are You a Journalist?

Make a Portfolio

Create a free Muck Rack account to customize your profile and upload a portfolio of your best work.