Archive for category Brisbane Lions

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:

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:

Brisbane’s sports community on LiveJournal and clones, bebo, blogger and Twitter

Posted by Laura on Tuesday, 5 January, 2010

This post is a series of posts looking at the size of Australian sports leagues on LiveJournal, its clones and other social networks. Earlier posts include Australian Football League on JournalFen , Australian Football League community on DeadJournal , National Rugby League on DeadJournal and JournalFenAustralian Football League on LiveJournal clones like Blurty, Dreamwidth Studios and InsaneJournal, Adelaide Crows community on LiveJournal, its clones and Blogger,and Official Australian Football League Twitter accounts and follower population by country. and Brisbane Lions community on LiveJournal, its clones and Blogger. Methodology for this post has been discussed in earlier posts.

Brisbane has a number of professional sports team including the Brisbane Broncos, Brisbane Lions, Queensland Maroons, Brisbane Roar, Brisbane Bullets (defunct), Queensland Reds, Queensland Bulls, Queensland Blades, Queensland Firebirds, Queensland Rams and Queensland Sundevils.  For all but two of these teams, the Blades and Rams, there is some small community on one of the following social networks: bebo, blogger, LiveJournal and its clones, Twitter.  If Twitter is excluded, the Broncos have the largest community with 333 people interested in them and the Sundevils the smallest with 1 person interested in them.

What does the Brisbane sports team fandom look like? Half (54%) the Australian community is based out of Queensland and about a quarter (28%) is based in New South Wales.  The rest is distributed amongst the other states, with the exception of Tasmania which has no Brisbane fans for any sports.

Map of Brisbane sports fandom by state and team

Rugby is traditionally more popular than footy in Queensland.   The distribution in Queensland suggests something a bit different, with 89 total fans for the Lions versus 83 for the Broncos.  Rugby and the Broncos are more popular only in New South Wales than footy and the Lions. One exception exists for the ACT where there are three fans for each.

Bearing in mind that people can be counted twice if they are one more than one network and are fans of more than one team, Brisbane sports fandom where the Australian state is known has the the largest interest base on bebo, with 272 people using it.  Next is LiveJournal with 62 users, Blogger with 20, Blurty with 2 and InsaneJournal with 1.  Brisbane fans in the ACT are more likely to use LiveJournal (3) with bebo (2) and blogger (2) being their next most popular choices.  Victorian fans of Brisbane teams just prefer bebo (11) to LiveJournal (10) with their third choice being blogger. (2)  In all other cases, bebo is the top choice in every state for Brisbane sports fans.  Outside of Queensland, no other fans use or used blurty or InsaneJournal.

There is an international interest in Brisbane sports teams.  This ranges from 0 to 50% of the total community that lists their country of origin.  Communities with 50% of their support base outside Australia include the Queensland Red community on bebo, and the Brisbane Roar community on bebo.  In both these cases, the community is 4 and 2 people respectively.  33.3% of the 30 member strong Queensland Maroons community on bebo comes from outside Australia, with 8 people from New Zealand and 2 from the Cook Islands. 32.4% of the Twitter followers of the Brisbane Broncos are from outside Australia with 13 from China, 68 from Great Britain and 286 from the United States. 28.9% of the Brisbane Broncos on bebo comes outside Australia with 32 people from New Zealand, 10 from Papau New Guinea, 6 from the United States, 2 from Fiji, the Philippines and Tonga.   The Queensland Reds unofficial Twitter follow list has 28.6% of its followers from outside the US. 50 followers are the US, 36 from Great Britain, 9 from Brazil and New Zealand, and 4 from Denmark and Italy.

bebo, Blogger and LiveJournal all allow users to display their age on their profiles.   This can help develop a picture of the age of the a team’s community online.  There is a small problem in that not everyone lists their age and these populations are very, very small.  Thus, this data cannot be really used to extrapolate beyond the specific community unless there is some other evidence to support that.

For the Brisbane Broncos community on blogger, the average age is 33, median is 31, mode is 20 with 9 of 12 people listing their ages.  This is not close to LiveJournal’s Broncos community which has an average age of 25, median age of 27 and mode age of 20 with 13 of 42 people listing their age.  The bebo community is much younger than both with an average age of 23, median age of 20 and mode age of 19 with 127 of 278 people listing their age.  For the lions, 49 people list their page on bebo with an average age of 24.5, median age of 21, mode age of 18.  On blogger, 10 Lions fans list their age.  They have a average ago of 33, median age of 30 and mode age of 27.  For LiveJournal Lions fans,  17 list their age.  They have an average age of 26, and a median and mode age of 24.  Only one other group, Queensland Maroons on bebo, have more than 10 fans who list their ages.  In that group, 21 list their ages, with an average age of 21.9, median age of 20 and mode age of 20.

Bebo and blogger both allow users to publicly display their gender.  The team and network with the highest percentage of male fans involves the Queensland Reds on bebo, where all six individuals list their gender as male.  The next highest percentage of male in the community include the Brisbane Bulls on bebo and the Queensland Bulls on bebo.  In both cases, the percentage of males is 60%.  In the case of the Brisbane Bulls,  40% or 2 people do not list a gender.  For the Queensland Bulls,  20% or one person lists identifies as female and the other did not list a gender.  The highest percentage of female members is the Queensland Bulls on blogger with 50% but that community only has two members.  The next highest percentage is for the Brisbane Broncos community on blogger at 42% or five people identifying as female.  All other members of that community identify as male.   The Brisbane Lions community on blogger has a female percentage at 38, with 6 people identifying as female.  56% of the members identify as male and 6%, or one person, do not list a gender.  The highest percentage of unknown/unlisted gender is for the Queensland Sundevils bebo community, which only has one person and they don’t identify their gender.  After that is the Brisbane Roar community on bebo, where 69% or 11 people do not identify their gender, 4 people identify as male and 1 identifies as female.  The Brisbane Lions community on bebo has 40% unknown/unlisted with 53 people not including their gender. 36% of the Lions bebo community identifies as male and 24% identifies as female.

This isn’t the best write up, mostly just summarizing some of the data.    The rest of the data used for this post will show up in future posts.  As I learn more, I’m planning on integrating more analysis of what this data means.

Related Posts:

Brisbane Lions community on LiveJournal, its clones and Blogger

Posted by Laura on Tuesday, 5 January, 2010

This post is a series of posts looking at the size of Australian sports leagues on LiveJournal, its clones and other social networks. Earlier posts include Australian Football League on JournalFen , Australian Football League community on DeadJournal , National Rugby League on DeadJournal and JournalFen, Australian Football League on LiveJournal clones like Blurty, Dreamwidth Studios and InsaneJournal, Adelaide Crows community on LiveJournal, its clones and Blogger,and Official Australian Football League Twitter accounts and follower population by country.

This post is looking at the size and characteristics of the Brisbane Lions community on LiveJournal and Blogger. The sundry of disclaimers and methodologies can be found on earlier posts. LiveJournal data was collected on December 30, 2009 and Blogger information was gathered on December 29, 2009.

The Brisbane Lions community on Blogger is a bit smaller than the community for the Adelaide Crows, with 16 people listing the team or city and a footy related interest as an interest. This group has six women, nine men and one person who does not list a gender. This percentage of 38% puts their female audience at larger than the Crows (33%), Blues (25%), Magpies (25%) and Bombers (29%) communities located on Blogger. Twelve people list their ages of which two are obvious errors or intentional mistakes: One is 252 years old and the other is 253. The average age for a Lions fan on Blogger is 33, the median age is 30 and the mode age is 27. In terms of birthdays, two are Aries, one is a Cancer, two are Leos, four are Libras, two are Pisces, two are Scropios and one is a Virgo. All sixteen list their country of residence. Three are not from Australia: Two are from London, England and one is an American from Colorado. Ten of the Australians lists their state of residence. Of these, seven are from Queensland, two are from the ACT and one is from Victoria.

Like Blogger, the Brisbane Lions LiveJournal community is smaller than the community for the Adelaide Crows, with only 61 people listing the Brisbane Lions as an interest. 14 of these 16 updated in the past week and 33 total have updated in the past year. 4 have never updated. While smaller, this group appears to be a bit more active on LiveJournal than the community for the Adelaide Crows. 16 of the 61 people list their year of birth. Of these 16, the mean year of birth is 1984, and median and mode year of birth is 1986. The oldest were born in 1972 and the youngest was born in 1991. 56 of the 61 list their country of residence. 4 are from the United Kingdom and 7 are from the United States. The percentages of the total population is inverse of what it is for Blogger. With 45 from Australia, the percentage of the population from the country is similar to that of Blogger, 80% on LiveJournal compared to 81% on Blogger. These numbers are also some what comparable to the Twitter population which has 77% from Australia, 2% from the United Kingdom and 21% from United States out of 325 people counted. 33 of the 45 Australians list a state of residence. Of this, 19 are from Queensland, 10 are from Victoria, 2 are from South Australia with 1 from the Northern Territory and Western Australia.

What does the breakdown by state look like? The following chart shows LiveJournal, Blogger and its clones:

Related Posts: