Twitter and some statistics

Two and a bit months ago, I started archiving my friends timeline on Twitter into a SQLite database for posterity (I didn’t really like the idea that it just vanishes after a while).

It then occurred to me earlier that I didn’t actually know how many tweets I read in two months… the answer appears to be over 40,000.

Posting this fact on twitter, the first reply I got was “how many are about sandwiches?” to which the answer is 39. Wow. What wonders 🙂

I thought about the only useful thing I could probably do in the short term was make a pretty graph of the rate of tweet flying past my friends timeline per day… so here it is:


Raw data

Other interesting facts:

  • @TelegraphNews accounts for 6% of the throughput
  • 62 tweets contain the word “argh”
  • 350 mentioned “facebook”

I may get around to thinking up new and more interesting stuff to do with this data later… maybe 🙂

UPDATE:

tweet word cloud