My Twitter archive

I’ve finally been able to download my tweet archive from Twitter. I’m really impressed with how they’ve made the data browsable and easy to explore. Here are my first tweets from January 2007:

My tweets from January 2007

Fascinating, no? You can also see some account details, which informed me that I am user ID #703,673 and that I joined on 25 Jan 2007, 8:53:08 PM (UTC).

You can get your own tweets (if they are available to you) via your settings at twitter.com/settings/account.

Along with the browsable HTML pages you also get your data in CSV and JSON formats. The CSV data looks like this.

"tweet_id","in_reply_to_status_id","in_reply_to_user_id","retweeted_status_id","retweeted_status_user_id","timestamp","source","text","expanded_urls"
"371896042","","","","","2007-10-29 06:09:46 +0000","<a href=""http://www.tweet-r.com/"" rel=""nofollow"">Tweetr</a>","Shit! I just got up an hour early!"
"371015222","","","","","2007-10-28 21:34:50 +0000","<a href=""http://www.tweet-r.com/"" rel=""nofollow"">Tweetr</a>","There is something oddly satisfying about nicely tabulated code..."
"370899332","","","","","2007-10-28 20:15:35 +0000","<a href=""http://www.tweet-r.com/"" rel=""nofollow"">Tweetr</a>","The opening credits to Dexter make me hungry!"
"370797522","","","","","2007-10-28 19:11:20 +0000","<a href=""http://www.tweet-r.com/"" rel=""nofollow"">Tweetr</a>","Giving Flock another look see, now I use more social sites."
"369444592","","","","","2007-10-28 03:31:53 +0000","<a href=""http://www.tweet-r.com/"" rel=""nofollow"">Tweetr</a>","Playing with Yahoo Pipes. I probably shouldn't get into something like this at 3.30am!"
"340847092","","","","","2007-10-16 22:03:38 +0000","<a href=""http://www.tweet-r.com/"" rel=""nofollow"">Tweetr</a>","What shall I pay for the Radiohead album?"
"340754942","","","","","2007-10-16 21:13:55 +0000","<a href=""http://www.tweet-r.com/"" rel=""nofollow"">Tweetr</a>","Twitters, please help! Does anyone have an MP3 of the new Jonathan Coulton track from Portal, ""Still Alive""? Please share. I have cake..."
"331442672","","","","","2007-10-12 19:08:01 +0000","<a href=""http://www.tweet-r.com/"" rel=""nofollow"">Tweetr</a>","Is it wrong that I think my new surge protector looks sexy?"

If you’re wondering what you could do with all this data, take a look at ThinkUp – the last I heard they were working on an importer.

About these ads

2 thoughts on “My Twitter archive

  1. You should try ThinkUp.com it is a free, open source web application that captures all your activity on social networks like Twitter, Facebook, Google+ and Foursquare.

Comments are closed.