Sunday, January 1, 2023

Twitter Archive Wrap-up

The previous three posts have all my Twitter activity from 2008-9, 2010, and 2011.  Not all of the tweets have to do with It's Pub Night or with beer, but the Twitter account is mostly an extension of the blog.  It's not a place where I interact with family or work colleagues, and not very seriously with the few friends who are connected on Twitter.

This post has links to what I tweeted and analyzes when, who, where, and how I tweeted.  The only unanswered question is WHY?

When I was actively blogging, I got very annoyed by blogs that were more about blogging than about their supposed subjects.  I'm not sure how I would have reacted to these posts which just hash and rehash blogging and tweeting done years ago.  In my defense, one reason I started a blog was to document the current moment, for the benefit of readers in the future, and this furthers that ideal.  I will put the tweet archives for 2012-2022 on separate pages to keep them out of the blog post stream. 

Here are all the posts and pages with the complete tweet history, up until late November 2022 when I requested the archive from Twitter.

It's been fun to look over the Twitter archive and remember what was happening 10-15 years ago.  While extracting, timestamping, linkifying, and ordering the tweets, I gathered some statistics about them that may or may not be interesting.


I was never a very prolific tweeter, and it has really fallen off in recent years.  The archive I downloaded contains 9230 total tweets.  Here are the yearly totals:

  • 2008: 25
  • 2009: 797
  • 2010: 1347
  • 2011: 1847
  • 2012: 1333
  • 2013: 1092
  • 2014: 723
  • 2015: 307
  • 2016: 357
  • 2017: 526
  • 2018: 342
  • 2019: 141
  • 2020: 157
  • 2021: 146
  • 2022: 89
You might attribute the recent dearth to the pandemic, but the downward trend began in 2012 and was obvious by 2014.  Looking through the archive, there is a single tweet with the word "covid" in it, and that is a re-tweet of someone else.  Mainly, Twitter became less fun as more politicians and celebrities joined, and as the company tweaked their algorithms in ways that disfavored quirky occasional posters like myself.  There were fewer local fun people to interact with.  I don't think we were shadowbanned, but the effect of the algorithms was the same.

1555 of the tweets seem to be retweets, though in the early days you might add RT to a piece of original art to pretend to have a conversation with someone like Barack Obama or your friend Wallace, like:

Friday July 25, 2014 05:02 PM

  RT @BarackObama Thanks dude! RT @halfbipolar 9:15 RT @BarackObama Hey @halfbipolar What time does pillowfight play at the Hawthorne Theater?

Actually I can't remember if I started that or if Wallace did.  Anyway, some of the statistics below could be skewed a little by retweets, though the big picture is accurate.

More pictures start appearing in tweets in mid-2012, and become more common as time goes on.  There were pictures in tweets before then, but often had to be hosted on a different site like twitpic.


Another fun thing about this project was to look back at who the beer Twitter/Portland Twitter characters were at that time.  Some are still active; some have lost interest or quit drinking; some I now realize I did not know at all and have no way to begin tracking them down.  A few have passed away and are dearly missed.

In the early days you could make IRL friends that you first met on Twitter.  I don't think that happens much anymore, thanks to the algorithms.

All told, I mentioned or replied to or retweeted 1131 unique user IDs.  I mentioned my wife once, and each daughter three times.  I wasn't connected on Twitter to any other family members, and absolutely no one at work.  Here are the top people I tweeted to or mentioned in tweets:

  • SamuraiArtist: 589
  • Beervana: 268
  • jwall4: 144
  • AGSHender: 143
  • UrbanBeerHiker: 143
  • NewSchoolBeer: 136
  • JfwellsPDX: 122
  • itspubnight: 118
  • brewpublic: 115
  • HumuloneRed: 115
  • socialretard: 113
  • ConOat: 112
  • beerinator: 101
  • TracyTThomas: 95
  • turbodog: 92
  • SnobRitch: 91
  • Notteham: 83
  • bikeportland: 72
  • rojasburke: 71
  • TheBeermongers: 66

Man I miss UrbanBeerHiker.  Though I did see him 4 years ago, about a year or so after he ditched Twitter.


At first most of my tweets were done via text message, which was actually a pretty common way to tweet back then, if you recall.  I would also get text messages if someone mentioned me, or if selected people tweeted anything.  It took a while before I sent a few pictures to Twitter via text message.  Here are the various ways my tweets arrived on the platform:

  • Yoono (2010-2014): 3141
  • Twitter Web Client (2008-2018): 1922
    • Plus 19 tweets from Twitter "Mobile Web"
    • Plus 70 tweets from "Twitter Web App" -- how is this different?
      • 54 of those are from 2022 after TweetCaster stopped working
  • TweetCaster for Android (2014-2022): 1832
  • Twitter SMS (2008-2015): 1505
    • Plus 98 "MMS" tweets (picture attached)
    • Also 3 text tweets while I was at a show at Dante's in 2016 (???)
    • Also 1 text tweet in 2018 from a plane on the runway in India
  • Echofon (2010-2011): 463
  • Twitpic (2010-2012): 81
  • Instagram (2017-2018): 43
  • (2009-2011): 28
  • twitterfeed (2009-2010): 12
    • Supposed to automate tweeting of new blog posts, but more work than simply tweeting them myself.
  • Twitter for Android (2014, 2022): 6
  • Twitter for Websites (2011, 2013-2014): 6

About 17% of my tweets were via text message.  Another 22% were typed into the Twitter webpage. In 2010 I discovered browser plugins that made reading and posting to Twitter better:  first Echofon, then yoono.  40% of my tweets were with these plugins, and now I can't remember a thing about how I used them.  In 2014 I got my first smartphone, and quickly discovered that third-party apps are much better than Twitter's own app:  1) no advertisements or promoted tweets; 2) they give you the tweets in order, not according to Twitter's stupid algorithms; 3) you can temporarily mute people or subjects.  I used TweetCaster for about 20% of my tweets until it abruptly stopped working in 2022.


I am not a great hashtagger.  There are less than 500 hashtags in my tweets, and 158 were from trying to cross-post to Facebook without having to log onto it.  Another 48 were from the #ontappdx days of Taplister, back when Twitter was about more than Twitter.  Here are my top 20 hashtags:

  • fb: 158
  • OBF: 50
  • ontappdx: 48
  • PDX: 43
  • gabf: 41
  • freshhop: 38
  • craftbeer: 29
  • pdxbeer: 28
  • pedalpalooza: 25
  • BBC11: 21
  • beer: 15
  • ff: 15
  • SundayParkways: 15
  • SBWF: 14
  • freshhops: 13
  • haf2011: 13
  • pdxbeergeeks: 10
  • hrhops12: 8
  • rimshot: 8
  • sampletraystunt: 8


Below is the list of sites I linked to the most on Twitter.  A lot of the links in my tweets are obscured by link shorteners.  For this list, I replaced as many of them as possible with the true targets, though that is heavily skewed towards posts on itself.  The and shorteners are defunct, so those 63 links are not knowable.  Some and links couldn't be found for some reason, or maybe they pointed to other or URLs (my process of tracing the links is not exhaustive).  The links are often modern quote tweets, not real interesting links.  Still, the list gives you a pretty good picture of where I linked to:

  • 603
  • 585
  • 311
  • 146
  • 62
  • 53
  • 50
  • 39
  • 38
  • 24
  • 17
  • 16
  • 15
  • 15
  • 15
  • 14
  • 13
  • 10
  • 10
  • 9
  • 8
  • 7
  • 7
  • 7
  • 7
  • 7
  • 7
  • 6
  • 6
  • 6
  • 6
  • 6
  • 6
  • 5
  • 5
  • 5
  • 5
  • 5
  • 5

Preserving History

This exercise seems like a way to further the historical preservation goal mentioned at the beginning of this post.  It also shows how fragile documents can be, even in the Internet age.  For a while I used a link shortener called, which seemed really cool because you could make custom links like "", but it went offline at some point and took all the links with it.  Even if a shortened link still exists, the website it points to may be gone, or may have reorganized their content. Some links to new It's Pub Night posts now fail, though others succeed. Other information is lost when tweets are replies to someone else's tweet, but Twitter can't find the original.  Everything can combine to leave tantalizing mysteries like:

Thursday October 15, 2009 10:40 AM

  @rpFactotum That's awesome and too bad at the same time. Happened last night?

The username "@rpFactotum" is no longer valid on Twitter, the tweet being replied to can't be found, and the link points to content that has vanished or been renamed.  Wish I knew what this bad awesome thing was that happened the night of Oct. 14, 2009.

I fixed whatever broken links in these tweets pointed back into It's Pub Night.  In terms of broken links in the blog itself, if you're lucky the Wayback Machine will have preserved the original links.  For example, San Francisco vs. Portland from 2010 links to two paintings in the SFMOMA collection which are uniform gray rectangles, but now in 2023 the links are broken.  The archived page at the Wayback Machine has links that correctly point to an archived version of the museum website, so you can see what I was carping about.  With that in mind, here are snapshots of It's Pub Night for the busiest years, so that hopefully you could navigate to links which are broken today:

Just before I requested the archive in November 2022, and days before the new Twitter owner posted his infamous pair of polls, I posted my first Twitter poll.  The text of the tweet is in the archive, but not the poll choices or results.  Since the poll was about this anniversary, I'll put a picture of it here (sadly I got the anniversary date wrong).  As a measure of how brutal the Twitter algorithms are, my poll only got 15 responses.  I realize not all followers are real or active, and lots of people are discouraged by Twitter right now, but interaction from 1% of followers tells me I've been put on a shelf.  I had to beg for some of the votes even.


  1. Good to see that I could beat @socialretard at something. He is a hell of a pool and dart player. Cheers! Miss you, too!

  2. @ubh Those were some fun times. Hope we intersect in the real world again soon.


Thanks for leaving a comment! I will delete spam and long stupid comments. Comments that are smart or short will survive.

Please tag anonymous comments with your name, initials, or CB handle so that people can respond to you.