Ben Welsh on Muck Rack

Ben Welsh

Verified
Covers:  energy, data, politics, money in politics, public safety

Editor, @LATdatadesk at @latimes · Organizer, californiacivicdata.org · Archivist, pastpages.org · Send tips to ben.welsh@latimes.com

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.

Introducing a new bulk downloads site tracking money in California politics

californiacivicdata.org — Today we're launching an expansion of this site, remaking it as the only destination offering hassle-free access to the bulk data tracking money in California politics. Until now, analysts investigating the role of lobbyists and campaign donors at the Sacramento statehouse have been limited to an unwieldy dump from CAL-ACCESS, the jumbled, dirty and difficult database maintained by California's Secretary of State.

These magnets have become some of L.A.'s highest-scoring public schools

latimes.com — New tests show the city's magnets have soared far above other schools. Read our guide to what it means and explore a list of how every magnet school scored. A magnet is a public school that is open to all students, regardless of where they live.

LAFD fire marshal replaced amid upheaval over inspections

latimes.com — After months of internal upheaval over a backlog in inspections, the Los Angeles Fire Department is replacing the official in charge of enforcing fire safety codes for apartment houses, schools, hospitals and other high-occupancy buildings. Fire Chief Ralph M.

connect to mysql, query, print the results . palewire

palewi.re — Today let's take a look at how you can use Python to connect to your MySQL database, issue a SQL query and do things with the results. It's not that hard to write a simple SQL command by hand and muck with the results, so why bother?

Meet the California Civic Data Coalition's first student developer

Clinton or Sanders: Who did your L.A. neighborhood choose?

latimes.com — Hillary Clinton carried California by a big margin in Tuesday's primary, but early results show the vote varied across Los Angeles County. Explore how each precinct voted using this interactive map.

Live June 7 primary results

graphics.latimes.com — The 2016 presidential nomination battles approaches its end Tuesday with contests in the final six states, including delegate-rich California.

Montana primary 2016 election results and map

South Dakota primary 2016 election results and map

New Mexico primary 2016 election results and map

More Articles →
Sep 26, 2016

RT @ChadMoriyama: Alanna Rizzo tries to interview Clayton Kershaw, who proceeds to go nuts. Had to upload this.  https://streamable.com/hj9x 

Sep 26, 2016

Floods coming to my hometown. Interesting to see how city, @gazettedotcom, others rallying attention to prevent repeat of 2008 disaster https://t.co/bw6q9rjZfM

Sep 26, 2016

@hiltzikm I'm open to it being better relative to other herd-like activity

Sep 25, 2016

If you ever need evidence political journalism is a herd, this fad is waiting for you.  https://twitter.com/rickhasen/status/780254676574842880 

Sep 25, 2016

@erikhinton Do the Harry Potter fans know how unhealthy this all is?

Sep 25, 2016

@hunter_owens p sure we just made America great again.

Sep 25, 2016

@hunter_owens easily in top 10 dodgers moments all time

Sep 25, 2016

If you can't like the Dodgers after this, I just don't know.

Sep 25, 2016

Vin Scully is saying goodbye by leading a singalong of "Wind Beneath My Wings." Cynicism died today at Dodger Stadium.


Are You a Journalist?

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

Create a Portfolio