Interesting (to me anyway) F1 Stats

  • Thread starter amp88
  • 71 comments
  • 14,954 views
Ok, the bug is fixed now, I've re-uploaded the corrected tables and I've attached the correct spreadsheets to this post.

The bug was in the way files are sorted by name. In a directory listing of files named "1", "2", "10" and "11", the 'sorted' list would be "1", "10", "11", "2". This caused the rounds to be parsed in the wrong order, leading to incorrect race numbers for the first wins. I should have saved the files with a double-digit round number anyway, but it must have slipped my mind when I was writing the parser.
 

Attachments

  • F1 Stats - amp88 - Revised.zip
    21.2 KB · Views: 29
SpongeBubba
Awesome work!
Click to expand...

Thanks :)

At the request of Azhur, here are the highest and lowest average place changes from grid position to finish position, with at least 10 race starts. I can't think of anything better to call this, but to explain it, if a driver starts from 5th place on the grid and finishes in 3rd, his place change is +2 (i.e. he gained two places). Similarly, if he started in 3rd and finished in 5th, his place change is -2.

As expected, drivers who generally qualify well (Ayrton Senna is a perfect example) come out 'badly' in this statistic. Since they start high up the grid, it's difficult to gain places in the race (or impossible to gain places starting from pole position).

The "Highest Average Place Change" is a measure of which drivers have gained the most average places in races and the "Lowest Average Place Change" is a measure of which drivers have lost the most average places in races.

Highest Average Place Change
highestAveragePlaceChange.GIF


Lowest Average Place Change
lowestAveragePlaceChange.GIF
 
Two additions this time. The greatest number of one-two finishes for constructors and the highest championships-to-seasons ratio for constructors (only counting 1958 to 2005).

oneTwoFinishes.GIF


champsSeasonRatio.GIF


Any requests?
 
somebody
I wouldn't mind seeing the drivers who have driven with the greatest number of different teams.
Click to expand...
Chris Amon wins that one, I think he drove for 11 teams.
- Lola, Brabham, Ferrari, March, Matra, Tecno, Tyrrell (one race, two meetings), Amon (yes, his own team and own car), Ensign, Wolf-Williams...I'm forgetting one.
 
somebody
I wouldn't mind seeing the drivers who have driven with the greatest number of different teams.
Click to expand...

Here you go :)

greatestDifferentTeams.GIF


Chris Amon does, as pupik said, top the list, having entered with 12 different constructors (Lola, Lotus, Cooper, Brabham, Ferrari, March, Matra, Tecno, Tyrrell, Amon, BRM and Ensign). Maurice Trintignant shares the top spot (having driven for Simca-Gordini, Simca-Gordini-Gordini, Gordini, Ferrari, Vanwall, Bugatti, Cooper, Maserati, BRM, Aston Martin, Lotus and Lola), however, I think this may be due to Simca-Gordini, Simca-Gordini-Gordini and Gordini being considered three constructors.

pupik, any input on how I should consider those three constructors?

Jacques Villeneuve is credited with having entered with 6 different constructors (Arrows, RAM, Williams, BAR, Renault and Sauber), but two of these (Arrows and RAM) must have been a different Jacques Villeneuve because they were entered in the 1981 and 1983 seasons). I don't know if there are any other anomalies like this, I can't be bothered checking them all.
 
amp88
Maurice Trintignant shares the top spot (having driven for Simca-Gordini, Simca-Gordini-Gordini, Gordini, Ferrari, Vanwall, Bugatti, Cooper, Maserati, BRM, Aston Martin, Lotus and Lola), however, I think this may be due to Simca-Gordini, Simca-Gordini-Gordini and Gordini being considered three constructors.
Click to expand...
It's a matter of semantics; I think it was a matter of who trew in more money/research into the project; Gordini were the engine buliders, but then they took over the Simca project when F1 became F2 and then F1 again. I'd certainly treat it as the same "team", since a team is an entrant. If the entrant is different, then it's not the same team.

In the 1930's up until the late 1970's, you had customer cars of the same make belonging to separate teams, or last year's cars sold off to other entrants. The Concorde Agreement of 1981-82 killed off customer cars for good.

Jacques Villeneuve is credited with having entered with 6 different constructors (Arrows, RAM, Williams, BAR, Renault and Sauber), but two of these (Arrows and RAM) must have been a different Jacques Villeneuve because they were entered in the 1981 and 1983 seasons). I don't know if there are any other anomalies like this, I can't be bothered checking them all.
Click to expand...
There's 2 Jacques Villeneuves; technically, Jacques the World Champ (Williams, BAR, Sauber, Renault, BMW) is a "Junior".

Jacques Villeneuve Sr. tried to enter the 1981 and 1983 Canadian GPs for Arrows and RAM, respectively; he failed to qualify for both events.
 
So would you just classify all versions of Simca-Gordini/Simca-Gordini-Gordini/Gordini as being "Simca-Gordini" and that'd be it done with?
 
It would take some research as to whether it was actually a team change or a name change, or both. I can't recall off the top of my head whther it was a new team or not; my copies of Grand Prix! might help out.


Edit: Did a 5-minute search at The Nostalgia Forum (If you're a fan of any old or obscure racing series, this is a favorite of mine, bar none!) and pulled this from a member named fines.

http://forums.autosport.com/showthread.php?s=&threadid=12702
I'm sure there are others more prolific on this, but Amedée Gordini built his first single-seater "SIMCA-Gordini" already in 1946, soon followed by a considerable number the following years. With an 1100cc 4 cylinder engine it can hardly be described as a pukka GP car, but with enlarged engines and (later) added superchargers these little cars appeared quite often in Grand Épreuves, and with some success at that. At the end of 1951, SIMCA (a French Fiat contractor) withdrew their support and the cars raced on, now simply known as "Gordini".

Another good link about the Gordinis: http://8w.forix.com/gordini.html

All this talk would be nothing without a pic...
mt-f53.jpg


​

Another example would be the Onyx cars of 1990; they were re-named Monteverdi for the last two races. Definatley not a new team. Footwork and Arrows from the same period; same team, different name. Also March and Leyton House, sponsors had their way...same deal.
 
That looks like Reims. You can go there still, and see the old pit, grandstand and scoreboard buildings. One of the (three) N-roads has been turned into a 4-lane highway, and there are roundabouts at each of the corners, but the whole thing is driveable. It's quite surreal.
 
GilesGuthrie
That looks like Reims. You can go there still, and see the old pit, grandstand and scoreboard buildings. One of the (three) N-roads has been turned into a 4-lane highway, and there are roundabouts at each of the corners, but the whole thing is driveable. It's quite surreal.
Click to expand...
Correct, it's Maurice Trintgnant in the '52 French GP approaching the Thilliois (sp?) hairpin.

Rumor has it that Riems is going to be re-built and some of the roads preserved, Spa-Francorchamps-style, even though it hasn't seen racing action since the mid-1970's.
 
amp88
Reasons for retirement and the number of retirements caused.

I'm not quite sure what the distinction is between "accident" and "collision". I imagine accidents involve more than one car, collisions involve one car hitting something other than another car (walls, barriers etc), but I'm not sure.

retirement.GIF
Click to expand...

You missed off the number 1 cause of retirement!

A good word from Murray Walker...

Pupik
There's 2 Jacques Villeneuves; technically, Jacques the World Champ (Williams, BAR, Sauber, Renault, BMW) is a "Junior".

Jacques Villeneuve Sr. tried to enter the 1981 and 1983 Canadian GPs for Arrows and RAM, respectively; he failed to qualify for both events.
Click to expand...

How can Jacques Villeneuve be Jacques Villeneuve Jr. unless he's the son of Jacques Villeneuve - which he isn't?

Other Jacques Villeneuve is "Uncle Jacques" - Jacques Villeneuve's Uncle. They ought to be Jacques Villeneuve I and Jacques Villeneuve II.
 
Famine
How can Jacques Villeneuve be Jacques Villeneuve Jr. unless he's the son of Jacques Villeneuve - which he isn't?

Other Jacques Villeneuve is "Uncle Jacques" - Jacques Villeneuve's Uncle. They ought to be Jacques Villeneuve I and Jacques Villeneuve II.
Click to expand...
I always thought Jacques (the WC) was the son of Gilles' brother, Jacques (non-starter), hence the name. So I know the geneology of Gordini, but not Villeneuve.

Oops.
 
Pupik
I always thought Jacques (the WC) was the son of Gilles' brother, Jacques (non-starter), hence the name. So I know the geneology of Gordini, but not Villeneuve.

Oops.
Click to expand...

No, Jacques (current F1 Driver) was the son of Gilles and the nephew of Jacques Sr. Interestingly, Gilles's brother was actually quite a good pedaller.
 
Can you list the oldest drivers to race in F1, Oldest driver to win a race, Oldest driver to win a championship? with oldest at top

Youngest driver to race in F1, Youngest to win a race, yougest to win a championship with youngest at the top. Possibly make each one top 20 or so?

Thanks
 
Unfortunately that's not possible with the stats available on the official F1 website. Date of Birth isn't listed anywhere in the race results or on the site, so I'd have to somehow search another F1 site to try and get the date of birth of each of the drivers. I don't know how difficult that'd be and there's also the problem of multiple matches.

Sorry :(
 
Ok guys this looks like a perfect topic for me :)
I have a question:
What was the avarage number of fans waching racers for every track , for last 5 years ?

To be honest i need that information and i thought i coul get it here.

In other words how much of free places is avaible to obtain before every race ?
 
villainpl
Ok guys this looks like a perfect topic for me :)
I have a question:
What was the avarage number of fans waching racers for every track , for last 5 years ?

To be honest i need that information and i thought i coul get it here.

In other words how much of free places is avaible to obtain before every race ?
Click to expand...

I can't think of anywhere where that information would be available and it certainly isn't available through the Results Archive of the official F1 site, sorry.
 
Small_Fryz
Can you list the oldest drivers to race in F1, Oldest driver to win a race, Oldest driver to win a championship? with oldest at top

Youngest driver to race in F1, Youngest to win a race, yougest to win a championship with youngest at the top. Possibly make each one top 20 or so?

Thanks
Click to expand...

I often go to a great French site called stats f1 which has that information and very comprehensive lists done in many different ways - both relevant and irrelevant.
Might be a useful resource for your own tables amp88 if you're not already familiar with it - even if just to check your results against theirs...

Incidentally the oldest 20 GP winners are given there as:

Code: 
1   	FAGIOLI Luigi  	 53a 00m 22j  	 F 1951
2  	FARINA Giuseppe 	 46a 09m 03j 	 D 1953
3  	FANGIO Juan-Manuel 	 46a 01m 11j 	 D 1957
4  	TARUFFI Piero 	 45a 07m 06j 	 CH 1952
5  	BRABHAM Jack 	 43a 11m 05j 	 ZA 1970
6  	HANKS Sam 	 42a 10m 17j 	 IND 1957
7  	MANSELL Nigel 	 41a 03m 05j 	 AU 1994
8  	TRINTIGNANT Maurice 	 40a 06m 18j 	 MC 1958
9  	HILL Graham 	 40a 03m 03j 	 MC 1969
10  	REGAZZONI Clay 	 39a 10m 09j 	 GB 1979
11  	WALLARD Lee 	 39a 08m 22j 	 IND 1951
12  	REUTEMANN Carlos 	 39a 01m 05j 	 B 1981
13  	PIQUET Nelson 	 38a 09m 16j 	 CDN 1991
14  	PATRESE Riccardo 	 38a 06m 08j 	 J 1992
15  	ANDRETTI Mario 	 38a 05m 30j 	 NL 1978
16  	PROST Alain 	 38a 05m 01j 	 D 1993
17  	WARD Rodger 	 38a 04m 20j 	 IND 1959
18  	HILL Damon 	 37a 11m 13j 	 B 1998
19  	BERGER Gerhard 	 37a 11m 00j 	 D 1997
20  	JABOUILLE Jean-Pierre 	 37a 10m 16j 	 A 1980

[sorry about the screwy layout - I can't work out the justification]
 
highestRacesBeforeWin.GIF


Can you update that and stick Jenson in it? And you should remove him form the "highest number of races without a victory" table too.
 
OK guys sorry for that last question, sorry for bothering you with it. But maybe you know such a stuff from your experience ?

I have one last question - do you know where could i find some information about F1 tracks ? i mean not records of tracks but rather economical information, waht is done on tracks when F1 is not on them, how much terrain do they take etc? I know - google - but maybe you know some sites and would like to share some links ? If it is impossible to get such a info than once again im sorry for bothering you guys.
 
villainpl
I have one last question - do you know where could i find some information about F1 tracks ? i mean not records of tracks but rather economical information, waht is done on tracks when F1 is not on them, how much terrain do they take etc? I know - google - but maybe you know some sites and would like to share some links ? If it is impossible to get such a info than once again im sorry for bothering you guys.
Click to expand...

Most purpose-built race tracks have their own web sites nowadays, look them up on Google.

As for the attendance figures, I'd imagine they keep it a bit of a secret; some places don't advertise the number of people going through the gates every day, or the number of tickets to be sold. They don't want the competition, buyers, and/or shareholders find out attendance figures are to manipulate the value of the track/property/company.

Just a thought. Not sure if it makes any sence. But I'm sure the FIA keeps attendance figures, like prize money amounts, to themselves.
 
Im real patriot so i must ask ;)
How does statistic: lowest number of races until podium look like ?:)
 

Latest Posts

Back