Stats questions

[Ron The Bear]

What's the highest amount of goalkickers for a season for a team? Across all matches.

Individual?

38 - St.Kilda 1980, Carlton 1990, Essendon 1994
37 - Essendon 1992, Essendon 2007
36 - Essendon 1983, Collingwood 1986, Melbourne 1986, Essendon 2010
35 - Essendon 1971, Geelong 1982, Melbourne 1984, Melbourne 1987, Fitzroy 1987, Essendon 1991, Adelaide 1998, St.Kilda 2001, Essendon 2008, Richmond 2009, Greater Western Sydney 2012, Western Bulldogs 2012

A lot of poor teams in there. Generally speaking, it seems to be related to how many players are rotated through the side.

On a game by game basis, the highest totals are

246 - Carlton 2000, Geelong 2008
245 - Geelong 2011
243 - Geelong 2007
242 - Collingwood 2011
241 - Geelong 1992, Essendon 2000
237 - Geelong 2013
234 - Essendon 1984, Brisbane 1999
233 - Brisbane 2001, Brisbane 2002, Port Adelaide 2004, Collingwood 2010, Hawthorn 2012, Sydney 2012
231 - Geelong 1989, Essendon 1990

 

[frenchfri12]

Individual?

38 - St.Kilda 1980, Carlton 1990, Essendon 1994
37 - Essendon 1992, Essendon 2007
36 - Essendon 1983, Collingwood 1986, Melbourne 1986, Essendon 2010
35 - Essendon 1971, Geelong 1982, Melbourne 1984, Melbourne 1987, Fitzroy 1987, Essendon 1991, Adelaide 1998, St.Kilda 2001, Essendon 2008, Richmond 2009, Greater Western Sydney 2012, Western Bulldogs 2012

A lot of poor teams in there. Generally speaking, it seems to be related to how many players are rotated through the side.

On a game by game basis, the highest totals are

246 - Carlton 2000, Geelong 2008
245 - Geelong 2011
243 - Geelong 2007
242 - Collingwood 2011
241 - Geelong 1992, Essendon 2000
237 - Geelong 2013
234 - Essendon 1984, Brisbane 1999
233 - Brisbane 2001, Brisbane 2002, Port Adelaide 2004, Collingwood 2010, Hawthorn 2012, Sydney 2012
231 - Geelong 1989, Essendon 1990

How could individual be the worst teams, but individual multiplied by games is the best teams?

Also, what about the opposite, least goalkickers for the season, since about 1940, because before then they could go goalless in games.
Minimum score for of 1000 points, or after 1940.

 

[Ron The Bear]

How could individual be the worst teams, but individual multiplied by games is the best teams?

unsuccessful teams = volatile composition = no standouts & lots of players with a goal or two
successful teams = stable composition = a few players with healthy tallies

Since 1940, individual:

15 - Hawthorn 1948, Footscray 1956, Essendon 1960 (equal 12th-lowest all time)
16 - Essendon 1950, St.Kilda 1959, Essendon 1963 (equal 19th lowest)
17 - Carlton 1942, Footscray 1943, Fitzroy 1948, North Melbourne 1952, Essendon 1954, Hawthorn 1961, Essendon 1962. Hawthorn 1963 (equal 39th lowest)

Lowest: St.Kilda 1897, 12

For each decade:
1970's 20 Collingwood 1970 & 1971
1980's 22 Footscray 1985
1990's 22 Hawthorn 1993
2000+ 23 Fremantle 2003

Season:

59 - St.Kilda 1943 (Saints "eliminated" after 10 games, 23rd-lowest all time)
68 - North Melbourne 1943 (equal 46th lowest)
69 - St.Kilda 1955 (equal 53rd lowest)
75 - North Melbourne 1942 (equal 89th lowest)
76 - Hawthorn 1942 (equal 95th lowest)
83 - Collingwood 1942, Western Bulldogs 1943, North Melbourne 1951, Footscray 1966 (equal 142nd lowest)

Lowest: St.Kilda 1897, 28

For each decade:
1970's 116 South Melbourne 1972
1980's 121 St.Kilda 1988
1990's 122 Melbourne 1997
2000+ 130 Greater Western Sydney 2012

Avg goalkickers per team, per match:
1890's 3.52
1900's 4.35
1910's 4.76
1920's 5.37
1930's 5.88
1940's 6.03
1950's 5.69
1960's 5.99
1970's 7.09
1980's 7.66
1990's 7.60
2000's 8.99
2010's 8.00

 

[red+black]

The top 8 all have a 7-4 or better record. Has that happened before after 11 games?

 

[worbod]

I presume the difference of 697 games between Mick Malthouse (700) and Brendan Bolton (3) tonight would be a new record for games difference between coaches. Are there many other instances where there was a difference of 500 or more?

 

[Ron The Bear]

I presume the difference of 697 games between Mick Malthouse (700) and Brendan Bolton (3) tonight would be a new record for games difference between coaches. Are there many other instances where there was a difference of 500 or more?

337 occurrences in all. Top few:

Diff|Year|Rd|Clubs|Coach 1|Gms|Coach 2|Gms
\697|2014|13|Ca v Ha|Matlhouse, Mick|700|Bolton, Brendon|3
\693|1949|2|Co v Me|McHale, Jock|695|La Fontaine, Allan|2
\693|1949|3|Co v Fi|McHale, Jock|696|Smith, Norm W.|3
\693|1949|13|Co v Me|McHale, Jock|706|La Fontaine, Allan|13
\693|1949|14|Co v Fi|McHale, Jock|707|Smith, Norm W.|14
\688|2014|6|Ca v WC|Malthouse, Mick|694|Simpson, Adam|6
\688|2014|11|Ca v Br|Malthouse, Mick|698|Leppitsch, Justin|10
\687|2014|8|Ca v St|Malthouse, Mick|696|Richardson, Alan R.|9
\684|1949|11|Co v Sy|McHale, Jock|704|Hale, Jack|20
\682|1948|13|Co v Sy|McHale, Jock|685|Hale, Jack|3
\674|1949|8|Co v St|McHale, Jock|701|Froude, Fred|27
\674|1949|19|Co v St|McHale, Jock|712|Froude, Fred|38
\672|1948|7|Co v St|McHale, Jock|679|Froude, Fred|7
\672|1948|18|Co v St|McHale, Jock|690|Froude, Fred|18
\668|1948|10|Co v Fi|McHale, Jock|682|Cameron, Charlie J.|14
\665|2013|8|Ca v PA|Malthouse, Mick|672|Hinkley, Ken|7
\665|2013|23|Ca v PA|Malthouse, Mick|686|Hinkley, Ken|21
\665|2014|1|Ca v PA|Malthouse, Mick|689|Hinkley, Ken|24
\663|1949|1|Co v NM|McHale, Jock|694|Carter, F. Wally|31
\663|1949|12|Co v NM|McHale, Jock|705|Carter, F. Wally|42
\661|1948|1|Co v NM|McHale, Jock|673|Carter, F. Wally|12
\661|1948|12|Co v NM|McHale, Jock|684|Carter, F. Wally|23
\658|2013|12|GWS v PA|Sheedy, Kevin|668|Hinkley, Ken|10
\656|2013|2|GWS v PA|Sheedy, Kevin|658|Hinkley, Ken|2
\655|1949|4|Co v Ha|McHale, Jock|697|Albiston, Alec|42
\655|1949|15|Co v Ha|McHale, Jock|708|Albiston, Alec|53
\653|1947|2|Co v Ha|McHale, Jock|655|Albiston, Alec|2
\653|1947|6|Co v WB|McHale, Jock|659|Crowe, Jim|6
\653|1947|13|Co v Ha|McHale, Jock|666|Albiston, Alec|13
\653|1947|17|Co v WB|McHale, Jock|670|Crowe, Jim|17
\653|1948|9|Co v Ha|McHale, Jock|681|Albiston, Alec|28

 

[Ron The Bear]

The top 8 all have a 7-4 or better record. Has that happened before after 11 games?

No.

 

[ClarkeM]

What's the largest losing streak turned into a winning streak? For instance, Collingwood loses first six games of the year but then wins the next five.


Thanks.

 

[Ron The Bear]

What's the largest losing streak turned into a winning streak? For instance, Collingwood loses first six games of the year but then wins the next five.


Thanks.

Longest streak of losses immediately preceding a streak of x wins:

x W|L|Cb|Year
\20|2|Br|2002
\19|2|Me|1956
\18|2|Ca|1995
\16|3|Es|1950
\15|4|Es|1981
\11|4|WC|1996
\9|5|Ca|1976
\7|6|Ha|2010
\6|9|Me|2004
\5|10|Ge|1905
\4|13|Sy|1904
\3|15|Ri|2005
\2|29|Sy|1973
\1|48|St|1900

Read: e.g. in 1976, Carlton lost 5 in a row before winning 9 in a row

(In fact Carlton's 1976 season went 7W-5L-9W-1D-2L)

 

[Port Of Gold]

Port Adelaide won
Their first five matches last year,
Then lost the next five.

 

[twarby]

are Essendons 33 inside 50s in a loss the most ever? guessing it must be

also how does Melbourne's opponents goal accuracy rank for previous teams (currently 42.5%)

 

[RedmanWasHere]

Ron The Bear.

With your treasure trove of information, can you please tell me which teammates:

Jason Dunstall and Danny Frawley shared? (e.g. Dean Anderson.)
Jason Dunstall and Billy Brownless shared?
Dunstall and Garry Lyon.
Billy Brownless and Lyon.
Lyon and Frawley. (e.g. Stephen Newport.)
Sam Newman and Brownless shared? (e.g. Mark Bos and Neville Bruns.)

Cheers.

Also, which 2 Football media personalities shared the most teammates?

 

[RedmanWasHere]

Just to clarify, the 2 media type's must never have played alongside each other.

 

[Ron The Bear]

Ron The Bear.

With your treasure trove of information, can you please tell me which teammates:

Jason Dunstall and Danny Frawley shared? (e.g. Dean Anderson.)
Jason Dunstall and Billy Brownless shared?
Dunstall and Garry Lyon.
Billy Brownless and Lyon.
Lyon and Frawley. (e.g. Stephen Newport.)
Sam Newman and Brownless shared? (e.g. Mark Bos and Neville Bruns.)

Cheers.

Also, which 2 Football media personalities shared the most teammates?

In senior games:

Dunstall/Frawley - Tim Allen, Dean Anderson, Lawrence Bingham, Robert Handley, Paul Harding, Russell Morris, Ricky Nixon, Glenn Nugent, Sean Ralphsmith, Peter Russo, Chris Wittman

Dunstall/Brownless - Tim Hargreaves, Aaron Lord, Austin McCrabb

Dunstall/Lyon - nil

Brownless/Lyon - Bret Bailey, Trevor Spencer

Lyon/Frawley - Dean Chiron, Steven Clark, Greg Doyle, David Grant, Martin Heppell, Jeff Hilton, Rod Keogh, Peter Kiel, Stephen Newport, Rod Owen, Jamie Shanahan, Steve Turner, Brian Wilson

Newman/Brownless - Mark Bos, Terry Bright, Neville Bruns, Ray Card, Peter Johnston, Graeme Landy, Gary Malarkey, John Mossop, 'Scratcher' Neal, Michael Turner, Murray Witcombe, Mark Yeates

Due to the nearly limitless possibilities, I'm not even going to try to match all media personalities!

 

[The Swert]

When was the last time all teams had a least 3 wins after 12 rounds? This seems like the closest season in ages at the bottom of the table.

 

[Ron The Bear]

When was the last time all teams had a least 3 wins after 12 rounds? This seems like the closest season in ages at the bottom of the table.

2010 and 1998 after 13 rounds. 1988 after 12 rounds.

 

[SJ]

When was the last time all teams had a least 3 wins after 12 rounds? This seems like the closest season in ages at the bottom of the table.

It's the closest season in terms of gap between top and bottom after 12 matches since 1997.

 

[SJ]

are Essendons 33 inside 50s in a loss the most ever? guessing it must be

also how does Melbourne's opponents goal accuracy rank for previous teams (currently 42.5%)

*Paul* have you thought about adding a list of these to your site?

 

[Lensen]

Mav Weller kicked the first goal in the Saints game on the weekend, taking St Kilda first goal tally for the year to 1.

Is round 13 as late as this as ever happened for a side?

 

[Rourke]

Mav Weller kicked the first goal in the Saints game on the weekend, taking St Kilda first goal tally for the year to 1.

And all it did was make Geelong angry
Very good question though, based on sheer randomness I would expect it's happened a couple of times. Unfortunately I don't think there are reliable records past 15 years ago.

 

[Lensen]

And all it did was make Geelong angry
Very good question though, based on sheer randomness I would expect it's happened a couple of times. Unfortunately I don't think there are reliable records past 15 years ago.

Yeah, I meant in terms of records held. I'm sure it probably happened during one of the Saints awful first 20 years or so

 

[red+black]

Q. Last x year old to win a premiership?
Q. Number of x year olds to win a premiership?

where x = 18, 17, 16

 

[Ron The Bear]

Q. Last x year old to win a premiership?
Q. Number of x year olds to win a premiership?

where x = 18, 17, 16

Age|Year|Cb|Player(s)
\17|1974|Ri|Cameron Clayton
\18|1993|Es|Dustin Fletcher, Joe Misiti
\19|2012|Sy|Luke Parker
\20|2013|Ha|Bradley Hill
\21|2013|Ha|Jack Gunston
\22|2013|Ha|Luke Breust, Liam Shiels
\23|2012|Sy|Craig Bird, Lewis Jetta
\24|2013|Ha|Cyril Rioli, Isaac Smith, Ben Stratton
\25|2013|Ha|Grant Birchall, Paul Puopolo, Jonathan Simpkin
\26|2013|Ha|Max Bailey, Lance Franklin, Jarryd Roughead
\27|2013|Ha|Jordan Lewis
\28|2012|Sy|Nick Malceski, Mike Pyke
\29|2013|Ha|Josh Gibson, David Hale, Luke Hodge, Brad Sewell
\30|2013|Ha|Shaun Burgoyne, Sam Mitchell
\31|2013|Ha|Brent Guerra, Brian Lake
\32|2012|Sy|Jude Bolton, Adam Goodes
\33|2001|Br|Alastair Lynch
\34|2008|Ha|Shane Crawford
\35|2003|Br|Alastair Lynch
\36|1989|Ha|Michael Tuck
\37|1924|Es|Charlie Hardy*
\38|1991|Ha|Michael Tuck

* Hardy played 2 games during 1924 when there was no GF. Carlton's Jim Flynn played in a winning GF at 37 in 1908

Age|Players
\17|6
\18|27
\19|72
\20|138
\21|194
\22|238
\23|235
\24|225
\25|237
\26|213
\27|169
\28|164
\29|116
\30|81
\31|64
\32|37
\33|19
\34|10
\35|10
\36|3
\37|1
\38|1

NB excludes 65 Essendon players from 1897 and 1924 when no GF was played. They were aged between 17 (Alby Stamp) and 37 (Charlie Hardy) at their final game of the season

 

[red+black]

Age|Year|Cb|Player(s)
\18|1993|Es|Dustin Fletcher, Joe Misiti

Well that does surprise me. Can I be greedy and ask a similar question?

Q. Last x year old to play in a losing grand final?
Q. Number of x year olds to play in a losing grand final?

where x < 19 or x >= 34

 

[RedmanWasHere]

Via private message Ron The Bear, can you please send me editable Excel spreadsheets with one dedicated to games sorted by debut years and round of debut and the goals version of it?

E.G. Dustin Fletcher debuted in Round 2 1993 and has played 388 games which puts him a clear No. 1 for games played by someone who debuted in 1993.

He's got 70 goals which brings him back to the pack in terms of most goals by someone debuting in 1993 with Richo the clear leader on 800 goals.

Cheers.