Stats questions

[*Paul*]

My database is still missing 22.

Which one of these do you have
Ivan Astruc
Dave McGrath
Joe Marchant
Jim Schellnack
Dick Casey
Charlie Johnston
Jack Johnston
Bobby Monk
Joe Bray
David Bell
Dick Campbell
Cecil Quinlan
George Featherstone
Reg Gregson
Aubrey MacKenzie
Bill Hennington
George Weatherill
Tommy Smith
Sid Thompson
Roy Finlayson
Ivan Sharp
Jack White
Jerry McAuliffe

 

[35Daicos]

Which one of these do you have
Dave McGrath

There's a DOB of 10 Nov 1872 in The Encyclopedia of AFL Footballers (2011 edition) for David C McGrath - Fitzroy (1900) who I assume is the one you're referring to, as the 1900 Fitzroy playing list from the AFL Historical Statistics site is/was missing that birthdate. I'm not sure if there is meant to be any doubt about the DOB shown in the Encyclopedia.

M A Bobby Monk - Melbourne (1907-14) 21 Jan 1886 in The Encyclopedia, again no DOB in the AFL Historical Statistics pages.

David G. Bell - Melbourne (1909-10) 26 Jun 1890 in The Encyclopedia, ~~~

 

[*Paul*]

Excellent work. I really should update my Encyclopaedia, not only is it out of date, it's fallen apart.

 

[*Paul*]

My question is about free kick differentials in a game.

Obviously in the North v Port game there was a differential of 23. When was the last time a differential was that great and how often does something like that happen?

Biggest in 20 years.

35 Geelong v Melbourne                      59-24 197506071410
29 Western Bulldogs v Melbourne             41-70 197706251410
29 Fitzroy v Essendon                       31-60 197909081430
28 St Kilda v North Melbourne               60-32 197804221410
28 Fitzroy v Hawthorn                       59-31 197605291410
27 St Kilda v North Melbourne               54-27 197708201410
26 Sydney v St Kilda                        54-28 198105021410
26 St Kilda v Hawthorn                      50-24 197604031410
26 Geelong v Richmond                       54-28 197705281410
26 Fitzroy v North Melbourne                53-27 197705281410
26 Collingwood v Richmond                   60-34 198004191410
26 Carlton v Richmond                       62-36 198209111430
26 Carlton v Melbourne                      44-18 199305291400
26 Carlton v Hawthorn                       54-28 197704231410
25 Geelong v Essendon                       50-25 198206051410
25 Essendon v Hawthorn                      61-36 197605011410
25 Carlton v Sydney                         25-50 198406031410
24 Western Bulldogs v St Kilda              47-23 198103281410
24 West Coast v Richmond                    16-40 198905131410
24 Hawthorn v Collingwood                   34-58 197705281410
24 Hawthorn v Adelaide                      40-16 199308211408
24 Geelong v North Melbourne                60-36 197707301410
24 Fitzroy v North Melbourne                53-29 197407131410
24 Essendon v Sydney                        20-44 198408261410
24 Collingwood v Carlton                    71-47 197805131410
23 Western Bulldogs v West Coast            41-18 198907301410
23 Western Bulldogs v North Melbourne       53-30 198107251410
23 Sydney v Hawthorn                        54-31 198005311410
23 Port Adelaide v North Melbourne          15-38 201305041410
23 Geelong v Hawthorn                       56-33 197904211410
23 Geelong v Essendon                       33-56 198208211410
23 Essendon v North Melbourne               47-24 197704301410
23 Carlton v Melbourne                      52-29 198307021410
23 Carlton v Geelong                        26-49 197504051410

 

[35Daicos]

Which one of these do you have
Sid Thompson
Roy Finlayson
Ivan Sharp
Jack White
Jerry McAuliffe

Also (I got interrupted when half way through checking!):-
Sid Thompson - Footscray (1925 & 1927) 17 Jul 1905.

Roy Finlayson - Fitzroy (1929-1932) 31 Mar 1909.

Jack White - If this refers to Jack G White - St Kilda (1899-1900) the AFL Historical pages had/have 04-12-1876. The Encylopedia has no DOB for him BTW.

I just spotted John F "Jackie" White - Hawthorn (1933) 14 Jun 1912 in the Encyclopedia, he seems to be your man.

It does seem odd to me that The Encyclopedia of AFL Footballers (updated in 2011) has these DOBs, and yet the AFL site (last updated in 2011, at least from what I can see) doesn't have them, but anyway.

 

[worbod]

Thanks Rogers for your great info. As you have stated, stats relating to progressive margins within quarters do not date back a long way, but do you happen to have any stats for the game the Bulldogs played against Geelong in round 12, 2001. We were 47 points down in the second quarter, but my most recent edition of the AFL Season Guide (2011) does not feature this comeback in its Biggest Comebacks section within its Games Records chapter.
I'm also trying to discover the minute mark of the second quarter versus North Melbourne in round 15, 2000 when we were 42 points down.

For the record, I knew I had a copy of the second half of this game on VHS somewhere, which I had taped off the telly. I decided to watch it yesterday, hoping one of the Channel 7 commentators would mention when North had been 42 points ahead. Finally, halfway during the last quarter, with the scores lying at 94 apiece, Kevin Bartlett made mention that the biggest lead of the game had been when North were 42 points ahead at the 22 minute mark of the second quarter.

 

[Aussiemac82]

What is the best resource to find "Number of games started as Sub" for each player?

 

[Ron The Bear]

Which one of these do you have
Ivan Astruc
Dave McGrath
Joe Marchant
Jim Schellnack
Dick Casey
Charlie Johnston
Jack Johnston
Bobby Monk
Joe Bray
David Bell
Dick Campbell
Cecil Quinlan
George Featherstone
Reg Gregson
Aubrey MacKenzie
Bill Hennington
George Weatherill
Tommy Smith
Sid Thompson
Roy Finlayson
Ivan Sharp
Jack White
Jerry McAuliffe

Ah, I just had 1/1/1876 for Ivan Astruc, as per his Wikipedia entry. Probably should delete.

 

[Ron The Bear]

It does seem odd to me that The Encyclopedia of AFL Footballers (updated in 2011) has these DOBs, and yet the AFL site (last updated in 2011, at least from what I can see) doesn't have them, but anyway.

I once asked Jim Main about this; the authors' research is independent of the AFL's. The Encyclopedia contains some other anomalies re games/goals - numbers differ slightly from the AFL's here and there.

 

[Ron The Bear]

Excellent work. I really should update my Encyclopaedia, not only is it out of date, it's fallen apart.

They've been releasing an updated edition every two years. A new one is due.

 

[stemline]

Not sure I've followed this discussion properly - does anyone have Jerry McAuliffe's DOB?

 

[*Paul*]

What is the best resource to find "Number of games started as Sub" for each player?

http://stats.rleague.com/public/test.txt

 

[*Paul*]

Not sure I've followed this discussion properly - does anyone have Jerry McAuliffe's DOB?

It appears none of us do at any rate. This is my remaining 17 spontaneously winked into existence candidates
Aubrey MacKenzie
Bill Hennington
Cecil Quinlan
Charlie Johnston
Dick Campbell
Dick Casey
George Featherstone
George Weatherill
Ivan Astruc
Ivan Sharp
Jack Johnston
Jerry McAuliffe
Jim Schellnack
Joe Bray
Joe Marchant
Reg Gregson
Tommy Smith

 

[35Daicos]

Read somewhere (Sunday HS, maybe) that the birthdates of all but seven players were known. That was about three years ago. I used to rely on the now-defunct historical stats section on the AFL website for the data, which was updated periodically. My database is still missing 22.

From AFL Record 2012 Rd. 3 (page 16):-

The AFL’s statistical and historical department has had great success tracking down missing details of former League players in recent years. However, there are 10 players whose
date of birth is unknown. They are: ~~~

I'm not sure where they're up to now. Also, I'd have attached that one page from the .pdf but it (Adobe Reader) won't allow me to save just one page. The article (by Col Hutchinson) is well worth reading, for anyone interested in such things.

http://digital.slv.vic.gov.au/R/?func=collections&collection_id=1081

 

[35Daicos]

It appears none of us do at any rate. This is my remaining 17 spontaneously winked into existence candidates
Aubrey MacKenzie
Bill Hennington
Cecil Quinlan
Charlie Johnston
Dick Campbell
Dick Casey
George Featherstone
George Weatherill
Ivan Astruc
Ivan Sharp
Jack Johnston
Jerry McAuliffe
Jim Schellnack
Joe Bray
Joe Marchant
Reg Gregson
Tommy Smith

Related to my previous post, these are the 10 players whose dates of birth were unknown to the AFL (at least a year ago):-
Ivan Astruc
Richard Thomas Campbell
Richard James Casey
Joseph Patrick Fox
William Hennington
Charles and Jack Johnson (Johnston or Johnstone)
James Schellnack
Thomas 'Gunboat' Smith
James Hamish Watson.

 

[*Paul*]

Just looking at Joe Fox, the original files at the AFL stats site (March 2006) had a date for him, I'm assuming Watson as well. They must have rescinded those dates.

Seems Watson didn't have DOB in any version of the AFL site I have, I can't explain where I got his DOB from, must have just buggered it up. I should probably remove both.

 

[35Daicos]

Just looking at Joe Fox, the original files at the AFL stats site (March 2006) had a date for him, I'm assuming Watson as well. They must have rescinded those dates.

AFL Record 2009 Round 7 - Col Hutchinson appealed for information, including date of birth, on Fox. The pages I downloaded from the Historical Stats site a year or so ago don't show a D.O.B.

 

[Ron The Bear]

From AFL Record 2012 Rd. 3 (page 16):-

The AFL’s statistical and historical department has had great success tracking down missing details of former League players in recent years. However, there are 10 players whose
date of birth is unknown. They are: ~~~

I'm not sure where they're up to now. Also, I'd have attached that one page from the .pdf but it (Adobe Reader) won't allow me to save just one page. The article (by Col Hutchinson) is well worth reading, for anyone interested in such things.

http://digital.slv.vic.gov.au/R/?func=collections&collection_id=1081

Attached

 

[35Daicos]

Attached

I've done that successfully and very easily in the past, it's not working for me now.

 

[35Daicos]

Seems Watson didn't have DOB in any version of the AFL site I have, I can't explain where I got his DOB from, must have just buggered it up. I should probably remove both.

AFL Record 2009 Round 2 - Col Hutchinson appealed for information, including date of birth, on Watson. The pages I downloaded from the Historical Stats site (it was only in fact about 6 months ago) do show a D.O.B.- 25-08-1896.

There is no DOB for Watson in The Encyclopedia of AFL Footballers (2011 edition), for Fox it has 8 Sep 1877.

 

[*Paul*]

Ah yes, didn't look at the most recent version. So this one is solved it might be concluded.

 

[Ron The Bear]

I've done that successfully and very easily in the past, it's not working for me now.

Maybe because the file was > 1MB in size, i.e. above the BF upload limit? I did a 'Save As Other -> Reduced Size PDF' in Acrobat.

 

[35Daicos]

Maybe because the file was > 1MB in size, i.e. above the BF upload limit? I did a 'Save As Other -> Reduced Size PDF' in Acrobat.

The problem I'm having is not in BigFooty at all, it's trying to save just that one page of the .pdf file using Adobe Reader - it will only save the whole file. With the Save As Other option, the two choices are - Text / Word or Excel Online. Until recently I was able to save individual pages from .pdf files without a problem, something seems to have changed.

Still, it's not a big deal, thanks a lot for replying.

 

[The Passenger]

who are the top x amount of games played for people who debuted at 25 years or later.

And where does Ben Hudson sit? He's on 164 now and will probably be 175+ by the end of the season. Might not even be his last. Gotta be up there surely. Since his debut only missed about 15 games.

 

[Ron The Bear]

who are the top x amount of games played for people who debuted at 25 years or later.

And where does Ben Hudson sit? He's on 164 now and will probably be 175+ by the end of the season. Might not even be his last. Gotta be up there surely. Since his debut only missed about 15 games.

Top 25:

Games|Player|Club(s)|Career|Debut
\180|Rankin, Teddy|Ge|1897-1910|25y 58d
\164|Hudson, Ben|Ad,WB,Br,Co|2004-2013|25y 47d
\157|Angus, George|Co|1902-1911|27y 55d
\157|Clay, Bert|Fi|1940-1951|25y 46d
\154|Beasley, Simon|WB|1982-1989|25y244d
\152|Kickett, Derek|NM,Es,Sy|1989-1996|26y213d
\151|Lamb, Dwayne|WC|1987-1994|25y 99d
\149|Flynn, Jim|Ge,Ca|1897-1910|26y 62d
\149|Obst, Andrew|Me|1990-1997|25y224d
\147|Clover, Horrie|Ca|1920-1931|25y 49d
\137|Maher, Frank|Es|1921-1928|25y262d
\136|Anderson, Jim|Es|1897-1905|27y172d
\135|Johnson, Alan|Me|1982-1990|25y128d
\133|Alexander, Ron|Fi|1976-1981|25y115d
\133|Stephens, Brett|Fi|1987-1993|26y 36d
\129|Tulloch, Lardie|Co|1897-1904|26y 23d
\129|Windley, Bill|Sy|1897-1905|28y253d
\128|Bisset, Jack|Ri,Sy|1928-1936|27y233d
\126|Clark, Norman|Ca|1905-1912|26y245d
\124|Norris, Charlie|Co,Fi|1910-1918|28y344d
\123|McShane, Joe|Ge,Ca|1897-1904|28y160d
\122|Mead, Darren|PA|1997-2002|26y
\117|McDermott, Chris|Ad|1991-1996|27y138d
\117|Shaw, George|Fi|1911-1920|25y 35d
\117|Tunbridge, Geoff|Me|1957-1962|25y 15d