2018 USGP

2 files changed, 136 insertions, 0 deletions

diff --git a/rate.log b/rate.log
index 943efb8..4e66c65 100644
--- a/rate.log
+++ b/rate.log
@@ -74943,3 +74943,57 @@ Podium rating:  7658.43 7722.65
 Average rating:  2181.1625
 Average rating change:  39.8366666667
 
+2018 United States Grand Prix - qualifying (2018-10-20)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2694.14 2695.59
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2445.33 2449.85
+#7 (<Kimi Räikkönen (#1141)>) 3[3] 2498.23 2499.91
+#77 (<Valtteri Bottas (#1161)>) 4[4] 2528.88 2528.3
+#3 (<Daniel Ricciardo (#1157)>) 5[5] 2361.72 2363.64
+#31 (<Esteban Ocon (#1179)>) 6[6] 2125.71 2134.55
+#27 (<Nico Hülkenberg (#1148)>) 7[7] 2049.92 2060.69
+#8 (<Romain Grosjean (#1144)>) 8[8] 2136.51 2141.67
+#16 (<Charles Leclerc (#1184)>) 9[9] 2145.28 2148.46
+#11 (<Sergio Pérez (#1155)>) 10[10] 2176.07 2176.34
+#55 (<Carlos Sainz (#1170)>) 11[11] 1991.35 1999.99
+#20 (<Kevin Magnussen (#1165)>) 12[12] 1937.53 1946.87
+#10 (<Pierre Gasly (#1182)>) 13[13] 2046.78 2046.49
+#28 (<Brendon Hartley (#1183)>) 14[14] 2005.54 2005.6
+#33 (<Max Verstappen (#1172)>) 15[15] 2499.63 2480.48
+#14 (<Fernando Alonso (#1127)>) 16[16] 2069.59 2063.42
+#35 (<Sergey Sirotkin (#1185)>) 17[17] 1913.28 1911.89
+#18 (<Lance Stroll (#1181)>) 18[18] 2019.37 2011.58
+#9 (<Marcus Ericsson (#1167)>) 19[19] 2016.5 2007.25
+#2 (<Stoffel Vandoorne (#1178)>) 20[20] 1961.89 1950.67
+
+Podium rating:  7637.7 7645.35
+Average rating:  2181.1625
+Average rating change:  5.5835
+
+2018 United States Grand Prix (2018-10-21)
+
+#7 (<Kimi Räikkönen (#1141)>) 1[1] 2499.91 2543.95
+#33 (<Max Verstappen (#1172)>) 2[2] 2480.48 2504.47
+#44 (<Lewis Hamilton (#1140)>) 3[2] 2695.59 2684.55
+#5 (<Sebastian Vettel (#1135)>) 4[3] 2449.85 2448.33
+#77 (<Valtteri Bottas (#1161)>) 5[3] 2528.3 2510.83
+#27 (<Nico Hülkenberg (#1148)>) 6[4] 2060.69 2144.99
+#55 (<Carlos Sainz (#1170)>) 7[4] 1999.99 2154.83
+#11 (<Sergio Pérez (#1155)>) 8[4] 2176.34 2210.38
+#28 (<Brendon Hartley (#1183)>) 9[5] 2005.6 2039.4
+#9 (<Marcus Ericsson (#1167)>) 10[5] 2007.25 2040.29
+#2 (<Stoffel Vandoorne (#1178)>) 11[5] 1950.67 2037.93
+#10 (<Pierre Gasly (#1182)>) 12[5] 2046.49 2061.37
+#35 (<Sergey Sirotkin (#1185)>) 13[5] 1911.89 2019.53
+#18 (<Lance Stroll (#1181)>) 14[6] 2011.58 1986.63
+#3 (<Daniel Ricciardo (#1157)>) R[0] 2363.64 2363.64
+#16 (<Charles Leclerc (#1184)>) R[7] 2148.46 2029.81
+#8 (<Romain Grosjean (#1144)>) R[7] 2141.67 2025.87
+#14 (<Fernando Alonso (#1127)>) R[7] 2063.42 1982.46
+#31 (<Esteban Ocon (#1179)>) D[8] 2134.55 1977.77
+#20 (<Kevin Magnussen (#1165)>) D[8] 1946.87 1856.21
+
+Podium rating:  7675.98 7732.97
+Average rating:  2181.162
+Average rating change:  65.0347368421
+
diff --git a/sql/results.sql b/sql/results.sql
index a5c8129..c08c265 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2635,6 +2635,8 @@ INSERT INTO `races` VALUES(2629, '2018 Russian Grand Prix - qualifying', '2018-0
 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 `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 `countries` VALUES(9, 'Argentina');
 INSERT INTO `countries` VALUES(18, 'Australia');
@@ -60385,6 +60387,46 @@ 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 `entries` VALUES(56524, '1', 44, 1, 2633);
+INSERT INTO `entries` VALUES(56525, '2', 5, 2, 2633);
+INSERT INTO `entries` VALUES(56526, '3', 7, 3, 2633);
+INSERT INTO `entries` VALUES(56527, '4', 77, 4, 2633);
+INSERT INTO `entries` VALUES(56528, '5', 3, 5, 2633);
+INSERT INTO `entries` VALUES(56529, '6', 31, 6, 2633);
+INSERT INTO `entries` VALUES(56530, '7', 27, 7, 2633);
+INSERT INTO `entries` VALUES(56531, '8', 8, 8, 2633);
+INSERT INTO `entries` VALUES(56532, '9', 16, 9, 2633);
+INSERT INTO `entries` VALUES(56533, '10', 11, 10, 2633);
+INSERT INTO `entries` VALUES(56534, '11', 55, 11, 2633);
+INSERT INTO `entries` VALUES(56535, '12', 20, 12, 2633);
+INSERT INTO `entries` VALUES(56536, '13', 10, 13, 2633);
+INSERT INTO `entries` VALUES(56537, '14', 28, 14, 2633);
+INSERT INTO `entries` VALUES(56538, '15', 33, 15, 2633);
+INSERT INTO `entries` VALUES(56539, '16', 14, 16, 2633);
+INSERT INTO `entries` VALUES(56540, '17', 35, 17, 2633);
+INSERT INTO `entries` VALUES(56541, '18', 18, 18, 2633);
+INSERT INTO `entries` VALUES(56542, '19', 9, 19, 2633);
+INSERT INTO `entries` VALUES(56543, '20', 2, 20, 2633);
+INSERT INTO `entries` VALUES(56544, '1', 7, 1, 2634);
+INSERT INTO `entries` VALUES(56545, '2', 33, 2, 2634);
+INSERT INTO `entries` VALUES(56546, '3', 44, 2, 2634);
+INSERT INTO `entries` VALUES(56547, '4', 5, 3, 2634);
+INSERT INTO `entries` VALUES(56548, '5', 77, 3, 2634);
+INSERT INTO `entries` VALUES(56549, '6', 27, 4, 2634);
+INSERT INTO `entries` VALUES(56550, '7', 55, 4, 2634);
+INSERT INTO `entries` VALUES(56551, '8', 11, 4, 2634);
+INSERT INTO `entries` VALUES(56552, '9', 28, 5, 2634);
+INSERT INTO `entries` VALUES(56553, '10', 9, 5, 2634);
+INSERT INTO `entries` VALUES(56554, '11', 2, 5, 2634);
+INSERT INTO `entries` VALUES(56555, '12', 10, 5, 2634);
+INSERT INTO `entries` VALUES(56556, '13', 35, 5, 2634);
+INSERT INTO `entries` VALUES(56557, '14', 18, 6, 2634);
+INSERT INTO `entries` VALUES(56558, 'R', 16, 7, 2634);
+INSERT INTO `entries` VALUES(56559, 'R', 3, 0, 2634);
+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 `driver_entries` VALUES(1, 1, 1);
 INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -117049,3 +117091,43 @@ 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);
+INSERT INTO `driver_entries` VALUES(1140, 56524, 56664);
+INSERT INTO `driver_entries` VALUES(1135, 56525, 56665);
+INSERT INTO `driver_entries` VALUES(1141, 56526, 56666);
+INSERT INTO `driver_entries` VALUES(1161, 56527, 56667);
+INSERT INTO `driver_entries` VALUES(1157, 56528, 56668);
+INSERT INTO `driver_entries` VALUES(1179, 56529, 56669);
+INSERT INTO `driver_entries` VALUES(1148, 56530, 56670);
+INSERT INTO `driver_entries` VALUES(1144, 56531, 56671);
+INSERT INTO `driver_entries` VALUES(1184, 56532, 56672);
+INSERT INTO `driver_entries` VALUES(1155, 56533, 56673);
+INSERT INTO `driver_entries` VALUES(1170, 56534, 56674);
+INSERT INTO `driver_entries` VALUES(1165, 56535, 56675);
+INSERT INTO `driver_entries` VALUES(1182, 56536, 56676);
+INSERT INTO `driver_entries` VALUES(1183, 56537, 56677);
+INSERT INTO `driver_entries` VALUES(1172, 56538, 56678);
+INSERT INTO `driver_entries` VALUES(1127, 56539, 56679);
+INSERT INTO `driver_entries` VALUES(1185, 56540, 56680);
+INSERT INTO `driver_entries` VALUES(1181, 56541, 56681);
+INSERT INTO `driver_entries` VALUES(1167, 56542, 56682);
+INSERT INTO `driver_entries` VALUES(1178, 56543, 56683);
+INSERT INTO `driver_entries` VALUES(1141, 56544, 56684);
+INSERT INTO `driver_entries` VALUES(1172, 56545, 56685);
+INSERT INTO `driver_entries` VALUES(1140, 56546, 56686);
+INSERT INTO `driver_entries` VALUES(1135, 56547, 56687);
+INSERT INTO `driver_entries` VALUES(1161, 56548, 56688);
+INSERT INTO `driver_entries` VALUES(1148, 56549, 56689);
+INSERT INTO `driver_entries` VALUES(1170, 56550, 56690);
+INSERT INTO `driver_entries` VALUES(1155, 56551, 56691);
+INSERT INTO `driver_entries` VALUES(1183, 56552, 56692);
+INSERT INTO `driver_entries` VALUES(1167, 56553, 56693);
+INSERT INTO `driver_entries` VALUES(1178, 56554, 56694);
+INSERT INTO `driver_entries` VALUES(1182, 56555, 56695);
+INSERT INTO `driver_entries` VALUES(1185, 56556, 56696);
+INSERT INTO `driver_entries` VALUES(1181, 56557, 56697);
+INSERT INTO `driver_entries` VALUES(1184, 56558, 56698);
+INSERT INTO `driver_entries` VALUES(1157, 56559, 56699);
+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);