From 689db9a6c431a57c6e577dde059376101c0b2f6c Mon Sep 17 00:00:00 2001 From: emkael Date: Wed, 6 Nov 2019 16:53:49 +0100 Subject: 2019 US GP --- rate.log | 54 +++++++++++++++++++++++++++++++++++++ sql/results.sql | 82 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 136 insertions(+) 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 () 1[1] 2516.65 2520.62 +#5 () 2[2] 2476.3 2479.64 +#33 () 3[3] 2353.33 2358.71 +#16 () 4[4] 2410.76 2412.71 +#44 () 5[5] 2617.77 2613.4 +#23 () 6[6] 2373.84 2373.74 +#55 () 7[7] 2163.08 2169.67 +#4 () 8[8] 2185.09 2189.09 +#3 () 9[9] 2125.43 2130.55 +#10 () 10[10] 2195.29 2195.64 +#27 () 11[11] 2030.4 2036.65 +#20 () 12[12] 2069.07 2071.99 +#26 () 13[13] 2060.95 2062.64 +#18 () 14[14] 2050.89 2051.43 +#8 () 15[15] 2043.35 2042.63 +#99 () 16[16] 2067.39 2063.98 +#7 () 17[17] 2073.93 2068.62 +#63 () 18[18] 1948.04 1944.43 +#11 () 19[19] 2220.39 2204.46 +#88 () 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 () 1[1] 2520.62 2552.08 +#44 () 2[2] 2613.4 2605.89 +#33 () 3[2] 2358.71 2404.82 +#16 () 4[3] 2412.71 2412.09 +#23 () 5[3] 2373.74 2383.56 +#3 () 6[4] 2130.55 2193.39 +#4 () 7[4] 2189.09 2229.06 +#55 () 8[5] 2169.67 2137.15 +#27 () 9[5] 2036.65 2055.67 +#11 () 10[5] 2204.46 2158.57 +#7 () 11[5] 2068.62 2075.65 +#26 () 12[5] 2062.64 2071.95 +#18 () 13[5] 2051.43 2064.97 +#99 () 14[5] 2063.98 2072.78 +#8 () 15[5] 2042.63 2059.45 +#10 () 16[6] 2195.64 2069.1 +#63 () 17[6] 1944.43 1892.82 +#20 () 18[0] 2071.99 2071.99 +#88 () R[0] 1943.93 1943.93 +#5 () 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); -- cgit v1.2.3