Check out some of my favorite research tips, strategies and resources from this year’s Investigative Reporters and Editors conference, where about 1,100 incredibly talented journalists are meeting in San Antonio. These conferences are geared for journalists, but really anyone who’s interested in research tools will find many of these tips handy.
Jul 1, 2013: 8:32 am
More awesome search tips from Google expert Daniel Russell, with real-world examples.
Jun 24, 2013: 12:07 pm
Creative ways to find sources:
Perhaps the best tip sheet at #IRE13 – http://t.co/gY0bLhOqKj on building sources from @mattapuzzo
— Nick Penzenstadler (@npenzenstadler) June 22, 2013
Jun 24, 2013: 10:27 am
How to find America’s worst charities: Excellent tips by Kendall Taggart at the Center for Investigative Reporting.
Jun 24, 2013: 7:40 am
Tips and tweets:
Compliments to @IRE_NICAR staff, led by @markhorvit for a great conference. Leaving San Antonio totally jazzed #IRE2013 #IRE13
— Mark Katches (@markkatches) June 23, 2013
SearchReSearch: TipSheet for IRE 2013 ( #IRE13 ) http://t.co/So9pCxVDTm great resource for maximizing your Google search capabilities
— Kenneth Olson (@ken_v_olson) June 23, 2013
MT @gijn: Getting past NO when govt pushes back. Presentation by David Jackson (Chicago Tribune) #transparency http://t.co/UtZKsd5BCS #IRE13
— Melissa Nann Burke (@nannburke) June 23, 2013
New blog post | "Beyond the written word – visual data in journalism – presentation and links from #IRE13 http://t.co/OOsFQix6Ht
— Ben Jones (@DataRemixed) June 23, 2013
Retention schedules kept on Web sites are like a "menu of documents" at an agency or government. (@jaimidowdell, #ire13)
— Becky Yerak (@beckyyerak) June 23, 2013
.@SunFoundation's @bill_allison and Jacob Fenton demonstrating great tools to follow influence in government: http://t.co/X7rcMiBK09 #ire13
— Joe Yerardi (@JoeYerardi) June 22, 2013
Jun 23, 2013: 1:22 pm
Investigating the wealthy sounds like a daunting task, but there’s actually a vast amount of historical resources available to the reporter who wants to try.
Investigative reporter Lise Olsen of the Houston Chronicle once visited a probate court clerk’s office to check out a tip that lawyers were making themselves rich at the expense of the estate of a wealthy but incapacited man. The clerk asked how many boxes she wanted to get in the case — there were 30.
In other words, probate courts are a gold mine. Olsen suggested looking at fee schedules and reports filed by court-appointed guardians.
It helps that wealthy Texans are chatty and often more approachable than their East and West-coast counterparts, said Mimi Swartz, an executive editor at Texas Monthly. In many cases, the only people who crave more attention than rich Texans are their lawyers. You can learn a lot about how the real world works by simply listening to their stories.
“One way to pay kickbacks to judges is to play poker and lose,” Swartz said.
Ancestry.com can help you find genealogical records. For a modest fee, you can find an actual picture of the ship that ferried specific European immigrants across the Atlantic.
A curious mind can always lead you to a good story. Pulitzer-prize winning journalist Bill Dedman stumbled across the unusual case of reclusive heiress Huguette Clark while he was house hunting and checked the most expensive mansions that were for sale. It launched him on a story that started out as a feature about Clark, whose father was a wealthy copper-mine baron and disgraced lawmaker. But the story morphed into an investigation of Clark’s current whereabouts — she hadn’t lived in any of her mansions for years, and Dedman’s reporting raised questions about the people overseeing her vast fortune.
The bizarre tale struck a chord with readers. It went viral and Dedman ended up writing a book about it called “Empty Mansions: The Mysterious Life of Huguette Clark and the Spending of a Great American Fortune.”
Dedman relied on cemetery records, depositions in court cases and old newspaper clippings. He obtained pictures of Clark’s estates and the artwork she painted. He wanted to do a good job describing them, so he talked to experts.
Botanical consultants told him precisely what kind of unique plants were on the estate grounds.
A professor of fashion history described the kind of apparel Clark wore as a young woman.
An art expert told Dedman that in the old days, women usually painted with pastels. Oil painting was considered a manly art form. Yet Clark chose to be an oil painter. It showed an intriguing snippet of her character — which Dedman would not have discovered if he hadn’t gone to the trouble of talking to a knowledgeable expert.
Jun 22, 2013: 7:57 pm
Tips on Twitter:
Not able to be at #ire13? Check out tipsheets http://t.co/nQEbHouZCR More will be added.
— Jaimi Dowdell (@JaimiDowdell) June 22, 2013
If you want my slides on tracking government contracting, you can view them here: http://t.co/zj1oG2WVCM #IRE13
— Danielle Ivory (@danielle_ivory) June 22, 2013
From the #IRE13 session on investigating the oil and gas industry, here's a link to a fracking chemical database: http://t.co/dx8Pca83YJ
— Cezary Podkul (@Cezary) June 22, 2013
There are nine exemptions in FOIA. The 10th one they don't tell you about. It's "We don't want to give it to you." @wcochran #ire13
— Cherrill Crosby (@cherrill_crosby) June 22, 2013
Tipsheet from our #IRE13 panel about how to win open-records battles with uncooperative agencies: http://t.co/LgHp6aiph2
— John Tedesco (@John_Tedesco) June 23, 2013
Investigating trafficking across the U.S.-Mexico border: http://t.co/OkiN0l7yGU #IRE13
— IRE and NICAR (@IRE_NICAR) June 22, 2013
Take a look at @writerbarton's groundbreaking story about a man's death in police custody http://t.co/X10inL9szw #IRE13
— Lauren Gilger (@laurengilger) June 22, 2013
Yes! The link from the "Search Rodeo" session at #IRE13 is now live, compliments of @BarbGray – check it out here: http://t.co/IH25yQCBOP
— Cezary Podkul (@Cezary) June 22, 2013
Download a PDF of my "Digging Deeper with Social Media" talk at #IRE13 | links, examples, tools | http://t.co/S1SqcfABfa #kipcamp
— DougHaddix (@DougHaddix) June 22, 2013
Slides from my #IRE13 demo of @TabulaPDF: https://t.co/Mf4OCREjq4
— mike tigas (@mtigas) June 22, 2013
https://twitter.com/sgoldstein/status/348548832109416448
Jun 21, 2013: 4:35 pm
Tips on Twitter:
Stalking a billionaire with a boat? NPR's Margot Williams: http://t.co/vf2IFVpfcl #IRE2013 #IRE13 pic.twitter.com/k4CfiW3qmv
— Amy Pyle (@amy_pyle) June 21, 2013
New text searchable database of IRS 990 nonprofit forms from past 10 years via @LukeRosiak http://t.co/qAj4sBSViT #IRE13 #kipcamp
— DougHaddix (@DougHaddix) June 21, 2013
Getting skeptical sources to talk: "Sometimes people are more afraid of looking dumb than giving away sensitive information". So true #IRE13
— Aisha Dow (@aishamae) June 21, 2013
Enterprise on the ed beat handout here. #ire13 http://t.co/0i9GQRm7JX
— Mc Nelly Torres (@WatchdogDiva) June 21, 2013
#IRE13 Center for Investigative Reporting offers lots of reporters tools http://t.co/ClEWp47NCZ
— Bennett Loudon (@BennettLoudon) June 21, 2013
.@DavidBarstow: You need to spend a lot of time w the documents, reading everything and "marinate yourself in the information" #ire13
— Kelsey Ryan (@kelsey_ryan) June 21, 2013
Whatever you can't wait to tell a friend, don't leave it out of the story: advice from Jerry Mitchell, journalist. #IRE13 #GannettConnects
— Britt Kennerly (@bybrittkennerly) June 21, 2013
Jun 21, 2013: 4:11 pm
Check out interesting panels you missed at the IRE conference by reading the IRE Conference blog and Gannett’s IRE 2013 tumblr. Armies of reporters and journalism students are posting good stuff, including:
Jun 21, 2013: 11:40 am
Tips on Twitter about investigating charities:
https://twitter.com/melcrowe/status/348116910254198785
Investigating #nonprofits tip sheet #ire13 https://t.co/O9oWxFTz1j
— Kelsey Ryan (@kelsey_ryan) June 21, 2013
#IRE13: @CIRonline database of 8000 state regulatory actions against charities & solicitors: http://t.co/OjdYiUHgKo #IRE2013
— Douglas Lucas (@DouglasLucas) June 21, 2013
Jun 21, 2013: 11:23 am
So much information at IRE conferences is about how and where to find documents and information. It’s always interesting to hear what you should do after you amass that giant mountain of data and documents.
During yesterday’s Business Investigations panel, Reporter David Heath of the Center for Public Integrity talked about “the magic of simply sorting by date” when you take all your documents from a variety of sources and plug the information into a spreadsheet to make a timeline.
“It’s a very simple process,” Heath said. “It sounds too basic to talk about.” Heath includes everything he finds in the timeline early on in the reporting process because at first you don’t know what’s important. As the chronology grows, patterns, connections and narratives begin to emerge.
While investigating a shady company, Heath found a corporate filing signed by a man who claimed to lead the firm. But during that same time period, the same person also signed a different document in which he claimed to have nothing to do with the company. Heath later learned one of the government disclosures had been forged.
“Timelines are essential,” Heath said.
Other interesting tidbits at the panel:
Jun 20, 2013: 3:31 pm
Best #IRE13 tweets so far:
#IRE13 slides from "Compared to What…" with @JsavageCaller available here http://t.co/BXnmfQ8IqE Hit us up if you have questions.
— Coulter Jones (@coulterjones) June 20, 2013
If you missed our kickoff session for #IRE13, all the resources are here: http://t.co/UHQvlptmv2 #BizJ
— Reynolds Center (@BizJournalism) June 20, 2013
If, like me, you missed the session on cheap data wrangling tools, get the presentation and tip sheet here: http://t.co/jwJ0g3EbjA #IRE13
— Tyler Dukes (@mtdukes) June 20, 2013
Here's Google Drive link to spreadsheet of tipsheet from this am's session #IRE13 Apps Reporters Can Use.xlsx – https://t.co/FDNJcdv7vl
— Stephen Stock (@StephenStockTV) June 20, 2013
We're happy to announce free Tableau Desktop for journalists: http://t.co/qcA82sT6M3 @tableau #IRE13
— Ellie Fields (@eleanorpd) June 20, 2013
How #IRE13 comes together, in pictures. http://t.co/b7Rd5hXwli
— IRE and NICAR (@IRE_NICAR) June 20, 2013
My hotel at #IRE13 welcomes guests by explaining why things could get punch-drunk crazy after the Spurs game. pic.twitter.com/s4bC13QOVx
— Ben Giles (@ben_giles) June 20, 2013
Jun 20, 2013: 2:55 pm
Even before the 2013 IRE Conference officially started, the Donald W. Reynolds National Center for Business Journalism hosted a free seminar Wednesday about finding interesting news stories in seemingly dry economic data.
One cool thing about this panel was how they showcased actual news stories, then worked backwards and revealed how the kernel of the story idea was found in the data.
For this article about the Eagle Ford Shale boom that ran in the San Antonio Express-News, the reporters did the following:
- Visited the U.S. Bureau of Economic Analysis website;
- Clicked on the “interactive” tab;
- Sifted through a series of menus that took them down to the county level;
- Checked how much per-capita personal income had increased in the Eagle Ford Shale counties. Once you get the data you can look at it in a variety of formats, such as tables or charts:
This story and other articles used as examples all relied on economic data — but the stories were also filled with the voices of real people to bring those numbers to life.
All the resources and presentations discussed in the seminar are available here.
Jun 20, 2013: 2:50 pm
Naturally, the 2013 IRE Conference is on Guidebook. You can check the conference schedule on your phone, save the events you want to attend and get reminders. I also like how you can view a map of the hotel, read about the speakers and check the #IRE13 feeds on Twitter, Facebook and Instagram.
Yet another cool resource I learned from IRE.
Jun 29, 2012: 2:13 pm
Missed a panel at the IRE 2012 Conference in Boston? Tipsheets for members are available at IRE’s website. Yet another reason to join IRE.
Next year’s conference is in San Antonio, and we’re already talking about upcoming panels, speakers and events. Contact me if you have any ideas.
Thanks for a great time in Boston and hope to see you next year.
Jun 22, 2012: 10:39 am
How to attract an online audience for your investigation: http://t.co/beSA1th5 Awesome tips by @jessicaplautz from #IRE12
— ICIJ (@ICIJorg) June 21, 2012
Jun 21, 2012: 7:53 am
How to solve impossible problems: Daniel Russell’s awesome Google search techniques.
Jun 17, 2012: 9:09 pm
Tips on Twitter (via Katie Foody’s awesome Storify collection of tips from the IRE conference):
Need help cleaning up data? Mr. Data Converter, Mr. People, Google Refine. #IRE12 #irefree
— Lindsey Rogers Cook (@Lindzcook) June 14, 2012
The walkthrough of my Refine class, with sample data & slides. Arm yourself for the monkey apocalypse: http://t.co/GuCsIkEO #IRE12
— Tom Meagher (@ultracasual) June 15, 2012
Mapping & location-based data a big untapped resource for journalists. Guardian tutorial on Google Fusion: http://t.co/RIuCrpyW. #IRE2012
— Bill Mitchell (@bmitch) June 16, 2012
So many great Web tools coming out of Sunday #IRE12 session. Try www [dot] cometdocs [dot] com to convert PDF data to Excel. So cool.
— Lindsay VanHulle (@LindsayVanHulle) June 17, 2012
This. RT @willcarless: Great tip: use http://t.co/Fote8Hch to search for photos and see if they are fake #IRE12
— Tyler Dukes (@mtdukes) June 16, 2012
Gem of “Tracking Private Parts of Public Officials” Gov’t firewalls that log outbound web requests. Where are your officials surfing? #IRE12
— Saul Tannenbaum (@stannenb) June 16, 2012
Jun 17, 2012: 5:08 am
Fellow #ire12 conference goers. Try the app camscaner to scan and make PDF documents with your smartphone. Best app EVER.
— jeremyjojola (@jeremyjojola) June 17, 2012
Jun 16, 2012: 9:25 pm
https://twitter.com/willhuntsberry/status/214163754848485376/
Jun 16, 2012: 4:23 pm
You might want to create your own tip sheet, or handbook, that you can use throughout your journalism career.
My handbook is old and needs to be pruned. But you can see how it works. If I want to do a thorough job backgrounding someone, I go to the “Backgrounding” section of my handbook and start going down the list of things to check — licensing files, marriage licenses, etc.
Any time you come across a resource you think might come in handy, add it to your handbook. You might need it tomorrow — or a year from now.
Jun 16, 2012: 3:38 pm
Full link for #IRE12 #IRE2012 presentations on social media and backgrounding: http://t.co/T72BIbcc
— DougHaddix (@DougHaddix) June 16, 2012
Jun 16, 2012: 1:28 pm
Panel videos: IRE is posting videos of some panels at its latakoo page. Panels include tips for investigating businesses and a conversation about the state of the media after the News Corp. phone hacking scandal.
Jun 16, 2012: 9:16 am
Archives and historical documents can be powerful tools for journalists, even on deadline.
“It’s been my secret weapon,” said James Neff, investigations editor at the Seattle Times.
Some cool resources:
Regional collections of the maps are often available at local libraries, historical societies and universities.
Jun 16, 2012: 7:20 am
Check out the story behind the story of Craig Harris’ investigation of Arizona pension funds. Great stuff.
Jun 15, 2012: 4:46 pm
Resources used by Duff Wilson of Reuters for his investigation of the food industry and its lobbying against stricter health standards for children.
Jun 15, 2012: 11:44 am
Tips from Sara Ganim, reporter for the Patriot-News, who broke the Jerry Sandusky scandal:
“You wouldn’t find that in every newsroom,” Ganim said.
“Twitter is a really great way to stay in touch with your readers,” Ganim said. At Joe Paterno’s public memorial service, people on Twitter were asking her questions, guiding her to things to look for. “I found it incredibly helpful,” she said. “It’s a good gauge of what your readers want to know.”
Ganim didn’t want to rehash what the Associated Press was reporting — she argued with her boss that they needed to go back to their sources, the parents of the victims, to get their reaction. No one else could do that.
“That’s really how we were able to stay ahead,” Ganim said.
Jun 15, 2012: 11:09 am
Investigating Power: A vast video archive of interviews with investigative journalists — several of whom are speaking right now at the IRE Conference.
Jun 15, 2012: 10:18 am
Tips on Twitter:
Ira Rosen of 60 Minutes: “Dead space is your friend. You ask a question and you let it lay there and people fill up that dead space.” #IRE12
— Taylor Dobbs (@taylordobbs) June 15, 2012
Pulitzer winner James Grimaldi: "Showing the quid is easy. The quo is easy. It's the pro that's tough. How did connection happen?" #IRE12
— John Russell (@JohnRussell99) June 15, 2012
Don't settle for interviews with PR people. Insist on talking to the real source. The Art of the Interview at #IRE12
— Amy Karon (@amykaron) June 15, 2012
Berens: When hunting for data on investigative pieces, remember that these stories are really about people. This is why we do it. #IRE12
— Tyler Dukes (@mtdukes) June 15, 2012
"Every investigative story begins w/a timeline. It will pay gold" in showing patterns, narrative writing. M. Berens, Seattle Times #IRE12
— John Russell (@JohnRussell99) June 15, 2012
Jun 15, 2012: 8:33 am
Local communities are spending billions of dollars in tax subsidies to lure companies in the hope of getting more jobs and economic development. But the subsidies are often based on dubious claims and consultants’ studies that reporters should be checking.
The irony is that corporate subsidies erode the tax base for public schools — one of the things that actually does bolster economic development.
A few tips offered by panelists Daniel Connolly, Jim Heaney, Greg LeRoy and David Cay Johnston:
“Develop data,” said Heaney. “This is absolutely essential. You’ve got to go to the agency and ferret out all the costs. And most projects get multiple subsidies.”
Jun 15, 2012: 6:31 am
Data on deadline: Keli Rabon and Stephen Brock put together this list of handy databases you can use for breaking-news stories. “Be ready before breaking news hits,” Brock said at the panel “CAR under pressure.” “Practice the data.”
interesting websites from the presentation:
Jun 14, 2012: 4:07 pm
Demystifying Web scraping: Ted Han and Sean Sposito’s Google Docs presentation. Nifty.
Jun 14, 2012: 3:47 pm
Tips on Twitter:
Lots of great tips flying around #IRE12. A good one: Readers don't care abt work you did to analyze data, just findings (via @Coloradoan_TH)
— Brian M. Rosenthal (@brianmrosenthal) June 14, 2012
Does your city participate in the National Incident-Based Reporting System (NIBRS)? A gold mine of data on crime statistics. #IRE12
— Lindsay VanHulle (@LindsayVanHulle) June 14, 2012
Reading the #IRE2012 feed made me look up @alisonannyoung's Ghost Factories http://t.co/QlIt5HOL True multimedia. Nice video.
— Robin J Phillips (@RobinJP) June 14, 2012
#IRE12 blog post by @chelsbk How to get data from government agencies for any beat http://t.co/4U8XNxyX
— IRE and NICAR (@IRE_NICAR) June 14, 2012
Is anyone else who went to that privacy panel feeling a little paranoid now? #IRE2012
— Jordan Culver (@JordanCulver) June 14, 2012
Jun 14, 2012: 3:15 pm
Google Doc presentation of free computer-assisted reporting tools: Download a list of free resources discussed by Anthony DeBarros of USA Today and Matt Stiles of NPR.
Jun 14, 2012: 3:04 pm
Gannett Tumblr: Gannett journalists are covering the conference at “Gannett @ IRE. Great posts, pictures and videos.
Jun 14, 2012: 2:56 pm
Interactive wind map: Amazing map of wind patterns in the United States. “We hadn’t visualized wind before and hadn’t realized its power,” said Google’s Martin Wattenberg, who helped create the map by marshaling government data.
Jun 14, 2012: 12:38 pm
Panel tip: Get the records retention schedule.
From the Department of Things Reporters Should Really Be Doing A Whole Lot More Often, this tip comes from Ellen Gabler.
“I love teaching people about asking for data,” said Gabler this morning at “The ask: Requesting and negotiating for data.” To know what to ask for, you have to know what exists.
“Ask agencies for their records retention schedule,” Gabler said. This gives you a complete list of every type of document kept by the agency, which can point you to interesting records and databases.
Jun 14, 2012: 12:13 pm
Panel Tip: Create a data log.
Steve Doig and Elizabeth Lucas offered this gem at the “Taming monstrous datasets” panel.
When you analyze data, the queries can get really complicated. You might be doing some queries, crunch some numbers, and move on to the next part of the story. Then, weeks or months later when it’s time to publish and you’re bulletproofing those figures, an editor is going to ask how you came up with them. “You need to be able to answer that,” Doig said.
The solution is keeping a log of your work. It’s tedious, Lucas said, but it’s worth the trouble. When you turn in numbers for a story, attach a log documenting your process.
“An audit trail is absolutely essential,” Doig said.
Jun 14, 2012: 11:59 am
Jun 14, 2012: 10:37 am
Jun 14, 2012: 10:00 am
Awesome. Thanks! RT @John_Tedesco: So many great resources at #IRE13, I’m compiling a list of links and tips here: http://t.co/r9NpbTEUl8
Awesome RT @John_Tedesco So many great resources at #IRE13, I’m compiling a list of links and tips here: http://t.co/VEI7ocY2ds
Live-blogging the IRE 2013 Conference in San Antonio: Resources that will help you be a better journalist http://t.co/6kWVWjscvR
Thank you! “@John_Tedesco: So many great resources at #IRE13, I’m compiling a list of links and tips here: http://t.co/6wony4WysT”