{"id":980,"date":"2009-05-16T00:38:00","date_gmt":"2009-05-16T07:38:00","guid":{"rendered":"https:\/\/www.curtiscchen.com\/journal\/2009\/05\/16\/twitterage\/"},"modified":"2009-05-16T00:38:00","modified_gmt":"2009-05-16T07:38:00","slug":"twitterage","status":"publish","type":"post","link":"https:\/\/www.curtiscchen.com\/journal\/2009\/05\/16\/twitterage\/","title":{"rendered":"Twitterage"},"content":{"rendered":"<p>On Thursday and Friday, I was an extra (background performer) for episode 204 of <span style=\"font-style: italic;\">Leverage<\/span>, which is shooting their second season in Portland.<span style=\"color: rgb(204, 0, 0);\">*<\/span>  Since there&#8217;s a lot of waiting around during each day, I thought it would be fun to Twitter a few <a href=\"http:\/\/search.twitter.com\/search?q=sparckl+leverage\">interesting, spoiler-free remarks<\/a> about my experience.<\/p>\n<p>That worked out pretty well, and tonight I decided to reformat and post those tweets in a more permanent location and a more readable format.  I discovered that no single application exists to do what I want, which is to export a specific subset of my status messages and conversations.  (C&#8217;mon, Interwebs, <span style=\"font-style: italic;\">this<\/span> is the one time you don&#8217;t anticipate my needs?  We need to talk.)<\/p>\n<p><a href=\"http:\/\/search.twitter.com\/\">Twitter&#8217;s search interface<\/a> only exports to a noisy XML feed, and what I really wanted was a simple, denormalized CSV data file which I could slice and dice manually.  I found three web apps that claim to do this:<\/p>\n<ol>\n<li><a href=\"http:\/\/bradkellett.com\/experiments\/tweetdumpr\/\">TweetDumpr<\/a> only exports status messages (without timestamps) to a flat text file.<\/li>\n<li><a href=\"http:\/\/twickie.pirillo.com\/\">Twickie<\/a> offers several formatting options, but the &#8220;Get CSV&#8221; link doesn&#8217;t work.<\/li>\n<li><a href=\"http:\/\/tweetake.com\/\">Tweetake<\/a> is the one that actually worked, but it didn&#8217;t provide many filtering options.<\/li>\n<\/ol>\n<p>Of course, Twitter&#8217;s own filtering abilities are pretty limited.  What I really wanted was a custom timeline including all tweets which:<\/p>\n<ul>\n<li>were posted by me <span style=\"font-weight: bold;\">and<\/span><\/li>\n<li>were posted within a specific time window <span style=\"font-weight: bold;\">and<\/span><\/li>\n<li>include the hashtag #Leverage <span style=\"font-weight: bold;\">and<\/span><\/li>\n<li>include one of the hashtags #extra <span style=\"font-weight: bold;\">or<\/span> #extras; <span style=\"font-weight: bold;\">or<\/span><\/li>\n<li>are part of a conversation (replies, retweets, <span style=\"font-style: italic;\">etc.<\/span>) linked to any tweets matching the above criteria.<\/li>\n<\/ul>\n<p>I guess I&#8217;ll be digging into the <a href=\"http:\/\/apiwiki.twitter.com\/\">Twitter API<\/a> later.<\/p>\n<p>For now, you can see the crappy Excel HTML dump of my tweets from <a href=\"http:\/\/malum-iter.com\/tweetake-leverage-days1n2.htm\">two days of being a #Leverage 204 #extra<\/a>.  Note that all times are GMT; subtract seven hours to get local time in PDX.<\/p>\n<p>And yes, I still refuse to use the unreadable abomination that is LoudTwitter.<\/p>\n<p>~CKL<\/p>\n<p><span style=\"color: rgb(204, 0, 0);\">*<\/span> <small>You can be an extra too!  <a href=\"http:\/\/castingscoop.blogspot.com\/2009\/04\/sign-up-now-to-be-extra-on-tnts.html\">Here&#8217;s how.<\/a><\/small><\/p>\n","protected":false},"excerpt":{"rendered":"<p>On Thursday and Friday, I was an extra (background performer) for episode 204 of Leverage, which is shooting their second season in Portland.* Since there&#8217;s a lot of waiting around during each day, I thought it would be fun to&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_share_on_mastodon":"0"},"categories":[32,56],"tags":[],"class_list":["post-980","post","type-post","status-publish","format-standard","hentry","category-sci-tech","category-tv"],"share_on_mastodon":{"url":"","error":""},"_links":{"self":[{"href":"https:\/\/www.curtiscchen.com\/journal\/wp-json\/wp\/v2\/posts\/980","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.curtiscchen.com\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.curtiscchen.com\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.curtiscchen.com\/journal\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.curtiscchen.com\/journal\/wp-json\/wp\/v2\/comments?post=980"}],"version-history":[{"count":0,"href":"https:\/\/www.curtiscchen.com\/journal\/wp-json\/wp\/v2\/posts\/980\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.curtiscchen.com\/journal\/wp-json\/wp\/v2\/media?parent=980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.curtiscchen.com\/journal\/wp-json\/wp\/v2\/categories?post=980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.curtiscchen.com\/journal\/wp-json\/wp\/v2\/tags?post=980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}