May 14

Track how the feds are doing with TRAC

Part of  a series on databases.

Tucked in a suite behind a non-descript beige door here at the Newhouse School at Syracuse University is an amazing group of people who crunch numbers and publish surprising statistics that help your readers/listeners/viewers gain insight into the performance of federal agencies and staff in your area.

David Burnham and Sue Long run TRAC and consult regularly with news organizations. Photo from TRAC.

It’s the Transactional Records Access Clearinghouse, TRAC, pairing the great minds of David Burnham, an investigative reporter, and Sue Long, a statistical whiz and professor.

The two did data journalism before the name existed!

They started years ago by analyzing IRS records to track who was getting audited. To this day,  dozens of media organizations (including the New York Times)  publish TRAC statistics each April 15 about which areas of the country are most and least likely to be audited by the IRS!

But TRAC has expanded over these 20 years and now provide access to multiple databases from the U.S. Department of Justice and other federal agencies. With TRAC data you can find all types of statistics related to crime, justice and more, including:

  • a comparison of how often drug dealing is prosecuted in Northern New York compared to South Florida,
  • a comparison of the  the average sentence in Arizona (or any region)  for a certain white collar crime, compared to those in another part of the country,
  • a review of the activity level and effectiveness of a U.S. attorney’s office by looking at the  number of cases that office wins,
  • the number of persons accused of terrorism and whether that percent is increasing or decreasing over time.

And there’s much, much more. TRAC’s goal is to help the public understand the  staffing, spending, and enforcement activities of the federal government. And by looking at that, citizens can get some sense of priorities and whether they match up to the rhetoric of politicians and public servants!

TRAC is not a database for a quick-hit story, as it’s going to take some time on the TRAC website to understand the terms, learn to navigate the site, and make sense of the statistics. Much of the information is free, some is available for a fee to help underwrite the ongoing work.

Here’s your chance to get a taste of what TRAC is up to. The staff is doing a webinar this week Thurs., May 17 at 2 p.m. EST on immigration trends and data. Or you can watch previous webinars at the TRAC Webinar Page.

Posted in Databases, Finding Stories | Leave a comment
May 08

If A Plane Crashes — Be Ready!

from Landings.com

More than 470 people died in airline accidents in 2010, the latest year for which the National Transportation Safety Board reports. That’s many fewer lives than are killed each year on highways, nearly 33,000.  Still, you’ll probably have an airline crash to cover in your career.   Are you ready?

One of the mantras I distinctly being told in the TV newsroom when I first started: If there’s a plane crach, first at the scene, get the tail number.  The tail number is the key to finding much more. Plug that number into the online site, Landings.com and you can find the plane’s registration, model number, read any previous problems with the plane (known as service difficulty reports), and more.

The tail number begins with a N and you put it into the search box on this Landings.com page.  See the screenshot clip at the right for a list of lots of other helpful information at the Landings site.

Other websites to help in your reporting:

Posted in Backgrounding for News Stories, Databases | Leave a comment
May 03

Find Doctors In Your Area Paid by Drug Companies

Part of a series on databases to help in daily reporting.

One important journalistic principle is avoiding conflicts of interest. We usually think about that for journalist avoiding ties that might taint their work. But I think it applies to sources as well –making sure we use independent sources or know their connections to any companies about which they speak.  Thus it might be helpful for you to know if any of the doctors you have used , or might use in a story about prescription drugs have been paid by drug companies.

The expenses may be legitimate.  Many would argue that doctors have a right to be reimbursed if they lead a seminar, for example, at an event funded by a pharmaceutial company. And such payments don’t mean their interview with you is necessarily tainted. But you’d probably rather know that have a reader, viewer, or listener point it out. 

Pro Publica took all the information it could find from drug companies about their payments to doctors, cleaned and standardized the data and published it as a searchable database, Dollars for Docs. It was not an easy task. But its database is easy to use.

Be sure to read the “about the data” section on the ProPublica site so you understand that database’s sources, coverage and classification system.

Some of the drug companies provided the information as the result of legal settlements with the feds. Pro Publica reports that the federal government will require all drug companies to do so beginning next year, and will put the information on a searchable databases for consumers.  Until then, check out the Dollars for Docs.

Posted in Databases, Finding Sources, Finding Stories | Leave a comment
Apr 30

Tracking Campaign Finance — and More

Part of a series on how databases can add value to daily news stories. 

Have you heard the political drumbeat?  The national presidential race appears down to two contendors.  U.S. Senate campaigns are likely in full swing. And in some states, the politicing may be ongoing in state or local races, as well.  So campaign finance databases can be of great help in stories, and not just those about politics.  You can use them to:

  • find key contributors
  • track the industries supporting certain candidates
  • check candidate expenditures
  • check candidate and/or donor addresses
  • find interviewees who have an informed opinion on the race (because they’ve donated)

To underscore the latter point, it’s not just political stories where you can use this database. Sometimes hard to find a supporter of Candidate X, or someone from one of the alternative political parties.  To find those interviewees,  search for  donors to that candidate or donors to a previous candidate from that lesser-known party.

For federal campaigns, I recommend these two websites:

With a hat tip to news librarians MargotWilliams, Leigh Montgomery and Derek Willis , I also found some master sites that link to all state campaign finance reports by state. Some of the links I tested aren’t updated, so if you can’t find your state,  I would go to the state website, find the elections unit and go from there.

The latter is an amazing site and I got lost in wonder for 20 minutes!  So when you have an extra 20, take a look and learn it so when you need it in a pinch, you are already familiar with it.


Posted in Backgrounding for News Stories, Databases | Leave a comment
Apr 27

Track Charities with a 990

Part of a series on how databases can add value to daily news stories. 

We’re coming up on the time when non-profits and charities have to file their 990 reports to the IRS, giving basic financial information, salaries of top employees, and an overview of  their missions. You can find great tidbits in these reports. They can give you background on a new organization. Or you can compare the costs and expenditures of  similar groups to each other  The required forms are due May 15 for those non-profits who run on a calendar year, so start your plans!

Guidestar logoA non-profit is required to show you a copy at its main headquarters. You can also get one, and past years’ copies, free online at Guidestar.  It posts them within two months of filing.

Guidestar gets the forms from the IRS and the organizations themselves.  Its database contains more than five million forms!

Just like with income taxes,  the non-profits can get an extension until Aug. 15 or even Nov. 15. For those operating on another fiscal year it is, according to Guidestar, due by the 15th day of the fifth month after  its fiscal year ends. So for example, a charity that  operates on a July -June fiscal year, must produce one by Nov. 15.   You might want to put a ticker on your calendar.

Posted in Uncategorized | Leave a comment
Apr 23

Database Quickies: Property Records

Part of a series  on databases that add value to a daily story.

A well-known person in our area, under federal investigation, suddenly put his house up for sale.  It became a page 1 story in the local paper, with details about the house. The story included the house layout, the number of rooms, and the home’s value.  The reporter may have gotten all this from an online real estate listing, but did you know a lot of this information, and sometimes more,  is available through online property records provided by municipal governments?

The county in which I live puts all the property tax records online for easy perusing. I can find out the number of rooms, the home’s assessment, the taxes required (and whether they’ve been paid), and even comparables  in the same area.  I can trace the ownership and see how much each owner paid for the home.

Reporters can use  property records to confirm ownership of a home, find an address when they need to send a photographer to get photos/video of it, or go themselves for  an evening home interview with someone who has been ducking them.

Many cities and counties have property tax records online. Check at your county’s website or call the local property tax office.  You can pay several online services for records, but before you do, see BRB Publications. It has the  best general directory I’ve found to find free public records by state.  BRB, Tempe, Ariz.,  publishes books and online sites  for locating public records.

Leave a comment below if you know of other master sites for free property records or tell us ways you’ve used property records in a story.

Posted in Backgrounding for News Stories, Databases | Leave a comment
Apr 19

Database Quickies: Corporation Filings to SEC

Part of a series  on databases that add value to a daily story.

An international  company with a small plant aways from where I live announced it is closing that facility and  laying off 150 employees. The closure,  in a small town of about 8000 residents, became big news there and led one of the local TV newscasts that night.

In all the stories I read, saw or listened to,  no reporter mentioned that this same corporation ran a plant just 22 miles down the road from the one it was closing.  I’m guessing they didn’t know.

So how did I know? I skimmed through the company’s filings on Edgar, the online database of required company filings  at the Securities and Exchange Commission (SEC).

Now I’m no business expert, but years ago I interviewed the New York Times’ business reporter Diana Henriques, @dianabhenriques,  who gave me tips on what forms would be most helpful to reporters:

  • Start your search on the 8th line on the left, "Search for "Company Filings".

    10-K, the annual report;

  • 10- Q, covering business operations,  property, finances, pending suits, and background on the officers;
  • 8-K,  for significant changes in the company such as a sale,  new management, or a court judgment.

The SEC publishes  a list of all the forms by number so you can look for others that might be interesting.

The site can appear a bit clunky to navigate as the interface isn’t intuitive. But if you spend 10 minutes one day with its tutorial learning to navigate it, then when you need a quick factoid or a new angle on that company, you’ll be able to maneuver through the site quickly.

Remember the SEC only requires these filings from companies who sell securities, including stock.

Posted in Backgrounding for News Stories, Databases, Finding Stories | Leave a comment
Apr 17

Database Quickies: Census

Start of a series on databases accessible quickly to add value to a daily story. 

Here's just a portion of the screen from the Census Quick Facts page for Onondaga County, N.Y.

I’ve just finished teaching students about databases that can be accessed quickly and can make a story stronger with context or a take-away fact. Reporters, especially in TV,  have so little time now to research anything, so I thought @readyreporter readers might like to know about some of these quick helps.  I’ll start today and share several over the next few weeks.

One easy-to-use site is the Census Quick Facts database.  While digging through the full census site  is a bit daunting, the Quick Facts page is just three clicks away and gives a lot of interesting information such as:

  • population under 5, or over 65
  • number of veterans
  • home ownership rate
  • commute time
  • per capita (money) income and median household income
  • home residency more than one year
  • business ownership by women and minorities
  • building permits

You can search by city or county and it doesn’t take long to add up the numbers for the counties in your media market.  Try it out.

And if you have a database or website that is essential to your reporting, leave a comment below. I’d like to learn from you.

Posted in Backgrounding for News Stories, Databases | Leave a comment
Apr 10

Top Five Web Sites to Follow News

Job requirement: keep up with the news. So what are the best sites to check or autoload on your web browser?

In our student newsrooms, we see the AP wires within the ENPS system where we write scripts. But in addition,  I suggest producers in my radio reporting class keep five websites open, on various tabs in their browser,  to check regularly. You can adapt them to your computer, smartphone or IPad:

I love newsmap.jp, as a quick way to see what's in the news. Delighted to find out it comes from the designer of my favorite app, Flipboard.

Newsmap a graphical representation of headlines on Google News, with the most frequent stories gaining the largest space and type. It includes these world, national, business, technology, sports, entertainment and health categories. You  pull up headlines in just one of the topics, or see them all.  This treemap is courtesy of design engineer Marcos Weskamp, San Francisco,  @marumushi, also of Flipboard fame.

  • County 911 dispatch log Our county, fortunately,  publishes its log so we can track accidents and emergencies. They appear in chronological order and with locations and the name of the policy agency who is responding.
  • News release email account which we monitor for incoming media releases.
  • Audio feeds from  news services which we are licensed to use.
  • Our own online news website,  NCC News Online , so we know what’s being published  as we work on our radio cast.

What are the must-haves that you keep available through the day? Leave a message below.


 

Posted in Uncategorized | Leave a comment
Apr 03

Help for covering religion this week

Okay, so you didn’t grow up Jewish or Christian and you need a little help this week.  It’s Holy Week for Christians, and Passover begins Saturday for Jews, so here’s some key resources to help you understand the days, their history and peoples’ observances.

ReligionHeadlines, one of the several websites affiliated with Religion Newswriters, @ReligionReport,   has several backgrounders that can help on Judiasm.  It links to an about.com page with resources on the basics of  Passover and common questions about Judaism.

ReligionWriters even offers this primer on how to cover topics related to spirituality and religion and several tools such as links to statistics and story ideas.  It also updates a list of links on current topics on this beat.

I like BeliefNet for background on religion, as well as for trends and current stories. If you need some background on the various holidays this week, see this Holy Week section.

A final helpful resource is Religion News Service, (RNS) , @ReligionNewsNow, with news stories about current topics and activities of the various religious bodies in the U.S.

Posted in Finding Stories | Leave a comment