summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2017-07-18 00:10:16 +0200
committeremkael <emkael@tlen.pl>2017-07-18 00:10:16 +0200
commit57b4020aab792a0eae4143a60df744a566e03fd4 (patch)
tree4af0103238cbd09da463c26df6a0553d39af6131
parent927e5c4b494d81735b406ba5dfd5746165a83461 (diff)
* 2017 Austrian and British GP
-rw-r--r--rate.log108
-rw-r--r--sql/results.sql164
2 files changed, 272 insertions, 0 deletions
diff --git a/rate.log b/rate.log
index 0eee53d..c2d8bdb 100644
--- a/rate.log
+++ b/rate.log
@@ -73379,3 +73379,111 @@ Average rating change: 6.16526315789
Podium rating: 7005.66 7189.68
Average rating: 2187.2895
Average rating change: 48.1735714286
+2017 Austrian Grand Prix - qualifying (2017-07-09)
+
+#77 (<Valtteri Bottas (#1161)>) 1[1] 2497.21 2501.75
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2554.18 2555.91
+#44 (<Lewis Hamilton (#1140)>) 3[3] 2568.15 2568.01
+#7 (<Kimi Räikkönen (#1141)>) 4[4] 2301.37 2306.63
+#3 (<Daniel Ricciardo (#1157)>) 5[5] 2545.76 2542.86
+#33 (<Max Verstappen (#1172)>) 6[6] 2293.94 2296.26
+#8 (<Romain Grosjean (#1144)>) 7[7] 2022.05 2034.39
+#11 (<Sergio Pérez (#1155)>) 8[8] 2260.7 2261.03
+#31 (<Esteban Ocon (#1179)>) 9[9] 2183.04 2184.91
+#55 (<Carlos Sainz (#1170)>) 10[10] 2062.82 2068.51
+#27 (<Nico Hülkenberg (#1148)>) 11[11] 2095.44 2098.03
+#14 (<Fernando Alonso (#1127)>) 12[12] 2115.81 2115.87
+#2 (<Stoffel Vandoorne (#1178)>) 13[13] 1945.15 1952.82
+#26 (<Daniil Kvyat (#1166)>) 14[14] 2037.23 2036.89
+#20 (<Kevin Magnussen (#1165)>) 15[15] 2096.25 2091.61
+#30 (<Jolyon Palmer (#1175)>) 16[16] 2023.98 2021.03
+#19 (<Felipe Massa (#1142)>) 17[17] 2011.41 2007.42
+#18 (<Lance Stroll (#1181)>) 18[18] 2146.71 2134.97
+#9 (<Marcus Ericsson (#1167)>) 19[19] 1960.6 1953.04
+#94 (<Pascal Wehrlein (#1177)>) 20[20] 2024.0 2013.85
+
+Podium rating: 7619.54 7625.67
+Average rating: 2187.29
+Average rating change: 4.4405
+
+2017 Austrian Grand Prix (2017-07-10)
+
+#77 (<Valtteri Bottas (#1161)>) 1[1] 2501.75 2544.83
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2555.91 2563.99
+#3 (<Daniel Ricciardo (#1157)>) 3[2] 2542.86 2553.46
+#44 (<Lewis Hamilton (#1140)>) 4[3] 2568.01 2541.82
+#7 (<Kimi Räikkönen (#1141)>) 5[3] 2306.63 2344.52
+#8 (<Romain Grosjean (#1144)>) 6[4] 2034.39 2149.45
+#11 (<Sergio Pérez (#1155)>) 7[5] 2261.03 2213.63
+#31 (<Esteban Ocon (#1179)>) 8[5] 2184.91 2164.64
+#19 (<Felipe Massa (#1142)>) 9[5] 2007.42 2056.92
+#18 (<Lance Stroll (#1181)>) 10[5] 2134.97 2133.96
+#30 (<Jolyon Palmer (#1175)>) 11[5] 2021.03 2065.3
+#2 (<Stoffel Vandoorne (#1178)>) 12[5] 1952.82 2050.84
+#27 (<Nico Hülkenberg (#1148)>) 13[5] 2098.03 2111.71
+#94 (<Pascal Wehrlein (#1177)>) 14[5] 2013.85 2060.89
+#9 (<Marcus Ericsson (#1167)>) 15[6] 1953.04 1942.95
+#26 (<Daniil Kvyat (#1166)>) 16[7] 2036.89 1974.96
+#55 (<Carlos Sainz (#1170)>) R[0] 2068.51 2068.51
+#20 (<Kevin Magnussen (#1165)>) R[0] 2091.61 2091.61
+#14 (<Fernando Alonso (#1127)>) R[8] 2115.87 1998.42
+#33 (<Max Verstappen (#1172)>) R[8] 2296.26 2113.39
+
+Podium rating: 7600.52 7662.28
+Average rating: 2187.2895
+Average rating change: 51.9127777778
+
+2017 British Grand Prix - qualifying (2017-07-16)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2541.82 2545.42
+#7 (<Kimi Räikkönen (#1141)>) 2[2] 2344.52 2351.41
+#5 (<Sebastian Vettel (#1135)>) 3[3] 2563.99 2563.96
+#77 (<Valtteri Bottas (#1161)>) 4[4] 2544.83 2543.57
+#33 (<Max Verstappen (#1172)>) 5[5] 2113.39 2124.92
+#27 (<Nico Hülkenberg (#1148)>) 6[6] 2111.71 2121.72
+#11 (<Sergio Pérez (#1155)>) 7[7] 2213.63 2217.31
+#31 (<Esteban Ocon (#1179)>) 8[8] 2164.64 2168.91
+#2 (<Stoffel Vandoorne (#1178)>) 9[9] 2050.84 2059.06
+#8 (<Romain Grosjean (#1144)>) 10[10] 2149.45 2151.23
+#30 (<Jolyon Palmer (#1175)>) 11[11] 2065.3 2069.61
+#26 (<Daniil Kvyat (#1166)>) 12[12] 1974.96 1983.61
+#14 (<Fernando Alonso (#1127)>) 13[13] 1998.42 2003.26
+#55 (<Carlos Sainz (#1170)>) 14[14] 2068.51 2066.26
+#19 (<Felipe Massa (#1142)>) 15[15] 2056.92 2053.64
+#18 (<Lance Stroll (#1181)>) 16[16] 2133.96 2125.29
+#20 (<Kevin Magnussen (#1165)>) 17[17] 2091.61 2083.42
+#94 (<Pascal Wehrlein (#1177)>) 18[18] 2060.89 2052.61
+#9 (<Marcus Ericsson (#1167)>) 19[19] 1942.95 1936.59
+#3 (<Daniel Ricciardo (#1157)>) 20[20] 2553.46 2524.03
+
+Podium rating: 7450.33 7460.79
+Average rating: 2187.29
+Average rating change: 6.7765
+
+2017 British Grand Prix (2017-07-17)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2545.42 2579.29
+#77 (<Valtteri Bottas (#1161)>) 2[2] 2543.57 2553.8
+#7 (<Kimi Räikkönen (#1141)>) 3[2] 2351.41 2407.05
+#33 (<Max Verstappen (#1172)>) 4[3] 2124.92 2230.16
+#3 (<Daniel Ricciardo (#1157)>) 5[3] 2524.03 2506.13
+#27 (<Nico Hülkenberg (#1148)>) 6[4] 2121.72 2196.31
+#5 (<Sebastian Vettel (#1135)>) 7[4] 2563.96 2506.33
+#31 (<Esteban Ocon (#1179)>) 8[5] 2168.91 2119.88
+#11 (<Sergio Pérez (#1155)>) 9[5] 2217.31 2149.25
+#19 (<Felipe Massa (#1142)>) 10[5] 2053.64 2052.9
+#2 (<Stoffel Vandoorne (#1178)>) 11[5] 2059.06 2056.07
+#20 (<Kevin Magnussen (#1165)>) 12[5] 2083.42 2070.21
+#8 (<Romain Grosjean (#1144)>) 13[5] 2151.23 2109.46
+#9 (<Marcus Ericsson (#1167)>) 14[5] 1936.59 2000.22
+#26 (<Daniil Kvyat (#1166)>) 15[5] 1983.61 2024.97
+#18 (<Lance Stroll (#1181)>) 16[5] 2125.29 2094.37
+#94 (<Pascal Wehrlein (#1177)>) 17[5] 2052.61 2052.3
+#14 (<Fernando Alonso (#1127)>) R[0] 2003.26 2003.26
+#30 (<Jolyon Palmer (#1175)>) R[0] 2069.61 2069.61
+#55 (<Carlos Sainz (#1170)>) R[6] 2066.26 1964.27
+
+Podium rating: 7440.4 7540.14
+Average rating: 2187.2915
+Average rating change: 42.7283333333
+
diff --git a/sql/results.sql b/sql/results.sql
index 884da5c..196f26d 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2577,6 +2577,10 @@ INSERT INTO `races` VALUES(2571, '2017 Canadian Grand Prix - qualifying', '2017-
INSERT INTO `races` VALUES(2572, '2017 Canadian Grand Prix', '2017-06-11', 0, 4);
INSERT INTO `races` VALUES(2573, '2017 Azerbaijan Grand Prix - qualifying', '2017-06-24', 0, 3);
INSERT INTO `races` VALUES(2574, '2017 Azerbaijan Grand Prix', '2017-06-25', 0, 4);
+INSERT INTO `races` VALUES(2575, '2017 Austrian Grand Prix - qualifying', '2017-07-09', 0, 3);
+INSERT INTO `races` VALUES(2576, '2017 Austrian Grand Prix', '2017-07-10', 0, 4);
+INSERT INTO `races` VALUES(2577, '2017 British Grand Prix - qualifying', '2017-07-16', 0, 3);
+INSERT INTO `races` VALUES(2578, '2017 British Grand Prix', '2017-07-17', 0, 4);
INSERT INTO `countries` VALUES(9, 'Argentina');
INSERT INTO `countries` VALUES(18, 'Australia');
@@ -59164,6 +59168,86 @@ INSERT INTO `entries` VALUES(55361, 'R', 27, 7, 2574);
INSERT INTO `entries` VALUES(55362, 'R', 33, 0, 2574);
INSERT INTO `entries` VALUES(55363, 'R', 26, 0, 2574);
INSERT INTO `entries` VALUES(55364, 'R', 30, 0, 2574);
+INSERT INTO `entries` VALUES(55365, '1', 77, 1, 2575);
+INSERT INTO `entries` VALUES(55366, '2', 5, 2, 2575);
+INSERT INTO `entries` VALUES(55367, '3', 44, 3, 2575);
+INSERT INTO `entries` VALUES(55368, '4', 7, 4, 2575);
+INSERT INTO `entries` VALUES(55369, '5', 3, 5, 2575);
+INSERT INTO `entries` VALUES(55370, '6', 33, 6, 2575);
+INSERT INTO `entries` VALUES(55371, '7', 8, 7, 2575);
+INSERT INTO `entries` VALUES(55372, '8', 11, 8, 2575);
+INSERT INTO `entries` VALUES(55373, '9', 31, 9, 2575);
+INSERT INTO `entries` VALUES(55374, '10', 55, 10, 2575);
+INSERT INTO `entries` VALUES(55375, '11', 27, 11, 2575);
+INSERT INTO `entries` VALUES(55376, '12', 14, 12, 2575);
+INSERT INTO `entries` VALUES(55377, '13', 2, 13, 2575);
+INSERT INTO `entries` VALUES(55378, '14', 26, 14, 2575);
+INSERT INTO `entries` VALUES(55379, '15', 20, 15, 2575);
+INSERT INTO `entries` VALUES(55380, '16', 30, 16, 2575);
+INSERT INTO `entries` VALUES(55381, '17', 19, 17, 2575);
+INSERT INTO `entries` VALUES(55382, '18', 18, 18, 2575);
+INSERT INTO `entries` VALUES(55383, '19', 9, 19, 2575);
+INSERT INTO `entries` VALUES(55384, '20', 94, 20, 2575);
+INSERT INTO `entries` VALUES(55385, '1', 77, 1, 2576);
+INSERT INTO `entries` VALUES(55386, '2', 5, 2, 2576);
+INSERT INTO `entries` VALUES(55387, '3', 3, 2, 2576);
+INSERT INTO `entries` VALUES(55388, '4', 44, 3, 2576);
+INSERT INTO `entries` VALUES(55389, '5', 7, 3, 2576);
+INSERT INTO `entries` VALUES(55390, '6', 8, 4, 2576);
+INSERT INTO `entries` VALUES(55391, '7', 11, 5, 2576);
+INSERT INTO `entries` VALUES(55392, '8', 31, 5, 2576);
+INSERT INTO `entries` VALUES(55393, '9', 19, 5, 2576);
+INSERT INTO `entries` VALUES(55394, '10', 18, 5, 2576);
+INSERT INTO `entries` VALUES(55395, '11', 30, 5, 2576);
+INSERT INTO `entries` VALUES(55396, '12', 2, 5, 2576);
+INSERT INTO `entries` VALUES(55397, '13', 27, 5, 2576);
+INSERT INTO `entries` VALUES(55398, '14', 94, 5, 2576);
+INSERT INTO `entries` VALUES(55399, '15', 9, 6, 2576);
+INSERT INTO `entries` VALUES(55400, '16', 26, 7, 2576);
+INSERT INTO `entries` VALUES(55401, 'R', 55, 0, 2576);
+INSERT INTO `entries` VALUES(55402, 'R', 20, 0, 2576);
+INSERT INTO `entries` VALUES(55403, 'R', 14, 8, 2576);
+INSERT INTO `entries` VALUES(55404, 'R', 33, 8, 2576);
+INSERT INTO `entries` VALUES(55405, '1', 44, 1, 2577);
+INSERT INTO `entries` VALUES(55406, '2', 7, 2, 2577);
+INSERT INTO `entries` VALUES(55407, '3', 5, 3, 2577);
+INSERT INTO `entries` VALUES(55408, '4', 77, 4, 2577);
+INSERT INTO `entries` VALUES(55409, '5', 33, 5, 2577);
+INSERT INTO `entries` VALUES(55410, '6', 27, 6, 2577);
+INSERT INTO `entries` VALUES(55411, '7', 11, 7, 2577);
+INSERT INTO `entries` VALUES(55412, '8', 31, 8, 2577);
+INSERT INTO `entries` VALUES(55413, '9', 2, 9, 2577);
+INSERT INTO `entries` VALUES(55414, '10', 8, 10, 2577);
+INSERT INTO `entries` VALUES(55415, '11', 30, 11, 2577);
+INSERT INTO `entries` VALUES(55416, '12', 26, 12, 2577);
+INSERT INTO `entries` VALUES(55417, '13', 14, 13, 2577);
+INSERT INTO `entries` VALUES(55418, '14', 55, 14, 2577);
+INSERT INTO `entries` VALUES(55419, '15', 19, 15, 2577);
+INSERT INTO `entries` VALUES(55420, '16', 18, 16, 2577);
+INSERT INTO `entries` VALUES(55421, '17', 20, 17, 2577);
+INSERT INTO `entries` VALUES(55422, '18', 94, 18, 2577);
+INSERT INTO `entries` VALUES(55423, '19', 9, 19, 2577);
+INSERT INTO `entries` VALUES(55424, '20', 3, 20, 2577);
+INSERT INTO `entries` VALUES(55425, '1', 44, 1, 2578);
+INSERT INTO `entries` VALUES(55426, '2', 77, 2, 2578);
+INSERT INTO `entries` VALUES(55427, '3', 7, 2, 2578);
+INSERT INTO `entries` VALUES(55428, '4', 33, 3, 2578);
+INSERT INTO `entries` VALUES(55429, '5', 3, 3, 2578);
+INSERT INTO `entries` VALUES(55430, '6', 27, 4, 2578);
+INSERT INTO `entries` VALUES(55431, '7', 5, 4, 2578);
+INSERT INTO `entries` VALUES(55432, '8', 31, 5, 2578);
+INSERT INTO `entries` VALUES(55433, '9', 11, 5, 2578);
+INSERT INTO `entries` VALUES(55434, '10', 19, 5, 2578);
+INSERT INTO `entries` VALUES(55435, '11', 2, 5, 2578);
+INSERT INTO `entries` VALUES(55436, '12', 20, 5, 2578);
+INSERT INTO `entries` VALUES(55437, '13', 8, 5, 2578);
+INSERT INTO `entries` VALUES(55438, '14', 9, 5, 2578);
+INSERT INTO `entries` VALUES(55439, '15', 26, 5, 2578);
+INSERT INTO `entries` VALUES(55440, '16', 18, 5, 2578);
+INSERT INTO `entries` VALUES(55441, '17', 94, 5, 2578);
+INSERT INTO `entries` VALUES(55442, 'R', 14, 0, 2578);
+INSERT INTO `entries` VALUES(55443, 'R', 55, 6, 2578);
+INSERT INTO `entries` VALUES(55444, 'R', 30, 0, 2578);
INSERT INTO `driver_entries` VALUES(1, 1, 1);
INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -114669,3 +114753,83 @@ INSERT INTO `driver_entries` VALUES(1148, 55361, 55501);
INSERT INTO `driver_entries` VALUES(1172, 55362, 55502);
INSERT INTO `driver_entries` VALUES(1166, 55363, 55503);
INSERT INTO `driver_entries` VALUES(1175, 55364, 55504);
+INSERT INTO `driver_entries` VALUES(1161, 55365, 55505);
+INSERT INTO `driver_entries` VALUES(1135, 55366, 55506);
+INSERT INTO `driver_entries` VALUES(1140, 55367, 55507);
+INSERT INTO `driver_entries` VALUES(1141, 55368, 55508);
+INSERT INTO `driver_entries` VALUES(1157, 55369, 55509);
+INSERT INTO `driver_entries` VALUES(1172, 55370, 55510);
+INSERT INTO `driver_entries` VALUES(1144, 55371, 55511);
+INSERT INTO `driver_entries` VALUES(1155, 55372, 55512);
+INSERT INTO `driver_entries` VALUES(1179, 55373, 55513);
+INSERT INTO `driver_entries` VALUES(1170, 55374, 55514);
+INSERT INTO `driver_entries` VALUES(1148, 55375, 55515);
+INSERT INTO `driver_entries` VALUES(1127, 55376, 55516);
+INSERT INTO `driver_entries` VALUES(1178, 55377, 55517);
+INSERT INTO `driver_entries` VALUES(1166, 55378, 55518);
+INSERT INTO `driver_entries` VALUES(1165, 55379, 55519);
+INSERT INTO `driver_entries` VALUES(1175, 55380, 55520);
+INSERT INTO `driver_entries` VALUES(1142, 55381, 55521);
+INSERT INTO `driver_entries` VALUES(1181, 55382, 55522);
+INSERT INTO `driver_entries` VALUES(1167, 55383, 55523);
+INSERT INTO `driver_entries` VALUES(1177, 55384, 55524);
+INSERT INTO `driver_entries` VALUES(1161, 55385, 55525);
+INSERT INTO `driver_entries` VALUES(1135, 55386, 55526);
+INSERT INTO `driver_entries` VALUES(1157, 55387, 55527);
+INSERT INTO `driver_entries` VALUES(1140, 55388, 55528);
+INSERT INTO `driver_entries` VALUES(1141, 55389, 55529);
+INSERT INTO `driver_entries` VALUES(1144, 55390, 55530);
+INSERT INTO `driver_entries` VALUES(1155, 55391, 55531);
+INSERT INTO `driver_entries` VALUES(1179, 55392, 55532);
+INSERT INTO `driver_entries` VALUES(1142, 55393, 55533);
+INSERT INTO `driver_entries` VALUES(1181, 55394, 55534);
+INSERT INTO `driver_entries` VALUES(1175, 55395, 55535);
+INSERT INTO `driver_entries` VALUES(1178, 55396, 55536);
+INSERT INTO `driver_entries` VALUES(1148, 55397, 55537);
+INSERT INTO `driver_entries` VALUES(1177, 55398, 55538);
+INSERT INTO `driver_entries` VALUES(1167, 55399, 55539);
+INSERT INTO `driver_entries` VALUES(1166, 55400, 55540);
+INSERT INTO `driver_entries` VALUES(1170, 55401, 55541);
+INSERT INTO `driver_entries` VALUES(1165, 55402, 55542);
+INSERT INTO `driver_entries` VALUES(1127, 55403, 55543);
+INSERT INTO `driver_entries` VALUES(1172, 55404, 55544);
+INSERT INTO `driver_entries` VALUES(1140, 55405, 55545);
+INSERT INTO `driver_entries` VALUES(1141, 55406, 55546);
+INSERT INTO `driver_entries` VALUES(1135, 55407, 55547);
+INSERT INTO `driver_entries` VALUES(1161, 55408, 55548);
+INSERT INTO `driver_entries` VALUES(1172, 55409, 55549);
+INSERT INTO `driver_entries` VALUES(1148, 55410, 55550);
+INSERT INTO `driver_entries` VALUES(1155, 55411, 55551);
+INSERT INTO `driver_entries` VALUES(1179, 55412, 55552);
+INSERT INTO `driver_entries` VALUES(1178, 55413, 55553);
+INSERT INTO `driver_entries` VALUES(1144, 55414, 55554);
+INSERT INTO `driver_entries` VALUES(1175, 55415, 55555);
+INSERT INTO `driver_entries` VALUES(1166, 55416, 55556);
+INSERT INTO `driver_entries` VALUES(1127, 55417, 55557);
+INSERT INTO `driver_entries` VALUES(1170, 55418, 55558);
+INSERT INTO `driver_entries` VALUES(1142, 55419, 55559);
+INSERT INTO `driver_entries` VALUES(1181, 55420, 55560);
+INSERT INTO `driver_entries` VALUES(1165, 55421, 55561);
+INSERT INTO `driver_entries` VALUES(1177, 55422, 55562);
+INSERT INTO `driver_entries` VALUES(1167, 55423, 55563);
+INSERT INTO `driver_entries` VALUES(1157, 55424, 55564);
+INSERT INTO `driver_entries` VALUES(1140, 55425, 55565);
+INSERT INTO `driver_entries` VALUES(1161, 55426, 55566);
+INSERT INTO `driver_entries` VALUES(1141, 55427, 55567);
+INSERT INTO `driver_entries` VALUES(1172, 55428, 55568);
+INSERT INTO `driver_entries` VALUES(1157, 55429, 55569);
+INSERT INTO `driver_entries` VALUES(1148, 55430, 55570);
+INSERT INTO `driver_entries` VALUES(1135, 55431, 55571);
+INSERT INTO `driver_entries` VALUES(1179, 55432, 55572);
+INSERT INTO `driver_entries` VALUES(1155, 55433, 55573);
+INSERT INTO `driver_entries` VALUES(1142, 55434, 55574);
+INSERT INTO `driver_entries` VALUES(1178, 55435, 55575);
+INSERT INTO `driver_entries` VALUES(1165, 55436, 55576);
+INSERT INTO `driver_entries` VALUES(1144, 55437, 55577);
+INSERT INTO `driver_entries` VALUES(1167, 55438, 55578);
+INSERT INTO `driver_entries` VALUES(1166, 55439, 55579);
+INSERT INTO `driver_entries` VALUES(1181, 55440, 55580);
+INSERT INTO `driver_entries` VALUES(1177, 55441, 55581);
+INSERT INTO `driver_entries` VALUES(1127, 55442, 55582);
+INSERT INTO `driver_entries` VALUES(1170, 55443, 55583);
+INSERT INTO `driver_entries` VALUES(1175, 55444, 55584);