summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2020-08-11 16:46:13 +0200
committeremkael <emkael@tlen.pl>2020-08-11 16:46:13 +0200
commit8678b0f1616c23ced7657cb3ff2042f4e5c4e827 (patch)
treeb200b21af2a50bb8123046557e5082e6ad0b85ba
parentc415146d9855b0012650f29bf87684cc3de33e40 (diff)
2020 Silverstone Grands Prix
-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 bffb19d..97b3790 100644
--- a/rate.log
+++ b/rate.log
@@ -76449,3 +76449,111 @@ Podium rating: 7661.84 7724.14
Average rating: 2200.443
Average rating change: 33.4089473684
+2020 British Grand Prix - qualifying (2020-08-01)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2606.52 2609.28
+#77 (<Valtteri Bottas (#1161)>) 2[2] 2580.69 2582.28
+#33 (<Max Verstappen (#1172)>) 3[3] 2536.93 2537.74
+#16 (<Charles Leclerc (#1184)>) 4[4] 2148.23 2160.08
+#4 (<Lando Norris (#1186)>) 5[5] 2252.75 2258.68
+#18 (<Lance Stroll (#1181)>) 6[6] 2275.5 2278.95
+#55 (<Carlos Sainz (#1170)>) 7[7] 2169.59 2175.73
+#3 (<Daniel Ricciardo (#1157)>) 8[8] 2185.59 2189.45
+#31 (<Esteban Ocon (#1179)>) 9[9] 2093.07 2099.26
+#5 (<Sebastian Vettel (#1135)>) 10[10] 2102.78 2106.96
+#10 (<Pierre Gasly (#1182)>) 11[11] 2117.0 2118.98
+#23 (<Alexander Albon (#1187)>) 12[12] 2329.95 2321.85
+#27 (<Nico Hülkenberg (#1148)>) 13[13] 2083.9 2084.07
+#26 (<Daniil Kvyat (#1166)>) 14[14] 2092.05 2090.28
+#63 (<George Russell (#1188)>) 15[15] 2046.45 2044.95
+#20 (<Kevin Magnussen (#1165)>) 16[16] 2098.62 2093.38
+#99 (<Antonio Giovinazzi (#1180)>) 17[17] 2119.63 2111.9
+#7 (<Kimi Räikkönen (#1141)>) 18[18] 2116.51 2107.31
+#8 (<Romain Grosjean (#1144)>) 19[19] 2092.64 2082.85
+#6 (<Nicholas Latifi (#1189)>) 20[20] 1856.41 1850.84
+
+Podium rating: 7724.14 7729.3
+Average rating: 2195.2405
+Average rating change: 4.8905
+
+2020 British Grand Prix (2020-08-02)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2609.28 2636.25
+#33 (<Max Verstappen (#1172)>) 2[2] 2537.74 2553.19
+#16 (<Charles Leclerc (#1184)>) 3[2] 2160.08 2291.43
+#3 (<Daniel Ricciardo (#1157)>) 4[3] 2189.45 2277.15
+#4 (<Lando Norris (#1186)>) 5[3] 2258.68 2319.94
+#31 (<Esteban Ocon (#1179)>) 6[4] 2099.26 2166.78
+#10 (<Pierre Gasly (#1182)>) 7[4] 2118.98 2178.71
+#23 (<Alexander Albon (#1187)>) 8[4] 2321.85 2305.1
+#18 (<Lance Stroll (#1181)>) 9[4] 2278.95 2276.89
+#5 (<Sebastian Vettel (#1135)>) 10[4] 2106.96 2171.45
+#77 (<Valtteri Bottas (#1161)>) 11[5] 2582.28 2409.65
+#63 (<George Russell (#1188)>) 12[5] 2044.95 2041.28
+#55 (<Carlos Sainz (#1170)>) 13[5] 2175.73 2120.85
+#99 (<Antonio Giovinazzi (#1180)>) 14[5] 2111.9 2082.43
+#6 (<Nicholas Latifi (#1189)>) 15[5] 1850.84 1932.7
+#8 (<Romain Grosjean (#1144)>) 16[5] 2082.85 2064.78
+#7 (<Kimi Räikkönen (#1141)>) 17[6] 2107.31 2019.66
+#27 (<Nico Hülkenberg (#1148)>) W[0] 2084.07 2084.07
+#26 (<Daniil Kvyat (#1166)>) R[7] 2090.28 1985.32
+#20 (<Kevin Magnussen (#1165)>) R[7] 2093.38 1987.21
+
+Podium rating: 7307.1 7480.87
+Average rating: 2195.241
+Average rating change: 62.7705263158
+
+70th Anniversary Grand Prix - qualifying (2020-08-08)
+
+#77 (<Valtteri Bottas (#1161)>) 1[1] 2409.65 2416.58
+#44 (<Lewis Hamilton (#1140)>) 2[2] 2636.25 2636.64
+#27 (<Nico Hülkenberg (#1148)>) 3[3] 2084.07 2101.01
+#33 (<Max Verstappen (#1172)>) 4[4] 2553.19 2551.77
+#3 (<Daniel Ricciardo (#1157)>) 5[5] 2277.15 2282.39
+#18 (<Lance Stroll (#1181)>) 6[6] 2276.89 2280.54
+#10 (<Pierre Gasly (#1182)>) 7[7] 2178.71 2184.97
+#16 (<Charles Leclerc (#1184)>) 8[8] 2291.43 2291.3
+#23 (<Alexander Albon (#1187)>) 9[9] 2305.1 2302.84
+#4 (<Lando Norris (#1186)>) 10[10] 2319.94 2315.51
+#31 (<Esteban Ocon (#1179)>) 11[11] 2166.78 2167.18
+#5 (<Sebastian Vettel (#1135)>) 12[12] 2171.45 2170.04
+#55 (<Carlos Sainz (#1170)>) 13[13] 2120.85 2120.13
+#8 (<Romain Grosjean (#1144)>) 14[14] 2064.78 2064.97
+#63 (<George Russell (#1188)>) 15[15] 2041.28 2040.89
+#26 (<Daniil Kvyat (#1166)>) 16[16] 1985.32 1984.1
+#20 (<Kevin Magnussen (#1165)>) 17[17] 1987.21 1983.49
+#6 (<Nicholas Latifi (#1189)>) 18[18] 1932.7 1929.27
+#99 (<Antonio Giovinazzi (#1180)>) 19[19] 2082.43 2071.44
+#7 (<Kimi Räikkönen (#1141)>) 20[20] 2019.66 2009.79
+
+Podium rating: 7129.97 7154.23
+Average rating: 2195.242
+Average rating change: 3.9995
+
+70th Anniversary Grand Prix (2020-08-09)
+
+#33 (<Max Verstappen (#1172)>) 1[1] 2551.77 2585.22
+#44 (<Lewis Hamilton (#1140)>) 2[2] 2636.64 2632.02
+#77 (<Valtteri Bottas (#1161)>) 3[2] 2416.58 2458.52
+#16 (<Charles Leclerc (#1184)>) 4[3] 2291.3 2343.47
+#23 (<Alexander Albon (#1187)>) 5[3] 2302.84 2350.67
+#18 (<Lance Stroll (#1181)>) 6[4] 2280.54 2276.82
+#27 (<Nico Hülkenberg (#1148)>) 7[4] 2101.01 2171.38
+#31 (<Esteban Ocon (#1179)>) 8[4] 2167.18 2209.74
+#4 (<Lando Norris (#1186)>) 9[4] 2315.51 2298.67
+#26 (<Daniil Kvyat (#1166)>) 10[4] 1984.1 2152.72
+#10 (<Pierre Gasly (#1182)>) 11[5] 2184.97 2152.04
+#5 (<Sebastian Vettel (#1135)>) 12[5] 2170.04 2143.39
+#55 (<Carlos Sainz (#1170)>) 13[5] 2120.13 2114.53
+#3 (<Daniel Ricciardo (#1157)>) 14[6] 2282.39 2133.96
+#7 (<Kimi Räikkönen (#1141)>) 15[6] 2009.79 1972.22
+#8 (<Romain Grosjean (#1144)>) 16[6] 2064.97 2006.08
+#99 (<Antonio Giovinazzi (#1180)>) 17[6] 2071.44 2009.94
+#63 (<George Russell (#1188)>) 18[6] 2040.89 1991.52
+#6 (<Nicholas Latifi (#1189)>) 19[6] 1929.27 1918.46
+#20 (<Kevin Magnussen (#1165)>) R[0] 1983.49 1983.49
+
+Podium rating: 7604.99 7675.76
+Average rating: 2195.2425
+Average rating change: 48.0984210526
+
diff --git a/sql/results.sql b/sql/results.sql
index 13c2b82..71070ac 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2691,6 +2691,10 @@ INSERT INTO `races` VALUES(2685, '2020 Styrian Grand Prix - qualifying', '2020-0
INSERT INTO `races` VALUES(2686, '2020 Styrian Grand Prix', '2020-07-12', 0, 4);
INSERT INTO `races` VALUES(2687, '2020 Hungarian Grand Prix - qualifying', '2020-07-18', 0, 3);
INSERT INTO `races` VALUES(2688, '2020 Hungarian Grand Prix', '2020-07-19', 0, 4);
+INSERT INTO `races` VALUES(2689, '2020 British Grand Prix - qualifying', '2020-08-01', 0, 3);
+INSERT INTO `races` VALUES(2690, '2020 British Grand Prix', '2020-08-02', 0, 4);
+INSERT INTO `races` VALUES(2691, '70th Anniversary Grand Prix - qualifying', '2020-08-08', 0, 3);
+INSERT INTO `races` VALUES(2692, '70th Anniversary Grand Prix', '2020-08-09', 0, 4);
INSERT INTO `countries` VALUES(9, 'Argentina');
INSERT INTO `countries` VALUES(18, 'Australia');
@@ -61563,6 +61567,86 @@ INSERT INTO `entries` VALUES(57639, '17', 99, 4, 2688);
INSERT INTO `entries` VALUES(57640, '18', 63, 4, 2688);
INSERT INTO `entries` VALUES(57641, '19', 6, 5, 2688);
INSERT INTO `entries` VALUES(57642, 'R', 10, 0, 2688);
+INSERT INTO `entries` VALUES(57643, '1', 44, 1, 2689);
+INSERT INTO `entries` VALUES(57644, '2', 77, 2, 2689);
+INSERT INTO `entries` VALUES(57645, '3', 33, 3, 2689);
+INSERT INTO `entries` VALUES(57646, '4', 16, 4, 2689);
+INSERT INTO `entries` VALUES(57647, '5', 4, 5, 2689);
+INSERT INTO `entries` VALUES(57648, '6', 18, 6, 2689);
+INSERT INTO `entries` VALUES(57649, '7', 55, 7, 2689);
+INSERT INTO `entries` VALUES(57650, '8', 3, 8, 2689);
+INSERT INTO `entries` VALUES(57651, '9', 31, 9, 2689);
+INSERT INTO `entries` VALUES(57652, '10', 5, 10, 2689);
+INSERT INTO `entries` VALUES(57653, '11', 10, 11, 2689);
+INSERT INTO `entries` VALUES(57654, '12', 23, 12, 2689);
+INSERT INTO `entries` VALUES(57655, '13', 27, 13, 2689);
+INSERT INTO `entries` VALUES(57656, '14', 26, 14, 2689);
+INSERT INTO `entries` VALUES(57657, '15', 63, 15, 2689);
+INSERT INTO `entries` VALUES(57658, '16', 20, 16, 2689);
+INSERT INTO `entries` VALUES(57659, '17', 99, 17, 2689);
+INSERT INTO `entries` VALUES(57660, '18', 7, 18, 2689);
+INSERT INTO `entries` VALUES(57661, '19', 8, 19, 2689);
+INSERT INTO `entries` VALUES(57662, '20', 6, 20, 2689);
+INSERT INTO `entries` VALUES(57663, '1', 44, 1, 2690);
+INSERT INTO `entries` VALUES(57664, '2', 33, 2, 2690);
+INSERT INTO `entries` VALUES(57665, '3', 16, 2, 2690);
+INSERT INTO `entries` VALUES(57666, '4', 3, 3, 2690);
+INSERT INTO `entries` VALUES(57667, '5', 4, 3, 2690);
+INSERT INTO `entries` VALUES(57668, '6', 31, 4, 2690);
+INSERT INTO `entries` VALUES(57669, '7', 10, 4, 2690);
+INSERT INTO `entries` VALUES(57670, '8', 23, 4, 2690);
+INSERT INTO `entries` VALUES(57671, '9', 18, 4, 2690);
+INSERT INTO `entries` VALUES(57672, '10', 5, 4, 2690);
+INSERT INTO `entries` VALUES(57673, '11', 77, 5, 2690);
+INSERT INTO `entries` VALUES(57674, '12', 63, 5, 2690);
+INSERT INTO `entries` VALUES(57675, '13', 55, 5, 2690);
+INSERT INTO `entries` VALUES(57676, '14', 99, 5, 2690);
+INSERT INTO `entries` VALUES(57677, '15', 6, 5, 2690);
+INSERT INTO `entries` VALUES(57678, '16', 8, 5, 2690);
+INSERT INTO `entries` VALUES(57679, '17', 7, 6, 2690);
+INSERT INTO `entries` VALUES(57680, 'R', 26, 7, 2690);
+INSERT INTO `entries` VALUES(57681, 'R', 20, 7, 2690);
+INSERT INTO `entries` VALUES(57682, 'W', 27, 0, 2690);
+INSERT INTO `entries` VALUES(57683, '1', 77, 1, 2691);
+INSERT INTO `entries` VALUES(57684, '2', 44, 2, 2691);
+INSERT INTO `entries` VALUES(57685, '3', 27, 3, 2691);
+INSERT INTO `entries` VALUES(57686, '4', 33, 4, 2691);
+INSERT INTO `entries` VALUES(57687, '5', 3, 5, 2691);
+INSERT INTO `entries` VALUES(57688, '6', 18, 6, 2691);
+INSERT INTO `entries` VALUES(57689, '7', 10, 7, 2691);
+INSERT INTO `entries` VALUES(57690, '8', 16, 8, 2691);
+INSERT INTO `entries` VALUES(57691, '9', 23, 9, 2691);
+INSERT INTO `entries` VALUES(57692, '10', 4, 10, 2691);
+INSERT INTO `entries` VALUES(57693, '11', 31, 11, 2691);
+INSERT INTO `entries` VALUES(57694, '12', 5, 12, 2691);
+INSERT INTO `entries` VALUES(57695, '13', 55, 13, 2691);
+INSERT INTO `entries` VALUES(57696, '14', 8, 14, 2691);
+INSERT INTO `entries` VALUES(57697, '15', 63, 15, 2691);
+INSERT INTO `entries` VALUES(57698, '16', 26, 16, 2691);
+INSERT INTO `entries` VALUES(57699, '17', 20, 17, 2691);
+INSERT INTO `entries` VALUES(57700, '18', 6, 18, 2691);
+INSERT INTO `entries` VALUES(57701, '19', 99, 19, 2691);
+INSERT INTO `entries` VALUES(57702, '20', 7, 20, 2691);
+INSERT INTO `entries` VALUES(57703, '1', 33, 1, 2692);
+INSERT INTO `entries` VALUES(57704, '2', 44, 2, 2692);
+INSERT INTO `entries` VALUES(57705, '3', 77, 2, 2692);
+INSERT INTO `entries` VALUES(57706, '4', 16, 3, 2692);
+INSERT INTO `entries` VALUES(57707, '5', 23, 3, 2692);
+INSERT INTO `entries` VALUES(57708, '6', 18, 4, 2692);
+INSERT INTO `entries` VALUES(57709, '7', 27, 4, 2692);
+INSERT INTO `entries` VALUES(57710, '8', 31, 4, 2692);
+INSERT INTO `entries` VALUES(57711, '9', 4, 4, 2692);
+INSERT INTO `entries` VALUES(57712, '10', 26, 4, 2692);
+INSERT INTO `entries` VALUES(57713, '11', 10, 5, 2692);
+INSERT INTO `entries` VALUES(57714, '12', 5, 5, 2692);
+INSERT INTO `entries` VALUES(57715, '13', 55, 5, 2692);
+INSERT INTO `entries` VALUES(57716, '14', 3, 6, 2692);
+INSERT INTO `entries` VALUES(57717, '15', 7, 6, 2692);
+INSERT INTO `entries` VALUES(57718, '16', 8, 6, 2692);
+INSERT INTO `entries` VALUES(57719, '17', 99, 6, 2692);
+INSERT INTO `entries` VALUES(57720, '18', 63, 6, 2692);
+INSERT INTO `entries` VALUES(57721, '19', 6, 6, 2692);
+INSERT INTO `entries` VALUES(57722, 'R', 20, 0, 2692);
INSERT INTO `driver_entries` VALUES(1, 1, 1);
INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -119345,3 +119429,83 @@ INSERT INTO `driver_entries` VALUES(1180, 57639, 57778);
INSERT INTO `driver_entries` VALUES(1188, 57640, 57779);
INSERT INTO `driver_entries` VALUES(1189, 57641, 57780);
INSERT INTO `driver_entries` VALUES(1182, 57642, 57781);
+INSERT INTO `driver_entries` VALUES(1140, 57643, 57782);
+INSERT INTO `driver_entries` VALUES(1161, 57644, 57783);
+INSERT INTO `driver_entries` VALUES(1172, 57645, 57784);
+INSERT INTO `driver_entries` VALUES(1184, 57646, 57785);
+INSERT INTO `driver_entries` VALUES(1186, 57647, 57786);
+INSERT INTO `driver_entries` VALUES(1181, 57648, 57787);
+INSERT INTO `driver_entries` VALUES(1170, 57649, 57788);
+INSERT INTO `driver_entries` VALUES(1157, 57650, 57789);
+INSERT INTO `driver_entries` VALUES(1179, 57651, 57790);
+INSERT INTO `driver_entries` VALUES(1135, 57652, 57791);
+INSERT INTO `driver_entries` VALUES(1182, 57653, 57792);
+INSERT INTO `driver_entries` VALUES(1187, 57654, 57793);
+INSERT INTO `driver_entries` VALUES(1148, 57655, 57794);
+INSERT INTO `driver_entries` VALUES(1166, 57656, 57795);
+INSERT INTO `driver_entries` VALUES(1188, 57657, 57796);
+INSERT INTO `driver_entries` VALUES(1165, 57658, 57797);
+INSERT INTO `driver_entries` VALUES(1180, 57659, 57798);
+INSERT INTO `driver_entries` VALUES(1141, 57660, 57799);
+INSERT INTO `driver_entries` VALUES(1144, 57661, 57800);
+INSERT INTO `driver_entries` VALUES(1189, 57662, 57801);
+INSERT INTO `driver_entries` VALUES(1140, 57663, 57802);
+INSERT INTO `driver_entries` VALUES(1172, 57664, 57803);
+INSERT INTO `driver_entries` VALUES(1184, 57665, 57804);
+INSERT INTO `driver_entries` VALUES(1157, 57666, 57805);
+INSERT INTO `driver_entries` VALUES(1186, 57667, 57806);
+INSERT INTO `driver_entries` VALUES(1179, 57668, 57807);
+INSERT INTO `driver_entries` VALUES(1182, 57669, 57808);
+INSERT INTO `driver_entries` VALUES(1187, 57670, 57809);
+INSERT INTO `driver_entries` VALUES(1181, 57671, 57810);
+INSERT INTO `driver_entries` VALUES(1135, 57672, 57811);
+INSERT INTO `driver_entries` VALUES(1161, 57673, 57812);
+INSERT INTO `driver_entries` VALUES(1188, 57674, 57813);
+INSERT INTO `driver_entries` VALUES(1170, 57675, 57814);
+INSERT INTO `driver_entries` VALUES(1180, 57676, 57815);
+INSERT INTO `driver_entries` VALUES(1189, 57677, 57816);
+INSERT INTO `driver_entries` VALUES(1144, 57678, 57817);
+INSERT INTO `driver_entries` VALUES(1141, 57679, 57818);
+INSERT INTO `driver_entries` VALUES(1166, 57680, 57819);
+INSERT INTO `driver_entries` VALUES(1165, 57681, 57820);
+INSERT INTO `driver_entries` VALUES(1148, 57682, 57821);
+INSERT INTO `driver_entries` VALUES(1161, 57683, 57822);
+INSERT INTO `driver_entries` VALUES(1140, 57684, 57823);
+INSERT INTO `driver_entries` VALUES(1148, 57685, 57824);
+INSERT INTO `driver_entries` VALUES(1172, 57686, 57825);
+INSERT INTO `driver_entries` VALUES(1157, 57687, 57826);
+INSERT INTO `driver_entries` VALUES(1181, 57688, 57827);
+INSERT INTO `driver_entries` VALUES(1182, 57689, 57828);
+INSERT INTO `driver_entries` VALUES(1184, 57690, 57829);
+INSERT INTO `driver_entries` VALUES(1187, 57691, 57830);
+INSERT INTO `driver_entries` VALUES(1186, 57692, 57831);
+INSERT INTO `driver_entries` VALUES(1179, 57693, 57832);
+INSERT INTO `driver_entries` VALUES(1135, 57694, 57833);
+INSERT INTO `driver_entries` VALUES(1170, 57695, 57834);
+INSERT INTO `driver_entries` VALUES(1144, 57696, 57835);
+INSERT INTO `driver_entries` VALUES(1188, 57697, 57836);
+INSERT INTO `driver_entries` VALUES(1166, 57698, 57837);
+INSERT INTO `driver_entries` VALUES(1165, 57699, 57838);
+INSERT INTO `driver_entries` VALUES(1189, 57700, 57839);
+INSERT INTO `driver_entries` VALUES(1180, 57701, 57840);
+INSERT INTO `driver_entries` VALUES(1141, 57702, 57841);
+INSERT INTO `driver_entries` VALUES(1172, 57703, 57842);
+INSERT INTO `driver_entries` VALUES(1140, 57704, 57843);
+INSERT INTO `driver_entries` VALUES(1161, 57705, 57844);
+INSERT INTO `driver_entries` VALUES(1184, 57706, 57845);
+INSERT INTO `driver_entries` VALUES(1187, 57707, 57846);
+INSERT INTO `driver_entries` VALUES(1181, 57708, 57847);
+INSERT INTO `driver_entries` VALUES(1148, 57709, 57848);
+INSERT INTO `driver_entries` VALUES(1179, 57710, 57849);
+INSERT INTO `driver_entries` VALUES(1186, 57711, 57850);
+INSERT INTO `driver_entries` VALUES(1166, 57712, 57851);
+INSERT INTO `driver_entries` VALUES(1182, 57713, 57852);
+INSERT INTO `driver_entries` VALUES(1135, 57714, 57853);
+INSERT INTO `driver_entries` VALUES(1170, 57715, 57854);
+INSERT INTO `driver_entries` VALUES(1157, 57716, 57855);
+INSERT INTO `driver_entries` VALUES(1141, 57717, 57856);
+INSERT INTO `driver_entries` VALUES(1144, 57718, 57857);
+INSERT INTO `driver_entries` VALUES(1180, 57719, 57858);
+INSERT INTO `driver_entries` VALUES(1188, 57720, 57859);
+INSERT INTO `driver_entries` VALUES(1189, 57721, 57860);
+INSERT INTO `driver_entries` VALUES(1165, 57722, 57861);