Recent posts

Charting Tweets At #UNITY12

Last week I attended the UNITY journalism conference in Las Vegas, and during my stay I ingested more than 9,000 tweets that had the #UNITY12 hashtag. This line chart shows how the traffic ebbed and flowed each day:

As of dinnertime Saturday, when I stopped collecting the tweets, these attendees were the most prolific users of the hashtag: @NABJDigital (164 tweets), @sandhyadirks (136), @emmacarew (118), @joshstoffregen (102), @VictoriaLim (98), @DorisTruong (88), @webjournalist (77), @L2theS2theV (75), @barbaradozetos (70), @cecepmarshall (69).

Download the data, and let me know what you find.

Ranking TechRaking Tweets

Dozens of technologists and journalists today descended on Google’s beautiful Mountain View, Calif., campus for a discussion about technology and journalism. The conference, organized by the Center for Investigative Reporting, led to some prolific tweeting, as one might expect.

I used a simple script to ingest the 1,500-plus tweets with the search API into a sqlite database. This chart, made with Google Docs’ chart tools (when in Rome…), shows the top 25 most prolific tweeters (as of 4:30 p.m. pacific) who used the #techraking and #techrakingcir hash tags.

Congrats, Ian Hill, you top the list (which includes, I think, some spammers):

This is just a quick chart made in a rush. Feel free to download and check out the pipe-delimited data for yourself: #techraking | #techrakingcir. Send me your visualizations or thoughts, and I’ll post ‘em here. See the full list of Twitter user counts here.

Use Calendar Heat Maps to Visualize Your Tweets Over Time

Following Nathan Yau’s excellent tutorial for creating heat maps with time series data (he used vehicle accidents by day for a year), I visualized 3,559 of my tweets back to March 2009.

These maps, created with a modified R script from the tutorial, show how often I sent tweets (both personal and RT), with darker shades representing more activity. It’s fun to go back to the dark days and recall what sparked flurries of tweets:

The Sentiment on Bill Keller (Updated)

Reaction to New York Times editor Bill Keller’s recent piece about Twitter appears to be mixed — at least according to a quick sentiment analysis of related tweets. 


Excellent piece


Must you always nay say, @nytkeller?

Here’s how this application charted recent tweets mention Keller: 

UPDATE (10 a.m. Monday): Since the publication in the print edition of the magazine, it seems reaction is much more positive: 

Charting Twitter Stats

One hundred is the new 140 on Twitter, according to my wife. How am I doing? My tweets since August 2009: 

Tweets: 1523. Average tweet: 89 characters.

Longest tweet:

RT @KenLegler: MERRYº°¨¨°º¤ø °¨¨°º¤ø ¸„ø¤º°¨¨°º¤ø¸CHRISTMAS¤ø ¸„ø¤º°¨¨°º¤ø ø¤º°¨¨¨°º¤ø ¸„ø¤MERRYº°¨¨°º¤ø ¸„ø¤º°¨¨°º¤Ã

Shortest tweet: