From 8678b0f1616c23ced7657cb3ff2042f4e5c4e827 Mon Sep 17 00:00:00 2001 From: emkael Date: Tue, 11 Aug 2020 16:46:13 +0200 Subject: 2020 Silverstone Grands Prix --- rate.log | 108 +++++++++++++++++++++++++++++++++++++ sql/results.sql | 164 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 272 insertions(+) diff --git a/rate.log b/rate.log index bffb19d..97b3790 100644 --- a/rate.log +++ b/rate.log @@ -76449,3 +76449,111 @@ Podium rating: 7661.84 7724.14 Average rating: 2200.443 Average rating change: 33.4089473684 +2020 British Grand Prix - qualifying (2020-08-01) + +#44 () 1[1] 2606.52 2609.28 +#77 () 2[2] 2580.69 2582.28 +#33 () 3[3] 2536.93 2537.74 +#16 () 4[4] 2148.23 2160.08 +#4 () 5[5] 2252.75 2258.68 +#18 () 6[6] 2275.5 2278.95 +#55 () 7[7] 2169.59 2175.73 +#3 () 8[8] 2185.59 2189.45 +#31 () 9[9] 2093.07 2099.26 +#5 () 10[10] 2102.78 2106.96 +#10 () 11[11] 2117.0 2118.98 +#23 () 12[12] 2329.95 2321.85 +#27 () 13[13] 2083.9 2084.07 +#26 () 14[14] 2092.05 2090.28 +#63 () 15[15] 2046.45 2044.95 +#20 () 16[16] 2098.62 2093.38 +#99 () 17[17] 2119.63 2111.9 +#7 () 18[18] 2116.51 2107.31 +#8 () 19[19] 2092.64 2082.85 +#6 () 20[20] 1856.41 1850.84 + +Podium rating: 7724.14 7729.3 +Average rating: 2195.2405 +Average rating change: 4.8905 + +2020 British Grand Prix (2020-08-02) + +#44 () 1[1] 2609.28 2636.25 +#33 () 2[2] 2537.74 2553.19 +#16 () 3[2] 2160.08 2291.43 +#3 () 4[3] 2189.45 2277.15 +#4 () 5[3] 2258.68 2319.94 +#31 () 6[4] 2099.26 2166.78 +#10 () 7[4] 2118.98 2178.71 +#23 () 8[4] 2321.85 2305.1 +#18 () 9[4] 2278.95 2276.89 +#5 () 10[4] 2106.96 2171.45 +#77 () 11[5] 2582.28 2409.65 +#63 () 12[5] 2044.95 2041.28 +#55 () 13[5] 2175.73 2120.85 +#99 () 14[5] 2111.9 2082.43 +#6 () 15[5] 1850.84 1932.7 +#8 () 16[5] 2082.85 2064.78 +#7 () 17[6] 2107.31 2019.66 +#27 () W[0] 2084.07 2084.07 +#26 () R[7] 2090.28 1985.32 +#20 () R[7] 2093.38 1987.21 + +Podium rating: 7307.1 7480.87 +Average rating: 2195.241 +Average rating change: 62.7705263158 + +70th Anniversary Grand Prix - qualifying (2020-08-08) + +#77 () 1[1] 2409.65 2416.58 +#44 () 2[2] 2636.25 2636.64 +#27 () 3[3] 2084.07 2101.01 +#33 () 4[4] 2553.19 2551.77 +#3 () 5[5] 2277.15 2282.39 +#18 () 6[6] 2276.89 2280.54 +#10 () 7[7] 2178.71 2184.97 +#16 () 8[8] 2291.43 2291.3 +#23 () 9[9] 2305.1 2302.84 +#4 () 10[10] 2319.94 2315.51 +#31 () 11[11] 2166.78 2167.18 +#5 () 12[12] 2171.45 2170.04 +#55 () 13[13] 2120.85 2120.13 +#8 () 14[14] 2064.78 2064.97 +#63 () 15[15] 2041.28 2040.89 +#26 () 16[16] 1985.32 1984.1 +#20 () 17[17] 1987.21 1983.49 +#6 () 18[18] 1932.7 1929.27 +#99 () 19[19] 2082.43 2071.44 +#7 () 20[20] 2019.66 2009.79 + +Podium rating: 7129.97 7154.23 +Average rating: 2195.242 +Average rating change: 3.9995 + +70th Anniversary Grand Prix (2020-08-09) + +#33 () 1[1] 2551.77 2585.22 +#44 () 2[2] 2636.64 2632.02 +#77 () 3[2] 2416.58 2458.52 +#16 () 4[3] 2291.3 2343.47 +#23 () 5[3] 2302.84 2350.67 +#18 () 6[4] 2280.54 2276.82 +#27 () 7[4] 2101.01 2171.38 +#31 () 8[4] 2167.18 2209.74 +#4 () 9[4] 2315.51 2298.67 +#26 () 10[4] 1984.1 2152.72 +#10 () 11[5] 2184.97 2152.04 +#5 () 12[5] 2170.04 2143.39 +#55 () 13[5] 2120.13 2114.53 +#3 () 14[6] 2282.39 2133.96 +#7 () 15[6] 2009.79 1972.22 +#8 () 16[6] 2064.97 2006.08 +#99 () 17[6] 2071.44 2009.94 +#63 () 18[6] 2040.89 1991.52 +#6 () 19[6] 1929.27 1918.46 +#20 () R[0] 1983.49 1983.49 + +Podium rating: 7604.99 7675.76 +Average rating: 2195.2425 +Average rating change: 48.0984210526 + diff --git a/sql/results.sql b/sql/results.sql index 13c2b82..71070ac 100644 --- a/sql/results.sql +++ b/sql/results.sql @@ -2691,6 +2691,10 @@ INSERT INTO `races` VALUES(2685, '2020 Styrian Grand Prix - qualifying', '2020-0 INSERT INTO `races` VALUES(2686, '2020 Styrian Grand Prix', '2020-07-12', 0, 4); INSERT INTO `races` VALUES(2687, '2020 Hungarian Grand Prix - qualifying', '2020-07-18', 0, 3); INSERT INTO `races` VALUES(2688, '2020 Hungarian Grand Prix', '2020-07-19', 0, 4); +INSERT INTO `races` VALUES(2689, '2020 British Grand Prix - qualifying', '2020-08-01', 0, 3); +INSERT INTO `races` VALUES(2690, '2020 British Grand Prix', '2020-08-02', 0, 4); +INSERT INTO `races` VALUES(2691, '70th Anniversary Grand Prix - qualifying', '2020-08-08', 0, 3); +INSERT INTO `races` VALUES(2692, '70th Anniversary Grand Prix', '2020-08-09', 0, 4); INSERT INTO `countries` VALUES(9, 'Argentina'); INSERT INTO `countries` VALUES(18, 'Australia'); @@ -61563,6 +61567,86 @@ INSERT INTO `entries` VALUES(57639, '17', 99, 4, 2688); INSERT INTO `entries` VALUES(57640, '18', 63, 4, 2688); INSERT INTO `entries` VALUES(57641, '19', 6, 5, 2688); INSERT INTO `entries` VALUES(57642, 'R', 10, 0, 2688); +INSERT INTO `entries` VALUES(57643, '1', 44, 1, 2689); +INSERT INTO `entries` VALUES(57644, '2', 77, 2, 2689); +INSERT INTO `entries` VALUES(57645, '3', 33, 3, 2689); +INSERT INTO `entries` VALUES(57646, '4', 16, 4, 2689); +INSERT INTO `entries` VALUES(57647, '5', 4, 5, 2689); +INSERT INTO `entries` VALUES(57648, '6', 18, 6, 2689); +INSERT INTO `entries` VALUES(57649, '7', 55, 7, 2689); +INSERT INTO `entries` VALUES(57650, '8', 3, 8, 2689); +INSERT INTO `entries` VALUES(57651, '9', 31, 9, 2689); +INSERT INTO `entries` VALUES(57652, '10', 5, 10, 2689); +INSERT INTO `entries` VALUES(57653, '11', 10, 11, 2689); +INSERT INTO `entries` VALUES(57654, '12', 23, 12, 2689); +INSERT INTO `entries` VALUES(57655, '13', 27, 13, 2689); +INSERT INTO `entries` VALUES(57656, '14', 26, 14, 2689); +INSERT INTO `entries` VALUES(57657, '15', 63, 15, 2689); +INSERT INTO `entries` VALUES(57658, '16', 20, 16, 2689); +INSERT INTO `entries` VALUES(57659, '17', 99, 17, 2689); +INSERT INTO `entries` VALUES(57660, '18', 7, 18, 2689); +INSERT INTO `entries` VALUES(57661, '19', 8, 19, 2689); +INSERT INTO `entries` VALUES(57662, '20', 6, 20, 2689); +INSERT INTO `entries` VALUES(57663, '1', 44, 1, 2690); +INSERT INTO `entries` VALUES(57664, '2', 33, 2, 2690); +INSERT INTO `entries` VALUES(57665, '3', 16, 2, 2690); +INSERT INTO `entries` VALUES(57666, '4', 3, 3, 2690); +INSERT INTO `entries` VALUES(57667, '5', 4, 3, 2690); +INSERT INTO `entries` VALUES(57668, '6', 31, 4, 2690); +INSERT INTO `entries` VALUES(57669, '7', 10, 4, 2690); +INSERT INTO `entries` VALUES(57670, '8', 23, 4, 2690); +INSERT INTO `entries` VALUES(57671, '9', 18, 4, 2690); +INSERT INTO `entries` VALUES(57672, '10', 5, 4, 2690); +INSERT INTO `entries` VALUES(57673, '11', 77, 5, 2690); +INSERT INTO `entries` VALUES(57674, '12', 63, 5, 2690); +INSERT INTO `entries` VALUES(57675, '13', 55, 5, 2690); +INSERT INTO `entries` VALUES(57676, '14', 99, 5, 2690); +INSERT INTO `entries` VALUES(57677, '15', 6, 5, 2690); +INSERT INTO `entries` VALUES(57678, '16', 8, 5, 2690); +INSERT INTO `entries` VALUES(57679, '17', 7, 6, 2690); +INSERT INTO `entries` VALUES(57680, 'R', 26, 7, 2690); +INSERT INTO `entries` VALUES(57681, 'R', 20, 7, 2690); +INSERT INTO `entries` VALUES(57682, 'W', 27, 0, 2690); +INSERT INTO `entries` VALUES(57683, '1', 77, 1, 2691); +INSERT INTO `entries` VALUES(57684, '2', 44, 2, 2691); +INSERT INTO `entries` VALUES(57685, '3', 27, 3, 2691); +INSERT INTO `entries` VALUES(57686, '4', 33, 4, 2691); +INSERT INTO `entries` VALUES(57687, '5', 3, 5, 2691); +INSERT INTO `entries` VALUES(57688, '6', 18, 6, 2691); +INSERT INTO `entries` VALUES(57689, '7', 10, 7, 2691); +INSERT INTO `entries` VALUES(57690, '8', 16, 8, 2691); +INSERT INTO `entries` VALUES(57691, '9', 23, 9, 2691); +INSERT INTO `entries` VALUES(57692, '10', 4, 10, 2691); +INSERT INTO `entries` VALUES(57693, '11', 31, 11, 2691); +INSERT INTO `entries` VALUES(57694, '12', 5, 12, 2691); +INSERT INTO `entries` VALUES(57695, '13', 55, 13, 2691); +INSERT INTO `entries` VALUES(57696, '14', 8, 14, 2691); +INSERT INTO `entries` VALUES(57697, '15', 63, 15, 2691); +INSERT INTO `entries` VALUES(57698, '16', 26, 16, 2691); +INSERT INTO `entries` VALUES(57699, '17', 20, 17, 2691); +INSERT INTO `entries` VALUES(57700, '18', 6, 18, 2691); +INSERT INTO `entries` VALUES(57701, '19', 99, 19, 2691); +INSERT INTO `entries` VALUES(57702, '20', 7, 20, 2691); +INSERT INTO `entries` VALUES(57703, '1', 33, 1, 2692); +INSERT INTO `entries` VALUES(57704, '2', 44, 2, 2692); +INSERT INTO `entries` VALUES(57705, '3', 77, 2, 2692); +INSERT INTO `entries` VALUES(57706, '4', 16, 3, 2692); +INSERT INTO `entries` VALUES(57707, '5', 23, 3, 2692); +INSERT INTO `entries` VALUES(57708, '6', 18, 4, 2692); +INSERT INTO `entries` VALUES(57709, '7', 27, 4, 2692); +INSERT INTO `entries` VALUES(57710, '8', 31, 4, 2692); +INSERT INTO `entries` VALUES(57711, '9', 4, 4, 2692); +INSERT INTO `entries` VALUES(57712, '10', 26, 4, 2692); +INSERT INTO `entries` VALUES(57713, '11', 10, 5, 2692); +INSERT INTO `entries` VALUES(57714, '12', 5, 5, 2692); +INSERT INTO `entries` VALUES(57715, '13', 55, 5, 2692); +INSERT INTO `entries` VALUES(57716, '14', 3, 6, 2692); +INSERT INTO `entries` VALUES(57717, '15', 7, 6, 2692); +INSERT INTO `entries` VALUES(57718, '16', 8, 6, 2692); +INSERT INTO `entries` VALUES(57719, '17', 99, 6, 2692); +INSERT INTO `entries` VALUES(57720, '18', 63, 6, 2692); +INSERT INTO `entries` VALUES(57721, '19', 6, 6, 2692); +INSERT INTO `entries` VALUES(57722, 'R', 20, 0, 2692); INSERT INTO `driver_entries` VALUES(1, 1, 1); INSERT INTO `driver_entries` VALUES(2, 2, 2); @@ -119345,3 +119429,83 @@ INSERT INTO `driver_entries` VALUES(1180, 57639, 57778); INSERT INTO `driver_entries` VALUES(1188, 57640, 57779); INSERT INTO `driver_entries` VALUES(1189, 57641, 57780); INSERT INTO `driver_entries` VALUES(1182, 57642, 57781); +INSERT INTO `driver_entries` VALUES(1140, 57643, 57782); +INSERT INTO `driver_entries` VALUES(1161, 57644, 57783); +INSERT INTO `driver_entries` VALUES(1172, 57645, 57784); +INSERT INTO `driver_entries` VALUES(1184, 57646, 57785); +INSERT INTO `driver_entries` VALUES(1186, 57647, 57786); +INSERT INTO `driver_entries` VALUES(1181, 57648, 57787); +INSERT INTO `driver_entries` VALUES(1170, 57649, 57788); +INSERT INTO `driver_entries` VALUES(1157, 57650, 57789); +INSERT INTO `driver_entries` VALUES(1179, 57651, 57790); +INSERT INTO `driver_entries` VALUES(1135, 57652, 57791); +INSERT INTO `driver_entries` VALUES(1182, 57653, 57792); +INSERT INTO `driver_entries` VALUES(1187, 57654, 57793); +INSERT INTO `driver_entries` VALUES(1148, 57655, 57794); +INSERT INTO `driver_entries` VALUES(1166, 57656, 57795); +INSERT INTO `driver_entries` VALUES(1188, 57657, 57796); +INSERT INTO `driver_entries` VALUES(1165, 57658, 57797); +INSERT INTO `driver_entries` VALUES(1180, 57659, 57798); +INSERT INTO `driver_entries` VALUES(1141, 57660, 57799); +INSERT INTO `driver_entries` VALUES(1144, 57661, 57800); +INSERT INTO `driver_entries` VALUES(1189, 57662, 57801); +INSERT INTO `driver_entries` VALUES(1140, 57663, 57802); +INSERT INTO `driver_entries` VALUES(1172, 57664, 57803); +INSERT INTO `driver_entries` VALUES(1184, 57665, 57804); +INSERT INTO `driver_entries` VALUES(1157, 57666, 57805); +INSERT INTO `driver_entries` VALUES(1186, 57667, 57806); +INSERT INTO `driver_entries` VALUES(1179, 57668, 57807); +INSERT INTO `driver_entries` VALUES(1182, 57669, 57808); +INSERT INTO `driver_entries` VALUES(1187, 57670, 57809); +INSERT INTO `driver_entries` VALUES(1181, 57671, 57810); +INSERT INTO `driver_entries` VALUES(1135, 57672, 57811); +INSERT INTO `driver_entries` VALUES(1161, 57673, 57812); +INSERT INTO `driver_entries` VALUES(1188, 57674, 57813); +INSERT INTO `driver_entries` VALUES(1170, 57675, 57814); +INSERT INTO `driver_entries` VALUES(1180, 57676, 57815); +INSERT INTO `driver_entries` VALUES(1189, 57677, 57816); +INSERT INTO `driver_entries` VALUES(1144, 57678, 57817); +INSERT INTO `driver_entries` VALUES(1141, 57679, 57818); +INSERT INTO `driver_entries` VALUES(1166, 57680, 57819); +INSERT INTO `driver_entries` VALUES(1165, 57681, 57820); +INSERT INTO `driver_entries` VALUES(1148, 57682, 57821); +INSERT INTO `driver_entries` VALUES(1161, 57683, 57822); +INSERT INTO `driver_entries` VALUES(1140, 57684, 57823); +INSERT INTO `driver_entries` VALUES(1148, 57685, 57824); +INSERT INTO `driver_entries` VALUES(1172, 57686, 57825); +INSERT INTO `driver_entries` VALUES(1157, 57687, 57826); +INSERT INTO `driver_entries` VALUES(1181, 57688, 57827); +INSERT INTO `driver_entries` VALUES(1182, 57689, 57828); +INSERT INTO `driver_entries` VALUES(1184, 57690, 57829); +INSERT INTO `driver_entries` VALUES(1187, 57691, 57830); +INSERT INTO `driver_entries` VALUES(1186, 57692, 57831); +INSERT INTO `driver_entries` VALUES(1179, 57693, 57832); +INSERT INTO `driver_entries` VALUES(1135, 57694, 57833); +INSERT INTO `driver_entries` VALUES(1170, 57695, 57834); +INSERT INTO `driver_entries` VALUES(1144, 57696, 57835); +INSERT INTO `driver_entries` VALUES(1188, 57697, 57836); +INSERT INTO `driver_entries` VALUES(1166, 57698, 57837); +INSERT INTO `driver_entries` VALUES(1165, 57699, 57838); +INSERT INTO `driver_entries` VALUES(1189, 57700, 57839); +INSERT INTO `driver_entries` VALUES(1180, 57701, 57840); +INSERT INTO `driver_entries` VALUES(1141, 57702, 57841); +INSERT INTO `driver_entries` VALUES(1172, 57703, 57842); +INSERT INTO `driver_entries` VALUES(1140, 57704, 57843); +INSERT INTO `driver_entries` VALUES(1161, 57705, 57844); +INSERT INTO `driver_entries` VALUES(1184, 57706, 57845); +INSERT INTO `driver_entries` VALUES(1187, 57707, 57846); +INSERT INTO `driver_entries` VALUES(1181, 57708, 57847); +INSERT INTO `driver_entries` VALUES(1148, 57709, 57848); +INSERT INTO `driver_entries` VALUES(1179, 57710, 57849); +INSERT INTO `driver_entries` VALUES(1186, 57711, 57850); +INSERT INTO `driver_entries` VALUES(1166, 57712, 57851); +INSERT INTO `driver_entries` VALUES(1182, 57713, 57852); +INSERT INTO `driver_entries` VALUES(1135, 57714, 57853); +INSERT INTO `driver_entries` VALUES(1170, 57715, 57854); +INSERT INTO `driver_entries` VALUES(1157, 57716, 57855); +INSERT INTO `driver_entries` VALUES(1141, 57717, 57856); +INSERT INTO `driver_entries` VALUES(1144, 57718, 57857); +INSERT INTO `driver_entries` VALUES(1180, 57719, 57858); +INSERT INTO `driver_entries` VALUES(1188, 57720, 57859); +INSERT INTO `driver_entries` VALUES(1189, 57721, 57860); +INSERT INTO `driver_entries` VALUES(1165, 57722, 57861); -- cgit v1.2.3