summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2016-04-27 14:00:58 +0200
committeremkael <emkael@tlen.pl>2016-04-27 14:00:58 +0200
commitb2d5d58e24103884b8883962ffb49488eedc7270 (patch)
tree36bddeefe2118de19a841059cdcb694009ec9820
parent269ea36274d7ebaf917529df96584add827a73ef (diff)
* death dates for drivers table
-rw-r--r--import/11_death_dates.sql449
-rw-r--r--import/README.md2
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.