diff options
author | emkael <emkael@tlen.pl> | 2017-07-18 00:10:16 +0200 |
---|---|---|
committer | emkael <emkael@tlen.pl> | 2017-07-18 00:10:16 +0200 |
commit | 57b4020aab792a0eae4143a60df744a566e03fd4 (patch) | |
tree | 4af0103238cbd09da463c26df6a0553d39af6131 | |
parent | 927e5c4b494d81735b406ba5dfd5746165a83461 (diff) |
* 2017 Austrian and British GP
-rw-r--r-- | rate.log | 108 | ||||
-rw-r--r-- | sql/results.sql | 164 |
2 files changed, 272 insertions, 0 deletions
@@ -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); |