2018 Mexican GP

2 files changed, 136 insertions, 0 deletions

diff --git a/rate.log b/rate.log
index 4e66c65..225f31a 100644
--- a/rate.log
+++ b/rate.log
@@ -74997,3 +74997,57 @@ Podium rating:  7675.98 7732.97
 Average rating:  2181.162
 Average rating change:  65.0347368421
 
+2018 Mexican Grand Prix - qualifying (2018-10-26)
+
+#3 (<Daniel Ricciardo (#1157)>) 1[1] 2363.64 2372.0
+#33 (<Max Verstappen (#1172)>) 2[2] 2504.47 2507.72
+#44 (<Lewis Hamilton (#1140)>) 3[3] 2684.55 2682.97
+#5 (<Sebastian Vettel (#1135)>) 4[4] 2448.33 2449.69
+#77 (<Valtteri Bottas (#1161)>) 5[5] 2510.83 2509.14
+#7 (<Kimi Räikkönen (#1141)>) 6[6] 2543.95 2539.96
+#27 (<Nico Hülkenberg (#1148)>) 7[7] 2144.99 2151.38
+#55 (<Carlos Sainz (#1170)>) 8[8] 2154.83 2159.2
+#16 (<Charles Leclerc (#1184)>) 9[9] 2029.81 2038.27
+#9 (<Marcus Ericsson (#1167)>) 10[10] 2040.29 2046.66
+#31 (<Esteban Ocon (#1179)>) 11[11] 1977.77 1987.1
+#14 (<Fernando Alonso (#1127)>) 12[12] 1982.46 1989.12
+#11 (<Sergio Pérez (#1155)>) 13[13] 2210.38 2202.91
+#28 (<Brendon Hartley (#1183)>) 14[14] 2039.4 2037.81
+#10 (<Pierre Gasly (#1182)>) 15[15] 2061.37 2057.15
+#8 (<Romain Grosjean (#1144)>) 16[16] 2025.87 2021.72
+#2 (<Stoffel Vandoorne (#1178)>) 17[17] 2037.93 2031.61
+#20 (<Kevin Magnussen (#1165)>) 18[18] 1856.21 1854.92
+#18 (<Lance Stroll (#1181)>) 19[19] 1986.63 1976.24
+#35 (<Sergey Sirotkin (#1185)>) 20[20] 2019.53 2007.68
+
+Podium rating:  7552.66 7562.69
+Average rating:  2181.162
+Average rating change:  5.4545
+
+2018 Mexican Grand Prix (2018-10-27)
+
+#33 (<Max Verstappen (#1172)>) 1[1] 2507.72 2548.56
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2449.69 2477.09
+#7 (<Kimi Räikkönen (#1141)>) 3[2] 2539.96 2551.19
+#44 (<Lewis Hamilton (#1140)>) 4[3] 2682.97 2649.2
+#77 (<Valtteri Bottas (#1161)>) 5[4] 2509.14 2485.73
+#27 (<Nico Hülkenberg (#1148)>) 6[5] 2151.38 2107.92
+#16 (<Charles Leclerc (#1184)>) 7[5] 2038.27 2034.36
+#2 (<Stoffel Vandoorne (#1178)>) 8[5] 2031.61 2030.18
+#9 (<Marcus Ericsson (#1167)>) 9[5] 2046.66 2039.64
+#10 (<Pierre Gasly (#1182)>) 10[5] 2057.15 2046.26
+#31 (<Esteban Ocon (#1179)>) 11[5] 1987.1 2012.74
+#18 (<Lance Stroll (#1181)>) 12[5] 1976.24 2007.12
+#35 (<Sergey Sirotkin (#1185)>) 13[5] 2007.68 2015.14
+#28 (<Brendon Hartley (#1183)>) 14[5] 2037.81 2034.07
+#20 (<Kevin Magnussen (#1165)>) 15[5] 1854.92 1936.84
+#8 (<Romain Grosjean (#1144)>) 16[6] 2021.72 1923.96
+#3 (<Daniel Ricciardo (#1157)>) R[0] 2372.0 2372.0
+#11 (<Sergio Pérez (#1155)>) R[0] 2202.91 2202.91
+#55 (<Carlos Sainz (#1170)>) R[0] 2159.2 2159.2
+#14 (<Fernando Alonso (#1127)>) R[0] 1989.12 1989.12
+
+Podium rating:  7497.37 7576.84
+Average rating:  2181.1625
+Average rating change:  28.1725
+
diff --git a/sql/results.sql b/sql/results.sql
index c08c265..bb6d1f3 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2637,6 +2637,8 @@ INSERT INTO `races` VALUES(2631, '2018 Japanese Grand Prix - qualifying', '2018-
 INSERT INTO `races` VALUES(2632, '2018 Japanese Grand Prix', '2018-10-07', 0, 4);
 INSERT INTO `races` VALUES(2633, '2018 United States Grand Prix - qualifying', '2018-10-20', 0, 3);
 INSERT INTO `races` VALUES(2634, '2018 United States Grand Prix', '2018-10-21', 0, 4);
+INSERT INTO `races` VALUES(2635, '2018 Mexican Grand Prix - qualifying', '2018-10-26', 0, 3);
+INSERT INTO `races` VALUES(2636, '2018 Mexican Grand Prix', '2018-10-27', 0, 4);
 
 INSERT INTO `countries` VALUES(9, 'Argentina');
 INSERT INTO `countries` VALUES(18, 'Australia');
@@ -60427,6 +60429,46 @@ INSERT INTO `entries` VALUES(56560, 'R', 8, 7, 2634);
 INSERT INTO `entries` VALUES(56561, 'R', 14, 7, 2634);
 INSERT INTO `entries` VALUES(56562, 'D', 31, 8, 2634);
 INSERT INTO `entries` VALUES(56563, 'D', 20, 8, 2634);
+INSERT INTO `entries` VALUES(56564, '1', 3, 1, 2635);
+INSERT INTO `entries` VALUES(56565, '2', 33, 2, 2635);
+INSERT INTO `entries` VALUES(56566, '3', 44, 3, 2635);
+INSERT INTO `entries` VALUES(56567, '4', 5, 4, 2635);
+INSERT INTO `entries` VALUES(56568, '5', 77, 5, 2635);
+INSERT INTO `entries` VALUES(56569, '6', 7, 6, 2635);
+INSERT INTO `entries` VALUES(56570, '7', 27, 7, 2635);
+INSERT INTO `entries` VALUES(56571, '8', 55, 8, 2635);
+INSERT INTO `entries` VALUES(56572, '9', 16, 9, 2635);
+INSERT INTO `entries` VALUES(56573, '10', 9, 10, 2635);
+INSERT INTO `entries` VALUES(56574, '11', 31, 11, 2635);
+INSERT INTO `entries` VALUES(56575, '12', 14, 12, 2635);
+INSERT INTO `entries` VALUES(56576, '13', 11, 13, 2635);
+INSERT INTO `entries` VALUES(56577, '14', 28, 14, 2635);
+INSERT INTO `entries` VALUES(56578, '15', 10, 15, 2635);
+INSERT INTO `entries` VALUES(56579, '16', 8, 16, 2635);
+INSERT INTO `entries` VALUES(56580, '17', 2, 17, 2635);
+INSERT INTO `entries` VALUES(56581, '18', 20, 18, 2635);
+INSERT INTO `entries` VALUES(56582, '19', 18, 19, 2635);
+INSERT INTO `entries` VALUES(56583, '20', 35, 20, 2635);
+INSERT INTO `entries` VALUES(56584, '1', 33, 1, 2636);
+INSERT INTO `entries` VALUES(56585, '2', 5, 2, 2636);
+INSERT INTO `entries` VALUES(56586, '3', 7, 2, 2636);
+INSERT INTO `entries` VALUES(56587, '4', 44, 3, 2636);
+INSERT INTO `entries` VALUES(56588, '5', 77, 4, 2636);
+INSERT INTO `entries` VALUES(56589, '6', 27, 5, 2636);
+INSERT INTO `entries` VALUES(56590, '7', 16, 5, 2636);
+INSERT INTO `entries` VALUES(56591, '8', 2, 5, 2636);
+INSERT INTO `entries` VALUES(56592, '9', 9, 5, 2636);
+INSERT INTO `entries` VALUES(56593, '10', 10, 5, 2636);
+INSERT INTO `entries` VALUES(56594, '11', 31, 5, 2636);
+INSERT INTO `entries` VALUES(56595, '12', 18, 5, 2636);
+INSERT INTO `entries` VALUES(56596, '13', 35, 5, 2636);
+INSERT INTO `entries` VALUES(56597, '14', 28, 5, 2636);
+INSERT INTO `entries` VALUES(56598, '15', 20, 5, 2636);
+INSERT INTO `entries` VALUES(56599, '16', 8, 6, 2636);
+INSERT INTO `entries` VALUES(56600, 'R', 3, 0, 2636);
+INSERT INTO `entries` VALUES(56601, 'R', 11, 0, 2636);
+INSERT INTO `entries` VALUES(56602, 'R', 55, 0, 2636);
+INSERT INTO `entries` VALUES(56603, 'R', 14, 0, 2636);
 
 INSERT INTO `driver_entries` VALUES(1, 1, 1);
 INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -117131,3 +117173,43 @@ INSERT INTO `driver_entries` VALUES(1144, 56560, 56700);
 INSERT INTO `driver_entries` VALUES(1127, 56561, 56701);
 INSERT INTO `driver_entries` VALUES(1179, 56562, 56702);
 INSERT INTO `driver_entries` VALUES(1165, 56563, 56703);
+INSERT INTO `driver_entries` VALUES(1157, 56564, 56704);
+INSERT INTO `driver_entries` VALUES(1172, 56565, 56705);
+INSERT INTO `driver_entries` VALUES(1140, 56566, 56706);
+INSERT INTO `driver_entries` VALUES(1135, 56567, 56707);
+INSERT INTO `driver_entries` VALUES(1161, 56568, 56708);
+INSERT INTO `driver_entries` VALUES(1141, 56569, 56709);
+INSERT INTO `driver_entries` VALUES(1148, 56570, 56710);
+INSERT INTO `driver_entries` VALUES(1170, 56571, 56711);
+INSERT INTO `driver_entries` VALUES(1184, 56572, 56712);
+INSERT INTO `driver_entries` VALUES(1167, 56573, 56713);
+INSERT INTO `driver_entries` VALUES(1179, 56574, 56714);
+INSERT INTO `driver_entries` VALUES(1127, 56575, 56715);
+INSERT INTO `driver_entries` VALUES(1155, 56576, 56716);
+INSERT INTO `driver_entries` VALUES(1183, 56577, 56717);
+INSERT INTO `driver_entries` VALUES(1182, 56578, 56718);
+INSERT INTO `driver_entries` VALUES(1144, 56579, 56719);
+INSERT INTO `driver_entries` VALUES(1178, 56580, 56720);
+INSERT INTO `driver_entries` VALUES(1165, 56581, 56721);
+INSERT INTO `driver_entries` VALUES(1181, 56582, 56722);
+INSERT INTO `driver_entries` VALUES(1185, 56583, 56723);
+INSERT INTO `driver_entries` VALUES(1172, 56584, 56724);
+INSERT INTO `driver_entries` VALUES(1135, 56585, 56725);
+INSERT INTO `driver_entries` VALUES(1141, 56586, 56726);
+INSERT INTO `driver_entries` VALUES(1140, 56587, 56727);
+INSERT INTO `driver_entries` VALUES(1161, 56588, 56728);
+INSERT INTO `driver_entries` VALUES(1148, 56589, 56729);
+INSERT INTO `driver_entries` VALUES(1184, 56590, 56730);
+INSERT INTO `driver_entries` VALUES(1178, 56591, 56731);
+INSERT INTO `driver_entries` VALUES(1167, 56592, 56732);
+INSERT INTO `driver_entries` VALUES(1182, 56593, 56733);
+INSERT INTO `driver_entries` VALUES(1179, 56594, 56734);
+INSERT INTO `driver_entries` VALUES(1181, 56595, 56735);
+INSERT INTO `driver_entries` VALUES(1185, 56596, 56736);
+INSERT INTO `driver_entries` VALUES(1183, 56597, 56737);
+INSERT INTO `driver_entries` VALUES(1165, 56598, 56738);
+INSERT INTO `driver_entries` VALUES(1144, 56599, 56739);
+INSERT INTO `driver_entries` VALUES(1157, 56600, 56740);
+INSERT INTO `driver_entries` VALUES(1155, 56601, 56741);
+INSERT INTO `driver_entries` VALUES(1170, 56602, 56742);
+INSERT INTO `driver_entries` VALUES(1127, 56603, 56743);