2019 US GP

2 files changed, 136 insertions, 0 deletions

diff --git a/rate.log b/rate.log
index b118455..d5fa6bb 100644
--- a/rate.log
+++ b/rate.log
@@ -76125,3 +76125,57 @@ Podium rating:  7541.68 7610.72
 Average rating:  2196.7265
 Average rating change:  49.1705555556
 
+2019 United States Grand Prix - qualifying (2019-11-02)
+
+#77 (<Valtteri Bottas (#1161)>) 1[1] 2516.65 2520.62
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2476.3 2479.64
+#33 (<Max Verstappen (#1172)>) 3[3] 2353.33 2358.71
+#16 (<Charles Leclerc (#1184)>) 4[4] 2410.76 2412.71
+#44 (<Lewis Hamilton (#1140)>) 5[5] 2617.77 2613.4
+#23 (<Alexander Albon (#1187)>) 6[6] 2373.84 2373.74
+#55 (<Carlos Sainz (#1170)>) 7[7] 2163.08 2169.67
+#4 (<Lando Norris (#1186)>) 8[8] 2185.09 2189.09
+#3 (<Daniel Ricciardo (#1157)>) 9[9] 2125.43 2130.55
+#10 (<Pierre Gasly (#1182)>) 10[10] 2195.29 2195.64
+#27 (<Nico Hülkenberg (#1148)>) 11[11] 2030.4 2036.65
+#20 (<Kevin Magnussen (#1165)>) 12[12] 2069.07 2071.99
+#26 (<Daniil Kvyat (#1166)>) 13[13] 2060.95 2062.64
+#18 (<Lance Stroll (#1181)>) 14[14] 2050.89 2051.43
+#8 (<Romain Grosjean (#1144)>) 15[15] 2043.35 2042.63
+#99 (<Antonio Giovinazzi (#1180)>) 16[16] 2067.39 2063.98
+#7 (<Kimi Räikkönen (#1141)>) 17[17] 2073.93 2068.62
+#63 (<George Russell (#1188)>) 18[18] 1948.04 1944.43
+#11 (<Sergio Pérez (#1155)>) 19[19] 2220.39 2204.46
+#88 (<Robert Kubica (#1136)>) 20[20] 1952.57 1943.93
+
+Podium rating:  7346.28 7358.97
+Average rating:  2196.726
+Average rating change:  4.2095
+
+2019 United States Grand Prix (2019-11-03)
+
+#77 (<Valtteri Bottas (#1161)>) 1[1] 2520.62 2552.08
+#44 (<Lewis Hamilton (#1140)>) 2[2] 2613.4 2605.89
+#33 (<Max Verstappen (#1172)>) 3[2] 2358.71 2404.82
+#16 (<Charles Leclerc (#1184)>) 4[3] 2412.71 2412.09
+#23 (<Alexander Albon (#1187)>) 5[3] 2373.74 2383.56
+#3 (<Daniel Ricciardo (#1157)>) 6[4] 2130.55 2193.39
+#4 (<Lando Norris (#1186)>) 7[4] 2189.09 2229.06
+#55 (<Carlos Sainz (#1170)>) 8[5] 2169.67 2137.15
+#27 (<Nico Hülkenberg (#1148)>) 9[5] 2036.65 2055.67
+#11 (<Sergio Pérez (#1155)>) 10[5] 2204.46 2158.57
+#7 (<Kimi Räikkönen (#1141)>) 11[5] 2068.62 2075.65
+#26 (<Daniil Kvyat (#1166)>) 12[5] 2062.64 2071.95
+#18 (<Lance Stroll (#1181)>) 13[5] 2051.43 2064.97
+#99 (<Antonio Giovinazzi (#1180)>) 14[5] 2063.98 2072.78
+#8 (<Romain Grosjean (#1144)>) 15[5] 2042.63 2059.45
+#10 (<Pierre Gasly (#1182)>) 16[6] 2195.64 2069.1
+#63 (<George Russell (#1188)>) 17[6] 1944.43 1892.82
+#20 (<Kevin Magnussen (#1165)>) 18[0] 2071.99 2071.99
+#88 (<Robert Kubica (#1136)>) R[0] 1943.93 1943.93
+#5 (<Sebastian Vettel (#1135)>) R[0] 2479.64 2479.64
+
+Podium rating:  7492.73 7562.79
+Average rating:  2196.7265
+Average rating change:  31.1417647059
+
diff --git a/sql/results.sql b/sql/results.sql
index 23f0fbe..11cc44e 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2679,6 +2679,8 @@ INSERT INTO `races` VALUES(2673, '2019 Japanese Grand Prix - qualifying', '2019-
 INSERT INTO `races` VALUES(2674, '2019 Japanese Grand Prix', '2019-10-13', 0, 4);
 INSERT INTO `races` VALUES(2675, '2019 Mexican Grand Prix - qualifying', '2019-10-26', 0, 3);
 INSERT INTO `races` VALUES(2676, '2019 Mexican Grand Prix', '2019-10-27', 0, 4);
+INSERT INTO `races` VALUES(2677, '2019 United States Grand Prix - qualifying', '2019-11-02', 0, 3);
+INSERT INTO `races` VALUES(2678, '2019 United States Grand Prix', '2019-11-03', 0, 4);
 
 INSERT INTO `countries` VALUES(9, 'Argentina');
 INSERT INTO `countries` VALUES(18, 'Australia');
@@ -61310,6 +61312,46 @@ INSERT INTO `entries` VALUES(57399, '17', 8, 5, 2676);
 INSERT INTO `entries` VALUES(57400, '18', 88, 5, 2676);
 INSERT INTO `entries` VALUES(57401, 'R', 7, 0, 2676);
 INSERT INTO `entries` VALUES(57402, 'R', 4, 0, 2676);
+INSERT INTO `entries` VALUES(57403, '1', 77, 1, 2677);
+INSERT INTO `entries` VALUES(57404, '2', 5, 2, 2677);
+INSERT INTO `entries` VALUES(57405, '3', 33, 3, 2677);
+INSERT INTO `entries` VALUES(57406, '4', 16, 4, 2677);
+INSERT INTO `entries` VALUES(57407, '5', 44, 5, 2677);
+INSERT INTO `entries` VALUES(57408, '6', 23, 6, 2677);
+INSERT INTO `entries` VALUES(57409, '7', 55, 7, 2677);
+INSERT INTO `entries` VALUES(57410, '8', 4, 8, 2677);
+INSERT INTO `entries` VALUES(57411, '9', 3, 9, 2677);
+INSERT INTO `entries` VALUES(57412, '10', 10, 10, 2677);
+INSERT INTO `entries` VALUES(57413, '11', 27, 11, 2677);
+INSERT INTO `entries` VALUES(57414, '12', 20, 12, 2677);
+INSERT INTO `entries` VALUES(57415, '13', 26, 13, 2677);
+INSERT INTO `entries` VALUES(57416, '14', 18, 14, 2677);
+INSERT INTO `entries` VALUES(57417, '15', 8, 15, 2677);
+INSERT INTO `entries` VALUES(57418, '16', 99, 16, 2677);
+INSERT INTO `entries` VALUES(57419, '17', 7, 17, 2677);
+INSERT INTO `entries` VALUES(57420, '18', 63, 18, 2677);
+INSERT INTO `entries` VALUES(57421, '19', 11, 19, 2677);
+INSERT INTO `entries` VALUES(57422, '20', 88, 20, 2677);
+INSERT INTO `entries` VALUES(57423, '1', 77, 1, 2678);
+INSERT INTO `entries` VALUES(57424, '2', 44, 2, 2678);
+INSERT INTO `entries` VALUES(57425, '3', 33, 2, 2678);
+INSERT INTO `entries` VALUES(57426, '4', 16, 3, 2678);
+INSERT INTO `entries` VALUES(57427, '5', 23, 3, 2678);
+INSERT INTO `entries` VALUES(57428, '6', 3, 4, 2678);
+INSERT INTO `entries` VALUES(57429, '7', 4, 4, 2678);
+INSERT INTO `entries` VALUES(57430, '8', 55, 5, 2678);
+INSERT INTO `entries` VALUES(57431, '9', 27, 5, 2678);
+INSERT INTO `entries` VALUES(57432, '10', 11, 5, 2678);
+INSERT INTO `entries` VALUES(57433, '11', 7, 5, 2678);
+INSERT INTO `entries` VALUES(57434, '12', 26, 5, 2678);
+INSERT INTO `entries` VALUES(57435, '13', 18, 5, 2678);
+INSERT INTO `entries` VALUES(57436, '14', 99, 5, 2678);
+INSERT INTO `entries` VALUES(57437, '15', 8, 5, 2678);
+INSERT INTO `entries` VALUES(57438, '16', 10, 6, 2678);
+INSERT INTO `entries` VALUES(57439, '17', 63, 6, 2678);
+INSERT INTO `entries` VALUES(57440, '18', 20, 0, 2678);
+INSERT INTO `entries` VALUES(57441, 'R', 88, 0, 2678);
+INSERT INTO `entries` VALUES(57442, 'R', 5, 0, 2678);
 
 INSERT INTO `driver_entries` VALUES(1, 1, 1);
 INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -118852,3 +118894,43 @@ INSERT INTO `driver_entries` VALUES(1144, 57399, 57538);
 INSERT INTO `driver_entries` VALUES(1136, 57400, 57539);
 INSERT INTO `driver_entries` VALUES(1141, 57401, 57540);
 INSERT INTO `driver_entries` VALUES(1186, 57402, 57541);
+INSERT INTO `driver_entries` VALUES(1161, 57403, 57542);
+INSERT INTO `driver_entries` VALUES(1135, 57404, 57543);
+INSERT INTO `driver_entries` VALUES(1172, 57405, 57544);
+INSERT INTO `driver_entries` VALUES(1184, 57406, 57545);
+INSERT INTO `driver_entries` VALUES(1140, 57407, 57546);
+INSERT INTO `driver_entries` VALUES(1187, 57408, 57547);
+INSERT INTO `driver_entries` VALUES(1170, 57409, 57548);
+INSERT INTO `driver_entries` VALUES(1186, 57410, 57549);
+INSERT INTO `driver_entries` VALUES(1157, 57411, 57550);
+INSERT INTO `driver_entries` VALUES(1182, 57412, 57551);
+INSERT INTO `driver_entries` VALUES(1148, 57413, 57552);
+INSERT INTO `driver_entries` VALUES(1165, 57414, 57553);
+INSERT INTO `driver_entries` VALUES(1166, 57415, 57554);
+INSERT INTO `driver_entries` VALUES(1181, 57416, 57555);
+INSERT INTO `driver_entries` VALUES(1144, 57417, 57556);
+INSERT INTO `driver_entries` VALUES(1180, 57418, 57557);
+INSERT INTO `driver_entries` VALUES(1141, 57419, 57558);
+INSERT INTO `driver_entries` VALUES(1188, 57420, 57559);
+INSERT INTO `driver_entries` VALUES(1155, 57421, 57560);
+INSERT INTO `driver_entries` VALUES(1136, 57422, 57561);
+INSERT INTO `driver_entries` VALUES(1161, 57423, 57562);
+INSERT INTO `driver_entries` VALUES(1140, 57424, 57563);
+INSERT INTO `driver_entries` VALUES(1172, 57425, 57564);
+INSERT INTO `driver_entries` VALUES(1184, 57426, 57565);
+INSERT INTO `driver_entries` VALUES(1187, 57427, 57566);
+INSERT INTO `driver_entries` VALUES(1157, 57428, 57567);
+INSERT INTO `driver_entries` VALUES(1186, 57429, 57568);
+INSERT INTO `driver_entries` VALUES(1170, 57430, 57569);
+INSERT INTO `driver_entries` VALUES(1148, 57431, 57570);
+INSERT INTO `driver_entries` VALUES(1155, 57432, 57571);
+INSERT INTO `driver_entries` VALUES(1141, 57433, 57572);
+INSERT INTO `driver_entries` VALUES(1166, 57434, 57573);
+INSERT INTO `driver_entries` VALUES(1181, 57435, 57574);
+INSERT INTO `driver_entries` VALUES(1180, 57436, 57575);
+INSERT INTO `driver_entries` VALUES(1144, 57437, 57576);
+INSERT INTO `driver_entries` VALUES(1182, 57438, 57577);
+INSERT INTO `driver_entries` VALUES(1188, 57439, 57578);
+INSERT INTO `driver_entries` VALUES(1165, 57440, 57579);
+INSERT INTO `driver_entries` VALUES(1136, 57441, 57580);
+INSERT INTO `driver_entries` VALUES(1135, 57442, 57581);