summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2019-06-16 23:02:54 +0200
committeremkael <emkael@tlen.pl>2019-06-16 23:02:54 +0200
commit4610227242a6cac7056448c0a94fd5f75c005aad (patch)
treeece664379c518ac7575c2743d77a2f49df209abc
parentbb4a15931f2275646f91c8cb8bc9037deaf3f0f6 (diff)
2019 Canadian 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 b14c371..f7e34d9 100644
--- a/rate.log
+++ b/rate.log
@@ -75478,3 +75478,57 @@ Podium rating: 7897.65 7939.24
Average rating: 2196.724
Average rating change: 65.676
+2019 Canadian Grand Prix - qualifying (2019-06-08)
+
+#5 (<Sebastian Vettel (#1135)>) 1[1] 2552.29 2556.43
+#44 (<Lewis Hamilton (#1140)>) 2[2] 2751.02 2750.67
+#16 (<Charles Leclerc (#1184)>) 3[3] 2147.71 2160.89
+#3 (<Daniel Ricciardo (#1157)>) 4[4] 2144.06 2155.81
+#10 (<Pierre Gasly (#1182)>) 5[5] 2304.8 2308.51
+#77 (<Valtteri Bottas (#1161)>) 6[6] 2635.93 2630.68
+#27 (<Nico Hülkenberg (#1148)>) 7[7] 2016.76 2029.72
+#4 (<Lando Norris (#1186)>) 8[8] 2077.97 2086.43
+#55 (<Carlos Sainz (#1170)>) 9[9] 2237.83 2237.56
+#20 (<Kevin Magnussen (#1165)>) 10[10] 2085.56 2090.46
+#33 (<Max Verstappen (#1172)>) 11[11] 2541.14 2529.48
+#26 (<Daniil Kvyat (#1166)>) 12[12] 2182.38 2179.61
+#99 (<Antonio Giovinazzi (#1180)>) 13[13] 1939.91 1947.54
+#23 (<Alexander Albon (#1187)>) 14[14] 2163.45 2157.52
+#8 (<Romain Grosjean (#1144)>) 15[15] 2200.42 2191.27
+#11 (<Sergio Pérez (#1155)>) 16[16] 2051.42 2047.55
+#7 (<Kimi Räikkönen (#1141)>) 17[17] 2053.8 2048.22
+#18 (<Lance Stroll (#1181)>) 18[18] 1980.95 1974.33
+#63 (<George Russell (#1188)>) 19[19] 1930.29 1924.01
+#88 (<Robert Kubica (#1136)>) 20[20] 1936.81 1927.8
+
+Podium rating: 7451.02 7467.99
+Average rating: 2196.725
+Average rating change: 6.6735
+
+2019 Canadian Grand Prix (2019-06-09)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2750.67 2762.89
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2556.43 2572.36
+#16 (<Charles Leclerc (#1184)>) 3[2] 2160.89 2289.26
+#77 (<Valtteri Bottas (#1161)>) 4[3] 2630.68 2602.46
+#33 (<Max Verstappen (#1172)>) 5[3] 2529.48 2518.28
+#3 (<Daniel Ricciardo (#1157)>) 6[4] 2155.81 2150.33
+#27 (<Nico Hülkenberg (#1148)>) 7[4] 2029.72 2079.7
+#10 (<Pierre Gasly (#1182)>) 8[4] 2308.51 2246.1
+#18 (<Lance Stroll (#1181)>) 9[4] 1974.33 2075.42
+#26 (<Daniil Kvyat (#1166)>) 10[4] 2179.61 2164.17
+#55 (<Carlos Sainz (#1170)>) 11[4] 2237.56 2199.39
+#11 (<Sergio Pérez (#1155)>) 12[4] 2047.55 2089.68
+#9 (<Antonio Giovinazzi (#1180)>) 13[4] 1947.54 2062.23
+#8 (<Romain Grosjean (#1144)>) 14[4] 2191.27 2171.07
+#7 (<Kimi Räikkönen (#1141)>) 15[4] 2048.22 2090.06
+#63 (<George Russell (#1188)>) 16[5] 1924.01 1905.89
+#20 (<Kevin Magnussen (#1165)>) 17[5] 2090.46 2005.53
+#88 (<Robert Kubica (#1136)>) 18[6] 1927.8 1871.92
+#4 (<Lando Norris (#1186)>) R[0] 2086.43 2086.43
+#23 (<Alexander Albon (#1187)>) R[7] 2157.52 1991.32
+
+Podium rating: 7467.99 7624.51
+Average rating: 2196.7245
+Average rating change: 53.2894736842
+
diff --git a/sql/results.sql b/sql/results.sql
index 2332fdb..bb0ed79 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2655,6 +2655,8 @@ INSERT INTO `races` VALUES(2649, '2019 Spanish Grand Prix - qualifying', '2019-0
INSERT INTO `races` VALUES(2650, '2019 Spanish Grand Prix', '2019-05-12', 0, 4);
INSERT INTO `races` VALUES(2651, '2019 Monaco Grand Prix - qualifying', '2019-05-25', 0, 3);
INSERT INTO `races` VALUES(2652, '2019 Monaco Grand Prix', '2019-05-26', 0, 4);
+INSERT INTO `races` VALUES(2653, '2019 Canadian Grand Prix - qualifying', '2019-06-08', 0, 3);
+INSERT INTO `races` VALUES(2654, '2019 Canadian Grand Prix', '2019-06-09', 0, 4);
INSERT INTO `countries` VALUES(9, 'Argentina');
INSERT INTO `countries` VALUES(18, 'Australia');
@@ -60806,6 +60808,46 @@ INSERT INTO `entries` VALUES(56918, '17', 7, 6, 2652);
INSERT INTO `entries` VALUES(56919, '18', 88, 6, 2652);
INSERT INTO `entries` VALUES(56920, '19', 99, 7, 2652);
INSERT INTO `entries` VALUES(56921, 'R', 16, 8, 2652);
+INSERT INTO `entries` VALUES(56922, '1', 5, 1, 2653);
+INSERT INTO `entries` VALUES(56923, '2', 44, 2, 2653);
+INSERT INTO `entries` VALUES(56924, '3', 16, 3, 2653);
+INSERT INTO `entries` VALUES(56925, '4', 3, 4, 2653);
+INSERT INTO `entries` VALUES(56926, '5', 10, 5, 2653);
+INSERT INTO `entries` VALUES(56927, '6', 77, 6, 2653);
+INSERT INTO `entries` VALUES(56928, '7', 27, 7, 2653);
+INSERT INTO `entries` VALUES(56929, '8', 4, 8, 2653);
+INSERT INTO `entries` VALUES(56930, '9', 55, 9, 2653);
+INSERT INTO `entries` VALUES(56931, '10', 20, 10, 2653);
+INSERT INTO `entries` VALUES(56932, '11', 33, 11, 2653);
+INSERT INTO `entries` VALUES(56933, '12', 26, 12, 2653);
+INSERT INTO `entries` VALUES(56934, '13', 99, 13, 2653);
+INSERT INTO `entries` VALUES(56935, '14', 23, 14, 2653);
+INSERT INTO `entries` VALUES(56936, '15', 8, 15, 2653);
+INSERT INTO `entries` VALUES(56937, '16', 11, 16, 2653);
+INSERT INTO `entries` VALUES(56938, '17', 7, 17, 2653);
+INSERT INTO `entries` VALUES(56939, '18', 18, 18, 2653);
+INSERT INTO `entries` VALUES(56940, '19', 63, 19, 2653);
+INSERT INTO `entries` VALUES(56941, '20', 88, 20, 2653);
+INSERT INTO `entries` VALUES(56942, '1', 44, 1, 2654);
+INSERT INTO `entries` VALUES(56943, '2', 5, 2, 2654);
+INSERT INTO `entries` VALUES(56944, '3', 16, 2, 2654);
+INSERT INTO `entries` VALUES(56945, '4', 77, 3, 2654);
+INSERT INTO `entries` VALUES(56946, '5', 33, 3, 2654);
+INSERT INTO `entries` VALUES(56947, '6', 3, 4, 2654);
+INSERT INTO `entries` VALUES(56948, '7', 27, 4, 2654);
+INSERT INTO `entries` VALUES(56949, '8', 10, 4, 2654);
+INSERT INTO `entries` VALUES(56950, '9', 18, 4, 2654);
+INSERT INTO `entries` VALUES(56951, '10', 26, 4, 2654);
+INSERT INTO `entries` VALUES(56952, '11', 55, 4, 2654);
+INSERT INTO `entries` VALUES(56953, '12', 11, 4, 2654);
+INSERT INTO `entries` VALUES(56954, '13', 9, 4, 2654);
+INSERT INTO `entries` VALUES(56955, '14', 8, 4, 2654);
+INSERT INTO `entries` VALUES(56956, '15', 7, 4, 2654);
+INSERT INTO `entries` VALUES(56957, '16', 63, 5, 2654);
+INSERT INTO `entries` VALUES(56958, '17', 20, 5, 2654);
+INSERT INTO `entries` VALUES(56959, '18', 88, 6, 2654);
+INSERT INTO `entries` VALUES(56960, 'R', 23, 7, 2654);
+INSERT INTO `entries` VALUES(56961, 'R', 4, 0, 2654);
INSERT INTO `driver_entries` VALUES(1, 1, 1);
INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -117868,3 +117910,43 @@ INSERT INTO `driver_entries` VALUES(1141, 56918, 57058);
INSERT INTO `driver_entries` VALUES(1136, 56919, 57059);
INSERT INTO `driver_entries` VALUES(1180, 56920, 57060);
INSERT INTO `driver_entries` VALUES(1184, 56921, 57061);
+INSERT INTO `driver_entries` VALUES(1135, 56922, 57062);
+INSERT INTO `driver_entries` VALUES(1140, 56923, 57063);
+INSERT INTO `driver_entries` VALUES(1184, 56924, 57064);
+INSERT INTO `driver_entries` VALUES(1157, 56925, 57065);
+INSERT INTO `driver_entries` VALUES(1182, 56926, 57066);
+INSERT INTO `driver_entries` VALUES(1161, 56927, 57067);
+INSERT INTO `driver_entries` VALUES(1148, 56928, 57068);
+INSERT INTO `driver_entries` VALUES(1186, 56929, 57069);
+INSERT INTO `driver_entries` VALUES(1170, 56930, 57070);
+INSERT INTO `driver_entries` VALUES(1165, 56931, 57071);
+INSERT INTO `driver_entries` VALUES(1172, 56932, 57072);
+INSERT INTO `driver_entries` VALUES(1166, 56933, 57073);
+INSERT INTO `driver_entries` VALUES(1180, 56934, 57074);
+INSERT INTO `driver_entries` VALUES(1187, 56935, 57075);
+INSERT INTO `driver_entries` VALUES(1144, 56936, 57076);
+INSERT INTO `driver_entries` VALUES(1155, 56937, 57077);
+INSERT INTO `driver_entries` VALUES(1141, 56938, 57078);
+INSERT INTO `driver_entries` VALUES(1181, 56939, 57079);
+INSERT INTO `driver_entries` VALUES(1188, 56940, 57080);
+INSERT INTO `driver_entries` VALUES(1136, 56941, 57081);
+INSERT INTO `driver_entries` VALUES(1140, 56942, 57082);
+INSERT INTO `driver_entries` VALUES(1135, 56943, 57083);
+INSERT INTO `driver_entries` VALUES(1184, 56944, 57084);
+INSERT INTO `driver_entries` VALUES(1161, 56945, 57085);
+INSERT INTO `driver_entries` VALUES(1172, 56946, 57086);
+INSERT INTO `driver_entries` VALUES(1157, 56947, 57087);
+INSERT INTO `driver_entries` VALUES(1148, 56948, 57088);
+INSERT INTO `driver_entries` VALUES(1182, 56949, 57089);
+INSERT INTO `driver_entries` VALUES(1181, 56950, 57090);
+INSERT INTO `driver_entries` VALUES(1166, 56951, 57091);
+INSERT INTO `driver_entries` VALUES(1170, 56952, 57092);
+INSERT INTO `driver_entries` VALUES(1155, 56953, 57093);
+INSERT INTO `driver_entries` VALUES(1180, 56954, 57094);
+INSERT INTO `driver_entries` VALUES(1144, 56955, 57095);
+INSERT INTO `driver_entries` VALUES(1141, 56956, 57096);
+INSERT INTO `driver_entries` VALUES(1188, 56957, 57097);
+INSERT INTO `driver_entries` VALUES(1165, 56958, 57098);
+INSERT INTO `driver_entries` VALUES(1136, 56959, 57099);
+INSERT INTO `driver_entries` VALUES(1187, 56960, 57100);
+INSERT INTO `driver_entries` VALUES(1186, 56961, 57101);