Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Formula 1 history database

Started by Dino_Besen , Jun 06 2007 11:42

Please log in to reply

48 replies to this topic

#1 Dino_Besen

Member

38 posts
Joined: December 01

Posted 06 June 2007 - 11:42

First update after 3,5 years ... if someone is still interested :-)

http://www.geocities.com/f1db2000/

In XLS file format (Microsoft Excel)

#2 rvbasten

New Member

9 posts
Joined: April 06

Posted 07 June 2007 - 19:51

Wow, it looks great. Thanks!
As a Renault fan I checked the Renault data. I'm sorry to say that I found a little mistake :eek:

Renault raced with Michelin tyres in 1977 and not Goodyear.
I'm sure that with the amount of work you put in to it, a little mistake like that is easy to make.
So compliments and thanks!

#3 Dino_Besen

Member

38 posts
Joined: December 01

Posted 08 June 2007 - 16:07

Thanks ! :-)

After Canada GP I will correct this one.

btw. If this is only one ... then my work is done ... but I don't belive that is the case ... until next mistake ... :-)

#4 f1steveuk

Member

3,588 posts
Joined: June 04

Posted 08 June 2007 - 16:34

Good work. Incredibly similar to the data base I built using FIA records, but sadly they're too big to open side by side to compare data!!! I was in the process of doing all the chassis numbers and designer details, and had to create a second sheet (I think the first sheet was 195,000 cells), but both sheets are in xls, so maybe if others have data bases in xls, they could be combined into the first Atlas TNF publication!!

#5 macoran

Member

3,989 posts
Joined: August 05

Posted 09 June 2007 - 23:18

??? I can't open it, at least not in Excel.
What is a rar file ?

#6 Dino_Besen

Member

38 posts
Joined: December 01

Posted 09 June 2007 - 23:55

RAR is format like ZIP

XLS file is compressed because it's size iz 13MB ... thansk to RAR we have only 1,8MB file :-)

Download link:
http://www.freedownl...R_Download.html

#7 macoran

Member

3,989 posts
Joined: August 05

Posted 11 June 2007 - 10:52

Downloaded it,
hmmm, this is what I get in Excel:

Rar!Ïs
A&tÀ21FÑRHË8‘Æ65
f1history.xlsðdç‚ÐÜú†2Ä—†–Å,ïÕêÀ2›F/8®’‡DZ&‡Dx‚ÐLG˜¿ZD„Äúó½*¸ùœd]F@'VMìÿî“ŒÜÌ_ƒwÍ~ÀZ6ŽˆŸÅ]™(Í"‹Ñ÷QÕ°jZ0þ(c¦ ÎjzpR‘W«q")áÉ®5·IÔú=Dy]E#ÑÈ3°i2'Z.ïÊ…ë6€`·•}Û(¬Z¥v©4Øe«õ×IN±pGžÉj‰Š!ò§Œ‘8å.ÚIùáöWfü fGÒH–³î·îÑ%(M‰ÕQ²6vGÂ41#W®át‘»¶©÷sÛ
¤ê?ñ>/#¡_JÙ÷=ö

Must be doing something wrong I suppose

#8 Rob Ryder

Member

2,603 posts
Joined: June 00

Posted 11 June 2007 - 19:06

Originally posted by macoran
Downloaded it,
hmmm, this is what I get in Excel:

Try this Marc .. a straightforward .zipfile ;)

http://homepage.ntlw...s/f1history.zip

Rob

#9 macoran

Member

3,989 posts
Joined: August 05

Posted 11 June 2007 - 20:25

That's done it Rob :up:

Thanks !!

#10 Dino_Besen

Member

38 posts
Joined: December 01

Posted 13 June 2007 - 18:11

results of Canada 2007 included + corrections

http://www.geocities.com/f1db2000/

#11 Dino_Besen

Member

38 posts
Joined: December 01

Posted 07 July 2007 - 11:25

One very big update, 2 small (Indy 2007, Magny-Coura 2007) and some small corrections

http://www.geocities.com/f1db2000/

waiting for Silverstone :up:

#12 Dino_Besen

Member

38 posts
Joined: December 01

Posted 09 July 2007 - 14:22

http://www.geocities.com/f1db2000/

Update Silverstone 2007 :up:

#13 Rob Semmeling

Member

913 posts
Joined: December 02

Posted 09 July 2007 - 17:35

Impressive stuff, but...

1-5-1994 (...) San Marino (...) Ayrton Senna (...) Spun off

Are you kidding me?

#14 Dino_Besen

Member

38 posts
Joined: December 01

Posted 09 July 2007 - 19:25

ok ... will change to Accident

#15 Dino_Besen

Member

38 posts
Joined: December 01

Posted 23 July 2007 - 21:26

Updated results from Nurburgring 2007 + corrections regarding Kimi Raikkonnen, Cristiano da Matta, Heinz-Harald Frentzen + Ayrton Senna "Reason" at 1994 San Marino GP

have fun !

#16 Hieronymus

Member

2,032 posts
Joined: May 02

Posted 24 July 2007 - 18:12

Dino

This is really a major project of yours. Most interesting and to top it all, you are willing to share it for free. Good on you.

Several others has attempted far less spectacular and informative efforts than yours...at a price though!!

Good luck and thanks again for your efforts.

#17 Dino_Besen

Member

38 posts
Joined: December 01

Posted 24 July 2007 - 22:14

thanks

#18 Dino_Besen

Member

38 posts
Joined: December 01

Posted 30 July 2007 - 20:00

Added qualifying times and their rank for all races from 1950 to 2007 including all times from recent change in qualifying - 3 qualifying runs in one session.

http://www.geocities.com/f1db2000/

#19 Dino_Besen

Member

38 posts
Joined: December 01

Posted 09 August 2007 - 20:57

update - Hungaroring - available

http://www.geocities.com/f1db2000/

#20 quintin cloud

Member

4,649 posts
Joined: June 00

Posted 11 August 2007 - 07:08

I have been looking for the webpage for a long time now, good to see that it is still on the net, I have always found it a good reference when asked interesting questions.

Well done Dino :up:

#21 Ivigras

New Member

11 posts
Joined: September 06

Posted 11 August 2007 - 23:25

Really Impressive, besides of practice.

Seeking the GP of Mexico, find that in the column "Chassis" says BRM 3.0 V12 and in the column "Engine" says, Cooper T86B, seeking but in depth, find that all the year 68 has the same change.

Greetings.

#22 Dino_Besen

Member

38 posts
Joined: December 01

Posted 12 August 2007 - 07:13

Originally posted by Ivigras

Really Impressive, besides of practice.

Seeking the GP of Mexico, find that in the column "Chassis" says BRM 3.0 V12 and in the column "Engine" says, Cooper T86B, seeking but in depth, find that all the year 68 has the same change.

Greetings.

corrected

update available

#23 Dino_Besen

Member

38 posts
Joined: December 01

Posted 03 September 2007 - 20:58

*Update Turkey*

http://www.geocities.com/f1db2000/

enjoy

#24 Dino_Besen

Member

38 posts
Joined: December 01

Posted 12 September 2007 - 20:08

* Update Italy 2007 *

http://www.geocities.com/f1db2000/

enjoy

#25 Dino_Besen

Member

38 posts
Joined: December 01

Posted 18 September 2007 - 17:34

http://www.geocities.com/f1db2000/

Update Belgium 2007

#26 Dino_Besen

Member

38 posts
Joined: December 01

Posted 30 September 2007 - 18:46

http://www.geocities.com/f1db2000/

Update Japan 2007 - Fuji

#27 macoran

Member

3,989 posts
Joined: August 05

Posted 08 October 2007 - 19:57

Originally posted by Dino_Besen
http://www.geocities.com/f1db2000/

Update Japan 2007 - Fuji

Why did some of the 1970 Marches run on STP tyres ? :yawn:

Otherwise.....what a brilliant piece of work :up:

#28 Dino_Besen

Member

38 posts
Joined: December 01

Posted 08 October 2007 - 21:05

Originally posted by macoran

Why did some of the 1970 Marches run on STP tyres ? :yawn:

Otherwise.....what a brilliant piece of work

will be corrected :-)

#29 Jesper O. Hansen

Member

582 posts
Joined: January 03

Posted 09 October 2007 - 13:16

May I suggest to include a team owner og principal, although in the corporate world of current F1 that might be difficult to decide. But over time it would reflect on the changing leadership in teams like McLaren (Bruce McLaren, Teddy Mayer, Ron Dennis) or Sauber (Peter Sauber and now "BMW").
I'm currently using this method for series like World Sportscar Championship in it's various guises, 1980's group A touring cars and NASCAR in general.

Jesper

#30 brickyard

Member

612 posts
Joined: October 01

Posted 09 October 2007 - 16:28

Congratulations Dino... what an excelent job you've done so far.
and thank you for sharing it with us.

In such amount of information some errors will always exist, so we all can help to correct them.

so, you've got to correct this ones:

in 1976 only the Team Tyrrell used the P34.
Depailler debuted the car at the Spanish GP. Only in the next GP two cars were available to Scheckter and Depailler.
In the first three GP's the 007 model was used. And all the private entries also used the 007 model.

Regards

#31 brickyard

Member

612 posts
Joined: October 01

Posted 09 October 2007 - 20:53

Originally posted by brickyard
Congratulations Dino... what an excelent job you've done so far.
and thank you for sharing it with us.

In such amount of information some errors will always exist, so we all can help to correct them.

so, you've got to correct this ones:

in 1976 only the Team Tyrrell used the P34.
Depailler debuted the car at the Spanish GP. Only in the next GP two cars were available to Scheckter and Depailler.
In the first three GP's the 007 model was used. And all the private entries also used the 007 model.

Regards

Also in 1976 Rolf Stommelen drove a works Brabham BT45 at the German GP and not the RAM Racing's BT44B.

take a look here

#32 macoran

Member

3,989 posts
Joined: August 05

Posted 09 October 2007 - 22:50

Originally posted by Dino_Besen

will be corrected :-)

Both Lolas T97/30 in the 1997 Australian GP are listed as having run on Bridgestone tyres and "oils".

Pesnti-Rossi 1976 German GP Tyrrell 007 not P34

#33 brickyard

Member

612 posts
Joined: October 01

Posted 11 October 2007 - 18:36

Hello Dino,

two more corrections:

1977 British GP - Brian McGuire drove a McGuire BM1 but not for Kojima

1977 Japanese GP - Kazuyoshi Hoshino and Noritake Takahara both drove Kojimas KE009 and not Hesketh 308E's

keep up the good work :up:

#34 brickyard

Member

612 posts
Joined: October 01

Posted 11 October 2007 - 21:57

... and at the 1966 British GP, the Shannon Godiva should be Shannon SH1

#35 brickyard

Member

612 posts
Joined: October 01

Posted 12 October 2007 - 19:07

... and another one:

1975 - Dutch and British GP's - #35 Maki , the driver was Hiroshi Fushida (not Hirshi Hiroshi)

regards

#36 Allen Brown

Member

5,540 posts
Joined: December 00

Posted 13 October 2007 - 07:31

Originally posted by brickyard
... and at the 1966 British GP, the Shannon Godiva should be Shannon SH1

Really? What's your source for the 'SH1' designation?

#37 j-ickx-fan

Member

122 posts
Joined: December 03

Posted 13 October 2007 - 10:38

Thank you very much for your fantastic work on this database. :up:

I found a little mistake at the end of the line 17405.
It is the British GP 2001 and the data of the last 6 columns are for the 2000 French GP.
Thought it might helps.

#38 brickyard

Member

612 posts
Joined: October 01

Posted 15 October 2007 - 15:45

Originally posted by Allen Brown
Really? What's your source for the 'SH1' designation?

Hi Allen,

sources: here , here , here and here .

They could be not so reliable sources but Forix and Silhouet both share the same information, so...

I have to check latter as I think I've already read something about it in Mike Lawrence's or David Hodges books.

#39 Allen Brown

Member

5,540 posts
Joined: December 00

Posted 15 October 2007 - 15:56

I'm pretty sure it's been taken from the F1 Register book where Paul has 'SH-1' in quotes, which I take to mean that it's an invented number for identification purposes. Historians often invent model numbers or serial numbers to help track cars (I'm doing it at the moment on the 1950 and 1951 F2 HWMs) but we have to be careful those numbers don't later get mistaken for something original. I would never try to impose my numbering on someone else but I might gently encourage them to use it.

As far as I known, the Shannon didn't have a model number or a chassis number. One wasn't mentioned in period and the car shows no signs of a number today. I record it as "Shannon 66" or "Shannon 1966/F1" to distinguish it from the later minor formulae cars. Other people call it '1'. 'SH-1' is fine too.

Allen

#40 brickyard

Member

612 posts
Joined: October 01

Posted 15 October 2007 - 16:11

Originally posted by Allen Brown
I'm pretty sure it's been taken from the F1 Register book where Paul has 'SH-1' in quotes, which I take to mean that it's an invented number for identification purposes. Historians often invent model numbers or serial numbers to help track cars (I'm doing it at the moment on the 1950 and 1951 F2 HWMs) but we have to be careful those numbers don't later get mistaken for something original. I would never try to impose my numbering on someone else but I might gently encourage them to use it.

As far as I known, the Shannon didn't have a model number or a chassis number. One wasn't mentioned in period and the car shows no signs of a number today. I record it as "Shannon 66" or "Shannon 1966/F1" to distinguish it from the later minor formulae cars. Other people call it '1'. 'SH-1' is fine too.

Allen

Thank you Allen. That's useful information.
Since it's a one-off F1 car, I'll correct my data and simply call it Shannon.

BTW, I have another question/correction to make:

At the 1952 German GP there was a driver racing there called Bernd (or Benhardt) Nacke. But that racer's name was in fact a pseudonym of Karl-Gunther Bechem who was again present the following year. My question is, should those two names be treated as two different entities or should appear as one and only?

thanks!

#41 D-Type

Member

9,706 posts
Joined: February 03

Posted 15 October 2007 - 21:42

I would make both entries the same, say: Karl-Gunther Bechem (pseudonym: Bernd Nacke)

or, if it fits your database searchability better (and searchability is the reason for storing the information in a database) do:
1952 as Bernd Nacke (pseudonym of Karl-Gunther Bechem), and
1953 as Karl-Gunther Bechem (who sometimes used pseudonym Bernd Nacke)

#42 Doug Nye

Member

11,535 posts
Joined: February 02

Posted 15 October 2007 - 21:46

Originally posted by Allen Brown
record it as "Shannon 66" or "Shannon 1966/F1" to distinguish it from the later minor formulae cars. Other people call it '1'. 'SH-1' is fine too.

Allen

Sorry to be vulgar (yet again) - but I genuinely recall the Shannon being described by its driver at Brands Hatch as the above with the addition of a final 'T'. :blush:

DCN

#43 Dino_Besen

Member

38 posts
Joined: December 01

Posted 23 October 2007 - 17:44

*UPDATE*

Added results for China Grand Prix - Shanghai 2007 and Brazil Grand Prix - Interlagos 2007 and corrections to existing data.

http://www.geocities.com/f1db2000/
Download nad enjoy

#44 Dino_Besen

Member

38 posts
Joined: December 01

Posted 24 October 2007 - 18:29

I am taking freedom to tell you that Rob Gray is using data from this database

his site is http://www.atomicf1.com/

:clap:

#45 Dino_Besen

Member

38 posts
Joined: December 01

Posted 11 April 2008 - 21:57

All three races in 2008 added + new collumn (driver nationalitiy)

http://www.geocities.com/f1db2000/

enjoy

#46 ferdinand66

New Member

2 posts
Joined: October 07

Posted 09 November 2009 - 09:45

I think the link http://www.geocities.com/f1db2000/ to download the F1 database doesn't work...

#47 brickyard

Member

612 posts
Joined: October 01

Posted 11 November 2009 - 21:58

I think the link http://www.geocities.com/f1db2000/ to download the F1 database doesn't work...

Off course it doesn't. Geocities was "erased" from the web.

Regards
Luis

#48 ac_Masaryk

Member

48 posts
Joined: June 09

Posted 14 November 2009 - 19:44

are there any way to save these infos?

#49 Dino_Besen

Member

38 posts
Joined: December 01

Posted 28 October 2020 - 18:33

Anyone still interested ? :-)

It's 20th anniversary ... and I was thinking to update it :-)

Work in progress so far - but it will be soon.

Back to The Nostalgia Forum

Quick Navigation

Formula 1 history database

#1 Dino_Besen

#2 rvbasten

#3 Dino_Besen

#4 f1steveuk

#5 macoran

#6 Dino_Besen

#7 macoran

#8 Rob Ryder

#9 macoran

#10 Dino_Besen

#11 Dino_Besen

#12 Dino_Besen

#13 Rob Semmeling

#14 Dino_Besen

#15 Dino_Besen

#16 Hieronymus

#17 Dino_Besen

#18 Dino_Besen

#19 Dino_Besen

#20 quintin cloud

#21 Ivigras

#22 Dino_Besen

#23 Dino_Besen

#24 Dino_Besen

#25 Dino_Besen

#26 Dino_Besen

#27 macoran

#28 Dino_Besen

#29 Jesper O. Hansen

#30 brickyard

#31 brickyard

#32 macoran

#33 brickyard

#34 brickyard

#35 brickyard

#36 Allen Brown

#37 j-ickx-fan

#38 brickyard

#39 Allen Brown

#40 brickyard

#41 D-Type

#42 Doug Nye

#43 Dino_Besen

#44 Dino_Besen

#45 Dino_Besen

#46 ferdinand66

#47 brickyard

#48 ac_Masaryk

#49 Dino_Besen

Sign In