Archive for category Hawthorn Hawks

Most popular AFL related Twitter accounts (November 18)

Posted by Laura on Thursday, 18 November, 2010

I wasn’t intending to run this again until tomorrow.  Things came up.  I’m going away for the weekend and I want to get everyone’s follower information to see if I can’t begin to map that again.  Also, it’s been a month since I last that information.  (It took about five days.  That was back when Shane Warne had only 198,000 followers.)  I like benchmarking that data to see if there are geographic shifts in where people follow are from.  (Has the location of where Team GWS followers come from?)  So yeah, I figured I would run the script this morning instead of a week from now.

This particular list only includes AFL related accounts. (And everyone on it appears on the list of most popular for all of Australia.)   I’m hoping all the labels are right.  If anything is incorrect, players switched team, I’m missing people… let me know and I’ll fix it.  And yeah, I’ve ranked this one so you can more easily see who is popular and who is not.

Rank Account League Team Description Followers Statuses Listed Friends
1 AFL AFL AFL official 16764 5346 571 1269
2 harry_o AFL Collingwood Magpies player 10909 2211 302 534
3 Collingwood_FC AFL Collingwood Magpies official 9742 2095 291 5537
4 jimstynes AFL Melbourne Demons player 9490 145 226 13
5 karmichaelhunt AFL Gold Coast Football Club Karmichael Hunt (player) 9102 5424 293 193
6 Essendon_Fc AFL Essendon Bombers official team (male) 7440 4162 234 7291
7 GaryAblettJnr AFL Geelong Cats player 7051 138 123 34
8 mickmalthouse AFL Collingwood Magpies Mick Malthouse 6875 88 188 27
9 Adelaide_FC AFL Adelaide Crows official 6711 3154 239 6638
10 DT_13 AFL Collingwood Magpies Dale Thomas 6652 286 142 19
11 JobeWatson AFL Essendon Bombers player 6395 140 190 4
12 swandane AFL Collingwood Magpies player (male) 6243 139 109 10
13 sydneyswans AFL Sydney Swans official 6227 2813 253 2451
14 SP_10 AFL Collingwood Magpies player 6057 348 126 66
15 lehmo23 AFL Hawthorn Hawks player 5598 1871 208 591
16 stkildafc AFL St. Kilda Saints official 5494 2892 211 5549
17 BrendanFevola05 AFL Brisbane Lions player 5339 294 146 28
18 AngusMonfries AFL Essendon Bombers player 5241 268 186 18
19 Carlton_FC AFL Carlton Blues official 5213 2509 238 4055
20 tjrharley AFL Geelong Cats former player (male) 5094 912 162 193
21 Richmond_FC AFL Richmond Tigers official 4334 1206 173 4725
22 heathshaw39 AFL Collingwood Magpies player (male) 4318 61 91 7
23 northkangaroos AFL North Melbourne Kangaroos official 4312 1993 163 4724
24 craighutchy AFL AFL journalist (male)(Nine Network) 4266 223 117 655
25 SharrodW_21 AFL Collingwood Magpies player 4211 77 113 25
26 Geelong_FC AFL Geelong Cats fansite 3749 3746 161 1941
27 HawthornFC AFL Hawthorn Hawks official 3748 1052 170 10
28 nathan2jones AFL Melbourne Demons player 3531 1493 147 311
29 SuperCoachAFL AFL AFL fansite 3389 219 169 2305
30 SpidaEveritt AFL AFL former player 3225 240 76 1409
31 DemonsHQ AFL Melbourne Demons official 2934 2051 158 543
32 GoldCoastFC AFL Gold Coast Football Club official 2818 949 150 608
33 marcmurphy3 AFL Carlton Blues player 2665 130 84 42
34 stevenbaker10 AFL St. Kilda Saints player 2630 773 71 125
35 Fremantle_FC AFL Fremantle Dockers official 2612 651 141 164
36 WCEofficial AFL West Coast Eagles 2555 1367 143 1079
37 CamSchwab AFL Melbourne Demons ceo 2553 2122 106 460
38 PAFC AFL Port Adelaide Power official 2550 1253 162 79
39 FitzySA AFL Sydney Swans player (male) 2440 48 50 23
40 AndrewMackieGFC AFL Geelong Cats player 2292 33 97 3
41 chooka_86 AFL Carlton Blues player 2114 1509 77 198
42 triplemfooty AFL AFL Triple M Footy 2089 2860 79 112
43 Rickypetterd15 AFL Melbourne Demons unofficial 2063 340 93 90
44 JeffWhite34 AFL Melbourne Demons former player (male) 2061 7329 108 329
45 Adam0017 AFL Western Bulldogs player 2035 231 60 89
46 westernbulldogs AFL Western Bulldogs official 2034 324 101 53
47 andrewswallow AFL North Melbourne Kangaroos unofficial 1991 386 85 16
48 Beamdogg AFL Melbourne Demons player 1907 147 65 112
49 BradMilzy AFL Melbourne Demons player 1869 151 60 81
50 howcroft AFL Melbourne Demons player 1773 280 71 79
51 anthonyalsop AFL AFL sport media specialist (male) 1700 12487 122 1437
52 Real_ColSylvia AFL Melbourne Demons player 1689 20 56 32
53 AFLStatsGuys AFL AFL 1678 934 100 101
54 bigdyman AFL Collingwood Magpies player 1663 588 88 23
55 Hawks_AFL AFL Hawthorn Hawks unofficial 1631 1085 30 1951
56 SteveAlessio AFL Essendon Bombers former Essendon AFL player 1574 762 80 222
57 warrentredrea AFL Port Adelaide Power player 1537 506 58 93
58 brett_kirk AFL Sydney Swans player (Brett Kirk) (male) 1498 10 27 3
59 kadesimpson6 AFL Carlton Blues player 1495 47 50 13
59 sgrigg88 AFL Carlton Blues player 1495 87 53 19
61 ALFbrisbane AFL Brisbane Lions fansite 1445 38 58 3
62 GWS_Giants AFL Greater Western Sydney official team (male) 1433 268 79 177
63 PeterDaicos AFL Collingwood Magpies unofficial 1419 59 77 678
64 CaleMorton AFL Melbourne Demons player 1234 229 47 63
65 zacd_6 AFL St. Kilda Saints player 1220 115 35 55
66 DrDreamTeam AFL AFL Dream Team (male) 1210 547 50 27
67 AFLphotos AFL AFL official 1200 784 56 96
68 AFL_Shifter AFL AFL talent scout Kevin Sheehan 1191 108 35 12
69 AFLInsider AFL AFL official 1165 54 58 84
70 IanPrendergast AFL AFL AFL Players’ Association General Manager (male) 1100 821 58 289
71 ThaBigRush AFL Melbourne Demons player (male) 1093 35 43 32
72 samjacobs32 AFL Carlton Blues player 1081 53 36 23
73 AFL_JenWitham AFL AFL 1062 884 56 286
74 cornes18 AFL Port Adelaide Power player (male) 1047 183 36 60
75 Rivshouse AFL Melbourne Demons player 1039 10 49 8
76 collingwoodnews AFL Collingwood Magpies unofficial 1004 6 34 1
77 bater06 AFL Melbourne Demons Matthew Bate 986 110 40 63
78 njbrown17 AFL St. Kilda Saints player 982 43 54 19
79 troychaplin30 AFL Port Adelaide Power player 960 316 39 85
80 JasonJohnson14 AFL Essendon Bombers former Essendon AFL player 928 90 36 31
81 championdata AFL AFL Official Statisticians of the AFL. 899 2226 49 2
82 ssalopek3 AFL Port Adelaide Power player 858 200 36 51
83 ChadCornes AFL Port Adelaide Power player (male) 819 72 31 29
84 AFLBrisbaneFC AFL Brisbane Lions fansite 798 1212 34 25
85 Robeddy40 AFL St. Kilda Saints player 785 74 29 52
86 APWelsh AFL Essendon Bombers player 765 59 27 56
87 JaredCrouch AFL Sydney Swans former player 734 693 43 129
88 MattBurgan AFL Melbourne Demons melbournefc.com.au editor 727 1143 32 86
89 JackRiewoldt08 AFL Richmond Tigers player (male) 707 11 22 13
90 tboak10 AFL Port Adelaide Power player (male) 704 38 29 21
91 RustyRussell02 AFL Carlton Blues player (male) 683 19 19 9
92 RTTF_AU AFL Sydney Swans fansite 681 1297 38 952
93 Swatta02 AFL Sydney Swans player (male) 661 542 23 245
94 newto29 AFL Melbourne Demons player 653 193 31 94
95 Freo_Dockers AFL Fremantle Dockers fansite 645 2293 43 380
96 wingsofperth AFL West Coast Eagles unofficial 612 849 9 8
97 hughesy_53 AFL Melbourne Demons player 610 83 24 43
98 PencilsCase AFL Melbourne Demons Jake Spencer 588 36 38 40
99 GraceOf41 AFL Port Adelaide Power player (male) 587 184 16 30
100 chipa__8 AFL Melbourne Demons player (male) 575 31 16 44
101 KurtTippett4 AFL Adelaide Crows player (male) 567 136 11 32
102 MitchMorton AFL Richmond Tigers player (male) 553 50 19 30
103 Sam_Blease AFL Melbourne Demons player 547 69 15 69
104 Maverick_weller AFL Gold Coast Football Club player 546 603 31 77
105 DTTALK AFL AFL Dream Team (male) 520 1574 34 124
106 rgray17 AFL Port Adelaide Power player 517 52 21 42
107 TheBigTicket4 AFL Adelaide Crows player (male) 510 34 22 14
108 Carltonfc AFL Carlton Blues fansite 507 602 19 58
109 TalkingCarlton AFL Carlton Blues fansite 491 2243 33 36
110 FremantleFC AFL Fremantle Dockers unofficial 485 2 13 0
111 BrendanWhiteX AFL Hawthorn Hawks player (male) 482 72 10 30
112 surj9 AFL Port Adelaide Power player (male) 461 63 21 37
113 MitchJbrown17 AFL West Coast Eagles unofficial 460 13 42 6
114 essendonfc AFL Essendon Bombers unofficial 456 2 10 0
115 Harts08 AFL Port Adelaide Power player (male) 455 39 20 43
116 AFL_AdamMcNicol AFL AFL Adam McNicol (male) 449 31 14 149
117 AFL_JasonPhelan AFL AFL AFL employee 445 373 17 99
118 PAFCNews AFL Port Adelaide Power fansite (male) 430 1427 17 151
118 ryanmcrowley AFL Fremantle Dockers player 430 31 26 17
120 Israel_Folau AFL Gold Coast Football Club player 423 204 14 10
121 Tomlogan44 AFL Port Adelaide Power player (male) 402 83 18 28
122 _the_kennel_ AFL Western Bulldogs fansite 382 2775 21 37
123 AFL_LHolmesby AFL AFL 379 514 23 125
123 Blueseum AFL Carlton Blues fansite 379 186 18 1466
125 paulstewy14 AFL Port Adelaide Power player (male) 376 289 19 21
126 bmsew AFL Hawthorn Hawks unofficial 367 0 24 66
127 ChrisLKnights AFL Adelaide Crows player (male) 352 29 14 11
128 bNason47 AFL Richmond Tigers player (male) 351 0 19 4
129 MelbourneFC AFL Melbourne Demons fansite 330 1 9 0
130 Cousins9 AFL West Coast Eagles former player (male) 323 148 3 112
131 mitchF15 AFL Port Adelaide Power player (male) 318 47 14 23
132 WestCoastEagles AFL West Coast Eagles unofficial 315 2 2 0
133 okeeferyan AFL Sydney Swans player (male) 311 34 14 6
134 ccaallward AFL Western Bulldogs player 310 1 33 0
135 bigfootynews AFL AFL fansite 309 139 15 141
136 demonland AFL Melbourne Demons fansite 306 566 12 209
137 go_saints AFL St. Kilda Saints fansite 304 68 13 274
138 Dockerland AFL Fremantle Dockers fansite 295 387 13 0
138 WarnieDT AFL AFL Dream Team (male) 295 1151 10 396
140 Brogsy5 AFL Port Adelaide Power player 294 29 17 49
140 Demonblog AFL Melbourne Demons fansite 294 3453 13 53
142 Brodie_Martin41 AFL Adelaide Crows player (male) 285 195 11 52
143 Lobbe23 AFL Port Adelaide Power player (male) 272 32 16 37
144 Andrew_Crowell AFL Adelaide Crows AFL Ladder Project Officer (Adelaide Crows Emcee) (SANFL Radio Commentator) 271 513 18 258
145 JoeyDaye AFL Gold Coast Football Club player 262 300 26 124
146 AFL_BenBroad AFL AFL AFL employee 256 132 17 97
147 BionicSwan AFL Sydney Swans unofficial 242 415 27 20
148 NABCup AFL AFL fansite 225 2384 23 217
148 SydAFLFan AFL Sydney Swans fan account 225 695 8 646
150 groundwork21 AFL Port Adelaide Power player (male) 213 1 13 1
151 briansham AFL Fremantle Dockers unofficial 212 38 18 12
151 dstewy43 AFL Port Adelaide Power player (male) 212 58 13 32
153 GrandstandAFL AFL AFL ABC 211 31 14 10
154 jpittard29 AFL Port Adelaide Power player (male) 206 28 12 17
155 matesOmelbourne AFL Melbourne Demons unofficial 201 25 14 22
156 6prfootball AFL AFL radio station 200 964 15 16
157 CF_Demons AFL Melbourne Demons fansite 197 344 10 106
158 AFLgf2 AFL AFL fansite 196 150 4 849
158 Saints_FC AFL St. Kilda Saints fansite 196 86 14 8
160 Marcus__White AFL North Melbourne Kangaroos player 180 33 21 27
161 wceaglesfc AFL West Coast Eagles fansite 173 110 5 55
162 MayorDT AFL AFL Dream Team (male) 172 688 12 70
163 matt_jaensch AFL Adelaide Crows player (male) 168 79 8 15
164 swansreserves AFL Canberra Sydney Swans Reserves 167 1732 8 176
165 AFL_Aus AFL AFL fansite 148 157 10 0
165 ftscrazy AFL Western Bulldogs fansite 148 329 12 29
167 adelaidefc AFL Adelaide Crows fansite 146 186 5 0
168 RWBFooty AFL St. Kilda Saints unofficial 141 539 8 79
169 StangerDT AFL AFL Dream Team (male) 137 296 9 49
170 CFC_Multimedia AFL Carlton Blues 133 50 9 112
171 melbfcblog AFL Melbourne Demons fansite 132 156 5 84
172 RoyDT AFL AFL Dream Team (male) 125 26 5 17
173 CalvinDT AFL AFL Dream Team (male) 124 41 6 7
174 ChopperDT AFL AFL Dream Team (male) 123 5 5 21
174 yellow_n_black AFL Richmond Tigers unofficial 123 1130 12 12
176 Nicksy2323 AFL Sydney Swans player (male) 119 14 6 9
177 BF_Lions AFL Brisbane Lions fansite 117 416 5 46
178 thecattery AFL Geelong Cats unofficial 112 478 8 28
179 Bradenstokes AFL AFL Player Relations Coordinator with the AFLPA 111 157 6 158
180 ACT4GWS AFL Greater Western Sydney 96 222 3 58
181 hawkaDT AFL Hawthorn Hawks fansite 94 12 4 474
181 jarrad34 AFL Port Adelaide Power player (male) 94 2 7 34
183 demonwiki AFL Melbourne Demons fansite 92 195 3 76
184 lewis_moss AFL Gold Coast Football Club player (male) 89 54 5 32
184 natskii AFL Brisbane Lions player (male) 89 667 4 173
186 AFL_MarkConway AFL AFL AFL employee 76 330 11 100
186 AFL_MikeRogers AFL AFL AFL employee 76 28 11 24
188 CatmanForever AFL Geelong Cats fansite 71 700 7 6
188 nthmelbourne AFL North Melbourne Kangaroos fansite 71 54 2 92
190 Chippa39 AFLNT AFLNT official 67 972 0 122
191 AFL_MicCullen AFL AFL AFL employee 57 234 8 1
191 VictoriaParkHC AFL Collingwood Magpies grounds 57 98 2 23
193 fake_EssendonFC AFL Essendon Bombers fansite 49 66 4 79
194 NicksBB AFL Collingwood Magpies fansite 46 6 2 64
195 MOORE_26 AFL Port Adelaide Power player (male) 45 7 4 30
196 bc8977 AFL Fremantle Dockers unofficial 42 8 9 10
197 AFL_ChrisPike AFL AFL 41 283 8 0
198 bomberblitz AFL Essendon Bombers player 40 117 1 20
199 AFL_MuzzBelkin AFL AFL AFL employee 35 137 7 0
200 AFL_CamNoakes AFL AFL 29 122 7 1
201 AFL_BenOliver AFL AFL AFL employee 28 534 7 1
201 AFL_Nschmook AFL AFL AFL employee 28 238 6 0
201 AFL_ScottBevo AFL AFL 28 126 8 2
204 AFL_Jbartold AFL AFL AFL employee 26 81 8 0
204 AFL_PaulJohnson AFL AFL AFL employee 26 118 6 4
206 AFL_Undercover AFL AFL fansite 23 27 1 116
207 SwansPerthCrew AFL Sydney Swans fan group 22 182 3 131
208 AFL_KatrinaGill AFL AFL AFL employee 21 0 5 0
208 AFL_SteveRice AFL AFL AFL employee 21 53 7 12
209 bobalski AFL Canberra Sydney Swans Reserves 19 115 3 14
210 jreynojreyno AFL Essendon Bombers player 16 11 1 25
211 AFL_StuWarren AFL AFL AFL employee 12 20 4 0
212 AFL_JOConnell AFL AFL AFL employee 10 53 5 0

Related Posts:

A social media/web snapshot of Collingwood, Hawthorn and Port Adelaide

Posted by Laura on Sunday, 14 November, 2010

Last week, I asked my Twitter followers if there was any team that anyone might data about. I said I’d pretty much be happy to dump as much of the data I have regarding those teams (or athletes) into a document that might provide some interesting insights into the teams. Even if not, it would offer benchmarks for further study. A lot of what I have is random and really depends on what sites I’m looking at, how often I update, how motivated I am get additional data, etc. I tend to go hunting when I have a purpose and those periods see an increase in specific teams. What I need rarely turns out to be what I have but that’s a challenge with creative research.

That all said and done, what my followers requested were Collingwood, Hawthorn and Port Adelaide. The links below are to the pdf files containing the data I have about them. (There might be a few small things left out.)

Related Posts:

Growth of @HawthornFC related accounts on Twitter

Posted by Laura on Saturday, 13 November, 2010

A number of times, I’ve posted most popular lists.  This table takes the data found on those charts and looks at the historical growth forHawthorn  Hawks related Twitter accounts.  (If any of these players are no longer with Hawthorn, please let me know. Conversely, if you know of any Hawthorn accounts I’m missing, let me know.) If a cell is empty, it just means that I did not collect data for that account on that date.

bmsew Hawks_AFL HawthornFC LanceFranklin lehmo23 hawkaDT BrendanWhiteX
30-Dec-09 823
9-Mar-10 100 1,336 250
30-May-10 113 1,396 2,031 SUSPENDED
16-Jun-10 110 1,402 2,151
19-Jun-10 109 1,403 2,174
24-Jun-10 2,204
25-Jun-10 2,208
26-Jun-10 3,698
29-Jul-10 132 1,446 2,597 4,010
26-Aug-10 2,919
13-Sep-10 216 1,500 3,159 4,748 89
15-Sep-10 224 1,503 3,196 4,779 90
2-Oct-10 5,092
4-Oct-10 284 1,541 3,397 5,114 88
11-Oct-10 320 1,566 3,527 5,241 86
13-Oct-10 325 1,566 3,534 5,256 89
7-Nov-10 358 1,612 3,687 5,491 88 446
11-Nov-10 363 1,618 3,713 5,548 88 466

Related Posts:

  • No Related Posts

Data dump: Australian sport on LiveJournal and its clones

Posted by Laura on Sunday, 24 October, 2010

This post is another data dump. There are some numbers that changed here. (For interests where there were zero people and zero communities interested in it, I left it off this list. This was to make the list shorter than 500.) The Adelaide Crows lost both people and communities listing them as an interest. The Brisbane Broncos also lost a person. My guess is that these losses were less a result of loss of interest in a team than account deletions because of LiveJournal policy changes. If/When they shifted to say Dreamwidth, they may not have listed the same interests or reccreated all the communities that they had belonged to. On the other hand, this could be a bit moot as the Melbourne Victory and North Melbourne Kangaroos both gained one person listing them as an interest…


Service League Team Interest Date checked Communities People
LiveJournal Super 14 ACT Brumbies ACT Brumbies 23-Oct-10 1 17
LiveJournal AFL Adelaide Crows Adelaide Crows 7-Jun-10 6 69
LiveJournal AFL Adelaide Crows Adelaide Crows 23-Oct-10 4 68
LiveJournal A-League Adelaide United Adelaide United 12-Feb-10 10
LiveJournal A-League Adelaide United Adelaide United 31-May-10 10
LiveJournal A-League Adelaide United Adelaide United 25-Jun-10 1 10
LiveJournal A-League Adelaide United Adelaide United 24-Oct-10 1 10
LiveJournal A-League Adelaide United Adelaide United 24-Oct-10 1 10
LiveJournal World Cup Soccer Albicelestes Albicelestes 22-Jun-10 3 3
LiveJournal A-League A-League A-League 25-Jun-10 3 21
LiveJournal World Cup Soccer Azzurri Azzurri 22-Jun-10 27 154
LiveJournal World Cup Soccer Bafana Bafana Bafana Bafana 22-Jun-10 2 2
LiveJournal World Cup Soccer Beli Orlovi Beli Orlovi 22-Jun-10 1 1
LiveJournal World Cup Soccer Black Stars Black Stars 22-Jun-10 1 46
LiveJournal World Cup Soccer Blue Samurai Blue Samurai 22-Jun-10 0 1
LiveJournal NRL Brisbane Broncos Brisbane Broncos 2-Jan-10 42
LiveJournal NRL Brisbane Broncos Brisbane Broncos 13-May-10 41
LiveJournal NRL Brisbane Broncos Brisbane Broncos 2-Jun-10 5 40
LiveJournal NRL Brisbane Broncos Brisbane Broncos 7-Jun-10 5 40
LiveJournal NRL Brisbane Broncos Brisbane Broncos 23-Oct-10 5 40
LiveJournal AFL Brisbane Lions Brisbane Lions 7-Jun-10 6 59
LiveJournal AFL Brisbane Lions brisbane lions 23-Oct-10 6 59
LiveJournal A-League Brisbane Roar Brisbane Roar 31-May-10 2
LiveJournal A-League Brisbane Roar (Queensland Roar) Brisbane Roar 25-Jun-10 0 2
LiveJournal A-League Brisbane Roar (Queensland Roar) Queensland Roar 25-Jun-10 3 10
LiveJournal NRL Canberra Raiders Canberra Raiders 3-Jun-10 5 28
LiveJournal NRL Canberra Raiders Canberra Raiders 21-Jun-10 5 28
LiveJournal NRL Canberra Raiders Canberra Raiders 23-Oct-10 5 30
LiveJournal NRL Canterbury-Bankstown Bulldogs Canterbury Bulldogs 23-Oct-10 3 27
LiveJournal AFL Carlton Blues Carlton Blues 7-Jun-10 5 18
LiveJournal AFL Carlton Blues Carlton Blues 23-Oct-10 5 18
LiveJournal A-League Central Coast Mariners Central Coast Mariners 31-May-10 2
LiveJournal A-League Central Coast Mariners Central Coast Mariners 24-Oct-10 1 2
LiveJournal A-League Central Coast Mariners Football Club central coast mariners 25-Jun-10 1 2
LiveJournal AFL Collingwood Magpies Collingwood Magpies 7-Jun-10 4 23
LiveJournal AFL Collingwood Magpies Collingwood Magpies 23-Oct-10 4 23
LiveJournal NRL Cronulla-Sutherland Sharks cronulla sharks 23-Oct-10 4 16
LiveJournal World Cup Soccer Die Mannschaft Die Mannschaft 22-Jun-10 1 18
LiveJournal World Cup Soccer El Tri El Tri 22-Jun-10 7 62
LiveJournal AFL Essendon Bombers Essendon Bombers 7-Jun-10 5 52
LiveJournal AFL Essendon Bombers Essendon Bombers 23-Oct-10 5 52
LiveJournal AFL Fremantle Dockers Fremantle Dockers 7-Jun-10 3 39
LiveJournal AFL Fremantle Dockers Fremantle Dockers 23-Oct-10 3 39
LiveJournal AFL Geelong Cats Geelong Cats 7-Jun-10 5 22
LiveJournal AFL Geelong Cats Geelong Cats 23-Oct-10 5 21
LiveJournal AFL Gold Coast Football Club Israel Folau 24-Oct-10 0 1
LiveJournal NRL Gold Coast Titans Gold Coast Titans 23-Oct-10 2 3
LiveJournal World Cup Soccer Guaraní Guaraní 22-Jun-10 1 2
LiveJournal AFL Hawthorn Hawks Hawthorn Hawks 7-Jun-10 4 14
LiveJournal AFL Hawthorn Hawks Hawthorn Hawks 23-Oct-10 4 15
LiveJournal World Cup Soccer La Albirroja La Albirroja 22-Jun-10 1 1
LiveJournal World Cup Soccer La Celeste La Celeste 22-Jun-10 0 2
LiveJournal World Cup Soccer La Furia Roja La Furia Roja 22-Jun-10 9 59
LiveJournal World Cup Soccer La Nazionale La Nazionale 22-Jun-10 1 4
LiveJournal World Cup Soccer La Roja La Roja 22-Jun-10 2 13
LiveJournal World Cup Soccer La Seleccion La Seleccion 22-Jun-10 10 62
LiveJournal World Cup Soccer Les Bleus Les Bleus 22-Jun-10 8 57
LiveJournal NRL Manly-Warringah Sea Eagles manly sea-eagles 23-Oct-10 2 1
LiveJournal NRL Manly-Warringah Sea Eagles manly sea eagles 23-Oct-10 1 10
LiveJournal Women’s World Cup Soccer Matildas Matildas 25-Jun-10 1 6
LiveJournal Women’s World Cup Soccer Matildas Matildas 24-Oct-10 1 5
LiveJournal AFL Melbourne Demons Melbourne Demons 25-Feb-10 26
LiveJournal AFL Melbourne Demons Melbourne Demons 13-May-10 26
LiveJournal AFL Melbourne Demons Melbourne Demons 7-Jun-10 5 25
LiveJournal AFL Melbourne Demons Melbourne Demons 23-Oct-10 5 25
LiveJournal NRL Melbourne Storm Melbourne Storm 2-Jun-10 5 25
LiveJournal NRL Melbourne Storm Melbourne Storm 23-Oct-10 5 25
LiveJournal NRL Melbourne Storm Melbourne Storm 10-Jan-10 25
LiveJournal NRL Melbourne Storm Melbourne Storm 10-May-10 25
LiveJournal A-League Melbourne Victory Melbourne Victory 27-Feb-10 24
LiveJournal A-League Melbourne Victory Melbourne Victory 27-Feb-10 24
LiveJournal A-League Melbourne Victory Melbourne Victory 13-May-10 24
LiveJournal A-League Melbourne Victory Melbourne Victory 31-May-10 24
LiveJournal A-League Melbourne Victory Melbourne Victory 25-Jun-10 1 25
LiveJournal A-League Melbourne Victory Melbourne Victory 1-Jul-10 1 25
LiveJournal A-League Melbourne Victory Melbourne Victory 24-Oct-10 1 25
LiveJournal World Cup Soccer National Mannschaft National Mannschaft 22-Jun-10 0 4
LiveJournal World Cup Soccer Nationalmannschaft Nationalmannschaft 22-Jun-10 18 107
LiveJournal NRL New Zealand Warriors new zealand warriors 23-Oct-10 3 4
LiveJournal A-League Newcastle Jets Newcastle Jets 25-Jun-10 2 5
LiveJournal A-League Newcastle Jets Newcastle Jets 24-Oct-10 2 5
LiveJournal NRL Newcastle Knights newcastle knights 23-Oct-10 5 74
LiveJournal AFL North Melbourne Kangaroos North Melbourne Kangaroos 7-Jun-10 0 12
LiveJournal AFL North Melbourne Kangaroos North Melbourne Kangaroos 23-Oct-10 0 13
LiveJournal NRL North Queensland Cowboys north queensland cowboys 23-Oct-10 5 20
LiveJournal A-League North Queensland Fury FC North Queensland Fury 25-Jun-10 0 1
LiveJournal A-League North Queensland Fury FC North Queensland Fury 24-Oct-10 0 1
LiveJournal World Cup Soccer Oranje Oranje 22-Jun-10 14 95
LiveJournal NRL Parramatta Eels parramatta eels 23-Oct-10 3 47
LiveJournal NRL Penrith Panthers penrith panthers 23-Oct-10 4 34
LiveJournal A-League Perth Glory Perth Glory 25-Jun-10 2 13
LiveJournal A-League Perth Glory Perth Glory 24-Oct-10 2 13
LiveJournal AFL Port Adelaide Power Port Adelaide Power 7-Jun-10 4 10
LiveJournal AFL Port Adelaide Power Port Adelaide Power 23-Oct-10 4 10
LiveJournal A-League Queensland Roar (Brisbane Roar) Queensland Roar (Brisbane Roar) 17-Feb-10 10
LiveJournal A-League Queensland Roar (Brisbane Roar) Queensland Roar 24-Oct-10 3 10
LiveJournal A-League Queensland Roar (Brisbane Roar) Brisbane Roar 24-Oct-10 0 2
LiveJournal AFL Richmond Tigers Richmond Tigers 7-Jun-10 4 18
LiveJournal AFL Richmond Tigers Richmond Tigers 23-Oct-10 4 17
LiveJournal World Cup Soccer Seleção Seleção 22-Jun-10 1 6
LiveJournal World Cup Soccer Socceroos Socceroos 14-May-10 102
LiveJournal World Cup Soccer Socceroos Socceroos 15-May-10 102
LiveJournal World Cup Soccer Socceroos Socceroos 28-May-10 102
LiveJournal World Cup Soccer Socceroos Socceroos 3-Jun-10 6 102
LiveJournal World Cup Soccer Socceroos Socceroos 17-Jun-10 6 102
LiveJournal World Cup Soccer Socceroos Tim Cahill 17-Jun-10 7 59
LiveJournal World Cup Soccer Socceroos Socceroos 22-Jun-10 6 101
LiveJournal World Cup Soccer Socceroos Socceroos 24-Oct-10 6 101
LiveJournal World Cup Soccer Socceroos Tim Cahill 24-Oct-10 7 59
LiveJournal NRL South Sydney Rabbitohs south sydney rabbitohs 23-Oct-10 4 14
LiveJournal NRL St George Illawarra Dragons st george illawarra dragons 23-Oct-10 2 7
LiveJournal AFL St Kilda Saints St Kilda Saints 7-Jun-10 4 16
LiveJournal AFL St Kilda Saints st kilda saints 23-Oct-10 4 16
LiveJournal AFL St Kilda Saints st. kilda saints 23-Oct-10 1 4
LiveJournal AFL St. Kilda Saints st. kilda 26-May-10 12
LiveJournal AFL St. Kilda Saints st. kilda saints 26-May-10 3
LiveJournal AFL St. Kilda Saints st kilda saints 26-May-10 16
LiveJournal AFL St. Kilda Saints st kilda 26-May-10 94
LiveJournal AFL St. Kilda Saints St. Kilda Saints 7-Jun-10 1 3
LiveJournal AFL St. Kilda Saints st kilda 24-Oct-10 6 91
LiveJournal AFL St. Kilda Saints st. kilda 24-Oct-10 3 11
LiveJournal A-League Sydney FC Sydney FC 25-Jun-10 2 25
LiveJournal A-League Sydney FC Sydney FC 24-Oct-10 2 26
LiveJournal NRL Sydney Roosters sydney roosters 23-Oct-10 5 41
LiveJournal AFL Sydney Swans Sydney Swans 7-Jun-10 6 102
LiveJournal AFL Sydney Swans sydney swans 23-Oct-10 6 100
LiveJournal World Cup Soccer Taeguk Warriors Taeguk Warriors 22-Jun-10 0 2
LiveJournal World Cup Soccer The Red Devils The Red Devils 22-Jun-10 2 7
LiveJournal World Cup Soccer Three Lions Three Lions 22-Jun-10 2 14
LiveJournal World Cup Soccer USMNT USMNT 22-Jun-10 6 71
LiveJournal A-League Wellington Phoenix Wellington Phoenix 25-Jun-10 0 1
LiveJournal A-League Wellington Phoenix Wellington Phoenix 24-Oct-10 0 2
LiveJournal AFL West Coast Eagles West Coast Eagles 7-Jun-10 3 99
LiveJournal AFL West Coast Eagles West Coast Eagles 23-Oct-10 3 98
LiveJournal AFL Western Bulldogs Western Bulldogs 25-Feb-10 21
LiveJournal AFL Western Bulldogs Western Bulldogs 1-Jun-10 5 22
LiveJournal AFL Western Bulldogs jason akermanis 1-Jun-10 2 2
LiveJournal AFL Western Bulldogs Western Bulldogs 2-Jun-10 5 22
LiveJournal AFL Western Bulldogs Western Bulldogs 7-Jun-10 5 22
LiveJournal AFL Western Bulldogs Western Bulldogs 24-Jun-10 5 22
LiveJournal AFL Western Bulldogs Julia Gillard 24-Jun-10 5 13
LiveJournal AFL Western Bulldogs jason akermanis 24-Jun-10 2 2
LiveJournal AFL Western Bulldogs Western Bulldogs 23-Oct-10 5 23
LiveJournal AFL Western Bulldogs jason akermanis 24-Oct-10 2 2
LiveJournal AFL Western Bulldogs Julia Gillard 24-Oct-10 5 14
LiveJournal NRL Wests Tigers wests tigers 23-Oct-10 4 24
LiveJournal W-League W-League W-League 1-Jun-10 1
LiveJournal W-League W-League W-League 25-Jun-10 0 1
InsaneJournal AFL Adelaide Crows Adelaide Crows 24-Oct-10 0 3
InsaneJournal AFL Brisbane Lions brisbane lions 24-Oct-10 0 1
InsaneJournal AFL Fremantle Dockers Fremantle Dockers 24-Oct-10 0 2
InsaneJournal AFL Hawthorn Hawks Hawthorn Hawks 24-Oct-10 0 1
InsaneJournal NRL Newcastle Knights newcastle knights 24-Oct-10 0 1
InsaneJournal AFL North Melbourne Kangaroos North Melbourne Kangaroos 24-Oct-10 0 1
InsaneJournal NRL North Queensland Cowboys north queensland cowboys 24-Oct-10 0 1
InsaneJournal World Cup Soccer Socceroos Socceroos 14-May-10 3
InsaneJournal World Cup Soccer Socceroos Socceroos 24-Oct-10 0 3
InsaneJournal AFL St Kilda Saints st. kilda saints 24-Oct-10 0 1
InsaneJournal AFL West Coast Eagles West Coast Eagles 24-Oct-10 0 3
InsaneJournal AFL Western Bulldogs Western Bulldogs 24-Jun-10 0 1
InsaneJournal AFL Western Bulldogs Western Bulldogs 24-Oct-10 0 1
Dreamwidth AFL Adelaide Crows Adelaide Crows 7-Jun-10 0 4
Dreamwidth AFL Adelaide Crows Adelaide Crows 23-Aug-10 0 4
Dreamwidth AFL Adelaide Crows Adelaide Crows 24-Oct-10 0 4
Dreamwidth A-League A-League A-League 25-Jun-10 0 1
Dreamwidth A-League A-League A-League 23-Aug-10 0 1
Dreamwidth World Cup Soccer Azzurri Azzurri 22-Jun-10 0 2
Dreamwidth NRL Brisbane Broncos Brisbane Broncos 7-Jun-10 0 1
Dreamwidth NRL Brisbane Broncos Brisbane Broncos 24-Oct-10 0 1
Dreamwidth AFL Brisbane Lions Brisbane Lions 7-Jun-10 0 1
Dreamwidth AFL Brisbane Lions Brisbane Lions 23-Aug-10 0 1
Dreamwidth AFL Brisbane Lions brisbane lions 24-Oct-10 0 1
Dreamwidth World Cup Soccer Die Mannschaft Die Mannschaft 22-Jun-10 0 2
Dreamwidth World Cup Soccer El Tri El Tri 22-Jun-10 0 1
Dreamwidth AFL Fremantle Dockers Fremantle Dockers 7-Jun-10 0 1
Dreamwidth AFL Fremantle Dockers Fremantle Dockers 23-Aug-10 0 1
Dreamwidth AFL Fremantle Dockers Fremantle Dockers 24-Oct-10 0 1
Dreamwidth World Cup Soccer La Furia Roja La Furia Roja 22-Jun-10 0 1
Dreamwidth World Cup Soccer La Seleccion La Seleccion 22-Jun-10 0 2
Dreamwidth NRL Melbourne Storm Melbourne Storm 24-Oct-10 0 2
Dreamwidth NRL Melbourne Storm Melbourne Storm 9-Jan-10 2
Dreamwidth World Cup Soccer Nationalmannschaft Nationalmannschaft 22-Jun-10 0 3
Dreamwidth NRL Newcastle Knights newcastle knights 24-Oct-10 0 3
Dreamwidth AFL North Melbourne Kangaroos North Melbourne Kangaroos 7-Jun-10 0 1
Dreamwidth AFL North Melbourne Kangaroos North Melbourne Kangaroos 23-Aug-10 0 1
Dreamwidth AFL North Melbourne Kangaroos North Melbourne Kangaroos 24-Oct-10 0 1
Dreamwidth World Cup Soccer Oranje Oranje 22-Jun-10 1 3
Dreamwidth World Cup Soccer Schweizer Nati Schweizer Nati 22-Jun-10 0 1
Dreamwidth World Cup Soccer Socceroos Socceroos 14-May-10 3
Dreamwidth World Cup Soccer Socceroos Socceroos 28-May-10 3
Dreamwidth World Cup Soccer Socceroos Socceroos 7-Jun-10 0 3
Dreamwidth World Cup Soccer Socceroos Tim Cahill 17-Jun-10 0 1
Dreamwidth World Cup Soccer Socceroos Socceroos 17-Jun-10 0 3
Dreamwidth World Cup Soccer Socceroos Socceroos 22-Jun-10 0 3
Dreamwidth World Cup Soccer Socceroos Socceroos 25-Jun-10 0 3
Dreamwidth World Cup Soccer Socceroos Socceroos 23-Aug-10 0 3
Dreamwidth World Cup Soccer Socceroos Socceroos 24-Oct-10 0 3
Dreamwidth World Cup Soccer Socceroos Tim Cahill 24-Oct-10 0 2
Dreamwidth AFL St Kilda Saints St Kilda Saints 7-Jun-10 0 1
Dreamwidth AFL St Kilda Saints St Kilda Saints 23-Aug-10 0 1
Dreamwidth AFL St Kilda Saints st kilda saints 24-Oct-10 0 1
Dreamwidth NRL Sydney Roosters sydney roosters 24-Oct-10 0 1
Dreamwidth AFL Sydney Swans Sydney Swans 7-Jun-10 0 1
Dreamwidth AFL Sydney Swans Sydney Swans 23-Aug-10 0 1
Dreamwidth AFL Sydney Swans sydney swans 24-Oct-10 0 1
Dreamwidth World Cup Soccer Three Lions Three Lions 22-Jun-10 0 1
Dreamwidth W-League W-League W-League 1-Jun-10 1
Dreamwidth W-League W-League W-League 25-Jun-10 0 1
Dreamwidth W-League W-League W-League 23-Aug-10 0 1
Dreamwidth W-League W-League W-League 24-Oct-10 0 1
DeadJournal NRL Melbourne Storm Melbourne Storm 23-Dec-09 1
DeadJournal World Cup Soccer Socceroos Socceroos 14-May-10 1
Blurty NRL Melbourne Storm Melbourne Storm 9-Jan-10 1

Related Posts:

What #afl related hashtags get the most RT @ ReTweets?

Posted by Laura on Sunday, 15 August, 2010

While on vacation, a friend of mine recommended I read Want to be Retweeted? Add Hashtags to Your Tweets! The article is rather interesting and looks at the #hashtags that led to the most ReTweets.

I have a collection of AFL related tweets that I update semi-regularly. More often than not, I use these for geographic related analysis. My AFL tweet collection has a series of issues though that make me hesitant to always draw definitive conclusions from it. These issues include:

  • Incomplete tweet set for keywords: I only get what is available from Searchtastic.
  • Incomplete tweet set based on keyword limitations: Even supposing I could get all the tweets related to a keyword, I can’t find every reference to the AFL as there are too many possible words that could reference the AFL and its clubs.
  • Incomplete tweet set because of time: Some keywords were searched for earlier and some later. Not all keywords were looked at over the same period.
  • Irrelevant tweets: Keywords like #gosaints may refer to the St. Kilda Saints or the New Orleans Saints. AFL may refer to the AFL-CIO, a union in the United States. Unless every tweet is examined, irrelevant tweets will remain in the data set.

These are major obstacles to doing any sort of content analysis for Twitter when specific subgroups are looked at. Many of these issues are ones that other researchers are likely to have too: You can’t get the complete data set, will include garbage data and may not be entirely timely.

That said, despite these limitations, I still wanted to know what are the most popular #hashtags for AFL related tweets and what type of hashtags are likely to be ReTweeted.

To get my dataset of Tweets, first I went to Searchtastic, ran a series of searches over the course of 6 weeks, and exported those results to Excel. I noted the keyword I searched for and the team that keyword is related to. The keyword searches that were run on Searchtastic during this period included: #afl, #aflbluestigers, #aflcatslions, #afldemonsswans, #afldogscats, #afldogsfreo, #afldogspower, #afleaglesblues, #aflfooty, #aflhawksdemons, #aflkangasbombers, #aflkangasfreo, #AFLPAQUIZ, #aflpiestigers, #aflpowercrows, #aflpowereagles, #aflsaintshawks, #aflswanshawks , #brisbanelions, #dreamteam, #footy, #fremantle, #freo, #freo AFL, #goblues, #gobombers, #Gocats, #gocrows, #gopies, #gosaints, #goswans, #NMFC, #northmelbourne, #sackermanis, #supercoach, #sydneyswans, #teamgws, #thekennel, #wafl, #westcoast afl, ackermanis sacked, ACT4GWS, Adelaide Crows, Adelaide_FC, afl Bombers, AFL GWS, AFL Magpies, afl pies, AFL Tony Lockett, Aker Bulldogs, Akermanis, akermanis dogs, akermanis gillard, Australian rules, blues afl, Brad Johnson, Brad Johnson AFL, Brady Rawlings, brisbane afl, Brisbane Lions, Brownlow Medal, Cameron Mooney cats, Carlton Blues, Chris Judd Carlton, Collingwood, collingwood AFL, Collingwood Magpies, crows afl, Damien Hardwick, DemonsHQ, Dockers AFL, eagles afl, eagles perth, Eric Mackenzie , Essendon afl, Essendon Bombers, etihad kilda, folau afl, folau israel, Fremantle Dockers, fremantle ruckman, GCFC, geelong cats, Gold Coast Suns, harry_o, Hawthorn Hawks, HawthornFC, Jason Akermanis, Jeff Kennett, Judd Blues, kilda, kilda AFL, kilda riewoldt, lions afl, Mark Harvey, mcg kilda, Melbourne Demons, milburn cats, Nathan van Berlo Crows, North Melbourne Kangaroos, PAFC, Peter Szental, Port Adelaide Power, portadelaidefc, Richmond Football, Richmond Tigers, Rodney Eade dogs, roos afl, sackermanis, spoon eagles, spoon lions, spoon tigers, spoon wce, swans afl, swans footy, swans ruckman, Sydney Swans, tigers afl, Travis Johnstone, Trent Cotchin, WCE AFL, West Coast Eagles, and Western Bulldogs. These keywords represent all teams and often include multiple keywords for them.

The next step was to remove all duplicate tweets. As some tweets contain multiple keywords and some searches were run more than once over that 6-week time period, that possibility existed. To do this, three columns were copy and pasted to a new worksheet: Username, Tweet and In Reply To. On Excel, I did this using Filter -> Advanced Filter -> Unique records only. This process took the total tweets from 8,523 to 5,427.

The third step was to identify all the hash tags used in this data set. To do this, I copy and pasted all the tweets to Notepad. I ran a find and replace for [space]# and replaced with [tab]#. I copy and pasted these back, removed all cells that did not start with a #. After this was done, the data set was copy and pasted back to Notepad. Another find and replace was done, this time, [space] was replaced with [tab]. This was pasted back to excel and all cells that did not start with # were deleted. The completed list was 2,833 total hashtags used. Of these, 556 were unique. The following table counts their total usage:

Hashtag Total times used
#afl 724
#gosaints 110
#gocats 84
#DreamTeam 79
#aflswanshawks 53
#aflpiestigers 51
#aflpowereagles 51
#afldogscats 47
#aflfooty 46
#aflsaintshawks 45
#footy 44
#aflhawksdemons 43
#aflbluestigers 41
#aflcatslions 41
#afleaglesblues 41
#AFLPAQUIZ 39
#aflkangasfreo 38
#brisbanelions 38
#aflkangasbombers 36
#GoSwans 35
#Goblues 34
#ausvotes 33
#gopies 31
#ff 28
#afldogsfreo 25
#Essendon 21
#GoBombers 20
#afldemonsswans 18
#Fremantle 17
#SuperCoach 17
#afllionscrows 16
#adelaide 15
#aflpowercrows 14
#news 13
#thekennel 12
#football 10
#Sackermanis 9
#11BOYS 8
#afllionssaints 8
#AUG21STCLUBVENUS 8
#Blues 8
#collingwood 8
#GUAPGANG 8
#Hawks 8
#HNG 8
#Lions 8
#Australia 7
#Dockers 7
#fb 7
#freo 7
#sports 7
#wce 7
#aker 6
#jobs 6
#lost 6
#NMFC 6
#ABC 5
#aflbluesdogs 5
#Chelsea 5
#Eng 5
#NorthMelbourne 5
#pafc 5
#wafl 5
#aflbombersblues 4
#aflfreoswans 4
#akermanis 4
#blog 4
#bombers 4
#Bulldogs 4
#DOPEVIDEOALERT!! 4
#fail 4
#GOPIES! 4
#gopies!! 4
#GOSAINTS! 4
#gws 4
#pies 4
#sport 4
#worldcup 4
#aflcatshawks 3
#aflcrowscats 3
#afleagleslions 3
#argyleman 3
#beer 3
#bj008 3
#Crows 3
#dogs 3
#dss10 3
#footyshow 3
#Freelance 3
#Gillard 3
#goldcoast 3
#Light 3
#Melbourne 3
#plymouth 3
#sagreat 3
#sydneyswans 3
#tcot 3
#travel 3
#wa 3
#WORDPRESS 3
#17Julay 2
#afl: 2
#AFLCIO 2
#aka 2
#akermanis, 2
#alp 2
#Apple 2
#AstonVilla 2
#BERBATOV 2
#brisbane 2
#Carlton 2
#CarltonFC 2
#CATS 2
#CFL 2
#Chargers 2
#Chile 2
#Cousins 2
#DREAMTEAM!!! 2
#DT 2
#Eagles 2
#economist 2
#FERGUSON 2
#FollowFriday 2
#footyfriday 2
#gno 2
#GOBLUES! 2
#goCats! 2
#GOCROWS 2
#gosaints. 2
#Hamburg 2
#Health 2
#Idontthinkso 2
#Illegal 2
#job 2
#kentucky 2
#lastfm 2
#lp’s 2
#magpies 2
#mofo 2
#Monday 2
#monkbeer 2
#NBA 2
#New 2
#Obesity 2
#online 2
#P2 2
#ROONEY 2
#Soccer 2
#Sportal 2
#suns 2
#Sydney 2
#TeamFollowBack 2
#Þ¹ Óù²_ 2
#thefootyshow 2
#throughandthrough 2
#Tigers 2
#TT 2
#WhoDat 2
# 1
#011 1
#1 1
#1, 1
#15 1
#17 1
#2. 1
#2010 1
#3 1
#3DAL 1
#6 1
#6insolidaity 1
#7 1
#ABCnews24 1
#adelaide, 1
#adversity 1
#af… 1
#AFL! 1
#AFL, 1
#afl. 1
#Aflac 1
#aflbulldogscats 1
#aflcatspies 1
#aflcionow 1
#afldemonsbombers 1
#afldemonsswans. 1
#afldogscats101 1
#afldogskangas 1
#afldogspower 1
#afleaglesfreo 1
#AFLfootyshow 1
#aflhawksdogs 1
#aflordapele 1
#AFLPA 1
#AFLPAQUIZ. 1
#aflpiestigers. 1
#aflsaintshawks. 1
#afrodigital 1
#akergate. 1
#Akermanis. 1
#akermankiss 1
#Albania 1
#A-League 1
#alfsaintshawks 1
#AlfStewart 1
#allday 1
#AllieGentry 1
#annoyingquestion 1
#Argyle 1
#ArizonaFallLeague 1
#Art 1
#Astros 1
#AUG28THHIGHLANDPARK 1
#aussiemigration 1
#Autocar 1
#avidfan 1
#BagelTuesday 1
#bankshowdown 1
#Barcelona 1
#Basketball 1
#batman 1
#BBB 1
#BBB, 1
#bcfc 1
#BEATthebotssss 1
#beenthere 1
#Belgium 1
#BELIEVE 1
#BENNY 1
#betchaknowem 1
#beu 1
#BigFooty 1
#blessings 1
#bmb 1
#boomers 1
#Bordeaux 1
#boulen10? 1
#breakuplines 1
#Bremen 1
#Briggswentdownlike 1
#BrisbaneLions! 1
#BrisbaneLions. 1
#broncos 1
#brugerdisken 1
#Brumbies 1
#caa 1
#cannes 1
#Canterbury-Bankstown 1
#carnbombers 1
#Celtic 1
#CERN 1
#CERTIFIED 1
#championship 1
#Cheetahs 1
#chi 1
#cliffhanghaunters 1
#Climate 1
#CNNHeroes. 1
#cocaine 1
#Coffee 1
#Collingwood. 1
#Collingwood: 1
#collingwoodfc 1
#Colombia 1
#Conservation 1
#conservative. 1
#cop15 1
#Corvette 1
#cowboys 1
#coworking 1
#crazyideas 1
#cubs 1
#deals 1
#deetrain!) 1
#defense 1
#Demetriou 1
#dicaduca 1
#diet 1
#doublestandard 1
#draft 1
#draw365 1
#DREAMTEAM- 1
#DREAMTEAM! 1
#DREAMTEAM!!!!! 1
#DREAMTEAM!!!!!!! 1
#DREAMTEAM!!!!!!!!! 1
#DREAMTEAM!GET 1
#dreamteam(u 1
#DreamTeam, 1
#dreamteam..like 1
#dreamteam2010 1
#dreamteam2010(Ur 1
#drmtm 1
#druggies 1
#Duck 1
#duh 1
#duisburg 1
#dumb 1
#Eagles. 1
#ecommerce 1
#ecommretail 1
#EdeActueel 1
#efficiënt 1
#elmundial 1
#elvisfest 1
#ems 1
#emt 1
#England 1
#epic 1
#EquipedelaRêve 1
#ESPN3: 1
#everyday 1
#everyoneshappy 1
#excitedtweet 1
#faic 1
#fanniemae 1
#fascinating 1
#fat 1
#FCTwente 1
#FcukFranklin 1
#fd10p2m 1
#Fev 1
#FFGLBS 1
#FIFA 1
#fireupdons 1
#fitness 1
#flag 1
#flagship 1
#flash 1
#Flight 1
#flotilla 1
#FLYSTLYE 1
#FollowNow 1
#footyclassified 1
#footyOne 1
#footyshow. 1
#footyteammovies 1
#forçafluminense 1
#FoxFooty 1
#Foxtel 1
#free 1
#Freelancer 1
#freeweezy 1
#freo. 1
#freshen 1
#FridayFwit. 1
#fromtheouter 1
#Fuckem
%- %(
1
#fuckyeah 1
#Gabon 1
#gallery: 1
#game 1
#Gaza 1
#GCFC 1
#Geelong 1
#GeelongCats 1
#GER, 1
#GERONIMO 1
#GGMU 1
#GOAT 1
#GoBears 1
#goBears! 1
#GOBLUES. 1
#GOCHELSEA 1
#GOGIANTS 1
#gopies!!! 1
#GoSaints!! 1
#gosaintsFC 1
#gostkilda 1
#GoSwans! 1
#GoSwans!!! 1
#gothepies 1
#green, 1
#GroenWerkt 1
#GUCCI 1
#guitar 1
#Haiku 1
#haiti: 1
#HamOnt 1
#handig 1
#Hanley. 1
#HardMan 1
#harry-o 1
#hawks#Hawthorn#AFL 1
#Hawthorn 1
#hcr, 1
#healthybusiness, 1
#healthyliving 1
#hiring 1
#History 1
#hnw 1
#Hockey 1
#HOLIDAY 1
#hollin 1
#homepark 1
#hotels 1
#HTC 1
#humor 1
#iConfess 1
#i’dliketoseethat! 1
#ihatecollingwood 1
#ihatequotes 1
#ihaveadream 1
#IloveagoodConspiracryTheory 1
#imabitscared 1
#immaturelittleboy 1
#in 1
#inception, 1
#IndianapolisColts 1
#Insiders: 1

The next step was to count the total @ replies and hashtag uses. To do this, all the unique tweets were copied to a new worksheet. A filter was created to list all tweets that did not include an @ sign. These tweets were deleted. This brought the total tweets from 5,427 to 1,844. The next step was to create a filter to show all tweets that did not include a #. These tweets were then deleted. This brought the total Tweets down to 832. The next step was to look remove tweets that did not contain “RT @”, “RT:@”, “retweeting @”, “retweet @”, “via @”, “thx @”, “HT @”, or “r @”. This leaves 458 tweets that are retweets that contain hash tags.

The same process was conducted to count the hash tags that was used for all hash tags and RT @. The following list was created of people who were the most ReTweeted (or mentioned in the ReTweeted tweet) where the tweets contained #hashtags and the #hashtag totals for ReTweets. These were then totaled and counted, resulting in the following table:

Hashtag Count ReTweeted Count
#GOSAINTS 37 @afl 44
#DreamTeam 36 @Carlton_FC 24
#GoCats 26 @stkildafc 23
#AFL 25 @hawthornfc 16
#afleaglesblues 21 @Essendon_FC 15
#pafc 20 @Geelong_FC 12
#aflkangasbombers 19 @sydneyswans 12
#aflpiestigers 18 @iamdiddy 10
#aflsaintshawks 18 @Richmond_FC 9
#aflswanshawks 17 @AFLPA 8
#ausvotes 12 @Adelaide_FC 7
#aflpowereagles 10 @JuliaGillard 7
#AflKANGASfreo 9 @northkangaroos 7
#brisbanelions 9 @_the_kennel_ 6
#NMFC 8 @bigmacvikings 6
#sackermanis 8 @Collingwood_FC 6
#thekennel 8 @dizzyyet 6
#Adelaide 7 @redcafesd 6
#aflcatslions 7 @seanpaull 6
#afllionssaints 7 @aflcio 5
#aflhawksdemons 6 @Gottrocks 5
#AFLPAQUIZ 6 @myfabolouslife 5
#aflpowercrows 6 @PAFC 5
#11BOYS 5 @triplemfooty 5
#GoBombers 5 @AFLStatsGuys 4
#GoPies 5 @AveStarLJ 4
#P2 5 @Bickys 4
#tcot 5 @Bigdroppunt 4
#travel 5 @Blonde_Cheeks 4
#afldemonsswans 4 @CatsInsider 4
#fremantle 4 @crowdiegal 4
#gopies!! 4 @DemonsHQ 4
#goswans 4 @DjPaniic 4
#lions 4 @Fremantle_FC 4
#soccer 4 @jletti 4
#tags: 4 @JOEYCRACKTS 4
#throughandthrough 4 @SENNews 4
#afldogsfreo 3 @tabloidterror 4
#aker 3 @tedwards2 4
#akermanis 3 @THEjennykim 4
#AUG21STCLUBVENUS 3 @themonkbeer 4
#beer 3 @tjrharley 4
#ecfc 3 @aburt 3
#ENG 3 @charlenemay 3
#FF 3 @drwarwick 3
#GUAPGANG 3 @Footyfree 3
#HNG 3 @fromtheouter 3
#monkbeer 3 @garethdn 3
#sewelliscool 3 @mydogateart 3
#SydneySwans 3 @NikkiRoks 3
#WhoDat 3 @pluke17 3
#worldcup 3 @rachii_10 3
#aflbluestigers 2 @rickyrozay 3
#afleagleslions 2 @RTTF_AU 3
#aflfooty 2 @StadiumMustard 3
#aka 2 @TLW3 3
#argyleman 2 @trmash 3
#bj008 2 @afletch5 2
#bulldogs 2 @AFLNewsWire 2
#dogs 2 @AlexBrink10 2
#DOPEVIDEOALERT!! 2 @alexhart7 2
#dreamteam2010 2 @andrewbolt 2
#footy 2 @angiemartinez 2
#footyfriday 2 @annielin 2
#footyshow 2 @BradJohnson6 2
#Fuckem
%- %(
2 @BrigandLehmo 2
#Gillard 2 @brotheramos 2
#GoBears 2 @CalAthletics 2
#Goblues 2 @catsman09 2
#Illegal 2 @ChristophHewett 2
#lp 2 @DaRealRoot 2
#nowplaying 2 @Diamonds_Pearlz 2
#plymouth 2 @DreamTeamatl_TK 2
#putthatinyourpipeandsmokeit 2 @DT_13 2
#ROCGiRLs 2 @EdMorrissey 2
#sagreat 2 @emmat18 2
#supercoach 2 @EssendonBomber 2
#thefootyshow 2 @FakeWoosha 2
#TwoDat 2 @globoesportecom 2
#wce 2 @HaroldKuepers. 2
#1, 1 @hawthornfc15 2
#accommodation 1 @iAmRozayyy 2
#aflak 1 @j_carroll7 2
#aflcrowscats 1 @JAE_MILLZ 2
#afldogscats 1 @jasminewright96 2
#aflfreoswans 1 @jazzpafc 2
#AFLPA 1 @jeeziiroqk 2
#alp 1 @jimmywa11 2
#Argyle 1 @jmf27614 2
#Art 1 @jonboy79 2
#bankshowdown 1 @jonpierk 2
#BELIEVE 1 @jrwilliams22 2
#BENNY 1 @JsMiLeZ10 2
#BERBATOV 1 @kaatieee27 2
#BigFooty 1 @keithpitty 2
#BLOG 1 @Ladder_) 2
#boomers 1 @LEGITBOSS 2
#Briggswentdownlike 1 @letoyaluckett 2
#Celtic 1 @Lizziemcbizzie 2
#CERTIFIED 1 @M3lizza 2
#CFL 1 @milo317 2
#Chile 1 @MMMGUNNA 2
#Collingwood. 1 @MRS_MERCHANT 2
#CRS 1 @mstiffington 2
#cubs 1 @NeL_DTF 2
#deetrain! 1 @nick_wade 2
#draw365 1 @NICKIMINAJ 2
#DT 1 @NiKKi_E13 2
#Essendon 1 @noisyinstrument 2
#FERGUSON 1 @plymouthcc 2
#Flecoat 1 @ranyunfei 2
#Flight 1 @reggie_bush 2
#FLYSTLYE 1 @ruanji 2
#FollowNow 1 @SarahStanley 2
#Football 1 @SharinaBurns 2
#GERONIMO 1 @shelleyjames 2
#GGMU 1 @ShunnyBun 2
#glennbeck 1 @StadiumHero 2
#GOGIANTS 1 @SuadeMusic 2
#gop 1 @TalentedInk 2
#GoPies! 1 @TalkingCarlton 2
#GoSaints!!!! 1 @tech45cast 2
#gosaintsFC 1 @tgrant20 2
#gostkilda 1 @the_tony 2
#green, 1 @TheCONDO 2
#GUCCI 1 @therealsmoir 2
#haiti: 1 @TheRealYungBerg 2
#Hawks 1 @TheVoyuer 2
#healthybusiness 1 @thisgirlrox 2
#healthyliving 1 @thisischile 2
#hiring 1 @thisisScoMan 2
#HOLIDAY 1 @timvl 2
#HTC 1 @tip66 2
#ihaveadream 1 @tkpleslie 2
#in 1 @TrendsMelbourne 2
#Inter 1 @UnitedWayTC 2

Based on this sample, (because the whole of the population of AFL tweets is not available and cannot the total cannot be counted to determine the representative value of the sample) the most RTed #hashtag in a Tweet related to the AFL is #gosaints. #dreamteam comes in second. #gocats comes in third. #afl comes in fourth.

The #gosaints tag is popular and the team’s official account has encouraged its use. More recently, New Orleans Saints fans have used it as the NFL pre-season has started. #dreamteam is one of the two most popular AFL fantasy leagues and those fantasy leagues are big into fostering community. Beyond these top four, the most popular tags tend to involve specific match ups. If all tags related to match ups had been included around the time that the games took place, it is highly possible more would be on that list.

In terms of who gets RTed and mentioned in ReTweets, official accounts dominate: The AFL, Carlton, St. Kilda, Hawthorn, the Bombers, Geelong and the Swans. The first non-team account to appear is P. Diddy and he is followed by a number of influential Australian social media people. The next person / non-official AFL account to appear is Julia Gillard. AFL players do not appear to be ReTweeted en masse when compared to their club sides. This isn’t to say that people don’t actively read and follow them. If looking at ReTweets without #hashtags, @harry_o would appear on top with 50 mentions. It is probable that clubs are using #hashtags and players are not; there could be a digital cultural awareness divide between the two.

A copy of the data and some of my step by step process making it workable can be found at RTAFL.xls. I find the whole thing really interesting. If anyone has any tools to make dataming easier or has a suggestion for additional research in this area, let me know as I’d love to hear it.

Related Posts:

Sport allegiances out on the Great Barrier Reef

Posted by Laura on Wednesday, 11 August, 2010

One of my favorite hobbies when out and about is to look at people’s shirts, hats, jackets, backpacks and scarves to see what sport teams are represented. It can be really interesting. (Clothes say a lot about a person at times. And sport related clothing can to. Why people wear things can involve a conscious fashion decision, because they visited the place where the team is based, because they want to be affiliated with the team or a city, in order to have conversations, because their team is winning, etc.) In Canberra, you’re just as likely to see a Hawthown Hawks as you are the Brisbane Broncos or the All Blacks as you are to see the Canberra Raiders or ACT Brumbies. It makes the game of sport clothing watching a bit more fun.

Yesterday, I went out on the Great Barrier Reef. (Went out with Quicksilver based in Port Douglas. They have a trip that does not require snorkeling or scuba diving. Boat holds 440 people. Not a small sample.) The variety was rather interesting with no repeats. The only team represented that seemed out of place was South Africa’s football team and I was wearing that shirt.

That said, the following teams were all represented once:

  • Melbourne Storm
  • Hawthorn Hawks
  • South Sydney Rabbitohs (the guy wearing it immediately hit the bar after getting off the boat)
  • Hong Kong Rugby 7s
  • Cabonne United (Rugby league team from NSW)
  • USC Trojans
  • South African national football team
  • Boston marathon  (Not a team but still a major sporting event)
  • Canberra Raiders
  • Boston Red Sox
  • X-Games (not a team but a sporting event)
  • Chicago Bears

After I got out, I spotted a kid in the marina wearing a North Queensland Cowboys shirt.  I couldn’t tell if he was on the boat or not so on my list of places I have seen jerseys, I put it with the marina rather than the reef.  Anyway, I’m not sure exactly what to make of this list.  I know there were Kiwis and Dutch and Germans and English and Spanish speakers and Koreans aboard.  I could hear their accents and see them reading printed material in the language or some one would ask them where they were from and they would say.  I just didn’t see sport clothing.  I don’t know if the  Western Australians and South Australians weren’t on board or just weren’t wearing sport related stuff for their teams.  I thought the Victorians were supposed to be more sport mad but not really represented here.  The USA was represented with a fair representation of teams and events.

Related Posts: