The graph represents a network of 135 Twitter users whose recent tweets contained "SQLFamily", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 18,000 tweets. The network was obtained from Twitter on Friday, 02 December 2022 at 22:24 UTC.
The tweets in the network were tweeted over the 8-day, 16-hour, 32-minute period from Thursday, 24 November 2022 at 02:09 UTC to Friday, 02 December 2022 at 18:42 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
Vertices : 135
Unique Edges : 224
Edges With Duplicates : 38
Total Edges : 262
Number of Edge Types : 5
Tweet : 36
Retweet : 77
MentionsInRetweet : 61
Replies to : 28
Mentions : 60
Self-Loops : 37
Reciprocated Vertex Pair Ratio : 0.0246305418719212
Reciprocated Edge Ratio : 0.0480769230769231
Connected Components : 26
Single-Vertex Connected Components : 14
Maximum Vertices in a Connected Component : 91
Maximum Edges in a Connected Component : 216
Maximum Geodesic Distance (Diameter) : 8
Average Geodesic Distance : 3.404651
Graph Density : 0.0114980652294085
Modularity : 0.587331
NodeXL Version : 1.0.1.508
Data Import : The graph represents a network of 135 Twitter users whose recent tweets contained "SQLFamily", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 18,000 tweets. The network was obtained from Twitter on Friday, 02 December 2022 at 22:24 UTC.
The tweets in the network were tweeted over the 8-day, 16-hour, 32-minute period from Thursday, 24 November 2022 at 02:09 UTC to Friday, 02 December 2022 at 18:42 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".
Layout Algorithm : The graph was laid out using the Harel-Koren Fast Multiscale layout algorithm.
Graph Source : TwitterSearch
Graph Term : SQLFamily
Groups : The graph's vertices were grouped by cluster using the Clauset-Newman-Moore cluster algorithm.
Edge Color : Edge Weight
Edge Width : Edge Weight
Edge Alpha : Edge Weight
Vertex Radius : In-Degree
Top Domains
Top Word Pairs in Tweet in Entire Graph:
[30] re,part [24] part,#sqlfamily [22] sql,server [15] #sqlfamily,#sqlserver [14] book,12 [14] 12,copies [10] #sqlserver,#sqlfamily [10] #sqlserver,comments [10] community,#sqlfamily [10] tough,issue Top Word Pairs in Tweet in G1:
[24] re,part [19] part,#sqlfamily [10] sql,server [7] #sqlfamily,community [6] good,one [6] tough,issue [6] damn,good [6] think,re [6] interesting,email [6] comments,welcome Top Word Pairs in Tweet in G2:
[4] re,part [4] welcome,manashisarkar [3] case,community [3] hey,#sqlfamily [3] #sqlfamily,#sqlserver [3] curious,case [3] tough,issue [3] blog,curious [3] #sqlserver,comments [3] community,#sqlfamily Top Word Pairs in Tweet in G3:
[12] 12,copies [12] book,12 [6] gfritchey,book [6] ordered,12 [6] 12,auntkathi [6] thank,apress [6] auntkathi,sql [6] sale,99 [6] shipping,ordered [6] 2022,book Top Word Pairs in Tweet in G4:
[4] lt,lt [2] principal,sql [2] pipeline,service [2] service,principal Top Word Pairs in Tweet in G5:
[7] sqlserver,#azuresql [7] community,really [7] yourself,#sqlfamily [7] see,yourself [7] updated,learn [7] friends,see [7] product,share [7] connect,network [7] share,knowledge [7] #azuresql,community Top Word Pairs in Tweet in G6:
[7] #msftadvocate,#mvpbuzz [4] #azurearc,community [4] #mvpbuzz,#sqlserver [4] #sqlserver,#sqlfamily [4] #itpro,#azurestackhci [4] video,live [4] #devopscommunity,#itpro [4] recorded,video [4] live,#msftadvocate [4] #sqlfamily,#devopscommunity Top Word Pairs in Tweet in G7:
[5] log,bau [5] start,petition [5] times,see [5] default,#sqlfamily [5] frustrated,folks [5] stop,spamming [5] trace,flag [5] many,times [5] relevant,messages [5] flag,3226 Top Word Pairs in Tweet in G8:
[2] inperson,mcrdataplatform [2] usergoup,first [2] hybrid,session [2] dataleeds,dpacnewc [2] #sqlfamily,#datacommunitty [2] long,#sqlfamily [2] #datacommunitty,#datamesh [2] #manchester,great [2] mrpaulandrew,inperson [2] lots,faces Top Word Pairs in Tweet in G10:
[2] pm,'sending [2] #usergroup,#sqlserver [2] group,next [2] sql,server' [2] sure,join [2] #sqlfamily,#usergroup [2] sqlpip,#sqlfamily [2] next,session [2] join,msdatagroupbrum [2] msdatagroupbrum,group Top Replied-To in Entire Graph:
Top Replied-To in G1:
Top Replied-To in G2:
Top Replied-To in G3:
Top Replied-To in G5:
Top Replied-To in G8:
Top Replied-To in G9:
Top Mentioned in Entire Graph:
Top Mentioned in G1:
Top Mentioned in G2:
Top Mentioned in G3:
Top Mentioned in G5:
Top Mentioned in G6:
Top Mentioned in G8:
Top Mentioned in G9:
Top Mentioned in G10:
Top Tweeters in Entire Graph:
Top Tweeters in G1:
Top Tweeters in G2:
Top Tweeters in G3:
Top Tweeters in G4:
Top Tweeters in G5:
Top Tweeters in G6:
Top Tweeters in G7:
Top Tweeters in G8:
Top Tweeters in G9:
Top Tweeters in G10: