* 2017 US GP

2 files changed, 137 insertions, 0 deletions

diff --git a/rate.log b/rate.log
index b68a93f..dd7891a 100644
--- a/rate.log
+++ b/rate.log
@@ -73810,3 +73810,57 @@ Podium rating:  7370.36 7472.27
 Average rating:  2189.0045
 Average rating change:  36.3741176471
 
+2017 United States Grand Prix - qualifying (2017-10-21)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2643.82 2645.65
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2373.78 2380.08
+#77 (<Valtteri Bottas (#1161)>) 3[3] 2498.01 2499.31
+#3 (<Daniel Ricciardo (#1157)>) 4[4] 2478.24 2478.4
+#7 (<Kimi Räikkönen (#1141)>) 5[5] 2308.16 2311.9
+#33 (<Max Verstappen (#1172)>) 6[6] 2350.21 2350.88
+#31 (<Esteban Ocon (#1179)>) 7[7] 2191.8 2196.99
+#55 (<Carlos Sainz (#1170)>) 8[8] 2051.58 2061.41
+#14 (<Fernando Alonso (#1127)>) 9[9] 2059.17 2067.07
+#11 (<Sergio Pérez (#1155)>) 10[10] 2269.71 2266.9
+#19 (<Felipe Massa (#1142)>) 11[11] 2091.93 2095.16
+#26 (<Daniil Kvyat (#1166)>) 12[12] 1976.59 1984.44
+#2 (<Stoffel Vandoorne (#1178)>) 13[13] 2086.64 2086.11
+#8 (<Romain Grosjean (#1144)>) 14[14] 2156.38 2151.12
+#27 (<Nico Hülkenberg (#1148)>) 15[15] 2117.44 2112.32
+#9 (<Marcus Ericsson (#1167)>) 16[16] 1812.34 1817.46
+#18 (<Lance Stroll (#1181)>) 17[17] 2111.88 2103.02
+#39 (<Brendon Hartley (#1183)>) 18[18] 2000.0 1992.2
+#94 (<Pascal Wehrlein (#1177)>) 19[19] 1941.79 1934.59
+#20 (<Kevin Magnussen (#1165)>) 20[20] 2118.2 2102.65
+
+Podium rating:  7515.61 7525.04
+Average rating:  2181.8835
+Average rating change:  5.3125
+
+2017 United States Grand Prix (2017-10-22)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2645.65 2659.92
+#7 (<Sebastian Vettel (#1135)>) 2[2] 2380.08 2419.39
+#5 (<Kimi Räikkönen (#1141)>) 3[2] 2311.9 2370.65
+#33 (<Max Verstappen (#1172)>) 4[3] 2350.88 2366.16
+#77 (<Valtteri Bottas (#1161)>) 5[3] 2499.31 2479.59
+#31 (<Esteban Ocon (#1179)>) 6[4] 2196.99 2230.45
+#55 (<Carlos Sainz (#1170)>) 7[4] 2061.41 2146.11
+#11 (<Sergio Pérez (#1155)>) 8[5] 2266.9 2176.0
+#19 (<Felipe Massa (#1142)>) 9[5] 2095.16 2066.97
+#26 (<Daniil Kvyat (#1166)>) 10[5] 1984.44 2002.03
+#18 (<Lance Stroll (#1181)>) 11[5] 2103.02 2071.82
+#2 (<Stoffel Vandoorne (#1178)>) 12[5] 2086.11 2061.39
+#39 (<Brendon Hartley (#1183)>) 13[5] 1992.2 2006.26
+#8 (<Romain Grosjean (#1144)>) 14[5] 2151.12 2101.6
+#9 (<Marcus Ericsson (#1167)>) 15[5] 1817.46 1896.38
+#20 (<Kevin Magnussen (#1165)>) 16[5] 2102.65 2071.6
+#14 (<Fernando Alonso (#1127)>) R[0] 2067.07 2067.07
+#3 (<Daniel Ricciardo (#1157)>) R[0] 2478.4 2478.4
+#27 (<Nico Hülkenberg (#1148)>) R[0] 2112.32 2112.32
+#94 (<Pascal Wehrlein (#1177)>) R[6] 1934.59 1853.55
+
+Podium rating:  7337.63 7449.96
+Average rating:  2181.883
+Average rating change:  41.9223529412
+
diff --git a/sql/results.sql b/sql/results.sql
index 7ff7af1..cb667db 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2593,6 +2593,8 @@ INSERT INTO `races` VALUES(2587, '2017 Malaysian Grand Prix - qualifying', '2017
 INSERT INTO `races` VALUES(2588, '2017 Malaysian Grand Prix', '2017-10-01', 0, 4);
 INSERT INTO `races` VALUES(2589, '2017 Japanese Grand Prix - qualifying', '2017-10-07', 0, 3);
 INSERT INTO `races` VALUES(2590, '2017 Japanese Grand Prix', '2017-10-08', 0, 4);
+INSERT INTO `races` VALUES(2591, '2017 United States Grand Prix - qualifying', '2017-10-21', 0, 3);
+INSERT INTO `races` VALUES(2592, '2017 United States Grand Prix', '2017-10-22', 0, 4);
 
 INSERT INTO `countries` VALUES(9, 'Argentina');
 INSERT INTO `countries` VALUES(18, 'Australia');
@@ -3816,6 +3818,7 @@ INSERT INTO `drivers` VALUES(1179, 'Esteban Ocon', 1);
 INSERT INTO `drivers` VALUES(1180, 'Antonio Giovinazzi', 3);
 INSERT INTO `drivers` VALUES(1181, 'Lance Stroll', 24);
 INSERT INTO `drivers` VALUES(1182, 'Pierre Gasly', 1);
+INSERT INTO `drivers` VALUES(1183, 'Brendon Hartley', 20);
 
 INSERT INTO `entries` VALUES(1, '1', 3, 1, 1);
 INSERT INTO `entries` VALUES(2, '2', 6, 2, 1);
@@ -59501,6 +59504,46 @@ INSERT INTO `entries` VALUES(55681, 'R', 27, 0, 2590);
 INSERT INTO `entries` VALUES(55682, 'R', 9, 7, 2590);
 INSERT INTO `entries` VALUES(55683, 'R', 5, 0, 2590);
 INSERT INTO `entries` VALUES(55684, 'R', 55, 7, 2590);
+INSERT INTO `entries` VALUES(55685, '1', 44, 1, 2591);
+INSERT INTO `entries` VALUES(55686, '2', 5, 2, 2591);
+INSERT INTO `entries` VALUES(55687, '3', 77, 3, 2591);
+INSERT INTO `entries` VALUES(55688, '4', 3, 4, 2591);
+INSERT INTO `entries` VALUES(55689, '5', 7, 5, 2591);
+INSERT INTO `entries` VALUES(55690, '6', 33, 6, 2591);
+INSERT INTO `entries` VALUES(55691, '7', 31, 7, 2591);
+INSERT INTO `entries` VALUES(55692, '8', 55, 8, 2591);
+INSERT INTO `entries` VALUES(55693, '9', 14, 9, 2591);
+INSERT INTO `entries` VALUES(55694, '10', 11, 10, 2591);
+INSERT INTO `entries` VALUES(55695, '11', 19, 11, 2591);
+INSERT INTO `entries` VALUES(55696, '12', 26, 12, 2591);
+INSERT INTO `entries` VALUES(55697, '13', 2, 13, 2591);
+INSERT INTO `entries` VALUES(55698, '14', 8, 14, 2591);
+INSERT INTO `entries` VALUES(55699, '15', 27, 15, 2591);
+INSERT INTO `entries` VALUES(55700, '16', 9, 16, 2591);
+INSERT INTO `entries` VALUES(55701, '17', 18, 17, 2591);
+INSERT INTO `entries` VALUES(55702, '18', 39, 18, 2591);
+INSERT INTO `entries` VALUES(55703, '19', 94, 19, 2591);
+INSERT INTO `entries` VALUES(55704, '20', 20, 20, 2591);
+INSERT INTO `entries` VALUES(55705, '1', 44, 1, 2592);
+INSERT INTO `entries` VALUES(55706, '2', 7, 2, 2592);
+INSERT INTO `entries` VALUES(55707, '3', 5, 2, 2592);
+INSERT INTO `entries` VALUES(55708, '4', 33, 3, 2592);
+INSERT INTO `entries` VALUES(55709, '5', 77, 3, 2592);
+INSERT INTO `entries` VALUES(55710, '6', 31, 4, 2592);
+INSERT INTO `entries` VALUES(55711, '7', 55, 4, 2592);
+INSERT INTO `entries` VALUES(55712, '8', 11, 5, 2592);
+INSERT INTO `entries` VALUES(55713, '9', 19, 5, 2592);
+INSERT INTO `entries` VALUES(55714, '10', 26, 5, 2592);
+INSERT INTO `entries` VALUES(55715, '11', 18, 5, 2592);
+INSERT INTO `entries` VALUES(55716, '12', 2, 5, 2592);
+INSERT INTO `entries` VALUES(55717, '13', 39, 5, 2592);
+INSERT INTO `entries` VALUES(55718, '14', 8, 5, 2592);
+INSERT INTO `entries` VALUES(55719, '15', 9, 5, 2592);
+INSERT INTO `entries` VALUES(55720, '16', 20, 5, 2592);
+INSERT INTO `entries` VALUES(55721, 'R', 14, 0, 2592);
+INSERT INTO `entries` VALUES(55722, 'R', 3, 0, 2592);
+INSERT INTO `entries` VALUES(55723, 'R', 94, 6, 2592);
+INSERT INTO `entries` VALUES(55724, 'R', 27, 0, 2592);
 
 INSERT INTO `driver_entries` VALUES(1, 1, 1);
 INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -115326,3 +115369,43 @@ INSERT INTO `driver_entries` VALUES(1148, 55681, 55821);
 INSERT INTO `driver_entries` VALUES(1167, 55682, 55822);
 INSERT INTO `driver_entries` VALUES(1135, 55683, 55823);
 INSERT INTO `driver_entries` VALUES(1170, 55684, 55824);
+INSERT INTO `driver_entries` VALUES(1140, 55685, 55825);
+INSERT INTO `driver_entries` VALUES(1135, 55686, 55826);
+INSERT INTO `driver_entries` VALUES(1161, 55687, 55827);
+INSERT INTO `driver_entries` VALUES(1157, 55688, 55828);
+INSERT INTO `driver_entries` VALUES(1141, 55689, 55829);
+INSERT INTO `driver_entries` VALUES(1172, 55690, 55830);
+INSERT INTO `driver_entries` VALUES(1179, 55691, 55831);
+INSERT INTO `driver_entries` VALUES(1170, 55692, 55832);
+INSERT INTO `driver_entries` VALUES(1127, 55693, 55833);
+INSERT INTO `driver_entries` VALUES(1155, 55694, 55834);
+INSERT INTO `driver_entries` VALUES(1142, 55695, 55835);
+INSERT INTO `driver_entries` VALUES(1166, 55696, 55836);
+INSERT INTO `driver_entries` VALUES(1178, 55697, 55837);
+INSERT INTO `driver_entries` VALUES(1144, 55698, 55838);
+INSERT INTO `driver_entries` VALUES(1148, 55699, 55839);
+INSERT INTO `driver_entries` VALUES(1167, 55700, 55840);
+INSERT INTO `driver_entries` VALUES(1181, 55701, 55841);
+INSERT INTO `driver_entries` VALUES(1183, 55702, 55842);
+INSERT INTO `driver_entries` VALUES(1177, 55703, 55843);
+INSERT INTO `driver_entries` VALUES(1165, 55704, 55844);
+INSERT INTO `driver_entries` VALUES(1140, 55705, 55845);
+INSERT INTO `driver_entries` VALUES(1135, 55706, 55846);
+INSERT INTO `driver_entries` VALUES(1141, 55707, 55847);
+INSERT INTO `driver_entries` VALUES(1172, 55708, 55848);
+INSERT INTO `driver_entries` VALUES(1161, 55709, 55849);
+INSERT INTO `driver_entries` VALUES(1179, 55710, 55850);
+INSERT INTO `driver_entries` VALUES(1170, 55711, 55851);
+INSERT INTO `driver_entries` VALUES(1155, 55712, 55852);
+INSERT INTO `driver_entries` VALUES(1142, 55713, 55853);
+INSERT INTO `driver_entries` VALUES(1166, 55714, 55854);
+INSERT INTO `driver_entries` VALUES(1181, 55715, 55855);
+INSERT INTO `driver_entries` VALUES(1178, 55716, 55856);
+INSERT INTO `driver_entries` VALUES(1183, 55717, 55857);
+INSERT INTO `driver_entries` VALUES(1144, 55718, 55858);
+INSERT INTO `driver_entries` VALUES(1167, 55719, 55859);
+INSERT INTO `driver_entries` VALUES(1165, 55720, 55860);
+INSERT INTO `driver_entries` VALUES(1127, 55721, 55861);
+INSERT INTO `driver_entries` VALUES(1157, 55722, 55862);
+INSERT INTO `driver_entries` VALUES(1177, 55723, 55863);
+INSERT INTO `driver_entries` VALUES(1148, 55724, 55864);