2018 Canadian GP

2 files changed, 136 insertions, 0 deletions

diff --git a/rate.log b/rate.log
index bae3440..2ee726a 100644
--- a/rate.log
+++ b/rate.log
@@ -74349,3 +74349,57 @@ Podium rating:  7398.57 7511.91
 Average rating:  2181.17
 Average rating change:  57.7468421053
 
+2018 Canadian Grand Prix - qualifying (2018-06-09)
+
+#5 (<Sebastian Vettel (#1135)>) 1[1] 2509.49 2513.78
+#77 (<Valtteri Bottas (#1161)>) 2[2] 2512.69 2515.31
+#33 (<Max Verstappen (#1172)>) 3[3] 2187.88 2199.33
+#44 (<Lewis Hamilton (#1140)>) 4[4] 2599.81 2597.5
+#7 (<Kimi Räikkönen (#1141)>) 5[5] 2517.17 2514.89
+#3 (<Daniel Ricciardo (#1157)>) 6[6] 2402.61 2401.61
+#27 (<Nico Hülkenberg (#1148)>) 7[7] 2104.42 2113.28
+#31 (<Esteban Ocon (#1179)>) 8[8] 2097.08 2104.69
+#55 (<Carlos Sainz (#1170)>) 9[9] 2221.49 2221.91
+#11 (<Sergio Pérez (#1155)>) 10[10] 2165.47 2166.71
+#20 (<Kevin Magnussen (#1165)>) 11[11] 2162.22 2162.0
+#28 (<Brendon Hartley (#1183)>) 12[12] 1926.48 1936.87
+#16 (<Charles Leclerc (#1184)>) 13[13] 1953.43 1960.03
+#14 (<Fernando Alonso (#1127)>) 14[14] 2220.75 2211.6
+#2 (<Stoffel Vandoorne (#1178)>) 15[15] 2021.57 2019.98
+#10 (<Pierre Gasly (#1182)>) 16[16] 2099.31 2092.42
+#18 (<Lance Stroll (#1181)>) 17[17] 1972.42 1968.38
+#35 (<Sergey Sirotkin (#1185)>) 18[18] 1939.86 1935.17
+#9 (<Marcus Ericsson (#1167)>) 19[19] 2091.29 2078.38
+#8 (<Romain Grosjean (#1144)>) 20[20] 1917.97 1909.57
+
+Podium rating:  7210.06 7228.42
+Average rating:  2181.1705
+Average rating change:  5.348
+
+2018 Canadian Grand Prix (2018-06-10)
+
+#5 (<Sebastian Vettel (#1135)>) 1[1] 2513.78 2554.37
+#77 (<Valtteri Bottas (#1161)>) 2[2] 2515.31 2531.58
+#33 (<Max Verstappen (#1172)>) 3[2] 2199.33 2308.51
+#3 (<Daniel Ricciardo (#1157)>) 4[3] 2401.61 2412.91
+#44 (<Lewis Hamilton (#1140)>) 5[3] 2597.5 2566.04
+#7 (<Kimi Räikkönen (#1141)>) 6[4] 2514.89 2475.25
+#27 (<Nico Hülkenberg (#1148)>) 7[5] 2113.28 2122.85
+#55 (<Carlos Sainz (#1170)>) 8[5] 2221.91 2186.32
+#31 (<Esteban Ocon (#1179)>) 9[5] 2104.69 2118.09
+#16 (<Charles Leclerc (#1184)>) 10[5] 1960.03 2061.37
+#10 (<Pierre Gasly (#1182)>) 11[5] 2092.42 2111.34
+#8 (<Romain Grosjean (#1144)>) 12[5] 1909.57 2035.68
+#20 (<Kevin Magnussen (#1165)>) 13[5] 2162.0 2150.44
+#11 (<Sergio Pérez (#1155)>) 14[5] 2166.71 2153.18
+#9 (<Marcus Ericsson (#1167)>) 15[6] 2078.38 2003.65
+#2 (<Stoffel Vandoorne (#1178)>) 16[6] 2019.98 1971.81
+#35 (<Sergey Sirotkin (#1185)>) 17[6] 1935.17 1917.11
+#14 (<Fernando Alonso (#1127)>) R[0] 2211.6 2211.6
+#28 (<Brendon Hartley (#1183)>) R[7] 1936.87 1857.97
+#18 (<Lance Stroll (#1181)>) R[7] 1968.38 1873.33
+
+Podium rating:  7228.42 7394.46
+Average rating:  2181.1705
+Average rating change:  47.0194736842
+
diff --git a/sql/results.sql b/sql/results.sql
index c6603c3..fe8cb7e 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2613,6 +2613,8 @@ INSERT INTO `races` VALUES(2607, '2018 Spanish Grand Prix - qualifying', '2018-0
 INSERT INTO `races` VALUES(2608, '2018 Spanish Grand Prix', '2018-05-13', 0, 4);
 INSERT INTO `races` VALUES(2609, '2018 Monaco Grand Prix - qualifying', '2018-05-26', 0, 3);
 INSERT INTO `races` VALUES(2610, '2018 Monaco Grand Prix', '2018-05-27', 0, 4);
+INSERT INTO `races` VALUES(2611, '2018 Canadian Grand Prix - qualifying', '2018-06-09', 0, 3);
+INSERT INTO `races` VALUES(2612, '2018 Canadian Grand Prix', '2018-06-10', 0, 4);
 
 INSERT INTO `countries` VALUES(9, 'Argentina');
 INSERT INTO `countries` VALUES(18, 'Australia');
@@ -59923,6 +59925,46 @@ INSERT INTO `entries` VALUES(56080, '17', 18, 6, 2610);
 INSERT INTO `entries` VALUES(56081, 'R', 16, 7, 2610);
 INSERT INTO `entries` VALUES(56082, 'R', 28, 7, 2610);
 INSERT INTO `entries` VALUES(56083, 'R', 14, 0, 2610);
+INSERT INTO `entries` VALUES(56084, '1', 5, 1, 2611);
+INSERT INTO `entries` VALUES(56085, '2', 77, 2, 2611);
+INSERT INTO `entries` VALUES(56086, '3', 33, 3, 2611);
+INSERT INTO `entries` VALUES(56087, '4', 44, 4, 2611);
+INSERT INTO `entries` VALUES(56088, '5', 7, 5, 2611);
+INSERT INTO `entries` VALUES(56089, '6', 3, 6, 2611);
+INSERT INTO `entries` VALUES(56090, '7', 27, 7, 2611);
+INSERT INTO `entries` VALUES(56091, '8', 31, 8, 2611);
+INSERT INTO `entries` VALUES(56092, '9', 55, 9, 2611);
+INSERT INTO `entries` VALUES(56093, '10', 11, 10, 2611);
+INSERT INTO `entries` VALUES(56094, '11', 20, 11, 2611);
+INSERT INTO `entries` VALUES(56095, '12', 28, 12, 2611);
+INSERT INTO `entries` VALUES(56096, '13', 16, 13, 2611);
+INSERT INTO `entries` VALUES(56097, '14', 14, 14, 2611);
+INSERT INTO `entries` VALUES(56098, '15', 2, 15, 2611);
+INSERT INTO `entries` VALUES(56099, '16', 10, 16, 2611);
+INSERT INTO `entries` VALUES(56100, '17', 18, 17, 2611);
+INSERT INTO `entries` VALUES(56101, '18', 35, 18, 2611);
+INSERT INTO `entries` VALUES(56102, '19', 9, 19, 2611);
+INSERT INTO `entries` VALUES(56103, '20', 8, 20, 2611);
+INSERT INTO `entries` VALUES(56104, '1', 5, 1, 2612);
+INSERT INTO `entries` VALUES(56105, '2', 77, 2, 2612);
+INSERT INTO `entries` VALUES(56106, '3', 33, 2, 2612);
+INSERT INTO `entries` VALUES(56107, '4', 3, 3, 2612);
+INSERT INTO `entries` VALUES(56108, '5', 44, 3, 2612);
+INSERT INTO `entries` VALUES(56109, '6', 7, 4, 2612);
+INSERT INTO `entries` VALUES(56110, '7', 27, 5, 2612);
+INSERT INTO `entries` VALUES(56111, '8', 55, 5, 2612);
+INSERT INTO `entries` VALUES(56112, '9', 31, 5, 2612);
+INSERT INTO `entries` VALUES(56113, '10', 16, 5, 2612);
+INSERT INTO `entries` VALUES(56114, '11', 10, 5, 2612);
+INSERT INTO `entries` VALUES(56115, '12', 8, 5, 2612);
+INSERT INTO `entries` VALUES(56116, '13', 20, 5, 2612);
+INSERT INTO `entries` VALUES(56117, '14', 11, 5, 2612);
+INSERT INTO `entries` VALUES(56118, '15', 9, 6, 2612);
+INSERT INTO `entries` VALUES(56119, '16', 2, 6, 2612);
+INSERT INTO `entries` VALUES(56120, '17', 35, 6, 2612);
+INSERT INTO `entries` VALUES(56121, 'R', 14, 0, 2612);
+INSERT INTO `entries` VALUES(56122, 'R', 28, 7, 2612);
+INSERT INTO `entries` VALUES(56123, 'R', 18, 7, 2612);
 
 INSERT INTO `driver_entries` VALUES(1, 1, 1);
 INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -116147,3 +116189,43 @@ INSERT INTO `driver_entries` VALUES(1181, 56080, 56220);
 INSERT INTO `driver_entries` VALUES(1184, 56081, 56221);
 INSERT INTO `driver_entries` VALUES(1183, 56082, 56222);
 INSERT INTO `driver_entries` VALUES(1127, 56083, 56223);
+INSERT INTO `driver_entries` VALUES(1135, 56084, 56224);
+INSERT INTO `driver_entries` VALUES(1161, 56085, 56225);
+INSERT INTO `driver_entries` VALUES(1172, 56086, 56226);
+INSERT INTO `driver_entries` VALUES(1140, 56087, 56227);
+INSERT INTO `driver_entries` VALUES(1141, 56088, 56228);
+INSERT INTO `driver_entries` VALUES(1157, 56089, 56229);
+INSERT INTO `driver_entries` VALUES(1148, 56090, 56230);
+INSERT INTO `driver_entries` VALUES(1179, 56091, 56231);
+INSERT INTO `driver_entries` VALUES(1170, 56092, 56232);
+INSERT INTO `driver_entries` VALUES(1155, 56093, 56233);
+INSERT INTO `driver_entries` VALUES(1165, 56094, 56234);
+INSERT INTO `driver_entries` VALUES(1183, 56095, 56235);
+INSERT INTO `driver_entries` VALUES(1184, 56096, 56236);
+INSERT INTO `driver_entries` VALUES(1127, 56097, 56237);
+INSERT INTO `driver_entries` VALUES(1178, 56098, 56238);
+INSERT INTO `driver_entries` VALUES(1182, 56099, 56239);
+INSERT INTO `driver_entries` VALUES(1181, 56100, 56240);
+INSERT INTO `driver_entries` VALUES(1185, 56101, 56241);
+INSERT INTO `driver_entries` VALUES(1167, 56102, 56242);
+INSERT INTO `driver_entries` VALUES(1144, 56103, 56243);
+INSERT INTO `driver_entries` VALUES(1135, 56104, 56244);
+INSERT INTO `driver_entries` VALUES(1161, 56105, 56245);
+INSERT INTO `driver_entries` VALUES(1172, 56106, 56246);
+INSERT INTO `driver_entries` VALUES(1157, 56107, 56247);
+INSERT INTO `driver_entries` VALUES(1140, 56108, 56248);
+INSERT INTO `driver_entries` VALUES(1141, 56109, 56249);
+INSERT INTO `driver_entries` VALUES(1148, 56110, 56250);
+INSERT INTO `driver_entries` VALUES(1170, 56111, 56251);
+INSERT INTO `driver_entries` VALUES(1179, 56112, 56252);
+INSERT INTO `driver_entries` VALUES(1184, 56113, 56253);
+INSERT INTO `driver_entries` VALUES(1182, 56114, 56254);
+INSERT INTO `driver_entries` VALUES(1144, 56115, 56255);
+INSERT INTO `driver_entries` VALUES(1165, 56116, 56256);
+INSERT INTO `driver_entries` VALUES(1155, 56117, 56257);
+INSERT INTO `driver_entries` VALUES(1167, 56118, 56258);
+INSERT INTO `driver_entries` VALUES(1178, 56119, 56259);
+INSERT INTO `driver_entries` VALUES(1185, 56120, 56260);
+INSERT INTO `driver_entries` VALUES(1127, 56121, 56261);
+INSERT INTO `driver_entries` VALUES(1183, 56122, 56262);
+INSERT INTO `driver_entries` VALUES(1181, 56123, 56263);