summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2017-05-19 17:50:42 +0200
committeremkael <emkael@tlen.pl>2017-05-19 17:50:42 +0200
commitaa5c9332500aa6afb8c98b47d48c97508d5d039c (patch)
treef9037e20abb2f85695fd4a78c97f325b77edf6ad
parent2a2b6bdf9ddd8bd5f5c2d8bdd00cf499903e32c6 (diff)
* 2017 Spanish GP
-rw-r--r--rate.log54
-rw-r--r--sql/results.sql82
2 files changed, 136 insertions, 0 deletions
diff --git a/rate.log b/rate.log
index 3a62819..02e5e1c 100644
--- a/rate.log
+++ b/rate.log
@@ -73165,3 +73165,57 @@ Podium rating: 7309.38 7443.76
Average rating: 2183.762
Average rating change: 45.9538888889
+2017 Spanish Grand Prix - qualifying (2017-05-13)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2662.69 2665.08
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2588.47 2590.53
+#77 (<Valtteri Bottas (#1161)>) 3[3] 2444.21 2447.93
+#7 (<Kimi Räikkönen (#1141)>) 4[4] 2411.08 2414.09
+#33 (<Max Verstappen (#1172)>) 5[5] 2475.16 2474.89
+#3 (<Daniel Ricciardo (#1157)>) 6[6] 2457.21 2455.79
+#14 (<Fernando Alonso (#1127)>) 7[7] 2202.01 2207.08
+#11 (<Sergio Pérez (#1155)>) 8[8] 2215.87 2218.82
+#19 (<Felipe Massa (#1142)>) 9[9] 2119.22 2124.4
+#31 (<Esteban Ocon (#1179)>) 10[10] 2145.17 2147.68
+#20 (<Kevin Magnussen (#1165)>) 11[11] 2034.69 2040.23
+#55 (<Carlos Sainz (#1170)>) 12[12] 2031.86 2035.92
+#27 (<Nico Hülkenberg (#1148)>) 13[13] 2213.47 2208.51
+#8 (<Romain Grosjean (#1144)>) 14[14] 1954.11 1956.82
+#94 (<Pascal Wehrlein (#1177)>) 15[15] 1895.99 1898.99
+#9 (<Marcus Ericsson (#1167)>) 16[16] 1992.79 1988.76
+#30 (<Jolyon Palmer (#1175)>) 17[17] 1863.58 1863.13
+#18 (<Lance Stroll (#1181)>) 18[18] 1938.17 1932.05
+#2 (<Stoffel Vandoorne (#1178)>) 19[19] 1990.77 1979.65
+#26 (<Daniil Kvyat (#1166)>) 20[20] 2038.71 2024.88
+
+Podium rating: 7695.37 7703.54
+Average rating: 2183.7615
+Average rating change: 4.22
+
+2017 Spanish Grand Prix (2017-05-14)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2665.08 2685.66
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2590.53 2598.33
+#3 (<Daniel Ricciardo (#1157)>) 3[2] 2455.79 2490.27
+#11 (<Sergio Pérez (#1155)>) 4[3] 2218.82 2241.99
+#31 (<Esteban Ocon (#1179)>) 5[3] 2147.68 2197.46
+#27 (<Nico Hülkenberg (#1148)>) 6[3] 2208.51 2235.37
+#55 (<Carlos Sainz (#1170)>) 7[3] 2035.92 2131.37
+#94 (<Pascal Wehrlein (#1177)>) 8[3] 1898.99 2096.0
+#26 (<Daniil Kvyat (#1166)>) 9[3] 2024.88 2124.94
+#8 (<Romain Grosjean (#1144)>) 10[3] 1956.82 2127.18
+#9 (<Marcus Ericsson (#1167)>) 11[4] 1988.76 1987.33
+#14 (<Fernando Alonso (#1127)>) 12[4] 2207.08 2110.46
+#19 (<Felipe Massa (#1142)>) 13[4] 2124.4 2059.4
+#20 (<Kevin Magnussen (#1165)>) 14[4] 2040.23 2009.88
+#30 (<Jolyon Palmer (#1175)>) 15[4] 1863.13 1919.08
+#18 (<Lance Stroll (#1181)>) 16[4] 1932.05 1958.17
+#77 (<Valtteri Bottas (#1161)>) R[0] 2447.93 2447.93
+#2 (<Stoffel Vandoorne (#1178)>) R[5] 1979.65 1874.78
+#33 (<Max Verstappen (#1172)>) R[5] 2474.89 2213.08
+#7 (<Kimi Räikkönen (#1141)>) R[5] 2414.09 2166.53
+
+Podium rating: 7711.4 7774.26
+Average rating: 2183.7615
+Average rating change: 85.0136842105
+
diff --git a/sql/results.sql b/sql/results.sql
index 2bc558b..42049dc 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2569,6 +2569,8 @@ INSERT INTO `races` VALUES(2563, '2017 Bahrain Grand Prix - qualifying', '2017-0
INSERT INTO `races` VALUES(2564, '2017 Bahrain Grand Prix', '2017-04-16', 0, 4);
INSERT INTO `races` VALUES(2565, '2017 Russian Grand Prix - qualifying', '2017-04-29', 0, 3);
INSERT INTO `races` VALUES(2566, '2017 Russian Grand Prix', '2017-04-30', 0, 4);
+INSERT INTO `races` VALUES(2567, '2017 Spanish Grand Prix - qualifying', '2017-05-13', 0, 3);
+INSERT INTO `races` VALUES(2568, '2017 Spanish Grand Prix', '2017-05-14', 0, 4);
INSERT INTO `countries` VALUES(9, 'Argentina');
INSERT INTO `countries` VALUES(18, 'Australia');
@@ -58997,6 +58999,46 @@ INSERT INTO `entries` VALUES(55202, 'R', 3, 0, 2566);
INSERT INTO `entries` VALUES(55203, 'R', 30, 7, 2566);
INSERT INTO `entries` VALUES(55204, 'R', 8, 7, 2566);
INSERT INTO `entries` VALUES(55205, 'W', 14, 0, 2566);
+INSERT INTO `entries` VALUES(55206, '1', 44, 1, 2567);
+INSERT INTO `entries` VALUES(55207, '2', 5, 2, 2567);
+INSERT INTO `entries` VALUES(55208, '3', 77, 3, 2567);
+INSERT INTO `entries` VALUES(55209, '4', 7, 4, 2567);
+INSERT INTO `entries` VALUES(55210, '5', 33, 5, 2567);
+INSERT INTO `entries` VALUES(55211, '6', 3, 6, 2567);
+INSERT INTO `entries` VALUES(55212, '7', 14, 7, 2567);
+INSERT INTO `entries` VALUES(55213, '8', 11, 8, 2567);
+INSERT INTO `entries` VALUES(55214, '9', 19, 9, 2567);
+INSERT INTO `entries` VALUES(55215, '10', 31, 10, 2567);
+INSERT INTO `entries` VALUES(55216, '11', 20, 11, 2567);
+INSERT INTO `entries` VALUES(55217, '12', 55, 12, 2567);
+INSERT INTO `entries` VALUES(55218, '13', 27, 13, 2567);
+INSERT INTO `entries` VALUES(55219, '14', 8, 14, 2567);
+INSERT INTO `entries` VALUES(55220, '15', 94, 15, 2567);
+INSERT INTO `entries` VALUES(55221, '16', 9, 16, 2567);
+INSERT INTO `entries` VALUES(55222, '17', 30, 17, 2567);
+INSERT INTO `entries` VALUES(55223, '18', 18, 18, 2567);
+INSERT INTO `entries` VALUES(55224, '19', 2, 19, 2567);
+INSERT INTO `entries` VALUES(55225, '20', 26, 20, 2567);
+INSERT INTO `entries` VALUES(55226, '1', 44, 1, 2568);
+INSERT INTO `entries` VALUES(55227, '2', 5, 2, 2568);
+INSERT INTO `entries` VALUES(55228, '3', 3, 2, 2568);
+INSERT INTO `entries` VALUES(55229, '4', 11, 3, 2568);
+INSERT INTO `entries` VALUES(55230, '5', 31, 3, 2568);
+INSERT INTO `entries` VALUES(55231, '6', 27, 3, 2568);
+INSERT INTO `entries` VALUES(55232, '7', 55, 3, 2568);
+INSERT INTO `entries` VALUES(55233, '8', 94, 3, 2568);
+INSERT INTO `entries` VALUES(55234, '9', 26, 3, 2568);
+INSERT INTO `entries` VALUES(55235, '10', 8, 3, 2568);
+INSERT INTO `entries` VALUES(55236, '11', 9, 4, 2568);
+INSERT INTO `entries` VALUES(55237, '12', 14, 4, 2568);
+INSERT INTO `entries` VALUES(55238, '13', 19, 4, 2568);
+INSERT INTO `entries` VALUES(55239, '14', 20, 4, 2568);
+INSERT INTO `entries` VALUES(55240, '15', 30, 4, 2568);
+INSERT INTO `entries` VALUES(55241, '16', 18, 4, 2568);
+INSERT INTO `entries` VALUES(55242, 'R', 77, 0, 2568);
+INSERT INTO `entries` VALUES(55243, 'R', 2, 5, 2568);
+INSERT INTO `entries` VALUES(55244, 'R', 33, 5, 2568);
+INSERT INTO `entries` VALUES(55245, 'R', 7, 5, 2568);
INSERT INTO `driver_entries` VALUES(1, 1, 1);
INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -114343,3 +114385,43 @@ INSERT INTO `driver_entries` VALUES(1157, 55202, 55342);
INSERT INTO `driver_entries` VALUES(1175, 55203, 55343);
INSERT INTO `driver_entries` VALUES(1144, 55204, 55344);
INSERT INTO `driver_entries` VALUES(1127, 55205, 55345);
+INSERT INTO `driver_entries` VALUES(1140, 55206, 55346);
+INSERT INTO `driver_entries` VALUES(1135, 55207, 55347);
+INSERT INTO `driver_entries` VALUES(1161, 55208, 55348);
+INSERT INTO `driver_entries` VALUES(1141, 55209, 55349);
+INSERT INTO `driver_entries` VALUES(1172, 55210, 55350);
+INSERT INTO `driver_entries` VALUES(1157, 55211, 55351);
+INSERT INTO `driver_entries` VALUES(1127, 55212, 55352);
+INSERT INTO `driver_entries` VALUES(1155, 55213, 55353);
+INSERT INTO `driver_entries` VALUES(1142, 55214, 55354);
+INSERT INTO `driver_entries` VALUES(1179, 55215, 55355);
+INSERT INTO `driver_entries` VALUES(1165, 55216, 55356);
+INSERT INTO `driver_entries` VALUES(1170, 55217, 55357);
+INSERT INTO `driver_entries` VALUES(1148, 55218, 55358);
+INSERT INTO `driver_entries` VALUES(1144, 55219, 55359);
+INSERT INTO `driver_entries` VALUES(1177, 55220, 55360);
+INSERT INTO `driver_entries` VALUES(1167, 55221, 55361);
+INSERT INTO `driver_entries` VALUES(1175, 55222, 55362);
+INSERT INTO `driver_entries` VALUES(1181, 55223, 55363);
+INSERT INTO `driver_entries` VALUES(1178, 55224, 55364);
+INSERT INTO `driver_entries` VALUES(1166, 55225, 55365);
+INSERT INTO `driver_entries` VALUES(1140, 55226, 55366);
+INSERT INTO `driver_entries` VALUES(1135, 55227, 55367);
+INSERT INTO `driver_entries` VALUES(1157, 55228, 55368);
+INSERT INTO `driver_entries` VALUES(1155, 55229, 55369);
+INSERT INTO `driver_entries` VALUES(1179, 55230, 55370);
+INSERT INTO `driver_entries` VALUES(1148, 55231, 55371);
+INSERT INTO `driver_entries` VALUES(1170, 55232, 55372);
+INSERT INTO `driver_entries` VALUES(1177, 55233, 55373);
+INSERT INTO `driver_entries` VALUES(1166, 55234, 55374);
+INSERT INTO `driver_entries` VALUES(1144, 55235, 55375);
+INSERT INTO `driver_entries` VALUES(1167, 55236, 55376);
+INSERT INTO `driver_entries` VALUES(1127, 55237, 55377);
+INSERT INTO `driver_entries` VALUES(1142, 55238, 55378);
+INSERT INTO `driver_entries` VALUES(1165, 55239, 55379);
+INSERT INTO `driver_entries` VALUES(1175, 55240, 55380);
+INSERT INTO `driver_entries` VALUES(1181, 55241, 55381);
+INSERT INTO `driver_entries` VALUES(1161, 55242, 55382);
+INSERT INTO `driver_entries` VALUES(1178, 55243, 55383);
+INSERT INTO `driver_entries` VALUES(1172, 55244, 55384);
+INSERT INTO `driver_entries` VALUES(1141, 55245, 55385);