diff options
author | emkael <emkael@tlen.pl> | 2016-04-27 14:00:58 +0200 |
---|---|---|
committer | emkael <emkael@tlen.pl> | 2016-04-27 14:00:58 +0200 |
commit | b2d5d58e24103884b8883962ffb49488eedc7270 (patch) | |
tree | 36bddeefe2118de19a841059cdcb694009ec9820 | |
parent | 269ea36274d7ebaf917529df96584add827a73ef (diff) |
* death dates for drivers table
-rw-r--r-- | import/11_death_dates.sql | 449 | ||||
-rw-r--r-- | import/README.md | 2 |
2 files changed, 451 insertions, 0 deletions
diff --git a/import/11_death_dates.sql b/import/11_death_dates.sql new file mode 100644 index 0000000..4414605 --- /dev/null +++ b/import/11_death_dates.sql @@ -0,0 +1,449 @@ +ALTER TABLE drivers ADD dod DATE NULL AFTER dob; +UPDATE drivers SET dod = "2016-03-31" WHERE driverId = 318; -- Bertil Roos +UPDATE drivers SET dod = "2016-01-18" WHERE driverId = 617; -- Mike MacDowel +UPDATE drivers SET dod = "2016-01-09" WHERE driverId = 551; -- Maria de Filippis +UPDATE drivers SET dod = "2015-12-07" WHERE driverId = 367; -- Peter Westbury +UPDATE drivers SET dod = "2015-08-24" WHERE driverId = 51; -- Justin Wilson +UPDATE drivers SET dod = "2015-08-23" WHERE driverId = 389; -- Guy Ligier +UPDATE drivers SET dod = "2015-08-22" WHERE driverId = 743; -- Eric Thompson +UPDATE drivers SET dod = "2015-07-17" WHERE driverId = 824; -- Jules Bianchi +UPDATE drivers SET dod = "2015-07-13" WHERE driverId = 264; -- Andy Sutcliffe +UPDATE drivers SET dod = "2015-07-10" WHERE driverId = 362; -- Peter de Klerk +UPDATE drivers SET dod = "2015-07-01" WHERE driverId = 602; -- Robert La Caze +UPDATE drivers SET dod = "2015-05-29" WHERE driverId = 393; -- Tom Jones +UPDATE drivers SET dod = "2015-05-15" WHERE driverId = 254; -- Renzo Zorzi +UPDATE drivers SET dod = "2015-05-01" WHERE driverId = 490; -- Geoff Duke +UPDATE drivers SET dod = "2015-01-19" WHERE driverId = 626; -- Robert Manzon +UPDATE drivers SET dod = "2015-01-05" WHERE driverId = 306; -- Jean-Pierre Beltoise +UPDATE drivers SET dod = "2014-10-05" WHERE driverId = 110; -- Andrea de Cesaris +UPDATE drivers SET dod = "2014-08-31" WHERE driverId = 395; -- Jonathan Williams +UPDATE drivers SET dod = "2014-06-17" WHERE driverId = 621; -- Paul England +UPDATE drivers SET dod = "2014-05-19" WHERE driverId = 356; -- Jack Brabham +UPDATE drivers SET dod = "2014-05-04" WHERE driverId = 438; -- Tony Settember +UPDATE drivers SET dod = "2014-05-04" WHERE driverId = 371; -- Al Pease +UPDATE drivers SET dod = "2014-01-21" WHERE driverId = 705; -- Tony Crook +UPDATE drivers SET dod = "2014-01-05" WHERE driverId = 391; -- Brian Hart +UPDATE drivers SET dod = "2013-10-24" WHERE driverId = 481; -- Henry Taylor +UPDATE drivers SET dod = "2013-07-29" WHERE driverId = 738; -- Tony Gaze +UPDATE drivers SET dod = "2013-06-15" WHERE driverId = 498; -- Jose Froilan Gonzalez +UPDATE drivers SET dod = "2013-04-17" WHERE driverId = 583; -- Gerino Gerini +UPDATE drivers SET dod = "2013-02-24" WHERE driverId = 293; -- Dave Charlton +UPDATE drivers SET dod = "2012-12-19" WHERE driverId = 462; -- Colin Davis +UPDATE drivers SET dod = "2012-10-31" WHERE driverId = 667; -- John Fitch +UPDATE drivers SET dod = "2012-10-14" WHERE driverId = 532; -- Eddie Russo +UPDATE drivers SET dod = "2012-09-21" WHERE driverId = 662; -- Mike Sparken +UPDATE drivers SET dod = "2012-07-11" WHERE driverId = 609; -- Andre Simon +UPDATE drivers SET dod = "2012-06-03" WHERE driverId = 456; -- Roy Salvadori +UPDATE drivers SET dod = "2012-05-31" WHERE driverId = 756; -- Paul Pietsch +UPDATE drivers SET dod = "2012-05-19" WHERE driverId = 437; -- Ian Burgess +UPDATE drivers SET dod = "2012-05-13" WHERE driverId = 610; -- Les Leston +UPDATE drivers SET dod = "2012-05-10" WHERE driverId = 566; -- Carroll Shelby +UPDATE drivers SET dod = "2012-02-10" WHERE driverId = 698; -- Adolfo Cruz +UPDATE drivers SET dod = "2012-01-29" WHERE driverId = 296; -- Francois Migault +UPDATE drivers SET dod = "2012-01-26" WHERE driverId = 643; -- Roberto Mieres +UPDATE drivers SET dod = "2012-01-24" WHERE driverId = 714; -- Kurt Adolff +UPDATE drivers SET dod = "2011-12-05" WHERE driverId = 320; -- Peter Gethin +UPDATE drivers SET dod = "2011-12-03" WHERE driverId = 469; -- Rob Schroeder +UPDATE drivers SET dod = "2011-11-23" WHERE driverId = 509; -- Jim Rathmann +UPDATE drivers SET dod = "2011-10-31" WHERE driverId = 444; -- Roberto Lippi +UPDATE drivers SET dod = "2011-09-19" WHERE driverId = 428; -- Bernard Collomb +UPDATE drivers SET dod = "2011-08-13" WHERE driverId = 400; -- Chris Lawrence +UPDATE drivers SET dod = "2011-05-15" WHERE driverId = 353; -- Pete Lovely +UPDATE drivers SET dod = "2011-05-03" WHERE driverId = 715; -- Gunther Bechem +UPDATE drivers SET dod = "2011-02-08" WHERE driverId = 331; -- Luiz Bueno +UPDATE drivers SET dod = "2011-01-12" WHERE driverId = 645; -- Clemar Bucci +UPDATE drivers SET dod = "2010-12-17" WHERE driverId = 601; -- Dick Gibson +UPDATE drivers SET dod = "2010-12-10" WHERE driverId = 680; -- Jacques Swaters +UPDATE drivers SET dod = "2010-09-27" WHERE driverId = 401; -- Trevor Taylor +UPDATE drivers SET dod = "2010-07-07" WHERE driverId = 451; -- Frank Dochnal +UPDATE drivers SET dod = "2010-05-15" WHERE driverId = 271; -- Loris Kessel +UPDATE drivers SET dod = "2010-01-13" WHERE driverId = 570; -- Bill Moss +UPDATE drivers SET dod = "2009-11-22" WHERE driverId = 500; -- Gino Munaron +UPDATE drivers SET dod = "2009-08-29" WHERE driverId = 380; -- Frank Gardner +UPDATE drivers SET dod = "2009-07-18" WHERE driverId = 218; -- Ricardo Londono +UPDATE drivers SET dod = "2009-06-16" WHERE driverId = 397; -- Peter Arundell +UPDATE drivers SET dod = "2009-06-02" WHERE driverId = 408; -- Tony Maggs +UPDATE drivers SET dod = "2009-06-01" WHERE driverId = 516; -- Bob Christie +UPDATE drivers SET dod = "2009-05-12" WHERE driverId = 466; -- Heini Walter +UPDATE drivers SET dod = "2009-05-07" WHERE driverId = 459; -- Tony Marsh +UPDATE drivers SET dod = "2009-04-26" WHERE driverId = 805; -- Danny Kladis +UPDATE drivers SET dod = "2009-03-30" WHERE driverId = 334; -- Jackie Pretorius +UPDATE drivers SET dod = "2009-03-24" WHERE driverId = 753; -- Hans Klenk +UPDATE drivers SET dod = "2009-03-23" WHERE driverId = 494; -- Lloyd Ruby +UPDATE drivers SET dod = "2009-02-01" WHERE driverId = 535; -- Jim McWithey +UPDATE drivers SET dod = "2009-01-28" WHERE driverId = 711; -- Oswald Karch +UPDATE drivers SET dod = "2008-12-19" WHERE driverId = 368; -- Sam Tingle +UPDATE drivers SET dod = "2008-12-11" WHERE driverId = 694; -- Giovanni de Riu +UPDATE drivers SET dod = "2008-08-28" WHERE driverId = 403; -- Phil Hill +UPDATE drivers SET dod = "2008-04-29" WHERE driverId = 507; -- Chuck Daigh +UPDATE drivers SET dod = "2008-02-23" WHERE driverId = 632; -- Paul Frere +UPDATE drivers SET dod = "2008-02-06" WHERE driverId = 666; -- Tony Rolt +UPDATE drivers SET dod = "2008-01-03" WHERE driverId = 706; -- Jimmy Stewart +UPDATE drivers SET dod = "2007-11-02" WHERE driverId = 528; -- Don Freeland +UPDATE drivers SET dod = "2007-04-03" WHERE driverId = 739; -- Robin Montgomerie-Charrington +UPDATE drivers SET dod = "2007-03-26" WHERE driverId = 461; -- Heinz Schiller +UPDATE drivers SET dod = "2007-01-22" WHERE driverId = 640; -- Toulo de Graffenried +UPDATE drivers SET dod = "2006-12-15" WHERE driverId = 223; -- Clay Regazzoni +UPDATE drivers SET dod = "2006-12-04" WHERE driverId = 536; -- Len Sutton +UPDATE drivers SET dod = "2006-11-05" WHERE driverId = 806; -- Oscar Gonzalez +UPDATE drivers SET dod = "2006-10-17" WHERE driverId = 384; -- Luki Botha +UPDATE drivers SET dod = "2006-10-12" WHERE driverId = 789; -- Eugene Martin +UPDATE drivers SET dod = "2006-08-31" WHERE driverId = 565; -- Mike Magill +UPDATE drivers SET dod = "2006-07-09" WHERE driverId = 568; -- Azdrubal Fontes +UPDATE drivers SET dod = "2006-06-03" WHERE driverId = 411; -- Doug Serrurier +UPDATE drivers SET dod = "2006-05-29" WHERE driverId = 359; -- Johnny Servoz-Gavin +UPDATE drivers SET dod = "2006-03-29" WHERE driverId = 514; -- Bob Veith +UPDATE drivers SET dod = "2005-10-22" WHERE driverId = 416; -- David Clapham +UPDATE drivers SET dod = "2005-10-13" WHERE driverId = 530; -- Wayne Weiler +UPDATE drivers SET dod = "2005-09-24" WHERE driverId = 553; -- Andre Testut +UPDATE drivers SET dod = "2005-07-11" WHERE driverId = 646; -- Jesus Iglesias +UPDATE drivers SET dod = "2005-04-25" WHERE driverId = 340; -- John Love +UPDATE drivers SET dod = "2005-04-15" WHERE driverId = 656; -- Art Cross +UPDATE drivers SET dod = "2005-04-07" WHERE driverId = 477; -- Cliff Allison +UPDATE drivers SET dod = "2005-03-05" WHERE driverId = 450; -- Ernie de Vos +UPDATE drivers SET dod = "2005-02-13" WHERE driverId = 427; -- Maurice Trintignant +UPDATE drivers SET dod = "2004-09-10" WHERE driverId = 562; -- Jack Turner +UPDATE drivers SET dod = "2004-07-05" WHERE driverId = 449; -- Rodger Ward +UPDATE drivers SET dod = "2004-05-03" WHERE driverId = 744; -- Ken Downing +UPDATE drivers SET dod = "2004-02-15" WHERE driverId = 588; -- Luigi Taramazzo +UPDATE drivers SET dod = "2004-01-20" WHERE driverId = 689; -- Alan Brown +UPDATE drivers SET dod = "2003-10-26" WHERE driverId = 533; -- Johnny Boyd +UPDATE drivers SET dod = "2003-10-19" WHERE driverId = 800; -- Nello Pagani +UPDATE drivers SET dod = "2003-09-27" WHERE driverId = 668; -- Jean Lucas +UPDATE drivers SET dod = "2003-05-21" WHERE driverId = 573; -- Alessandro de Tomaso +UPDATE drivers SET dod = "2003-03-19" WHERE driverId = 648; -- Karl Kling +UPDATE drivers SET dod = "2003-03-10" WHERE driverId = 638; -- Ottorino Volonterio +UPDATE drivers SET dod = "2003-02-26" WHERE driverId = 600; -- Christian Goethals +UPDATE drivers SET dod = "2002-08-29" WHERE driverId = 651; -- Lance Macklin +UPDATE drivers SET dod = "2002-08-06" WHERE driverId = 302; -- Jim Crawford +UPDATE drivers SET dod = "2002-07-29" WHERE driverId = 489; -- Renato Pirocchi +UPDATE drivers SET dod = "2002-04-27" WHERE driverId = 546; -- Arthur Owen +UPDATE drivers SET dod = "2002-04-13" WHERE driverId = 636; -- Desmond Titterington +UPDATE drivers SET dod = "2002-04-09" WHERE driverId = 559; -- Pat Flaherty +UPDATE drivers SET dod = "2002-03-24" WHERE driverId = 575; -- Bob Said +UPDATE drivers SET dod = "2002-03-13" WHERE driverId = 798; -- Bayliss Levrett +UPDATE drivers SET dod = "2002-02-07" WHERE driverId = 486; -- Jack Fairman +UPDATE drivers SET dod = "2002-01-17" WHERE driverId = 779; -- John James +UPDATE drivers SET dod = "2002-01-07" WHERE driverId = 785; -- Geoff Crossley +UPDATE drivers SET dod = "2001-12-02" WHERE driverId = 506; -- Bruce Halford +UPDATE drivers SET dod = "2001-08-28" WHERE driverId = 576; -- Phil Cade +UPDATE drivers SET dod = "2001-08-13" WHERE driverId = 285; -- Otto Stuppacher +UPDATE drivers SET dod = "2001-08-01" WHERE driverId = 463; -- Jay Chamberlain +UPDATE drivers SET dod = "2001-05-26" WHERE driverId = 230; -- Vittorio Brambilla +UPDATE drivers SET dod = "2001-05-02" WHERE driverId = 519; -- Bill Homeier +UPDATE drivers SET dod = "2001-04-25" WHERE driverId = 105; -- Michele Alboreto +UPDATE drivers SET dod = "2001-04-24" WHERE driverId = 757; -- Josef Peters +UPDATE drivers SET dod = "2001-03-28" WHERE driverId = 726; -- George Connor +UPDATE drivers SET dod = "2001-02-28" WHERE driverId = 801; -- Charles Pozzi +UPDATE drivers SET dod = "2001-02-26" WHERE driverId = 699; -- Duke Nalon +UPDATE drivers SET dod = "2001-02-23" WHERE driverId = 644; -- Sergio Mantovani +UPDATE drivers SET dod = "2001-02-04" WHERE driverId = 679; -- Ernie McCoy +UPDATE drivers SET dod = "2001-01-15" WHERE driverId = 417; -- Alex Blignaut +UPDATE drivers SET dod = "2001-01-14" WHERE driverId = 398; -- Vic Wilson +UPDATE drivers SET dod = "2000-07-05" WHERE driverId = 802; -- Dorino Serafini +UPDATE drivers SET dod = "2000-06-29" WHERE driverId = 690; -- Rodney Nuckey +UPDATE drivers SET dod = "2000-02-01" WHERE driverId = 537; -- Dick Rathmann +UPDATE drivers SET dod = "2000-01-17" WHERE driverId = 767; -- Carl Forberg +UPDATE drivers SET dod = "1999-10-18" WHERE driverId = 355; -- John Cannon +UPDATE drivers SET dod = "1999-08-24" WHERE driverId = 424; -- Roberto Bussinello +UPDATE drivers SET dod = "1999-06-01" WHERE driverId = 291; -- Guy Tunmer +UPDATE drivers SET dod = "1999-05-01" WHERE driverId = 778; -- Brian Shawe Taylor +UPDATE drivers SET dod = "1999-02-15" WHERE driverId = 595; -- Billy Garrett +UPDATE drivers SET dod = "1999-02-06" WHERE driverId = 620; -- Umberto Maglioli +UPDATE drivers SET dod = "1998-10-04" WHERE driverId = 464; -- Tony Shelly +UPDATE drivers SET dod = "1998-10-02" WHERE driverId = 482; -- Olivier Gendebien +UPDATE drivers SET dod = "1998-07-28" WHERE driverId = 763; -- Consalvo Sanesi +UPDATE drivers SET dod = "1998-06-16" WHERE driverId = 693; -- Fred Wacker +UPDATE drivers SET dod = "1998-05-10" WHERE driverId = 607; -- Cesare Perdisa +UPDATE drivers SET dod = "1997-09-04" WHERE driverId = 557; -- Chuck Arnold +UPDATE drivers SET dod = "1997-08-24" WHERE driverId = 633; -- Luigi Villoresi +UPDATE drivers SET dod = "1997-08-16" WHERE driverId = 650; -- Jacques Pollet +UPDATE drivers SET dod = "1997-06-27" WHERE driverId = 781; -- Ken Richardson +UPDATE drivers SET dod = "1997-06-01" WHERE driverId = 748; -- Eitel Cantoni +UPDATE drivers SET dod = "1997-05-19" WHERE driverId = 526; -- Troy Ruttman +UPDATE drivers SET dod = "1997-02-06" WHERE driverId = 736; -- Roger Laurent +UPDATE drivers SET dod = "1996-09-28" WHERE driverId = 492; -- Menato Boffa +UPDATE drivers SET dod = "1996-08-13" WHERE driverId = 712; -- Willi Heeks +UPDATE drivers SET dod = "1996-08-06" WHERE driverId = 279; -- Emilio Zapico +UPDATE drivers SET dod = "1996-04-29" WHERE driverId = 604; -- Francois Picard +UPDATE drivers SET dod = "1996-02-19" WHERE driverId = 504; -- Antonio Creus +UPDATE drivers SET dod = "1996-02-01" WHERE driverId = 561; -- Ray Crawford +UPDATE drivers SET dod = "1996-01-23" WHERE driverId = 629; -- Cliff Griffith +UPDATE drivers SET dod = "1996-01-22" WHERE driverId = 803; -- Bill Cantrell +UPDATE drivers SET dod = "1995-11-27" WHERE driverId = 394; -- Giancarlo Baghetti +UPDATE drivers SET dod = "1995-10-18" WHERE driverId = 652; -- Ted Whiteaway +UPDATE drivers SET dod = "1995-08-21" WHERE driverId = 560; -- Bill Cheesbourg +UPDATE drivers SET dod = "1995-08-21" WHERE driverId = 521; -- Chuck Stevenson +UPDATE drivers SET dod = "1995-07-17" WHERE driverId = 579; -- Juan Fangio +UPDATE drivers SET dod = "1995-06-14" WHERE driverId = 522; -- Bobby Grim +UPDATE drivers SET dod = "1995-05-25" WHERE driverId = 625; -- Elie Bayol +UPDATE drivers SET dod = "1995-05-16" WHERE driverId = 517; -- Red Amick +UPDATE drivers SET dod = "1995-03-19" WHERE driverId = 409; -- Trevor Blokdyk +UPDATE drivers SET dod = "1995-03-01" WHERE driverId = 797; -- Jackie Holmes +UPDATE drivers SET dod = "1995-01-28" WHERE driverId = 775; -- Aldo Gordini +UPDATE drivers SET dod = "1994-12-18" WHERE driverId = 731; -- Henry Banks +UPDATE drivers SET dod = "1994-08-05" WHERE driverId = 550; -- Alain de Changy +UPDATE drivers SET dod = "1994-06-27" WHERE driverId = 611; -- Sam Hanks +UPDATE drivers SET dod = "1994-05-13" WHERE driverId = 708; -- Duncan Hamilton +UPDATE drivers SET dod = "1994-05-01" WHERE driverId = 102; -- Ayrton Senna +UPDATE drivers SET dod = "1994-04-30" WHERE driverId = 107; -- Roland Ratzenberger +UPDATE drivers SET dod = "1994-01-14" WHERE driverId = 795; -- Myron Fohr +UPDATE drivers SET dod = "1993-12-27" WHERE driverId = 429; -- Andre Pilette +UPDATE drivers SET dod = "1993-11-28" WHERE driverId = 776; -- Joe Kelly +UPDATE drivers SET dod = "1993-10-22" WHERE driverId = 404; -- Innes Ireland +UPDATE drivers SET dod = "1993-07-13" WHERE driverId = 683; -- Leslie Thorne +UPDATE drivers SET dod = "1993-07-08" WHERE driverId = 685; -- John Riseley-Prichard +UPDATE drivers SET dod = "1993-06-15" WHERE driverId = 231; -- James Hunt +UPDATE drivers SET dod = "1993-05-07" WHERE driverId = 434; -- Hap Sharp +UPDATE drivers SET dod = "1993-03-13" WHERE driverId = 520; -- Gene Hartley +UPDATE drivers SET dod = "1993-03-08" WHERE driverId = 518; -- Duane Carter +UPDATE drivers SET dod = "1993-02-03" WHERE driverId = 585; -- Paul Emery +UPDATE drivers SET dod = "1992-12-26" WHERE driverId = 759; -- Jan Flinterman +UPDATE drivers SET dod = "1992-11-28" WHERE driverId = 676; -- Frank Armi +UPDATE drivers SET dod = "1992-10-04" WHERE driverId = 304; -- Denny Hulme +UPDATE drivers SET dod = "1992-06-28" WHERE driverId = 721; -- Peter Hirt +UPDATE drivers SET dod = "1992-04-14" WHERE driverId = 405; -- Ronnie Bucknum +UPDATE drivers SET dod = "1992-03-03" WHERE driverId = 275; -- Lella Lombardi +UPDATE drivers SET dod = "1992-01-10" WHERE driverId = 499; -- Roberto Bonomi +UPDATE drivers SET dod = "1991-12-18" WHERE driverId = 725; -- George Abecassis +UPDATE drivers SET dod = "1991-08-14" WHERE driverId = 761; -- Alberto Crespo +UPDATE drivers SET dod = "1991-07-30" WHERE driverId = 605; -- Tom Bridger +UPDATE drivers SET dod = "1991-05-15" WHERE driverId = 751; -- Fritz Riess +UPDATE drivers SET dod = "1991-01-07" WHERE driverId = 765; -- Henri Louveau +UPDATE drivers SET dod = "1990-11-28" WHERE driverId = 580; -- Paco Godia +UPDATE drivers SET dod = "1990-11-24" WHERE driverId = 485; -- Juan Manuel Bordeu +UPDATE drivers SET dod = "1990-08-25" WHERE driverId = 784; -- David Hampshire +UPDATE drivers SET dod = "1990-07-26" WHERE driverId = 483; -- Giorgio Scarlatti +UPDATE drivers SET dod = "1990-07-25" WHERE driverId = 792; -- Alfredo Pian +UPDATE drivers SET dod = "1990-05-24" WHERE driverId = 758; -- Dries van der Lof +UPDATE drivers SET dod = "1990-04-18" WHERE driverId = 548; -- Bob Drake +UPDATE drivers SET dod = "1990-01-29" WHERE driverId = 677; -- Travis Webb +UPDATE drivers SET dod = "1990-01-26" WHERE driverId = 619; -- Bob Gerard +UPDATE drivers SET dod = "1989-12-16" WHERE driverId = 695; -- Oscar Galvez +UPDATE drivers SET dod = "1989-10-13" WHERE driverId = 615; -- Fred Agabashian +UPDATE drivers SET dod = "1989-09-20" WHERE driverId = 386; -- Richie Ginther +UPDATE drivers SET dod = "1989-08-20" WHERE driverId = 474; -- Syd van der Vyver +UPDATE drivers SET dod = "1989-08-08" WHERE driverId = 484; -- Brian Naylor +UPDATE drivers SET dod = "1989-06-07" WHERE driverId = 622; -- Chico Landi +UPDATE drivers SET dod = "1989-01-06" WHERE driverId = 524; -- Jim Hurtubise +UPDATE drivers SET dod = "1988-12-29" WHERE driverId = 329; -- Mike Beuttler +UPDATE drivers SET dod = "1988-12-04" WHERE driverId = 623; -- Alberto Uria +UPDATE drivers SET dod = "1988-08-01" WHERE driverId = 678; -- Len Duncan +UPDATE drivers SET dod = "1988-07-04" WHERE driverId = 488; -- Peter Monteverdi +UPDATE drivers SET dod = "1988-04-16" WHERE driverId = 319; -- Jose Dolhem +UPDATE drivers SET dod = "1988-03-24" WHERE driverId = 671; -- Roger Loyer +UPDATE drivers SET dod = "1988-02-14" WHERE driverId = 655; -- Cal Niday +UPDATE drivers SET dod = "1988-01-12" WHERE driverId = 641; -- Piero Taruffi +UPDATE drivers SET dod = "1988-01-03" WHERE driverId = 794; -- Joie Chitwood +UPDATE drivers SET dod = "1987-10-19" WHERE driverId = 691; -- Hermann Lang +UPDATE drivers SET dod = "1987-08-23" WHERE driverId = 202; -- Didier Pironi +UPDATE drivers SET dod = "1987-04-11" WHERE driverId = 710; -- Rudolf Krause +UPDATE drivers SET dod = "1987-03-01" WHERE driverId = 455; -- Wolfgang Seidel +UPDATE drivers SET dod = "1987-02-12" WHERE driverId = 742; -- Dennis Poore +UPDATE drivers SET dod = "1987-02-10" WHERE driverId = 737; -- Robert O'Brien +UPDATE drivers SET dod = "1987-02-10" WHERE driverId = 612; -- Andy Linden +UPDATE drivers SET dod = "1986-11-05" WHERE driverId = 750; -- Adolf Brudes +UPDATE drivers SET dod = "1986-07-15" WHERE driverId = 491; -- Alfonso Thiele +UPDATE drivers SET dod = "1986-07-05" WHERE driverId = 719; -- Albert Scherrer +UPDATE drivers SET dod = "1986-06-02" WHERE driverId = 594; -- Johnnie Tolan +UPDATE drivers SET dod = "1986-06-01" WHERE driverId = 189; -- Jo Gartner +UPDATE drivers SET dod = "1986-05-15" WHERE driverId = 173; -- Elio de Angelis +UPDATE drivers SET dod = "1985-12-23" WHERE driverId = 669; -- Prince Bira +UPDATE drivers SET dod = "1985-11-08" WHERE driverId = 418; -- Masten Gregory +UPDATE drivers SET dod = "1985-10-12" WHERE driverId = 630; -- Duke Dinsmore +UPDATE drivers SET dod = "1985-09-01" WHERE driverId = 185; -- Stefan Bellof +UPDATE drivers SET dod = "1985-08-12" WHERE driverId = 181; -- Manfred Winkelhock +UPDATE drivers SET dod = "1985-07-02" WHERE driverId = 259; -- David Purley +UPDATE drivers SET dod = "1985-05-10" WHERE driverId = 780; -- Toni Branca +UPDATE drivers SET dod = "1985-04-03" WHERE driverId = 752; -- Helmut Niedermayr +UPDATE drivers SET dod = "1984-11-25" WHERE driverId = 799; -- Jimmy Jackson +UPDATE drivers SET dod = "1984-09-08" WHERE driverId = 593; -- Johnnie Parsons +UPDATE drivers SET dod = "1984-08-11" WHERE driverId = 754; -- Marcel Balsa +UPDATE drivers SET dod = "1984-05-20" WHERE driverId = 701; -- Bill Holland +UPDATE drivers SET dod = "1984-05-08" WHERE driverId = 746; -- Gino Bianco +UPDATE drivers SET dod = "1984-03-01" WHERE driverId = 661; -- Peter Walker +UPDATE drivers SET dod = "1983-12-28" WHERE driverId = 774; -- Eugene Chaboud +UPDATE drivers SET dod = "1983-08-21" WHERE driverId = 534; -- Gene Force +UPDATE drivers SET dod = "1983-04-24" WHERE driverId = 243; -- Rolf Stommelen +UPDATE drivers SET dod = "1982-12-29" WHERE driverId = 720; -- Max de Terra +UPDATE drivers SET dod = "1982-12-16" WHERE driverId = 635; -- Colin Chapman +UPDATE drivers SET dod = "1982-11-25" WHERE driverId = 796; -- Walt Ader +UPDATE drivers SET dod = "1982-08-08" WHERE driverId = 688; -- Eric Brandon +UPDATE drivers SET dod = "1982-06-13" WHERE driverId = 204; -- Riccardo Paletti +UPDATE drivers SET dod = "1982-05-08" WHERE driverId = 203; -- Gilles Villeneuve +UPDATE drivers SET dod = "1982-04-07" WHERE driverId = 229; -- Harald Ertl +UPDATE drivers SET dod = "1982-03-18" WHERE driverId = 713; -- Theo Fitzau +UPDATE drivers SET dod = "1981-11-26" WHERE driverId = 467; -- Ernesto Prinoth +UPDATE drivers SET dod = "1981-10-15" WHERE driverId = 777; -- Philip Fotheringham-Parker +UPDATE drivers SET dod = "1981-10-13" WHERE driverId = 741; -- Philippe Etancelin +UPDATE drivers SET dod = "1981-07-30" WHERE driverId = 515; -- Bud Tingelstad +UPDATE drivers SET dod = "1981-03-29" WHERE driverId = 407; -- David Prophet +UPDATE drivers SET dod = "1981-03-23" WHERE driverId = 305; -- Mike Hailwood +UPDATE drivers SET dod = "1981-01-21" WHERE driverId = 787; -- Cuth Harrison +UPDATE drivers SET dod = "1981-01-15" WHERE driverId = 745; -- Graham Whitehead +UPDATE drivers SET dod = "1981-01-01" WHERE driverId = 768; -- Mauri Rose +UPDATE drivers SET dod = "1980-11-04" WHERE driverId = 448; -- Peter Broeker +UPDATE drivers SET dod = "1980-08-01" WHERE driverId = 221; -- Patrick Depailler +UPDATE drivers SET dod = "1979-09-16" WHERE driverId = 458; -- Rob Slotemaker +UPDATE drivers SET dod = "1979-06-22" WHERE driverId = 589; -- Louis Chiron +UPDATE drivers SET dod = "1978-10-20" WHERE driverId = 255; -- Gunnar Nilsson +UPDATE drivers SET dod = "1978-09-11" WHERE driverId = 238; -- Ronnie Peterson +UPDATE drivers SET dod = "1978-04-29" WHERE driverId = 692; -- Theo Helfrich +UPDATE drivers SET dod = "1978-03-07" WHERE driverId = 755; -- Rudolf Schoeller +UPDATE drivers SET dod = "1978-02-09" WHERE driverId = 717; -- Hans von Stuck +UPDATE drivers SET dod = "1977-12-07" WHERE driverId = 783; -- Georges Grignard +UPDATE drivers SET dod = "1977-08-29" WHERE driverId = 266; -- Brian McGuire +UPDATE drivers SET dod = "1977-08-28" WHERE driverId = 387; -- Mike Parkes +UPDATE drivers SET dod = "1977-06-18" WHERE driverId = 762; -- Franco Rol +UPDATE drivers SET dod = "1977-03-18" WHERE driverId = 250; -- Carlos Pace +UPDATE drivers SET dod = "1977-03-11" WHERE driverId = 497; -- Alberto Rodriguez Larreta +UPDATE drivers SET dod = "1977-03-05" WHERE driverId = 252; -- Tom Pryce +UPDATE drivers SET dod = "1976-12-30" WHERE driverId = 723; -- Rudi Fischer +UPDATE drivers SET dod = "1976-11-04" WHERE driverId = 724; -- Toni Ulmen +UPDATE drivers SET dod = "1976-05-30" WHERE driverId = 616; -- Elmer George +UPDATE drivers SET dod = "1976-02-14" WHERE driverId = 634; -- Piero Scotti +UPDATE drivers SET dod = "1976-02-13" WHERE driverId = 555; -- Paul Russo +UPDATE drivers SET dod = "1975-11-29" WHERE driverId = 294; -- Tony Brise +UPDATE drivers SET dod = "1975-11-29" WHERE driverId = 289; -- Graham Hill +UPDATE drivers SET dod = "1975-11-07" WHERE driverId = 760; -- Piero Dusio +UPDATE drivers SET dod = "1975-08-19" WHERE driverId = 288; -- Mark Donohue +UPDATE drivers SET dod = "1974-10-06" WHERE driverId = 324; -- Helmuth Koinigg +UPDATE drivers SET dod = "1974-06-30" WHERE driverId = 513; -- Eddie Johnson +UPDATE drivers SET dod = "1974-05-26" WHERE driverId = 351; -- Silvio Moser +UPDATE drivers SET dod = "1974-03-22" WHERE driverId = 309; -- Peter Revson +UPDATE drivers SET dod = "1974-03-04" WHERE driverId = 749; -- Bill Aston +UPDATE drivers SET dod = "1973-10-21" WHERE driverId = 439; -- Nasif Estefano +UPDATE drivers SET dod = "1973-10-06" WHERE driverId = 327; -- Francois Cevert +UPDATE drivers SET dod = "1973-07-29" WHERE driverId = 335; -- Roger Williamson +UPDATE drivers SET dod = "1973-04-28" WHERE driverId = 544; -- Piero Drogo +UPDATE drivers SET dod = "1973-04-27" WHERE driverId = 496; -- Carlos Menditeguy +UPDATE drivers SET dod = "1973-04-15" WHERE driverId = 709; -- Ernst Klodwig +UPDATE drivers SET dod = "1973-04-05" WHERE driverId = 747; -- David Murray +UPDATE drivers SET dod = "1973-03-30" WHERE driverId = 704; -- Yves Cabantous +UPDATE drivers SET dod = "1972-10-25" WHERE driverId = 804; -- Johnny Mantz +UPDATE drivers SET dod = "1972-07-24" WHERE driverId = 508; -- Lance Reventlow +UPDATE drivers SET dod = "1972-06-11" WHERE driverId = 347; -- Jo Bonnier +UPDATE drivers SET dod = "1971-10-24" WHERE driverId = 346; -- Jo Siffert +UPDATE drivers SET dod = "1971-07-11" WHERE driverId = 345; -- Pedro Rodriguez +UPDATE drivers SET dod = "1971-04-23" WHERE driverId = 539; -- Dempsey Wilson +UPDATE drivers SET dod = "1971-04-19" WHERE driverId = 586; -- Luigi Piotti +UPDATE drivers SET dod = "1971-01-10" WHERE driverId = 363; -- Ignazio Giunti +UPDATE drivers SET dod = "1970-09-05" WHERE driverId = 358; -- Jochen Rindt +UPDATE drivers SET dod = "1970-06-21" WHERE driverId = 361; -- Piers Courage +UPDATE drivers SET dod = "1970-06-02" WHERE driverId = 360; -- Bruce McLaren +UPDATE drivers SET dod = "1969-09-02" WHERE driverId = 435; -- Willy Mairesse +UPDATE drivers SET dod = "1969-02-08" WHERE driverId = 442; -- Kurt Kuhnke +UPDATE drivers SET dod = "1969-08-01" WHERE driverId = 423; -- Gerhard Mitter +UPDATE drivers SET dod = "1969-07-27" WHERE driverId = 382; -- Moises Solana +UPDATE drivers SET dod = "1969-05-26" WHERE driverId = 406; -- Paul Hawkins +UPDATE drivers SET dod = "1969-03-30" WHERE driverId = 376; -- Lucien Bianchi +UPDATE drivers SET dod = "1968-11-04" WHERE driverId = 547; -- Horace Gould +UPDATE drivers SET dod = "1968-07-07" WHERE driverId = 377; -- Jo Schlesser +UPDATE drivers SET dod = "1968-06-08" WHERE driverId = 375; -- Ludovico Scarfiotti +UPDATE drivers SET dod = "1968-05-07" WHERE driverId = 374; -- Mike Spence +UPDATE drivers SET dod = "1968-04-07" WHERE driverId = 373; -- Jim Clark +UPDATE drivers SET dod = "1968-01-07" WHERE driverId = 574; -- George Constantine +UPDATE drivers SET dod = "1967-11-07" WHERE driverId = 420; -- Ian Raby +UPDATE drivers SET dod = "1967-08-23" WHERE driverId = 681; -- Georges Berger +UPDATE drivers SET dod = "1967-08-14" WHERE driverId = 383; -- Bob Anderson +UPDATE drivers SET dod = "1967-06-18" WHERE driverId = 402; -- Giacomo Russo +UPDATE drivers SET dod = "1967-05-10" WHERE driverId = 385; -- Lorenzo Bandini +UPDATE drivers SET dod = "1966-11-12" WHERE driverId = 511; -- Don Branson +UPDATE drivers SET dod = "1966-09-08" WHERE driverId = 399; -- John Taylor +UPDATE drivers SET dod = "1966-08-17" WHERE driverId = 495; -- Ken Miles +UPDATE drivers SET dod = "1966-06-30" WHERE driverId = 642; -- Nino Farina +UPDATE drivers SET dod = "1966-06-11" WHERE driverId = 653; -- Jimmy Davies +UPDATE drivers SET dod = "1966-06-11" WHERE driverId = 564; -- Jud Larson +UPDATE drivers SET dod = "1966-04-07" WHERE driverId = 433; -- Walt Hansgen +UPDATE drivers SET dod = "1966-04-04" WHERE driverId = 556; -- Jimmy Daywalt +UPDATE drivers SET dod = "1966-03-09" WHERE driverId = 649; -- Pablo Birger +UPDATE drivers SET dod = "1965-05-20" WHERE driverId = 431; -- Edgar Barth +UPDATE drivers SET dod = "1965-01-01" WHERE driverId = 415; -- Ray Reed +UPDATE drivers SET dod = "1964-08-02" WHERE driverId = 430; -- Carel Godin de Beaufort +UPDATE drivers SET dod = "1964-05-30" WHERE driverId = 527; -- Eddie Sachs +UPDATE drivers SET dod = "1964-04-01" WHERE driverId = 452; -- Thomas Monarch +UPDATE drivers SET dod = "1964-02-28" WHERE driverId = 470; -- Timmy Mayer +UPDATE drivers SET dod = "1964-01-07" WHERE driverId = 686; -- Reg Parnell +UPDATE drivers SET dod = "1963-11-28" WHERE driverId = 766; -- Lee Wallard +UPDATE drivers SET dod = "1963-05-10" WHERE driverId = 740; -- Franco Comotti +UPDATE drivers SET dod = "1963-03-09" WHERE driverId = 672; -- Jorge Daponte +UPDATE drivers SET dod = "1962-12-21" WHERE driverId = 473; -- Gary Hocking +UPDATE drivers SET dod = "1962-11-01" WHERE driverId = 454; -- Ricardo Rodriguez +UPDATE drivers SET dod = "1962-08-24" WHERE driverId = 523; -- Shorty Templeman +UPDATE drivers SET dod = "1962-08-19" WHERE driverId = 552; -- Jean Lucienbonnet +UPDATE drivers SET dod = "1962-07-02" WHERE driverId = 493; -- Peter Ryan +UPDATE drivers SET dod = "1962-06-02" WHERE driverId = 571; -- Dennis Taylor +UPDATE drivers SET dod = "1962-04-12" WHERE driverId = 541; -- Ron Flockhart +UPDATE drivers SET dod = "1961-11-19" WHERE driverId = 558; -- Al Keller +UPDATE drivers SET dod = "1961-09-10" WHERE driverId = 476; -- Wolfgang von Trips +UPDATE drivers SET dod = "1961-06-15" WHERE driverId = 543; -- Giulio Cabianca +UPDATE drivers SET dod = "1961-05-12" WHERE driverId = 529; -- Tony Bettenhausen +UPDATE drivers SET dod = "1960-09-24" WHERE driverId = 512; -- Johnny Thomson +UPDATE drivers SET dod = "1960-06-28" WHERE driverId = 782; -- Juan Jover +UPDATE drivers SET dod = "1960-06-19" WHERE driverId = 525; -- Jimmy Bryan +UPDATE drivers SET dod = "1960-06-19" WHERE driverId = 505; -- Chris Bristow +UPDATE drivers SET dod = "1960-06-19" WHERE driverId = 502; -- Alan Stacey +UPDATE drivers SET dod = "1960-06-18" WHERE driverId = 538; -- Al Herman +UPDATE drivers SET dod = "1960-05-13" WHERE driverId = 501; -- Harry Schell +UPDATE drivers SET dod = "1960-02-27" WHERE driverId = 503; -- Ettore Chimeri +UPDATE drivers SET dod = "1960-02-23" WHERE driverId = 703; -- Arthur Legat +UPDATE drivers SET dod = "1960-01-31" WHERE driverId = 572; -- Harry Blanchard +UPDATE drivers SET dod = "1959-08-30" WHERE driverId = 596; -- Ed Elisian +UPDATE drivers SET dod = "1959-08-01" WHERE driverId = 554; -- Jean Behra +UPDATE drivers SET dod = "1959-08-01" WHERE driverId = 549; -- Ivor Bueb +UPDATE drivers SET dod = "1959-06-08" WHERE driverId = 790; -- Leslie Johnson +UPDATE drivers SET dod = "1959-05-17" WHERE driverId = 598; -- Jerry Unser +UPDATE drivers SET dod = "1959-04-04" WHERE driverId = 591; -- George Amick +UPDATE drivers SET dod = "1959-02-11" WHERE driverId = 613; -- Marshall Teague +UPDATE drivers SET dod = "1959-01-22" WHERE driverId = 578; -- Mike Hawthorn +UPDATE drivers SET dod = "1958-10-25" WHERE driverId = 590; -- Stuart Lewis-Evans +UPDATE drivers SET dod = "1958-09-22" WHERE driverId = 592; -- Jimmy Reece +UPDATE drivers SET dod = "1958-09-20" WHERE driverId = 687; -- Peter Whitehead +UPDATE drivers SET dod = "1958-08-03" WHERE driverId = 581; -- Peter Collins +UPDATE drivers SET dod = "1958-07-06" WHERE driverId = 577; -- Luigi Musso +UPDATE drivers SET dod = "1958-07-04" WHERE driverId = 599; -- Art Bisch +UPDATE drivers SET dod = "1958-06-14" WHERE driverId = 730; -- George Fonder +UPDATE drivers SET dod = "1958-06-03" WHERE driverId = 716; -- Erwin Bauer +UPDATE drivers SET dod = "1958-05-30" WHERE driverId = 597; -- Pat O'Connor +UPDATE drivers SET dod = "1958-05-19" WHERE driverId = 637; -- Archie Scott Brown +UPDATE drivers SET dod = "1957-07-14" WHERE driverId = 684; -- Bill Whitehouse +UPDATE drivers SET dod = "1957-07-14" WHERE driverId = 618; -- Herbert MacKay-Fraser +UPDATE drivers SET dod = "1957-05-30" WHERE driverId = 722; -- Piero Carini +UPDATE drivers SET dod = "1957-05-15" WHERE driverId = 631; -- Keith Andrews +UPDATE drivers SET dod = "1957-05-12" WHERE driverId = 606; -- Alfonso de Portago +UPDATE drivers SET dod = "1957-03-14" WHERE driverId = 608; -- Eugenio Castellotti +UPDATE drivers SET dod = "1957-01-12" WHERE driverId = 663; -- Ken Wharton +UPDATE drivers SET dod = "1956-10-29" WHERE driverId = 627; -- Louis Rosier +UPDATE drivers SET dod = "1956-06-17" WHERE driverId = 628; -- Bob Sweikert +UPDATE drivers SET dod = "1956-04-22" WHERE driverId = 654; -- Walt Faulkner +UPDATE drivers SET dod = "1956-03-03" WHERE driverId = 718; -- Ernst Loof +UPDATE drivers SET dod = "1956-02-03" WHERE driverId = 660; -- Johnny Claes +UPDATE drivers SET dod = "1955-11-06" WHERE driverId = 658; -- Jack McGrath +UPDATE drivers SET dod = "1955-07-10" WHERE driverId = 659; -- Jerry Hoyt +UPDATE drivers SET dod = "1955-07-09" WHERE driverId = 682; -- Don Beauman +UPDATE drivers SET dod = "1955-06-11" WHERE driverId = 773; -- Pierre Levegh +UPDATE drivers SET dod = "1955-05-30" WHERE driverId = 657; -- Bill Vukovich +UPDATE drivers SET dod = "1955-05-26" WHERE driverId = 647; -- Alberto Ascari +UPDATE drivers SET dod = "1955-05-18" WHERE driverId = 675; -- Manny Ayulo +UPDATE drivers SET dod = "1955-05-01" WHERE driverId = 673; -- Mike Nazaruk +UPDATE drivers SET dod = "1955-03-20" WHERE driverId = 674; -- Larry Crockett +UPDATE drivers SET dod = "1955-02-24" WHERE driverId = 791; -- Clemente Biondetti +UPDATE drivers SET dod = "1954-07-31" WHERE driverId = 670; -- Onofre Marimon +UPDATE drivers SET dod = "1954-07-05" WHERE driverId = 702; -- Bob Scott +UPDATE drivers SET dod = "1954-04-24" WHERE driverId = 764; -- Guy Mairesse +UPDATE drivers SET dod = "1954-02-27" WHERE driverId = 734; -- Bobby Ball +UPDATE drivers SET dod = "1953-11-21" WHERE driverId = 697; -- Felice Bonetto +UPDATE drivers SET dod = "1953-09-18" WHERE driverId = 735; -- Charles de Tornaco +UPDATE drivers SET dod = "1953-05-30" WHERE driverId = 700; -- Carl Scarborough +UPDATE drivers SET dod = "1953-05-15" WHERE driverId = 733; -- Chet Miller +UPDATE drivers SET dod = "1952-11-05" WHERE driverId = 728; -- Joe James +UPDATE drivers SET dod = "1952-09-20" WHERE driverId = 729; -- Bill Schindler +UPDATE drivers SET dod = "1952-08-31" WHERE driverId = 727; -- Jim Rigsby +UPDATE drivers SET dod = "1952-06-20" WHERE driverId = 786; -- Luigi Fagioli +UPDATE drivers SET dod = "1952-06-08" WHERE driverId = 732; -- Johnny McDowell +UPDATE drivers SET dod = "1951-11-11" WHERE driverId = 772; -- Mack Hellings +UPDATE drivers SET dod = "1951-07-29" WHERE driverId = 771; -- Walt Brown +UPDATE drivers SET dod = "1951-07-29" WHERE driverId = 770; -- Cecil Green +UPDATE drivers SET dod = "1951-07-29" WHERE driverId = 769; -- Bill Mackey +UPDATE drivers SET dod = "1950-09-10" WHERE driverId = 793; -- Raymond Sommer +UPDATE drivers SET dod = "1950-07-29" WHERE driverId = 788; -- Joe Fry diff --git a/import/README.md b/import/README.md index 21b9f92..ee5e5de 100644 --- a/import/README.md +++ b/import/README.md @@ -43,4 +43,6 @@ All the script does is running all the `01?_*.sql` scripts against selected data Provided, there's also the `10_fixes.sql` SQL script. It contains fixes for factual errors in the database which have been [reported upstream](http://ergast.com/mrd/bugs), but are yet to have fixes available in the dump. +Also, I've added dates of death for the `drivers` table - in `11_death_dates.sql` dump file. + Note that some data in the original database could easily be normalized - countries, nationalities and such things would work beatifully in a dictionary. I've decided not to include any such normalization for backwards compatibility - all of the queries against the original, vanilla database, work identically against the tweaked database. |