shibafu528/filter.rb Secret

## filter.rb
require 'csv'

clients = {}
records = []

Record = Struct.new(:id, :timestamp, :src)

CSV.foreach('tweets.csv', headers: true) do |r|
  id = r['tweet_id']
  ts = r['timestamp']
  src = r['source'].gsub(/^(?:<a href=".*" rel="nofollow">)?(.*)(?:<\/a>)$?/, '\1')
  records << Record.new(id, ts, src)
end

puts "| Source | Timestamp |"
puts "|--------|-----------|"

records.reverse.each do |record|
  unless clients.has_key? record.src
    puts "| #{record.src} | #{record.timestamp} |"
    clients[record.src] = 1
  end
end

## result.md

      
    Raw
  

              result.md
            
          
Source
Timestamp


Twitter Web Client
2009-03-24 00:00:00 +0000


twksr
2009-10-06 00:00:00 +0000


Seesmic Look
2010-01-23 00:00:00 +0000


Twit for Windows
2010-09-01 00:00:00 +0000


ニコニコ生放送
2010-09-01 00:00:00 +0000


erased63316
2010-11-03 00:00:00 +0000


Twitpic
2010-11-14 03:31:33 +0000


P3:PeraPeraPrv
2011-06-09 11:38:31 +0000


みについ
2011-06-10 11:47:36 +0000


Twitter for Websites
2011-11-30 13:08:16 +0000


Ustream.TV
2012-01-10 12:23:02 +0000


トルネ
2012-02-07 14:40:59 +0000


twicca
2012-03-03 11:21:50 +0000


Ubuntu
2012-05-21 12:23:42 +0000


niconico ニコレポ連携
2012-06-11 11:51:08 +0000


Apricot
2012-07-19 09:03:26 +0000


ShootingStar
2012-07-19 22:51:04 +0000


Thunderbird Chat
2012-08-29 11:24:36 +0000


週刊トロ・ステーション
2012-08-31 23:00:27 +0000


TweetCaster for Android
2012-09-14 12:53:52 +0000


かんたん画像付きツイートツール for ニンテンドー3DS
2012-11-15 12:11:55 +0000


Janetter
2012-11-23 00:54:12 +0000


Mobile Web
2012-11-23 22:16:26 +0000


2014's fortune by 2013's tweets
2013-01-01 10:23:50 +0000


Twitter for Android
2013-01-07 02:28:20 +0000


ニコニコニュース
2013-01-13 04:01:40 +0000


Togetter
2013-01-21 04:10:15 +0000


KrileⅡ
2013-02-10 03:37:48 +0000


mikutter
2013-02-17 08:29:47 +0000


ツイッターするやつ
2013-02-18 10:13:50 +0000


Twitter for Windows
2013-03-14 10:15:15 +0000


SmileEssence Lite
2013-04-08 14:26:09 +0000


Google
2013-04-13 19:08:49 +0000


Gunosy
2013-04-18 22:49:42 +0000


TwitCasting
2013-04-28 12:49:46 +0000


Mobile Web (M2)
2013-05-12 07:43:25 +0000


Cytus
2013-05-18 07:11:01 +0000


ニンテンドー3DS画像投稿ツール
2013-05-26 04:51:16 +0000


Foursquare
2013-06-01 01:13:32 +0000


twimaker
2013-06-05 14:57:18 +0000


Sleep as Android
2013-06-07 22:05:12 +0000


おいでよ パクツイの森
2013-06-13 14:25:55 +0000


erased1064506
2013-06-14 12:11:44 +0000


ツイッターするやつα
2013-06-14 12:20:04 +0000


Instagram
2013-06-15 19:44:49 +0000


ShareTwit for WindowsRT
2013-06-18 11:53:24 +0000


erased2950029
2013-06-22 23:02:11 +0000


feedly
2013-06-23 08:46:46 +0000


MeteorLine
2013-06-24 14:53:27 +0000


jigtwi
2013-06-26 14:47:53 +0000


erased1023935
2013-06-26 15:24:34 +0000


erased1687507
2013-06-27 16:20:55 +0000


twittbot.net
2013-07-08 13:50:11 +0000


メガネケエス
2013-07-09 09:51:54 +0000


twicca multi image plugin
2013-07-10 13:02:24 +0000


Twitter試験
2013-07-13 02:37:44 +0000


診断ティキット
2013-07-19 11:12:18 +0000


Krile2 (g)
2013-07-20 08:44:59 +0000


ｵｽﾄﾝｲﾝゲーム for Android
2013-07-20 21:59:32 +0000


メガネケエスRT
2013-07-23 01:01:35 +0000


Biyon≡(　ε:)
2013-07-29 16:00:18 +0000


これ聴いてるんだからねっ！ Advanced
2013-08-01 03:12:58 +0000


Yukari for Android
2013-08-02 05:51:43 +0000


バルス祭り
2013-08-02 12:11:29 +0000


艦メモ
2013-08-18 09:50:18 +0000


MetroTwit
2013-08-21 05:47:01 +0000


SobaCha
2013-08-23 08:14:49 +0000


最高の夏ジェネレーター
2013-08-30 13:47:22 +0000


installNow
2013-08-30 22:51:38 +0000


ShootingStar for API1.1
2013-09-10 12:03:44 +0000


erased855801
2013-09-10 12:19:32 +0000


iconDecotter　
2013-09-29 09:11:47 +0000


おひるねサークル
2013-10-26 00:40:17 +0000


StarryEyes (g)
2013-10-31 12:09:01 +0000


ツイッターしないやつ.
2013-11-10 14:57:25 +0000


Twidere for Android #2
2013-11-30 05:09:36 +0000


Justaway for Android
2013-12-26 15:03:15 +0000


Rebootter
2013-12-26 16:00:10 +0000


ギガネケエス
2013-12-28 10:11:35 +0000


ついっぷる　
2013-12-30 16:06:53 +0000


DeemoRayark
2014-01-18 09:28:38 +0000


大破～ん
2014-01-22 12:30:05 +0000


Ask.fm
2014-01-25 13:14:32 +0000


Saezuri
2014-01-29 11:58:37 +0000


hamoooooon
2014-02-04 04:19:43 +0000


update_color.rb
2014-02-21 16:54:53 +0000


Cerisier
2014-02-28 04:05:11 +0000


Shrimp　
2014-03-01 04:49:37 +0000


今日、誰と一緒に食べる？
2014-03-03 17:22:45 +0000


Geso for Android
2014-03-15 19:04:50 +0000


JavatterFX
2014-03-16 12:08:45 +0000


流星
2014-03-19 23:03:49 +0000


ｱｶｲﾄﾘ4
2014-03-20 13:15:08 +0000


MakiMaki for Android
2014-03-30 13:06:47 +0000


Sleeping( ˘ω˘)Syar
2014-03-30 21:46:52 +0000


ぐへへ～(＾p＾)
2014-04-03 18:18:33 +0000


Mo-Footer_API_v4
2014-04-08 07:36:54 +0000


Mevy
2014-04-11 10:33:33 +0000


OrangeSphere
2014-04-12 15:22:27 +0000


Javaビーム工房
2014-04-19 09:41:57 +0000


Twitter for Android Tablets
2014-04-20 22:43:35 +0000


... 三乁□_ wwwwwww
2014-04-27 00:47:23 +0000


GenTwoo
2014-05-05 23:43:18 +0000


eAMUSEMENT
2014-05-09 04:22:04 +0000


Twitter
2014-05-09 11:30:03 +0000


TweetDeck
2014-05-15 12:50:33 +0000


TwitPane for Android
2014-05-31 10:29:06 +0000


SmileEssence
2014-05-31 11:25:21 +0000


GitHub Service Hooks
2014-05-31 17:39:25 +0000


Vine for Android
2014-06-01 08:47:52 +0000


feedly cloud
2014-06-02 22:22:55 +0000


ねぴぁのおしり
2014-06-14 13:33:47 +0000


ブクログ(booklog.jp)
2014-06-27 10:08:13 +0000


Dropbox 
2014-06-28 15:34:35 +0000


TwitDuke
2014-07-10 15:22:01 +0000


kb10uy experimental
2014-07-15 09:04:56 +0000


Yukari for Desktop
2014-07-15 14:47:52 +0000


Asfc for ICS+
2014-07-27 00:07:17 +0000


Geso2
2014-08-25 22:46:13 +0000


connpass
2014-08-30 10:14:22 +0000


ツイタマ for Android
2014-09-06 07:15:16 +0000


ツイッターするやつγ
2014-09-19 17:58:38 +0000


#TwitADex
2014-11-02 12:31:31 +0000


Twittnuker
2014-11-29 23:24:15 +0000


Giza for Android
2014-11-30 09:57:25 +0000


オナ禁タイマー for Android
2014-12-05 18:55:31 +0000


Biyon Lite ≡(　ε:)
2015-01-02 06:05:48 +0000


Solid Worker
2015-01-05 07:19:45 +0000


東京アニメアワードフェスティバル2017 アニメファン投票！
2015-01-08 04:18:48 +0000


ジェネジェネ
2015-01-10 13:20:26 +0000


心拍数ツイート
2015-01-13 13:10:46 +0000


Twitwear
2015-01-25 11:54:35 +0000


Krile StarryEyes
2015-01-31 12:23:44 +0000


radiko.jp for Android
2015-01-31 15:01:57 +0000


OrangeSphere Next
2015-02-06 22:47:06 +0000


REFLEC BEAT 悠久のリフレシア AC
2015-03-24 07:44:13 +0000


Yukari +C
2015-03-26 01:07:48 +0000


Kottolin
2015-04-25 05:51:41 +0000


なでなで目覚まし かのん
2015-04-25 12:40:58 +0000


ついったーたのしいです(^o^)
2015-05-10 12:14:53 +0000


Mobile Music Game - Dynamix
2015-05-23 12:26:05 +0000


社畜ちゃん台詞メーカー
2015-05-24 13:40:33 +0000


Kotoura for Android
2015-05-30 07:54:58 +0000


Tumblr
2015-06-18 14:26:19 +0000


ツイッターするやつγ pro
2015-06-25 10:47:18 +0000


Absolutter
2015-07-11 05:36:09 +0000


Bitbucket Service Broker
2015-07-19 12:37:37 +0000


結月ゆかりのまな板に頬ずりｽﾘｽﾘｽﾘｽﾘｨ!!!!!
2015-07-19 15:53:38 +0000


Aristea
2015-08-01 15:32:39 +0000


erased7861122
2015-08-04 13:16:13 +0000


beeter (β)
2015-09-18 23:45:12 +0000


Tencocoa
2015-09-20 17:45:26 +0000


twitcle plus
2015-09-22 13:12:56 +0000


feather Android
2015-09-30 13:00:17 +0000


PlayStation®Vita
2015-11-03 08:23:39 +0000


Twidere for Android #4
2015-11-21 00:39:06 +0000


Twitter for Windows Phone
2015-12-08 03:39:57 +0000


メガネケエスWP
2015-12-08 15:56:31 +0000


Krile for Windows Phone
2015-12-09 15:59:40 +0000


除夜のEject
2015-12-31 12:27:35 +0000


notepadたんちゅっちゅ
2016-01-14 15:03:30 +0000


Flantter
2016-02-19 12:28:20 +0000


うさぎは性欲が強い→結月ゆかり→あっ(察し)
2016-03-09 03:23:04 +0000


Abs  for Android
2016-05-19 03:36:41 +0000


niconico ニコニコ動画
2016-08-28 10:45:10 +0000


みみず銀行
2016-10-02 06:58:41 +0000


NewSuperHookGirl
2016-10-10 13:14:11 +0000


PlayStation(R)4
2016-11-05 05:50:29 +0000


tw-rubygem
2016-11-19 13:01:44 +0000


TwitPanePlus for Android
2017-01-07 13:31:13 +0000


MateCha
2017-02-19 06:13:06 +0000


Nintendo Switch Share
2017-03-03 14:57:43 +0000
	require 'csv'

	clients = {}
	records = []

	Record = Struct.new(:id, :timestamp, :src)

	CSV.foreach('tweets.csv', headers: true) do \|r\|
	id = r['tweet_id']
	ts = r['timestamp']
	src = r['source'].gsub(/^(?:<a href="." rel="nofollow">)?(.)(?:<\/a>)$?/, '\1')
	records << Record.new(id, ts, src)
	end

	puts "\| Source \| Timestamp \|"
	puts "\|--------\|-----------\|"

	records.reverse.each do \|record\|
	unless clients.has_key? record.src
	puts "\| #{record.src} \| #{record.timestamp} \|"
	clients[record.src] = 1
	end
	end
Source	Timestamp
Twitter Web Client	2009-03-24 00:00:00 +0000
twksr	2009-10-06 00:00:00 +0000
Seesmic Look	2010-01-23 00:00:00 +0000
Twit for Windows	2010-09-01 00:00:00 +0000
ニコニコ生放送	2010-09-01 00:00:00 +0000
erased63316	2010-11-03 00:00:00 +0000
Twitpic	2010-11-14 03:31:33 +0000
P3:PeraPeraPrv	2011-06-09 11:38:31 +0000
みについ	2011-06-10 11:47:36 +0000
Twitter for Websites	2011-11-30 13:08:16 +0000
Ustream.TV	2012-01-10 12:23:02 +0000
トルネ	2012-02-07 14:40:59 +0000
twicca	2012-03-03 11:21:50 +0000
Ubuntu	2012-05-21 12:23:42 +0000
niconico ニコレポ連携	2012-06-11 11:51:08 +0000
Apricot	2012-07-19 09:03:26 +0000
ShootingStar	2012-07-19 22:51:04 +0000
Thunderbird Chat	2012-08-29 11:24:36 +0000
週刊トロ・ステーション	2012-08-31 23:00:27 +0000
TweetCaster for Android	2012-09-14 12:53:52 +0000
かんたん画像付きツイートツール for ニンテンドー3DS	2012-11-15 12:11:55 +0000
Janetter	2012-11-23 00:54:12 +0000
Mobile Web	2012-11-23 22:16:26 +0000
2014's fortune by 2013's tweets	2013-01-01 10:23:50 +0000
Twitter for Android	2013-01-07 02:28:20 +0000
ニコニコニュース	2013-01-13 04:01:40 +0000
Togetter	2013-01-21 04:10:15 +0000
KrileⅡ	2013-02-10 03:37:48 +0000
mikutter	2013-02-17 08:29:47 +0000
ツイッターするやつ	2013-02-18 10:13:50 +0000
Twitter for Windows	2013-03-14 10:15:15 +0000
SmileEssence Lite	2013-04-08 14:26:09 +0000
Google	2013-04-13 19:08:49 +0000
Gunosy	2013-04-18 22:49:42 +0000
TwitCasting	2013-04-28 12:49:46 +0000
Mobile Web (M2)	2013-05-12 07:43:25 +0000
Cytus	2013-05-18 07:11:01 +0000
ニンテンドー3DS画像投稿ツール	2013-05-26 04:51:16 +0000
Foursquare	2013-06-01 01:13:32 +0000
twimaker	2013-06-05 14:57:18 +0000
Sleep as Android	2013-06-07 22:05:12 +0000
おいでよパクツイの森	2013-06-13 14:25:55 +0000
erased1064506	2013-06-14 12:11:44 +0000
ツイッターするやつα	2013-06-14 12:20:04 +0000
Instagram	2013-06-15 19:44:49 +0000
ShareTwit for WindowsRT	2013-06-18 11:53:24 +0000
erased2950029	2013-06-22 23:02:11 +0000
feedly	2013-06-23 08:46:46 +0000
MeteorLine	2013-06-24 14:53:27 +0000
jigtwi	2013-06-26 14:47:53 +0000
erased1023935	2013-06-26 15:24:34 +0000
erased1687507	2013-06-27 16:20:55 +0000
twittbot.net	2013-07-08 13:50:11 +0000
メガネケエス	2013-07-09 09:51:54 +0000
twicca multi image plugin	2013-07-10 13:02:24 +0000
Twitter試験	2013-07-13 02:37:44 +0000
診断ティキット	2013-07-19 11:12:18 +0000
Krile2 (g)	2013-07-20 08:44:59 +0000
ｵｽﾄﾝｲﾝゲーム for Android	2013-07-20 21:59:32 +0000
メガネケエスRT	2013-07-23 01:01:35 +0000
Biyon≡(　ε:)	2013-07-29 16:00:18 +0000
これ聴いてるんだからねっ！ Advanced	2013-08-01 03:12:58 +0000
Yukari for Android	2013-08-02 05:51:43 +0000
バルス祭り	2013-08-02 12:11:29 +0000
艦メモ	2013-08-18 09:50:18 +0000
MetroTwit	2013-08-21 05:47:01 +0000
SobaCha	2013-08-23 08:14:49 +0000
最高の夏ジェネレーター	2013-08-30 13:47:22 +0000
installNow	2013-08-30 22:51:38 +0000
ShootingStar for API1.1	2013-09-10 12:03:44 +0000
erased855801	2013-09-10 12:19:32 +0000
iconDecotter	2013-09-29 09:11:47 +0000
おひるねサークル	2013-10-26 00:40:17 +0000
StarryEyes (g)	2013-10-31 12:09:01 +0000
ツイッターしないやつ.	2013-11-10 14:57:25 +0000
Twidere for Android #2	2013-11-30 05:09:36 +0000
Justaway for Android	2013-12-26 15:03:15 +0000
Rebootter	2013-12-26 16:00:10 +0000
ギガネケエス	2013-12-28 10:11:35 +0000
ついっぷる	2013-12-30 16:06:53 +0000
DeemoRayark	2014-01-18 09:28:38 +0000
大破～ん	2014-01-22 12:30:05 +0000
Ask.fm	2014-01-25 13:14:32 +0000
Saezuri	2014-01-29 11:58:37 +0000
hamoooooon	2014-02-04 04:19:43 +0000
update_color.rb	2014-02-21 16:54:53 +0000
Cerisier	2014-02-28 04:05:11 +0000
Shrimp	2014-03-01 04:49:37 +0000
今日、誰と一緒に食べる？	2014-03-03 17:22:45 +0000
Geso for Android	2014-03-15 19:04:50 +0000
JavatterFX	2014-03-16 12:08:45 +0000
流星	2014-03-19 23:03:49 +0000
ｱｶｲﾄﾘ4	2014-03-20 13:15:08 +0000
MakiMaki for Android	2014-03-30 13:06:47 +0000
Sleeping( ˘ω˘)Syar	2014-03-30 21:46:52 +0000
ぐへへ～(＾p＾)	2014-04-03 18:18:33 +0000
Mo-Footer_API_v4	2014-04-08 07:36:54 +0000
Mevy	2014-04-11 10:33:33 +0000
OrangeSphere	2014-04-12 15:22:27 +0000
Javaビーム工房	2014-04-19 09:41:57 +0000
Twitter for Android Tablets	2014-04-20 22:43:35 +0000
... 三乁□_ wwwwwww	2014-04-27 00:47:23 +0000
GenTwoo	2014-05-05 23:43:18 +0000
eAMUSEMENT	2014-05-09 04:22:04 +0000
Twitter	2014-05-09 11:30:03 +0000
TweetDeck	2014-05-15 12:50:33 +0000
TwitPane for Android	2014-05-31 10:29:06 +0000
SmileEssence	2014-05-31 11:25:21 +0000
GitHub Service Hooks	2014-05-31 17:39:25 +0000
Vine for Android	2014-06-01 08:47:52 +0000
feedly cloud	2014-06-02 22:22:55 +0000
ねぴぁのおしり	2014-06-14 13:33:47 +0000
ブクログ(booklog.jp)	2014-06-27 10:08:13 +0000
Dropbox	2014-06-28 15:34:35 +0000
TwitDuke	2014-07-10 15:22:01 +0000
kb10uy experimental	2014-07-15 09:04:56 +0000
Yukari for Desktop	2014-07-15 14:47:52 +0000
Asfc for ICS+	2014-07-27 00:07:17 +0000
Geso2	2014-08-25 22:46:13 +0000
connpass	2014-08-30 10:14:22 +0000
ツイタマ for Android	2014-09-06 07:15:16 +0000
ツイッターするやつγ	2014-09-19 17:58:38 +0000
#TwitADex	2014-11-02 12:31:31 +0000
Twittnuker	2014-11-29 23:24:15 +0000
Giza for Android	2014-11-30 09:57:25 +0000
オナ禁タイマー for Android	2014-12-05 18:55:31 +0000
Biyon Lite ≡(　ε:)	2015-01-02 06:05:48 +0000
Solid Worker	2015-01-05 07:19:45 +0000
東京アニメアワードフェスティバル2017 アニメファン投票！	2015-01-08 04:18:48 +0000
ジェネジェネ	2015-01-10 13:20:26 +0000
心拍数ツイート	2015-01-13 13:10:46 +0000
Twitwear	2015-01-25 11:54:35 +0000
Krile StarryEyes	2015-01-31 12:23:44 +0000
radiko.jp for Android	2015-01-31 15:01:57 +0000
OrangeSphere Next	2015-02-06 22:47:06 +0000
REFLEC BEAT 悠久のリフレシア AC	2015-03-24 07:44:13 +0000
Yukari +C	2015-03-26 01:07:48 +0000
Kottolin	2015-04-25 05:51:41 +0000
なでなで目覚ましかのん	2015-04-25 12:40:58 +0000
ついったーたのしいです(^o^)	2015-05-10 12:14:53 +0000
Mobile Music Game - Dynamix	2015-05-23 12:26:05 +0000
社畜ちゃん台詞メーカー	2015-05-24 13:40:33 +0000
Kotoura for Android	2015-05-30 07:54:58 +0000
Tumblr	2015-06-18 14:26:19 +0000
ツイッターするやつγ pro	2015-06-25 10:47:18 +0000
Absolutter	2015-07-11 05:36:09 +0000
Bitbucket Service Broker	2015-07-19 12:37:37 +0000
結月ゆかりのまな板に頬ずりｽﾘｽﾘｽﾘｽﾘｨ!!!!!	2015-07-19 15:53:38 +0000
Aristea	2015-08-01 15:32:39 +0000
erased7861122	2015-08-04 13:16:13 +0000
beeter (β)	2015-09-18 23:45:12 +0000
Tencocoa	2015-09-20 17:45:26 +0000
twitcle plus	2015-09-22 13:12:56 +0000
feather Android	2015-09-30 13:00:17 +0000
PlayStation®Vita	2015-11-03 08:23:39 +0000
Twidere for Android #4	2015-11-21 00:39:06 +0000
Twitter for Windows Phone	2015-12-08 03:39:57 +0000
メガネケエスWP	2015-12-08 15:56:31 +0000
Krile for Windows Phone	2015-12-09 15:59:40 +0000
除夜のEject	2015-12-31 12:27:35 +0000
notepadたんちゅっちゅ	2016-01-14 15:03:30 +0000
Flantter	2016-02-19 12:28:20 +0000
うさぎは性欲が強い→結月ゆかり→あっ(察し)	2016-03-09 03:23:04 +0000
Abs for Android	2016-05-19 03:36:41 +0000
niconico ニコニコ動画	2016-08-28 10:45:10 +0000
みみず銀行	2016-10-02 06:58:41 +0000
NewSuperHookGirl	2016-10-10 13:14:11 +0000
PlayStation(R)4	2016-11-05 05:50:29 +0000
tw-rubygem	2016-11-19 13:01:44 +0000
TwitPanePlus for Android	2017-01-07 13:31:13 +0000
MateCha	2017-02-19 06:13:06 +0000
Nintendo Switch Share	2017-03-03 14:57:43 +0000