FAQ | Problem?

SOTU OR %22State of the union%22_2017-04-20_21-36-02.xlsx
SOTU OR "State of the union"_2017-04-20_21-36-02.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
April 21, 2017
Short Description:
SOTU OR "State of the union" via NodeXL http://bit.ly/2osR6vT
@braddjaffy
@cnn
@cnnpolitics
@youtube
@mmpadellan
@dianez123

Description:
Description
The graph represents a network of 4,527 Twitter users whose tweets in the requested range contained "SOTU OR "State of the union"", or who were replied to or mentioned in those tweets. The network was obtained from the NodeXL Graph Server on Friday, 21 April 2017 at 04:41 UTC.

The requested start date was Friday, 21 April 2017 at 00:01 UTC and the maximum number of days (going backward) was 14.

The maximum number of tweets collected was 5,000.

The tweets in the network were tweeted over the 10-day, 18-hour, 54-minute period from Sunday, 09 April 2017 at 17:57 UTC to Thursday, 20 April 2017 at 12:52 UTC.

Additional tweets that were mentioned in this data set were also collected from prior time periods. These tweets may expand the complete time period of the data.

There is an edge for each "replies-to" relationship in a tweet, an edge for each "mentions" relationship in a tweet, and a self-loop edge for each tweet that is not a "replies-to" or "mentions".

The graph is directed.

The graph's vertices were grouped by cluster using the Clauset-Newman-Moore cluster algorithm.

The graph was laid out using the Harel-Koren Fast Multiscale layout algorithm.


Author Description


Overall Graph Metrics
Vertices : 4527
Unique Edges : 5748
Edges With Duplicates : 1732
Total Edges : 7480
Self-Loops : 1442
Reciprocated Vertex Pair Ratio : 0.0120320855614973
Reciprocated Edge Ratio : 0.023778071334214
Connected Components : 926
Single-Vertex Connected Components : 597
Maximum Vertices in a Connected Component : 2672
Maximum Edges in a Connected Component : 5160
Maximum Geodesic Distance (Diameter) : 15
Average Geodesic Distance : 4.601564
Graph Density : 0.000258624030355111
Modularity : 0.674897
NodeXL Version : 1.0.1.379

Top Influencers: Top 10 Vertices, Ranked by Betweenness Centrality
Top URLs
Top URLs in Tweet in Entire Graph:
[94] http://www.snappytv.com/tc/4468613
[71] http://www.cnn.com/videos/politics/2017/04/16/sotu-sanders-says-airlines-need-to-be-responsive.cnn?utm_source=dlvr.it&utm_medium=twitter
[57] http://www.cnn.com/video/data/2.0/video/politics/2017/04/09/sotu-moscow-haley.cnn.html
[46] http://www.snappytv.com/tc/4411327/2737934
[43] http://www.cnn.com/videos/politics/2017/04/09/sotu-haley-thinks-regime-change-coming-to-syria.cnn?utm_source=dlvr.it&utm_medium=twitter
[30] http://www.deccanchronicle.com/opinion/op-ed/150417/state-of-the-union-why-jadhav-needs-to-be-brought-back.html
[27] http://www.snappytv.com/tc/4411248
[27] http://www.cnn.com/2017/04/08/politics/nikki-haley-syria-interview-sotu-cnntv/index.html
[25] https://twitter.com/CerromeRussell/status/854675148384894977
[23] http://www.cnn.com/video/data/2.0/video/politics/2017/04/09/sotu-markey-strategy.cnn.html

Top URLs in Tweet in G1:
[1] http://www.dailykos.com/story/2016/6/26/1542594/-It-s-now-VERY-CLEAR-Bernie-Sanders-is-out-for-Bernie-Sanders-He-made-it-clear-on-State-of-the-Union
[1] https://twitter.com/i/web/status/852129618169561088
[1] https://www.youtube.com/watch?v=90iPgPgSPi8
[1] http://www.cnn.com/videos/politics/2017/04/02/wilbur-ross-jake-tapper-executive-order-signing-sotu.cnn/video/playlists/president-donald-trump/

Top URLs in Tweet in G2:
[68] http://www.cnn.com/videos/politics/2017/04/16/sotu-sanders-says-airlines-need-to-be-responsive.cnn?utm_source=dlvr.it&utm_medium=twitter
[43] http://www.cnn.com/videos/politics/2017/04/09/sotu-haley-thinks-regime-change-coming-to-syria.cnn?utm_source=dlvr.it&utm_medium=twitter
[18] http://www.cnn.com/videos/politics/2017/04/16/sotu-sanders-says-airlines-need-to-be-responsive.cnn
[17] http://www.cnn.com/videos/politics/2017/04/09/sotu-haley-thinks-regime-change-coming-to-syria.cnn
[9] http://lastamericanvagabond.airtime.pro/
[6] https://emberjs.com/blog/2017/04/05/emberconf-2017-state-of-the-union.html
[5] http://game.granbluefantasy.jp/#profile/3451026
[5] http://dlvr.it/NPFh32
[4] http://www.cnn.com/videos/politics/2017/04/09/nikki-haley-pressed-syria-strike-sotu.cnn
[4] https://www.c-span.org/video/?c4351026/clinton-1995-immigration-sotu

Top URLs in Tweet in G3:
[57] http://www.cnn.com/video/data/2.0/video/politics/2017/04/09/sotu-moscow-haley.cnn.html
[45] http://www.snappytv.com/tc/4411327/2737934
[23] http://www.cnn.com/video/data/2.0/video/politics/2017/04/09/sotu-markey-strategy.cnn.html
[19] http://www.cnn.com/video/data/2.0/video/politics/2017/04/09/sotu-haley-amazing-how-russia-covers-for-assad.cnn.html
[15] http://www.cnn.com/video/data/2.0/video/politics/2017/04/09/nikki-haley-full-intv-sotu.cnn.html
[12] http://www.cnn.com/video/data/2.0/video/politics/2017/04/09/sotu-cartoon-political-dynasties.cnn.html
[12] http://www.cnn.com/video/data/2.0/video/politics/2017/04/16/sotu-afghan-vet-trump-admin-lacks-commander-intent.cnn.html
[12] http://www.snappytv.com/tc/4468613
[11] http://www.cnn.com/video/data/2.0/video/politics/2017/04/09/sotu-markey-north-korea.cnn.html
[10] http://www.cnn.com/videos/politics/2017/04/16/bernie-sanders-syria-war-sotu.cnn

Top URLs in Tweet in G4:
[81] http://www.snappytv.com/tc/4468613
[22] http://www.snappytv.com/tc/4411248
[13] http://www.snappytv.com/tc/4411218
[13] http://www.cnn.com/video/data/2.0/video/politics/2017/04/16/bernie-sanders-full-interview-sotu.cnn.html
[5] http://www.snappytv.com/tc/4411174
[5] http://www.cnn.com/politics
[5] http://www.snappytv.com/tc/3023928
[3] http://www.snappytv.com/tc/4468590
[3] http://www.snappytv.com/tc/4349926
[3] http://www.cnn.com/videos/politics/2017/04/09/nikki-haley-assad-syria-sotu-tapper-intv.cnn/video/playlists/reactions-to-us-missile-strike-in-syria/

Top URLs in Tweet in G5:
[10] https://www.youtube.com/watch?v=HGNMRuSb-MI&feature=youtu.be&a
[9] https://www.youtube.com/watch?v=y54vlkxmv_4&feature=youtu.be
[8] https://www.youtube.com/watch?v=r0EJdCP8Txs&feature=youtu.be
[7] https://www.youtube.com/watch?v=HGNMRuSb-MI&feature=youtu.be
[6] https://twitter.com/avntisdouga/status/852873698931425280
[4] https://twitter.com/avntisdouga/status/851804384551985152
[4] https://www.youtube.com/watch?v=fPzssE8FRHo&feature=youtu.be
[3] https://www.youtube.com/watch?v=y54vlkxmv_4&feature=youtu.be&a
[2] https://www.youtube.com/watch?v=ysoPTAHQQf8&feature=youtu.be&a
[2] https://www.youtube.com/watch?v=pxIz0xgCye8&feature=youtu.be&a

Top URLs in Tweet in G6:
[1] https://twitter.com/i/web/status/853944465127387136
[1] http://www.cnn.com/videos/politics/2017/04/09/nikki-haley-assad-syria-sotu-tapper-intv.cnn/video/playlists/reactions-to-us-missile-strike-in-syria/
[1] https://twitter.com/i/web/status/836698746616430597
[1] https://twitter.com/i/web/status/836728544596144129

Top URLs in Tweet in G7:
[2] http://linkis.com/jUuvl
[1] http://www.attn.com/videos/16566/bill-maher-breaks-down-trumps-first-100-days-office?utm_source=twitter&utm_medium=direct
[1] http://m.tmi.me/1fioMJ
[1] http://linkis.com/YuLVM
[1] http://linkis.com/LFGWY
[1] http://linkis.com/JSlz1
[1] http://linkis.com/ACrUr
[1] http://www.youtube.com.linkis.com/4DEnH
[1] http://linkis.com/5kgrX
[1] http://www.youtube.com.linkis.com/uKgcV

Top URLs in Tweet in G8:
[3] https://twitter.com/Reuters/status/852255533553733633
[1] http://www.snappytv.com/tc/4468613

Top URLs in Tweet in G9:
[1] http://www.snappytv.com/tc/4411327/2737934

Top URLs in Tweet in G10:
[6] https://amp.twimg.com/v/a7cfefaf-5efd-402f-af36-a129c700c000
[3] http://aschaper1.blogspot.com/2017/04/justice-ice-paid-visit-today-to-wait.html
[2] http://aschaper1.blogspot.com/2017/04/victory-glendora-city-council-rejects.html?spref=tw
[2] https://www.washingtonpost.com/graphics/politics/2016-sotu/language/
[2] https://www.youtube.com/watch?v=w6-emdsdtek&feature=youtu.be
[1] https://twitter.com/i/web/status/854826373638004737
[1] https://twitter.com/i/web/status/855017348918640640
[1] http://aschaper1.blogspot.com/2017/04/photos-from-la-for-trump-in-santa.html?spref=tw
[1] http://aschaper1.blogspot.com/2017/04/standing-for-truth-texas-massresistance.html?spref=tw
[1] http://aschaper1.blogspot.com/2017/04/womens-march-member-joins-la-for-trump.html

Top Domains
Top Domains in Tweet in Entire Graph:
[530] cnn.com
[334] twitter.com
[260] youtube.com
[255] snappytv.com
[48] linkis.com
[47] fb.me
[33] deccanchronicle.com
[21] textilvergehen.de
[21] blogspot.com
[21] autofollow.fr

Top Domains in Tweet in G1:
[1] dailykos.com
[1] twitter.com
[1] youtube.com
[1] cnn.com

Top Domains in Tweet in G2:
[177] cnn.com
[64] twitter.com
[32] fb.me
[21] youtube.com
[10] linkis.com
[10] feedburner.com
[10] instagram.com
[9] airtime.pro
[8] c-span.org
[8] spotify.com

Top Domains in Tweet in G3:
[274] cnn.com
[110] snappytv.com
[14] linkis.com
[10] twitter.com
[5] snpy.tv
[2] house.gov
[2] larouchepac.com
[1] cnn.it
[1] politico.com
[1] tweetedtimes.com

Top Domains in Tweet in G4:
[140] snappytv.com
[31] cnn.com
[3] snpy.tv
[3] linkis.com
[1] theguardian.com
[1] facebook.com

Top Domains in Tweet in G5:
[205] youtube.com
[42] twitter.com
[2] ameblo.jp
[2] instagram.com
[1] ikelove.jp
[1] linkis.com
[1] youtu.be

Top Domains in Tweet in G6:
[3] twitter.com
[1] cnn.com

Top Domains in Tweet in G7:
[18] linkis.com
[1] attn.com
[1] tmi.me

Top Domains in Tweet in G8:
[3] twitter.com
[1] snappytv.com

Top Domains in Tweet in G9:
[1] snappytv.com

Top Domains in Tweet in G10:
[15] blogspot.com
[12] twitter.com
[6] twimg.com
[2] washingtonpost.com
[2] youtube.com
[1] fb.me
[1] politicalminute.com

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[725] cnnsotu
[187] sotu
[61] trump
[26] ガルパン版深夜のお絵描き60分一本勝負
[21] nikkihaley
[21] syria
[19] fcunion
[18] revoluciónestadista
[16] politics
[15] nowplaying



Top Hashtags in Tweet in G1:
[1] deplorable

Top Hashtags in Tweet in G2:
[75] sotu
[20] nikkihaley
[12] nowplaying
[9] news
[9] wkup
[9] tlav
[5] podcast
[5] facebook
[4] politicsampcurrentevents
[4] trump

Top Hashtags in Tweet in G3:
[602] cnnsotu
[22] sotu
[13] syria
[5] assad
[4] barackobama
[4] hillaryclinton
[4] syrianstrikes
[4] foxandfriends
[4] morningjoe
[4] todayshow

Top Hashtags in Tweet in G4:
[119] cnnsotu
[54] trump
[3] epic
[1] dumpthetrump

Top Hashtags in Tweet in G5:
[10] 楽天学割
[6] う祭
[4] 帰ってこいはじめ
[4] アバリスさんと繋がりたい
[4] アバンティーズ
[2] おるたな
[2] おるたなーの輪
[2] 私ともっと仲良くしたいよって人rt仲良い自信ある人いいね安定だろって人リプ
[2] rtした人をあり得ないほどの雑さで紹介する
[2] シークレットイベント

Top Hashtags in Tweet in G6:
[6] blackouttrump
[2] trumprussia

Top Hashtags in Tweet in G7:
[4] manmet80
[4] drjamespeterson
[3] mehdirhasan
[2] billmaher
[1] betterw05759703
[1] akmuskie
[1] texyellowdogdem
[1] asthehospturns
[1] russia_mideast

Top Hashtags in Tweet in G8:
[2] keystonexl
[2] sotu
[1] cnnsotu

Top Hashtags in Tweet in G10:
[21] sotu
[2] actonclimate
[2] first100
[1] indivisibleradio
[1] billclinton
[1] immigration
[1] dnc

Top Words
Top Words in Tweet in Entire Graph:
[1659] Words in Sentiment List#1: Positive
[2939] Words in Sentiment List#2: Negative
[21] Words in Sentiment List#3: Angry/Violent
[81755] Non-categorized Words
[86356] Total Words
[2119] state
[2083] union
[1710] lie
[999] obama
[981] https

Top Words in Tweet in G1:
[1472] lie
[739] out
[737] during
[736] joe
[736] wilson
[736] yelled
[736] obama
[736] state
[736] union
[736] gets

Top Words in Tweet in G2:
[306] state
[303] union
[145] sotu
[99] sanders
[95] haley
[88] airlines
[88] making
[87] problems
[86] syria
[69] 'regime

Top Words in Tweet in G3:
[810] cnnsotu
[334] jaketapper
[312] syria
[305] cnnpolitics
[211] haley
[188] nikki
[184] senmarkey
[176] https
[174] ambassador
[144] huge

Top Words in Tweet in G4:
[313] korea
[241] cnn
[200] berniesanders
[178] north
[160] dealing
[151] don
[151] t
[146] kim
[146] jong
[135] willripleycnn

Top Words in Tweet in G5:
[91] youtube
[87] eri_sotu
[80] union
[79] state
[45] video
[28] がアップロード
[27] interview
[26] 笑
[24] 今日の動画です
[21] anduze

Top Words in Tweet in G6:
[149] regime
[149] change
[148] maybe
[148] trump
[148] english
[148] translator
[148] busted
[148] america
[148] 1st
[148] syria

Top Words in Tweet in G7:
[143] state
[143] union
[128] billmaher
[126] exclusive
[126] attn
[126] spoke
[126] w
[126] special
[126] interview
[124] grading

Top Words in Tweet in G8:
[242] 'you
[125] state
[125] union
[123] lie
[122] joe
[122] wilson
[122] yelled
[122] during
[122] obama
[122] gets

Top Words in Tweet in G9:
[186] strategy
[93] kylegriffin1
[93] sen
[93] ed
[93] markey
[93] trump's
[93] missile
[93] strike
[93] tactic
[93] need

Top Words in Tweet in G10:
[42] state
[41] union
[26] sotu
[22] potus
[15] jeffsessions
[13] judgejeanine
[12] vp
[12] judgenap
[12] law
[11] lrihendry

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[2073] state,union
[902] obama,state
[899] joe,wilson
[899] wilson,yelled
[898] during,obama
[898] union,gets
[890] gets,drowned
[887] drowned,out
[882] chants,town
[785] yelled,lie

Top Word Pairs in Tweet in G1:
[736] joe,wilson
[736] wilson,yelled
[736] yelled,lie
[736] lie,during
[736] during,obama
[736] obama,state
[736] state,union
[736] union,gets
[736] gets,drowned
[736] drowned,out

Top Word Pairs in Tweet in G2:
[300] state,union
[88] sanders,airlines
[88] airlines,making
[87] making,problems
[68] 'regime,change'
[64] change',coming
[64] coming,syria
[63] haley,'regime
[29] union,address
[27] xxx,state

Top Word Pairs in Tweet in G3:
[188] nikki,haley
[167] ambassador,nikki
[147] cnnpolitics,ambassador
[144] huge,sigh
[144] sigh,relief
[144] cnnsotu,https
[142] haley,seen
[142] seen,huge
[142] relief,syria
[142] syria,airstrikes

Top Word Pairs in Tweet in G4:
[178] north,korea
[151] don,t
[146] kim,jong
[135] willripleycnn,n
[135] n,korea
[135] korea,kim
[135] jong,made
[135] made,clear
[135] clear,failures
[135] failures,don

Top Word Pairs in Tweet in G5:
[79] state,union
[20] stelar,state
[20] union,ft
[20] ft,anduze
[20] anduze,official
[20] official,video
[19] parov,stelar
[18] union,interview
[17] liked,youtube
[17] youtube,video

Top Word Pairs in Tweet in G6:
[149] regime,change
[148] maybe,trump
[148] trump,english
[148] english,translator
[148] translator,busted
[148] busted,america
[148] america,1st
[148] 1st,regime
[148] change,syria
[147] mmpadellan,maybe

Top Word Pairs in Tweet in G7:
[143] state,union
[126] exclusive,attn
[126] attn,spoke
[126] spoke,w
[126] w,billmaher
[126] billmaher,special
[126] special,state
[126] union,interview
[124] interview,grading
[123] matthewesegal,exclusive

Top Word Pairs in Tweet in G8:
[125] state,union
[122] joe,wilson
[122] wilson,yelled
[122] during,obama
[122] obama,state
[122] union,gets
[122] gets,drowned
[122] drowned,out
[122] chants,town
[121] yelled,'you

Top Word Pairs in Tweet in G9:
[93] sen,ed
[93] ed,markey
[93] markey,trump's
[93] trump's,missile
[93] missile,strike
[93] strike,tactic
[93] tactic,strategy
[93] strategy,need
[93] need,comprehensive
[93] comprehensive,strategy

Top Word Pairs in Tweet in G10:
[41] state,union
[12] judgejeanine,judgenap
[11] lrihendry,potus
[11] potus,vp
[11] vp,jeffsessions
[11] jeffsessions,judgejeanine
[11] judgenap,begging
[11] begging,you2
[11] you2,ban
[11] ban,sharia

Top Replied-To
Top Replied-To in Entire Graph:
@eri_sotu
@goku_sotu
@yuringu_ava
@karupisu966966
@youtube08240214
@urachaaan_35
@realdonaldtrump
@youtube_avn
@abantslove_you
@sorachisa0512

Top Replied-To in G1:
@braddjaffy

Top Replied-To in G3:
@realdonaldtrump
@jasonkander
@eddiejmurphy
@ricksantorum
@theleadcnn
@soopermexican
@cnnsotu
@jaketapper

Top Replied-To in G4:
@berniesanders
@cnn
@jaketapper
@thesickmanofeur

Top Replied-To in G5:
@eri_sotu
@yuringu_ava
@youtube08240214
@urachaaan_35
@rinavntis
@turime0208
@youtube_sakuuuu
@love_fs_bsk
@sorachisa0512
@abantslove_you

Top Replied-To in G6:
@marykim380

Top Replied-To in G9:
@onlylindacolyer

Top Replied-To in G10:
@joyannreid
@lrihendry
@elhenderz
@jeffsessions
@womensmarch
@breitbartnews
@patriotfire
@rednationrising
@sgvtribune
@calicrusader

Top Mentioned
Top Mentioned in Entire Graph:
@braddjaffy
@cnnpolitics
@jaketapper
@cnn
@berniesanders
@cnnsotu
@senmarkey
@mmpadellan
@willripleycnn
@nikkihaley

Top Mentioned in G1:
@braddjaffy
@ken_alabama
@cnnpolitics
@billkristol

Top Mentioned in G2:
@chavinanupam
@nikunjness
@tutunciyev_
@schererforever
@whatever1091
@kierobar
@velvetnikitab
@golfgalsue

Top Mentioned in G3:
@jaketapper
@cnnpolitics
@cnnsotu
@senmarkey
@nikkihaley
@realdonaldtrump
@berniesanders
@repedroyce
@cnn
@ricksantorum

Top Mentioned in G4:
@cnn
@berniesanders
@willripleycnn
@cnnpolitics
@trumpsuperpac
@cnni
@repedroyce
@senmarkey
@jaketapper
@united

Top Mentioned in G5:
@youtube
@turime1996
@skypeace_teojin
@to_tetsuya
@avntisdouga
@yocchi5810
@billpostmus
@torokeroo
@sushi_riku

Top Mentioned in G6:
@mmpadellan
@braddjaffy
@mrspock2017
@kellyg1160
@maskarovka1
@marykim380
@billkristol

Top Mentioned in G7:
@attn
@billmaher
@matthewesegal
@c0nvey
@braddjaffy
@hakimgreen

Top Mentioned in G8:
@tusk81
@berniesanders
@omackson
@cnnpolitics
@cnn
@jkhwlv
@braddjaffy

Top Mentioned in G9:
@kylegriffin1
@braddjaffy
@mmpadellan
@tusk81
@billkristol

Top Mentioned in G10:
@potus
@jeffsessions
@judgejeanine
@vp
@judgenap
@barackobama
@terracotta05
@lrihendry
@arthurcschaper
@foxnews

Top Tweeters
Top Tweeters in Entire Graph:
@inflamescrime
@jamesgreid
@berkleybearnews
@favstar250
@nakhon224
@parishatzi
@collectedn
@matthewtwihard
@amandsst
@ruhtyt

Top Tweeters in G1:
@melislily
@_rico21
@lehigh389
@politicalbee
@utzaake
@sevenclovers
@manyazuba
@jamestoupin
@docsaico
@3chicspolitico

Top Tweeters in G2:
@inflamescrime
@jamesgreid
@berkleybearnews
@nakhon224
@parishatzi
@collectedn
@ruhtyt
@amyrightside
@slowestpoison
@supra1bqteam

Top Tweeters in G3:
@chantelldawnsny
@pmorris153
@new_narrative
@lglwry
@mapocoloco
@orlandoandresm4
@luanamaclac
@michelle9647
@s_addams
@monalisazelf

Top Tweeters in G4:
@yuuji_k1
@rashidaldosari
@united
@joleonbusby
@alicmurray
@pamcurtis4210
@dominiquevanpee
@britpoptarts
@sdltheman88
@wonderfullone

Top Tweeters in G5:
@lyleklich
@newzfox
@billpostmus
@celestepewter
@mamaduck9370
@yu_kachan_
@kantamizutamari
@mahotonnn
@jinjin1027
@visotsky_igor1

Top Tweeters in G6:
@terri_georgia
@bigaerosmithfan
@galinagalanos
@anonbruja
@nancypeggy
@serabbi
@asthehospturns
@nayaknomi
@jhat1947
@barbb0925

Top Tweeters in G7:
@amycrocker76amy
@lcoco37
@penndragonart
@tottenbill
@owlbelief
@techno1log
@ofdhillary2016
@robin_volpi
@tedleew
@iktriad

Top Tweeters in G8:
@favstar250
@sydneya
@gpwriter
@burberryant
@kaijuking23
@spamueljohnson
@gurtling
@heinzilla
@deadchilljacky
@ellis_texas

Top Tweeters in G9:
@mmwlawtaos
@bmangh
@gekkosecond
@damonbethea1
@msgoddessrises
@cloudwanderer3
@jodotcom
@lorisums
@betseybess
@bndsnoopy61

Top Tweeters in G10:
@foxnews
@stranahan
@lrihendry
@rednationrising
@hambysr
@furiousfarmboy
@msnbc
@joyannreid
@mitchellvii
@funder