Entries from June 2007 ↓

Data visualization, or I want pretty pictures!

Edit: I forgot to include the all-important link.

Yesterday, MSNBC published a fantastic report on journalists who made campaign contributions from 2004 to 2007.

This is a huge deal, because the trust of the public in newspapers rests on the objectivity and transparency of the journalists.

But I feel almost as though MSNBC went out of its way to make me not want to read the entire article.

It is always a good idea to publish the findings of an investigation like this in plain English, so that if someone screwed up, it can be pointed out. But I got through the first five contributors before I thought “Well, these people suck,” and left the Web site.

Where’s my data visualization?

Not only do pretty graphics help me to understand the information better, I’ll stay on your Web site longer.

What they could have done:

  • Mug shots of each journalist with a hover feature.
  • Divide by the news outlet, when you scroll over a graphic for each one it offers a list you can click on to the details.
  • Show me how much money was given to each party.

I know that there is a lot of information here. 114 people, how much they donated, when, to whom, and comments. That’s hard to split up. But this is an important story. It really calls for a package of graphics, not just a long block of text.

Google Search

Google has some pretty interesting search capabilities under way:

  • Keyboard shortcuts
  • Left-hand search navigation
  • Right-hand contextual search navigation

and my personal favorite - timeline and map views.

For searches related to people, events and places, Google can create timelines and maps of the results. You would be able to see search results in chronological order or as points on a map.

Imagine searching for a news term and being able to see all the information in context. That’s unbelievably cool.

(J)journalist/(P)programmer

Two recent events set off a discussion among the journalists whose blogs I read to the effect of: Do journalists need to be programmers?

Adrian Holovaty got a grant to go off and spend his days working on EveryBlock, and Northwestern University got a grant to provide scholarships to computer programmers who want to learn journalism.

Of course, this discussion has occurred in classrooms and newsrooms already, but this was the first explosion on the subject online. At the root, the problem is that in order to create great online content, SOMEONE in the newsroom needs to be able to work with databases (PHP), ActionScript (Flash), and CSS. But newspapers aren’t hiring, or programmers don’t get involved in journalism, or something occurs that prevents the newsroom from having access to someone who can write some code.

Here are some of the opinions that have appeared:

(A lot of people are differentiating between Programmers and programmers, Writers and writers. That’s why I use upper- and lower-cases differently.)

Matt Waite: In 2 separate posts, Matt explains the reasons newsrooms need programmers and who should/shouldn’t be learning it. His position is not that all journalists should learn to code, but that the people who have an interest in both writing and programming can bring more to the table. Ultimately, “Journalism needs all the innovators it can get.”

David Cohn: David, clearly on the side of journalists learning to code, asks where the scholarships are to teach journalists to program, and points out that the hot players in geek journalism are journalists turned coders, not the other way around.

Dan Gilmor: Journalists don’t need to learn to program, they need to learn how to work with programmers.

William Hartnett: “Journalists need to know programming. Not all of us, but some.” He differentiates between Programming and programming, and argues that some programming can be considered journalistic tasks, “clean up dirty personnel records from the school district or parse some messy addresses in crime data from the sheriff’s office.”

Scott Rosenberg: Scott supports the idea of journalists learning programming, but they don’t need to Program. More important, they need to understand the technology available for storytelling online.

Howard Owens: Howard is a journalist/programmer himself. But he recommends that journalists learn new skills that compliment their talents and individual situations. And these new skills should be applicable online. In a later update, Howard says the instead of all running off to learn to code, journalists should “figure out the niche your employer needs filled, and fill it.”

To me, online journalism encompasses all of the aspects of the Internet, be it code or multimedia. I’m not sure you can call yourself an Online Journalist if your Web page is all HTML tables and a few lines of PHP make you quiver like Jell-o. If you don’t feel comfortable writing code from scratch, you should at least be able to edit it.

I’m definitely in favor of a scholarship for journalist/programmers and programmer/journalists. I feel like some journalism students are afraid to learn code because it is associated with, or feels like, math. I’m no math genius, I never got past statistics, and the only math I’ve come across so far is adding up margins and padding in CSS and adding seconds for audio in ActionScript.

I may never be able to build anything as cool as chicagocrime.org. But I enjoy coding, in the same way that I enjoy writing. So scholarship or not, I’ll learn how to manipulate database information, build time lines and maps in Flash, and anything else that looks like a great way to spread information online.

Editing is not just proofreading

Last semester, I took Editing as part of my course load. It was less demanding than some of my other classes, and time limitations meant that I didn’t give the subject the attention it deserves. I tried to make up for that by taking Advanced Editing during this first half of the summer.

In the Editing class, the emphasis is on grammar, punctuation and word choice. The professor gave us articles to “fix.” Many of the errors were inconsistencies, fact errors, awkward wording and the like. We also did a little bit of page layout on dummy sheets, and cutting down AP wire stories. Less integral to the class, but more interesting, were topics of diversity, ageism, sexism, bias, ethics and taste.

These are the issues that we have discussed in the Advanced Editing class.

The advantage of this class is that it is very small, (at least in the summer, we had only 11 students) which allows for greater freedom of class discussion. The professor would hand out an article or case study and we would discuss the issues as a group. We talked about verifying sources, making up information, copying press releases, critical thinking and journalists and math.

Recognizing these issues and grasping the “big picture” behind a story is what being an editor is all about. But it’s also what being a reporter should be about.

Being an “online” kinda gal, I’d rather be out shooting video, making Flash presentations or putting together a database than managing people and editing articles. But the chance to discuss the issues that editors face everyday has been invaluable, and I think that my future work will be better because of it. These problems are not unique to print journalism. They need to be addressed in other forms of media as well.

Advanced Editing wasn’t a required course, it was a choice I made because every puzzle piece counts. If I could stay in school long enough to take courses in layout, photography and business, I would. Sadly, I’ve only got one year left. But until they kick me outta here, I’m going to scrape together as many puzzle pieces as I can. They will make me a better journalist, but even more importantly, I think they will make me a better person.

More Online Politics: Newspapers and Databases

I’m always on the lookout for different ways to keep track of the political realm. It is an area that is very hard to cover well, concentrating on the issues without getting caught up in the “who has more money.” I believe it is an area that newspaper have so far failed to cover well. So I turn to the Internet.

The Washington Post has a Campaign Tracker, which lists and maps the campaign events of the 2008 presidential candidates. For each candidate, it lists the state and city with the most events, as well as the top state for fund raising. You can see the results by candidate, date and state, and there’s also an RSS feed. This is a nice start, but its focusing on the least important aspects of the campaigns. I’d like to see the issues candidates represent, whether or not they are being consistent, what groups are they getting support from, and links to every article in which they are mentioned.

EDIT: Derek Willis of the Post pointed out that I totally missed the candidate profiles, finance filings, and primary information linked to the Campaign Tracker.

WashingtonWatch reveals the costs behind proposed U.S. federal legislation and regulation. The site also asks for comments, allows responses to a poll and allows Bill summaries to be edited. The cost of a bill is broken down into “cost per family” which makes it easier to digest. Just looking at some of those costs makes me wince.

I may just be getting cool enough for people to send me press releases, cause I got this in my inbox the other day from the Congresspedia Associate Managing Editor:

  • Get an early look at Congresspedia’s new legislative section

  • What’s McConnell Hiding?’ Win $500 for getting Sen. McConnell to answer on the record

  • LOUIS—a new database of documents from the Congressional Record, congressional bills and resolutions, congressional reports, congressional hearings, GAO reports, presidential papers and the Federal Register.

  • MAPLight.org federal money & politics search engine launched (so far only California and U.S. Congress)

  • Open House Project delivers recommendations to increase transparency on Capitol Hill

I really like some of these ideas: pinning politicians down, easy search of Congressional documents, following paper trails and shining a light on Capitol Hill are all great things to put out there. And not necessarily things I expect from my newspaper.

(i)Google Gadgets

Last year, productivity blog Lifehacker declared that MSN Autos had the best gas price comparison.

So what makes MSN so great? First, they use the Oil Price Information system which contains more data in almost real time compared to volunteer “spotter” based sites like GasBuddy.com. Second the gas prices at MSN were listed in order from least to most expensive, were the most expansive (in personal tests), and included an interactive map, as well.

I just got my driver’s license and a car, so now I care about finding the cheapest gas in town. I haven’t seen any further comparisons or analysis, so I’ll let that stand.

Which brings me to Local Gas Prices, a gadget for your Google homepage that uses MSN Autos to find the cheapest gas in your area. Granted, I still have to plug the addresses into Google Maps, but at least I can get an at-a-glance idea at how many hours I need to work this week.

This is definitely not the most exciting thing to come my way this week. But I stuck around for a while because I love finding ways to use information that’s already online. Why should I have to build a whole new database when I can yank from someone else’s? (Let’s not get started on the legal aspects of this, that’s a whole different blog post.) I’d love to see a newspaper Web site build something like this (maybe even a Facebook app?) and do it well: on a map.

Making Twitter Useful

As far as web geeks go, I may be a little anti-social. I visit Facebook once a week, at most. I don’t even bother with Myspace anymore unless someone else calls my attention there. I don’t have many photos to post to Flickr, I don’t usually recommend links via Del.icio.us (mostly because the people I’m networked with usually beat me to the link), Digg is no longer even an RSS feed and I post to Twitter only once every few days.

But I maintain these connections, cause you just never know.

For example, I’m a “twitter-follower” of the NYT. I get instant messages with links to new stories. I’ve found that this means I actually read them, instead of skipping over the headline and lede in Google Reader.

Last week, the Orlando Sentinel made an account with Twitter, and used it to track and update the launching of Atlantis. The best part is, they didn’t just “tweet” shuttle-related updates.

“Fours hours until launch and all anyone is talking about is Paris Hilton’s meltdown in court and her return to jail. Sigh.”

So having resisted Twitter, finally given in, and being a lukewarm user at best, why does this rock my socks?

Because I wasn’t within reach of TV or computer on Friday. I got those updates as text messages on my phone. And being addicted to being in the know, that just made my day.

The lesson here is that some weird and funky things take off in the online world. News outlets should join in the fun.

Coconut Grove Grapevine

cgsign

I grew up in Coconut Grove, and my parents still live there. It was a great place to grow up: very little traffic, winding streets, trees and bushes and the best neighbors a kid could ask for.

It wasn’t until recently that I started to pay attention to the adult world in the Grove. While looking for ways to keep up on my ‘hood, I found the Coconut Grove Grapevine.

I don’t have any idea who the blogger is, but I trust the source. Both of my parents are involved in local politics; the facts check out. I’m even pretty sure the blogger is someone they know. Another reassuring point is the amount of community interaction that goes on in the comments. Letters from commissioners and local bigwigs as well as outspoken Grovites have appeared. People I know, know of, or don’t know at all are talking back, adding information and opinion to the mix.

My parents kept me up-to-date on commissioner elections a while ago, but I was only getting their point of view. While the CGG blogger is clearly biased toward the Grove, not all commenters were of the same opinion. I enjoyed getting to see the different sides of issues that affect a place I love, even if I no longer call it home.

This blog is how I found out that my idyllic little oasis is in trouble. Over-development has been a problem everywhere is South Florida, but it never seemed to hit the Grove - until now. I cheered Grove residents on as they campaigned against Home Depot. I kept a close eye and crossed fingers over a project that would allow more condos to be built on the water, obstructing the view and adding unwanted traffic. The Grove lost both wars.

While the Grapevine focuses on politics, I’ve also seen announcements for local festivals and even a “Paris Hilton goes to Jail party.”

For anyone trying to figure out what hyper-local is, this is it. Coconut Grove is a tiny area in big, busy Miami, and is often overlooked by television and print news. This blog doesn’t just keep me in the know, it makes me feel like I’m still a part of the community.

From Newsies.Gainesville.com

Combination personality profile/how to? This one needed a little more work.

Gainesville resident finds a hobby in blogging, by Megan Taylor.

Valedictorians and Graduations

My little sister just graduated from high school, and I’m recovering from taking the time from work and class to attend the ceremony.

Interesting tidbit: No more valedictorians. Dade County schools (possibly others, too) are switching to a cum laude system to keep schemers from getting the honor without earning it. The class speakers for graduations will be elected.