2018 Japanese GP

2 files changed, 136 insertions, 0 deletions

diff --git a/rate.log b/rate.log
index 31261b1..943efb8 100644
--- a/rate.log
+++ b/rate.log
@@ -74889,3 +74889,57 @@ Podium rating:  7625.77 7694.57
 Average rating:  2181.1615
 Average rating change:  34.3916666667
 
+2018 Japanese Grand Prix - qualifying (2018-10-06)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2676.98 2678.61
+#77 (<Valtteri Bottas (#1161)>) 2[2] 2505.36 2508.46
+#33 (<Max Verstappen (#1172)>) 3[3] 2469.04 2471.36
+#7 (<Kimi Räikkönen (#1141)>) 4[4] 2510.37 2510.16
+#8 (<Romain Grosjean (#1144)>) 5[5] 2054.4 2067.93
+#28 (<Brendon Hartley (#1183)>) 6[6] 2009.55 2023.55
+#10 (<Pierre Gasly (#1182)>) 7[7] 2082.29 2091.33
+#31 (<Esteban Ocon (#1179)>) 8[8] 2040.77 2050.13
+#5 (<Sebastian Vettel (#1135)>) 9[9] 2512.23 2503.98
+#11 (<Sergio Pérez (#1155)>) 10[10] 2130.1 2132.18
+#16 (<Charles Leclerc (#1184)>) 11[11] 2145.48 2145.28
+#20 (<Kevin Magnussen (#1165)>) 12[12] 2040.26 2043.25
+#55 (<Carlos Sainz (#1170)>) 13[13] 1996.76 2000.43
+#18 (<Lance Stroll (#1181)>) 14[14] 2047.64 2046.28
+#3 (<Daniel Ricciardo (#1157)>) 15[15] 2347.11 2332.57
+#27 (<Nico Hülkenberg (#1148)>) 16[16] 2054.81 2049.92
+#35 (<Sergey Sirotkin (#1185)>) 17[17] 1855.73 1857.08
+#14 (<Fernando Alonso (#1127)>) 18[18] 2141.02 2128.22
+#2 (<Stoffel Vandoorne (#1178)>) 19[19] 1948.92 1940.98
+#9 (<Marcus Ericsson (#1167)>) 20[20] 2054.42 2041.55
+
+Podium rating:  7651.38 7658.43
+Average rating:  2181.162
+Average rating change:  6.3065
+
+2018 Japanese Grand Prix (2018-10-07)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2678.61 2694.14
+#77 (<Valtteri Bottas (#1161)>) 2[2] 2508.46 2528.88
+#33 (<Max Verstappen (#1172)>) 3[2] 2471.36 2499.63
+#3 (<Daniel Ricciardo (#1157)>) 4[3] 2332.57 2361.72
+#7 (<Kimi Räikkönen (#1141)>) 5[3] 2510.16 2498.23
+#5 (<Sebastian Vettel (#1135)>) 6[4] 2503.98 2445.33
+#11 (<Sergio Pérez (#1155)>) 7[4] 2132.18 2176.07
+#8 (<Romain Grosjean (#1144)>) 8[4] 2067.93 2136.51
+#31 (<Esteban Ocon (#1179)>) 9[4] 2050.13 2125.71
+#55 (<Carlos Sainz (#1170)>) 10[5] 2000.43 1991.35
+#10 (<Pierre Gasly (#1182)>) 11[5] 2091.33 2046.78
+#9 (<Marcus Ericsson (#1167)>) 12[5] 2041.55 2016.5
+#28 (<Brendon Hartley (#1183)>) 13[5] 2023.55 2005.54
+#14 (<Fernando Alonso (#1127)>) 14[5] 2128.22 2069.59
+#2 (<Stoffel Vandoorne (#1178)>) 15[5] 1940.98 1961.89
+#35 (<Sergey Sirotkin (#1185)>) 16[5] 1857.08 1913.28
+#18 (<Lance Stroll (#1181)>) 17[5] 2046.28 2019.37
+#16 (<Charles Leclerc (#1184)>) R[0] 2145.28 2145.28
+#27 (<Nico Hülkenberg (#1148)>) R[0] 2049.92 2049.92
+#20 (<Kevin Magnussen (#1165)>) R[6] 2043.25 1937.53
+
+Podium rating:  7658.43 7722.65
+Average rating:  2181.1625
+Average rating change:  39.8366666667
+
diff --git a/sql/results.sql b/sql/results.sql
index bbc6dca..a5c8129 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2633,6 +2633,8 @@ INSERT INTO `races` VALUES(2627, '2018 Singapore Grand Prix - qualifying', '2018
 INSERT INTO `races` VALUES(2628, '2018 Singapore Grand Prix', '2018-09-16', 0, 4);
 INSERT INTO `races` VALUES(2629, '2018 Russian Grand Prix - qualifying', '2018-09-29', 0, 3);
 INSERT INTO `races` VALUES(2630, '2018 Russian Grand Prix', '2018-09-30', 0, 4);
+INSERT INTO `races` VALUES(2631, '2018 Japanese Grand Prix - qualifying', '2018-10-06', 0, 3);
+INSERT INTO `races` VALUES(2632, '2018 Japanese Grand Prix', '2018-10-07', 0, 4);
 
 INSERT INTO `countries` VALUES(9, 'Argentina');
 INSERT INTO `countries` VALUES(18, 'Australia');
@@ -60343,6 +60345,46 @@ INSERT INTO `entries` VALUES(56480, '17', 55, 6, 2630);
 INSERT INTO `entries` VALUES(56481, '18', 35, 6, 2630);
 INSERT INTO `entries` VALUES(56482, 'R', 10, 0, 2630);
 INSERT INTO `entries` VALUES(56483, 'R', 28, 0, 2630);
+INSERT INTO `entries` VALUES(56484, '1', 44, 1, 2631);
+INSERT INTO `entries` VALUES(56485, '2', 77, 2, 2631);
+INSERT INTO `entries` VALUES(56486, '3', 33, 3, 2631);
+INSERT INTO `entries` VALUES(56487, '4', 7, 4, 2631);
+INSERT INTO `entries` VALUES(56488, '5', 8, 5, 2631);
+INSERT INTO `entries` VALUES(56489, '6', 28, 6, 2631);
+INSERT INTO `entries` VALUES(56490, '7', 10, 7, 2631);
+INSERT INTO `entries` VALUES(56491, '8', 31, 8, 2631);
+INSERT INTO `entries` VALUES(56492, '9', 5, 9, 2631);
+INSERT INTO `entries` VALUES(56493, '10', 11, 10, 2631);
+INSERT INTO `entries` VALUES(56494, '11', 16, 11, 2631);
+INSERT INTO `entries` VALUES(56495, '12', 20, 12, 2631);
+INSERT INTO `entries` VALUES(56496, '13', 55, 13, 2631);
+INSERT INTO `entries` VALUES(56497, '14', 18, 14, 2631);
+INSERT INTO `entries` VALUES(56498, '15', 3, 15, 2631);
+INSERT INTO `entries` VALUES(56499, '16', 27, 16, 2631);
+INSERT INTO `entries` VALUES(56500, '17', 35, 17, 2631);
+INSERT INTO `entries` VALUES(56501, '18', 14, 18, 2631);
+INSERT INTO `entries` VALUES(56502, '19', 2, 19, 2631);
+INSERT INTO `entries` VALUES(56503, '20', 9, 20, 2631);
+INSERT INTO `entries` VALUES(56504, '1', 44, 1, 2632);
+INSERT INTO `entries` VALUES(56505, '2', 77, 2, 2632);
+INSERT INTO `entries` VALUES(56506, '3', 33, 2, 2632);
+INSERT INTO `entries` VALUES(56507, '4', 3, 3, 2632);
+INSERT INTO `entries` VALUES(56508, '5', 7, 3, 2632);
+INSERT INTO `entries` VALUES(56509, '6', 5, 4, 2632);
+INSERT INTO `entries` VALUES(56510, '7', 11, 4, 2632);
+INSERT INTO `entries` VALUES(56511, '8', 8, 4, 2632);
+INSERT INTO `entries` VALUES(56512, '9', 31, 4, 2632);
+INSERT INTO `entries` VALUES(56513, '10', 55, 5, 2632);
+INSERT INTO `entries` VALUES(56514, '11', 10, 5, 2632);
+INSERT INTO `entries` VALUES(56515, '12', 9, 5, 2632);
+INSERT INTO `entries` VALUES(56516, '13', 28, 5, 2632);
+INSERT INTO `entries` VALUES(56517, '14', 14, 5, 2632);
+INSERT INTO `entries` VALUES(56518, '15', 2, 5, 2632);
+INSERT INTO `entries` VALUES(56519, '16', 35, 5, 2632);
+INSERT INTO `entries` VALUES(56520, '17', 18, 5, 2632);
+INSERT INTO `entries` VALUES(56521, 'R', 16, 0, 2632);
+INSERT INTO `entries` VALUES(56522, 'R', 27, 0, 2632);
+INSERT INTO `entries` VALUES(56523, 'R', 20, 6, 2632);
 
 INSERT INTO `driver_entries` VALUES(1, 1, 1);
 INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -116967,3 +117009,43 @@ INSERT INTO `driver_entries` VALUES(1170, 56480, 56620);
 INSERT INTO `driver_entries` VALUES(1185, 56481, 56621);
 INSERT INTO `driver_entries` VALUES(1182, 56482, 56622);
 INSERT INTO `driver_entries` VALUES(1183, 56483, 56623);
+INSERT INTO `driver_entries` VALUES(1140, 56484, 56624);
+INSERT INTO `driver_entries` VALUES(1161, 56485, 56625);
+INSERT INTO `driver_entries` VALUES(1172, 56486, 56626);
+INSERT INTO `driver_entries` VALUES(1141, 56487, 56627);
+INSERT INTO `driver_entries` VALUES(1144, 56488, 56628);
+INSERT INTO `driver_entries` VALUES(1183, 56489, 56629);
+INSERT INTO `driver_entries` VALUES(1182, 56490, 56630);
+INSERT INTO `driver_entries` VALUES(1179, 56491, 56631);
+INSERT INTO `driver_entries` VALUES(1135, 56492, 56632);
+INSERT INTO `driver_entries` VALUES(1155, 56493, 56633);
+INSERT INTO `driver_entries` VALUES(1184, 56494, 56634);
+INSERT INTO `driver_entries` VALUES(1165, 56495, 56635);
+INSERT INTO `driver_entries` VALUES(1170, 56496, 56636);
+INSERT INTO `driver_entries` VALUES(1181, 56497, 56637);
+INSERT INTO `driver_entries` VALUES(1157, 56498, 56638);
+INSERT INTO `driver_entries` VALUES(1148, 56499, 56639);
+INSERT INTO `driver_entries` VALUES(1185, 56500, 56640);
+INSERT INTO `driver_entries` VALUES(1127, 56501, 56641);
+INSERT INTO `driver_entries` VALUES(1178, 56502, 56642);
+INSERT INTO `driver_entries` VALUES(1167, 56503, 56643);
+INSERT INTO `driver_entries` VALUES(1140, 56504, 56644);
+INSERT INTO `driver_entries` VALUES(1161, 56505, 56645);
+INSERT INTO `driver_entries` VALUES(1172, 56506, 56646);
+INSERT INTO `driver_entries` VALUES(1157, 56507, 56647);
+INSERT INTO `driver_entries` VALUES(1141, 56508, 56648);
+INSERT INTO `driver_entries` VALUES(1135, 56509, 56649);
+INSERT INTO `driver_entries` VALUES(1155, 56510, 56650);
+INSERT INTO `driver_entries` VALUES(1144, 56511, 56651);
+INSERT INTO `driver_entries` VALUES(1179, 56512, 56652);
+INSERT INTO `driver_entries` VALUES(1170, 56513, 56653);
+INSERT INTO `driver_entries` VALUES(1182, 56514, 56654);
+INSERT INTO `driver_entries` VALUES(1167, 56515, 56655);
+INSERT INTO `driver_entries` VALUES(1183, 56516, 56656);
+INSERT INTO `driver_entries` VALUES(1127, 56517, 56657);
+INSERT INTO `driver_entries` VALUES(1178, 56518, 56658);
+INSERT INTO `driver_entries` VALUES(1185, 56519, 56659);
+INSERT INTO `driver_entries` VALUES(1181, 56520, 56660);
+INSERT INTO `driver_entries` VALUES(1184, 56521, 56661);
+INSERT INTO `driver_entries` VALUES(1148, 56522, 56662);
+INSERT INTO `driver_entries` VALUES(1165, 56523, 56663);