The graph represents a network of 1,629 Twitter users whose recent tweets contained "#SQLHelp", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 20,000 tweets. The network was obtained from Twitter on Friday, 02 September 2022 at 21:21 UTC.
The tweets in the network were tweeted over the 478-day, 5-hour, 1-minute period from Wednesday, 12 May 2021 at 14:55 UTC to Friday, 02 September 2022 at 19:56 UTC.
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 : 1629
Unique Edges : 899
Edges With Duplicates : 6526
Total Edges : 7425
Number of Edge Types : 8
Tweet : 1274
Retweet : 1250
MentionsInRetweet : 1334
Replies to : 1434
MentionsInReplyTo : 1897
Mentions : 190
Quote : 40
MentionsInQuote : 6
Self-Loops : 1555
Reciprocated Vertex Pair Ratio : 0.0780228758169935
Reciprocated Edge Ratio : 0.144751799924214
Connected Components : 168
Single-Vertex Connected Components : 133
Maximum Vertices in a Connected Component : 1407
Maximum Edges in a Connected Component : 7112
Maximum Geodesic Distance (Diameter) : 10
Average Geodesic Distance : 3.829333
Graph Density : 0.000995093536530001
Modularity : 0.292312
NodeXL Version : 1.0.1.504
Data Import : The graph represents a network of 1,629 Twitter users whose recent tweets contained "#SQLHelp", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 20,000 tweets. The network was obtained from Twitter on Friday, 02 September 2022 at 21:21 UTC.
The tweets in the network were tweeted over the 478-day, 5-hour, 1-minute period from Wednesday, 12 May 2021 at 14:55 UTC to Friday, 02 September 2022 at 19:56 UTC.
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 : #SQLHelp
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
Vertex X : Column1
Top Domains
Top Word Pairs in Tweet in Entire Graph:
[536] join,types [515] #sql,#datascience [500] #machinelearning,#jupyter [500] #jupyter,#sql [495] #mysql,join [486] learn,#sql [473] #datascience,# [468] types,learn [468] #sql,online [468] online,courses Top Word Pairs in Tweet in G1:
[388] #mysql,join [388] join,types [388] types,learn [388] learn,#sql [388] #sql,online [388] online,courses [388] courses,co [388] co,zrjt0vwnzp [388] zrjt0vwnzp,#machinelearning [388] #machinelearning,#jupyter Top Word Pairs in Tweet in G2:
[208] sql,server [59] azure,sql [52] #sqlhelp,hashtag [45] #sqlhelp,anyone [37] keep,#sqlhelp [36] please,keep [35] anyone,know [35] hashtag,community [32] sql,2019 [32] community,driven Top Word Pairs in Tweet in G3:
[112] #sql,#datascience [106] #machinelearning,#jupyter [106] #jupyter,#sql [103] join,types [101] #mysql,join [95] commands,#100daysofcode [94] quick,summary [92] #sql,#sqlhelp [87] learn,#sql [85] gt,gt Top Word Pairs in Tweet in G4:
[30] sql,server [15] #sql,#sqlhelp [11] #sqlhelp,#sql [6] #sqlhelp,anyone [6] #sqlhelp,#sqlserver [5] anyone,know [3] anyone,good [3] thanks,#sqlhelp [3] #sqlserver,#sqlhelp [3] azure,sql Top Word Pairs in Tweet in G5:
[39] sql,server [29] please,keep [28] keep,#sqlhelp [28] #sqlhelp,hashtag [25] hashtag,community [25] community,driven [25] driven,advertising [25] advertising,promotion [25] promotion,marketing [25] need,#help Top Word Pairs in Tweet in G6:
[42] join,types [37] mysql,join [37] types,#devops [37] #devops,#devsecops [37] #devsecops,#kubernetes [37] #kubernetes,#cicd [37] #cicd,#k8s [37] #k8s,#linux [37] #linux,#docker [37] #docker,#sysadmin Top Word Pairs in Tweet in G7:
[16] sql,server [7] latest,sqlrnnr [7] sqlrnnr,daily [7] daily,thanks [6] #sql,#sqlhelp [5] read,more [5] #sqlhelp,#sqlfamily [5] hey,#sqlhelp [4] ci,cd [4] backup,strategy Top Word Pairs in Tweet in G8:
[18] sql,server [8] day,61 [8] 61,#100daysofcode [8] #100daysofcode,getting [8] getting,started [8] started,mysql [8] mysql,database [8] database,python [8] python,#database [8] #database,#mysql Top Word Pairs in Tweet in G9:
[15] present,ug [11] thursday,month [10] looking,speakers [10] speakers,present [10] ug,throughout [10] throughout,2022 [10] 2022,first [10] first,thursday [10] month,1pm [10] 1pm,bst Top Word Pairs in Tweet in G10:
[13] websites,practice [13] practice,sql [13] sql,w3resource [13] w3resource,sqlzoo [13] sqlzoo,w3school [13] w3school,sql [13] sql,practice [13] practice,hackerrank [13] hackerrank,sqlshack [13] sqlshack,metabase 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 G6:
Top Replied-To in G7:
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 G4:
Top Mentioned in G5:
Top Mentioned in G6:
Top Mentioned in G7:
Top Mentioned in G8:
Top Mentioned in G9:
Top Mentioned in G10: