summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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 53a3a4e..fec9d9c 100644
--- a/rate.log
+++ b/rate.log
@@ -73273,3 +73273,57 @@ Podium rating: 7269.96 7427.96
Average rating: 2181.549
Average rating change: 59.6966666667
+2017 Canadian Grand Prix - qualifying (2017-06-10)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2570.36 2573.38
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2625.37 2625.85
+#77 (<Valtteri Bottas (#1161)>) 3[3] 2447.81 2450.33
+#7 (<Kimi Räikkönen (#1141)>) 4[4] 2292.61 2298.38
+#33 (<Max Verstappen (#1172)>) 5[5] 2285.37 2289.82
+#3 (<Daniel Ricciardo (#1157)>) 6[6] 2509.98 2506.22
+#19 (<Felipe Massa (#1142)>) 7[7] 2129.53 2137.47
+#11 (<Sergio Pérez (#1155)>) 8[8] 2176.08 2180.29
+#31 (<Esteban Ocon (#1179)>) 9[9] 2139.53 2143.81
+#27 (<Nico Hülkenberg (#1148)>) 10[10] 2229.41 2228.09
+#26 (<Daniil Kvyat (#1166)>) 11[11] 2026.51 2032.82
+#14 (<Fernando Alonso (#1127)>) 12[12] 2110.46 2111.29
+#55 (<Carlos Sainz (#1170)>) 13[13] 2179.44 2175.5
+#8 (<Romain Grosjean (#1144)>) 14[14] 2175.13 2169.78
+#30 (<Jolyon Palmer (#1175)>) 15[15] 1989.02 1989.44
+#2 (<Stoffel Vandoorne (#1178)>) 16[16] 1877.67 1881.09
+#18 (<Lance Stroll (#1181)>) 17[17] 1952.48 1950.06
+#20 (<Kevin Magnussen (#1165)>) 18[18] 2102.83 2092.02
+#9 (<Marcus Ericsson (#1167)>) 19[19] 1924.65 1918.8
+#94 (<Pascal Wehrlein (#1177)>) 20[20] 2001.56 1991.38
+
+Podium rating: 7643.54 7649.56
+Average rating: 2187.29
+Average rating change: 4.364
+
+2017 Canadian Grand Prix (2017-06-11)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2573.38 2600.89
+#77 (<Valtteri Bottas (#1161)>) 2[2] 2450.33 2477.93
+#3 (<Daniel Ricciardo (#1157)>) 3[2] 2506.22 2522.03
+#5 (<Sebastian Vettel (#1135)>) 4[3] 2625.85 2589.21
+#11 (<Sergio Pérez (#1155)>) 5[3] 2180.29 2256.99
+#31 (<Esteban Ocon (#1179)>) 6[4] 2143.81 2194.57
+#7 (<Kimi Räikkönen (#1141)>) 7[4] 2298.38 2294.2
+#27 (<Nico Hülkenberg (#1148)>) 8[4] 2228.09 2247.27
+#18 (<Lance Stroll (#1181)>) 9[5] 1950.06 2002.02
+#8 (<Romain Grosjean (#1144)>) 10[5] 2169.78 2122.48
+#30 (<Jolyon Palmer (#1175)>) 11[5] 1989.44 2023.98
+#20 (<Kevin Magnussen (#1165)>) 12[5] 2092.02 2075.36
+#9 (<Marcus Ericsson (#1167)>) 13[5] 1918.8 1983.49
+#2 (<Stoffel Vandoorne (#1178)>) 14[5] 1881.09 1959.69
+#94 (<Pascal Wehrlein (#1177)>) 15[6] 1991.38 1941.03
+#14 (<Fernando Alonso (#1127)>) 16[0] 2111.29 2111.29
+#26 (<Daniil Kvyat (#1166)>) R[0] 2032.82 2032.82
+#33 (<Max Verstappen (#1172)>) R[0] 2289.82 2289.82
+#19 (<Felipe Massa (#1142)>) R[7] 2137.47 1998.72
+#55 (<Carlos Sainz (#1170)>) R[7] 2175.5 2022.02
+
+Podium rating: 7529.93 7600.85
+Average rating: 2187.291
+Average rating change: 52.63
+
diff --git a/sql/results.sql b/sql/results.sql
index 4b3e66f..a28ac0d 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2573,6 +2573,8 @@ INSERT INTO `races` VALUES(2567, '2017 Spanish Grand Prix - qualifying', '2017-0
INSERT INTO `races` VALUES(2568, '2017 Spanish Grand Prix', '2017-05-14', 0, 4);
INSERT INTO `races` VALUES(2569, '2017 Monaco Grand Prix - qualifying', '2017-05-27', 0, 3);
INSERT INTO `races` VALUES(2570, '2017 Monaco Grand Prix', '2017-05-28', 0, 4);
+INSERT INTO `races` VALUES(2571, '2017 Canadian Grand Prix - qualifying', '2017-06-10', 0, 3);
+INSERT INTO `races` VALUES(2572, '2017 Canadian Grand Prix', '2017-06-11', 0, 4);
INSERT INTO `countries` VALUES(9, 'Argentina');
INSERT INTO `countries` VALUES(18, 'Australia');
@@ -59081,6 +59083,46 @@ INSERT INTO `entries` VALUES(55282, 'R', 9, 6, 2570);
INSERT INTO `entries` VALUES(55283, 'R', 22, 6, 2570);
INSERT INTO `entries` VALUES(55284, 'R', 94, 6, 2570);
INSERT INTO `entries` VALUES(55285, 'R', 27, 0, 2570);
+INSERT INTO `entries` VALUES(55286, '1', 44, 1, 2571);
+INSERT INTO `entries` VALUES(55287, '2', 5, 2, 2571);
+INSERT INTO `entries` VALUES(55288, '3', 77, 3, 2571);
+INSERT INTO `entries` VALUES(55289, '4', 7, 4, 2571);
+INSERT INTO `entries` VALUES(55290, '5', 33, 5, 2571);
+INSERT INTO `entries` VALUES(55291, '6', 3, 6, 2571);
+INSERT INTO `entries` VALUES(55292, '7', 19, 7, 2571);
+INSERT INTO `entries` VALUES(55293, '8', 11, 8, 2571);
+INSERT INTO `entries` VALUES(55294, '9', 31, 9, 2571);
+INSERT INTO `entries` VALUES(55295, '10', 27, 10, 2571);
+INSERT INTO `entries` VALUES(55296, '11', 26, 11, 2571);
+INSERT INTO `entries` VALUES(55297, '12', 14, 12, 2571);
+INSERT INTO `entries` VALUES(55298, '13', 55, 13, 2571);
+INSERT INTO `entries` VALUES(55299, '14', 8, 14, 2571);
+INSERT INTO `entries` VALUES(55300, '15', 30, 15, 2571);
+INSERT INTO `entries` VALUES(55301, '16', 2, 16, 2571);
+INSERT INTO `entries` VALUES(55302, '17', 18, 17, 2571);
+INSERT INTO `entries` VALUES(55303, '18', 20, 18, 2571);
+INSERT INTO `entries` VALUES(55304, '19', 9, 19, 2571);
+INSERT INTO `entries` VALUES(55305, '20', 94, 20, 2571);
+INSERT INTO `entries` VALUES(55306, '1', 44, 1, 2572);
+INSERT INTO `entries` VALUES(55307, '2', 77, 2, 2572);
+INSERT INTO `entries` VALUES(55308, '3', 3, 2, 2572);
+INSERT INTO `entries` VALUES(55309, '4', 5, 3, 2572);
+INSERT INTO `entries` VALUES(55310, '5', 11, 3, 2572);
+INSERT INTO `entries` VALUES(55311, '6', 31, 4, 2572);
+INSERT INTO `entries` VALUES(55312, '7', 7, 4, 2572);
+INSERT INTO `entries` VALUES(55313, '8', 27, 4, 2572);
+INSERT INTO `entries` VALUES(55314, '9', 18, 5, 2572);
+INSERT INTO `entries` VALUES(55315, '10', 8, 5, 2572);
+INSERT INTO `entries` VALUES(55316, '11', 30, 5, 2572);
+INSERT INTO `entries` VALUES(55317, '12', 20, 5, 2572);
+INSERT INTO `entries` VALUES(55318, '13', 9, 5, 2572);
+INSERT INTO `entries` VALUES(55319, '14', 2, 5, 2572);
+INSERT INTO `entries` VALUES(55320, '15', 94, 6, 2572);
+INSERT INTO `entries` VALUES(55321, '16', 14, 0, 2572);
+INSERT INTO `entries` VALUES(55322, 'R', 26, 0, 2572);
+INSERT INTO `entries` VALUES(55323, 'R', 33, 0, 2572);
+INSERT INTO `entries` VALUES(55324, 'R', 19, 7, 2572);
+INSERT INTO `entries` VALUES(55325, 'R', 55, 7, 2572);
INSERT INTO `driver_entries` VALUES(1, 1, 1);
INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -114507,3 +114549,43 @@ INSERT INTO `driver_entries` VALUES(1167, 55282, 55422);
INSERT INTO `driver_entries` VALUES(1123, 55283, 55423);
INSERT INTO `driver_entries` VALUES(1177, 55284, 55424);
INSERT INTO `driver_entries` VALUES(1148, 55285, 55425);
+INSERT INTO `driver_entries` VALUES(1140, 55286, 55426);
+INSERT INTO `driver_entries` VALUES(1135, 55287, 55427);
+INSERT INTO `driver_entries` VALUES(1161, 55288, 55428);
+INSERT INTO `driver_entries` VALUES(1141, 55289, 55429);
+INSERT INTO `driver_entries` VALUES(1172, 55290, 55430);
+INSERT INTO `driver_entries` VALUES(1157, 55291, 55431);
+INSERT INTO `driver_entries` VALUES(1142, 55292, 55432);
+INSERT INTO `driver_entries` VALUES(1155, 55293, 55433);
+INSERT INTO `driver_entries` VALUES(1179, 55294, 55434);
+INSERT INTO `driver_entries` VALUES(1148, 55295, 55435);
+INSERT INTO `driver_entries` VALUES(1166, 55296, 55436);
+INSERT INTO `driver_entries` VALUES(1127, 55297, 55437);
+INSERT INTO `driver_entries` VALUES(1170, 55298, 55438);
+INSERT INTO `driver_entries` VALUES(1144, 55299, 55439);
+INSERT INTO `driver_entries` VALUES(1175, 55300, 55440);
+INSERT INTO `driver_entries` VALUES(1178, 55301, 55441);
+INSERT INTO `driver_entries` VALUES(1181, 55302, 55442);
+INSERT INTO `driver_entries` VALUES(1165, 55303, 55443);
+INSERT INTO `driver_entries` VALUES(1167, 55304, 55444);
+INSERT INTO `driver_entries` VALUES(1177, 55305, 55445);
+INSERT INTO `driver_entries` VALUES(1140, 55306, 55446);
+INSERT INTO `driver_entries` VALUES(1161, 55307, 55447);
+INSERT INTO `driver_entries` VALUES(1157, 55308, 55448);
+INSERT INTO `driver_entries` VALUES(1135, 55309, 55449);
+INSERT INTO `driver_entries` VALUES(1155, 55310, 55450);
+INSERT INTO `driver_entries` VALUES(1179, 55311, 55451);
+INSERT INTO `driver_entries` VALUES(1141, 55312, 55452);
+INSERT INTO `driver_entries` VALUES(1148, 55313, 55453);
+INSERT INTO `driver_entries` VALUES(1181, 55314, 55454);
+INSERT INTO `driver_entries` VALUES(1144, 55315, 55455);
+INSERT INTO `driver_entries` VALUES(1175, 55316, 55456);
+INSERT INTO `driver_entries` VALUES(1165, 55317, 55457);
+INSERT INTO `driver_entries` VALUES(1167, 55318, 55458);
+INSERT INTO `driver_entries` VALUES(1178, 55319, 55459);
+INSERT INTO `driver_entries` VALUES(1177, 55320, 55460);
+INSERT INTO `driver_entries` VALUES(1127, 55321, 55461);
+INSERT INTO `driver_entries` VALUES(1166, 55322, 55462);
+INSERT INTO `driver_entries` VALUES(1172, 55323, 55463);
+INSERT INTO `driver_entries` VALUES(1142, 55324, 55464);
+INSERT INTO `driver_entries` VALUES(1170, 55325, 55465);