summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2019-08-14 00:51:18 +0200
committeremkael <emkael@tlen.pl>2019-08-14 00:51:18 +0200
commitcb65bc5f224eab3c9ea5bd961f3f41a9dfe01ee6 (patch)
tree22e81511726c6bc4a351abc7a3556836fb2028eb
parent3ceef0e0799d552b1ec935e9bc3f54d3c2486ccb (diff)
2019 German GP
2019 Hungarian GP
-rw-r--r--rate.log108
-rw-r--r--sql/results.sql164
2 files changed, 272 insertions, 0 deletions
diff --git a/rate.log b/rate.log
index 1be946d..8fc85c5 100644
--- a/rate.log
+++ b/rate.log
@@ -75694,3 +75694,111 @@ Podium rating: 7784.18 7847.65
Average rating: 2196.7245
Average rating change: 64.528
+2019 German Grand Prix - qualifying (2019-07-27)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2742.14 2743.37
+#33 (<Max Verstappen (#1172)>) 2[2] 2542.7 2545.33
+#77 (<Valtteri Bottas (#1161)>) 3[3] 2625.34 2624.92
+#10 (<Pierre Gasly (#1182)>) 4[4] 2270.5 2277.48
+#7 (<Kimi Räikkönen (#1141)>) 5[5] 2182.38 2191.36
+#8 (<Romain Grosjean (#1144)>) 6[6] 1994.1 2015.56
+#55 (<Carlos Sainz (#1170)>) 7[7] 2226.48 2229.6
+#11 (<Sergio Pérez (#1155)>) 8[8] 2042.95 2052.59
+#27 (<Nico Hülkenberg (#1148)>) 9[9] 2179.94 2181.82
+#16 (<Charles Leclerc (#1184)>) 10[10] 2480.17 2470.51
+#99 (<Antonio Giovinazzi (#1180)>) 11[11] 1975.15 1985.61
+#20 (<Kevin Magnussen (#1165)>) 12[12] 1881.7 1894.11
+#3 (<Daniel Ricciardo (#1157)>) 13[13] 2194.05 2187.33
+#26 (<Daniil Kvyat (#1166)>) 14[14] 2182.84 2175.0
+#18 (<Lance Stroll (#1181)>) 15[15] 2104.16 2098.23
+#4 (<Lando Norris (#1186)>) 16[16] 2123.74 2115.32
+#23 (<Alexander Albon (#1187)>) 17[17] 2103.36 2094.27
+#63 (<George Russell (#1188)>) 18[18] 1884.84 1882.72
+#88 (<Robert Kubica (#1136)>) 19[19] 1872.28 1868.27
+#5 (<Sebastian Vettel (#1135)>) 20[20] 2325.65 2301.07
+
+Podium rating: 7910.18 7913.62
+Average rating: 2196.7235
+Average rating change: 7.879
+
+2019 German Grand Prix (2019-07-28)
+
+#33 (<Max Verstappen (#1172)>) 1[1] 2545.33 2585.01
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2301.07 2374.62
+#26 (<Daniil Kvyat (#1166)>) 3[2] 2175.0 2291.74
+#18 (<Lance Stroll (#1181)>) 4[3] 2098.23 2212.35
+#55 (<Carlos Sainz (#1170)>) 5[3] 2229.6 2294.61
+#23 (<Alexander Albon (#1187)>) 6[4] 2094.27 2145.93
+#8 (<Romain Grosjean (#1144)>) 7[4] 2015.56 2097.65
+#20 (<Kevin Magnussen (#1165)>) 8[4] 1894.11 2068.22
+#44 (<Lewis Hamilton (#1140)>) 9[4] 2743.37 2635.02
+#88 (<Robert Kubica (#1136)>) 10[4] 1868.27 2051.9
+#63 (<George Russell (#1188)>) 11[5] 1882.72 1965.12
+#7 (<Kimi Räikkönen (#1141)>) 12[5] 2191.36 2126.05
+#99 (<Antonio Giovinazzi (#1180)>) 13[5] 1985.61 2024.39
+#10 (<Pierre Gasly (#1182)>) 14[6] 2277.48 2110.43
+#4 (<Lando Norris (#1186)>) R[0] 2115.32 2115.32
+#3 (<Daniel Ricciardo (#1157)>) R[0] 2187.33 2187.33
+#77 (<Valtteri Bottas (#1161)>) R[6] 2624.92 2379.57
+#27 (<Nico Hülkenberg (#1148)>) R[6] 2181.82 2048.02
+#16 (<Charles Leclerc (#1184)>) R[6] 2470.51 2252.72
+#11 (<Sergio Pérez (#1155)>) R[6] 2052.59 1968.46
+
+Podium rating: 7021.4 7251.37
+Average rating: 2196.7235
+Average rating change: 113.530555556
+
+2019 Hungarian Grand Prix - qualifying (2019-08-03)
+
+#33 (<Max Verstappen (#1172)>) 1[1] 2585.01 2587.45
+#77 (<Valtteri Bottas (#1161)>) 2[2] 2379.57 2385.28
+#44 (<Lewis Hamilton (#1140)>) 3[3] 2635.02 2633.51
+#16 (<Charles Leclerc (#1184)>) 4[4] 2252.72 2260.06
+#5 (<Sebastian Vettel (#1135)>) 5[5] 2374.62 2375.69
+#10 (<Pierre Gasly (#1182)>) 6[6] 2110.43 2121.27
+#4 (<Lando Norris (#1186)>) 7[7] 2115.32 2124.32
+#55 (<Carlos Sainz (#1170)>) 8[8] 2294.61 2293.8
+#8 (<Romain Grosjean (#1144)>) 9[9] 2097.65 2104.31
+#7 (<Kimi Räikkönen (#1141)>) 10[10] 2126.05 2129.73
+#27 (<Nico Hülkenberg (#1148)>) 11[11] 2048.02 2053.82
+#23 (<Alexander Albon (#1187)>) 12[12] 2145.93 2145.45
+#26 (<Daniil Kvyat (#1166)>) 13[13] 2291.74 2283.05
+#99 (<Antonio Giovinazzi (#1180)>) 14[14] 2024.39 2026.45
+#20 (<Kevin Magnussen (#1165)>) 15[15] 2068.22 2066.68
+#63 (<George Russell (#1188)>) 16[16] 1965.12 1965.88
+#11 (<Sergio Pérez (#1155)>) 17[17] 1968.46 1966.64
+#3 (<Daniel Ricciardo (#1157)>) 18[18] 2187.33 2173.66
+#18 (<Lance Stroll (#1181)>) 19[19] 2212.35 2195.91
+#88 (<Robert Kubica (#1136)>) 20[20] 2051.9 2041.52
+
+Podium rating: 7599.6 7606.24
+Average rating: 2196.723
+Average rating change: 5.535
+
+2019 Hungarian Grand Prix (2019-08-04)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2633.51 2650.41
+#33 (<Max Verstappen (#1172)>) 2[2] 2587.45 2587.07
+#5 (<Sebastian Vettel (#1135)>) 3[2] 2375.69 2424.15
+#16 (<Charles Leclerc (#1184)>) 4[3] 2260.06 2326.46
+#55 (<Carlos Sainz (#1170)>) 5[4] 2293.8 2254.84
+#10 (<Pierre Gasly (#1182)>) 6[4] 2121.27 2156.9
+#7 (<Kimi Räikkönen (#1141)>) 7[4] 2129.73 2161.5
+#77 (<Valtteri Bottas (#1161)>) 8[4] 2385.28 2314.77
+#4 (<Lando Norris (#1186)>) 9[4] 2124.32 2158.55
+#23 (<Alexander Albon (#1187)>) 10[4] 2145.45 2170.04
+#11 (<Sergio Pérez (#1155)>) 11[4] 1966.64 2111.73
+#27 (<Nico Hülkenberg (#1148)>) 12[4] 2053.82 2119.63
+#20 (<Kevin Magnussen (#1165)>) 13[4] 2066.68 2126.87
+#3 (<Daniel Ricciardo (#1157)>) 14[4] 2173.66 2185.44
+#26 (<Daniil Kvyat (#1166)>) 15[5] 2283.05 2128.26
+#63 (<George Russell (#1188)>) 16[5] 1965.88 1943.34
+#18 (<Lance Stroll (#1181)>) 17[5] 2195.91 2077.73
+#99 (<Antonio Giovinazzi (#1180)>) 18[5] 2026.45 1983.88
+#88 (<Robert Kubica (#1136)>) 19[6] 2041.52 1948.61
+#8 (<Romain Grosjean (#1144)>) R[0] 2104.31 2104.31
+
+Podium rating: 7596.65 7661.63
+Average rating: 2196.724
+Average rating change: 56.9310526316
+
diff --git a/sql/results.sql b/sql/results.sql
index 511ba29..2a4862c 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2663,6 +2663,10 @@ INSERT INTO `races` VALUES(2657, '2019 Austrian Grand Prix - qualifying', '2019-
INSERT INTO `races` VALUES(2658, '2019 Austrian Grand Prix', '2019-06-30', 0, 4);
INSERT INTO `races` VALUES(2659, '2019 British Grand Prix - qualifying', '2019-07-13', 0, 3);
INSERT INTO `races` VALUES(2660, '2019 British Grand Prix', '2019-07-14', 0, 4);
+INSERT INTO `races` VALUES(2661, '2019 German Grand Prix - qualifying', '2019-07-27', 0, 3);
+INSERT INTO `races` VALUES(2662, '2019 German Grand Prix', '2019-07-28', 0, 4);
+INSERT INTO `races` VALUES(2663, '2019 Hungarian Grand Prix - qualifying', '2019-08-03', 0, 3);
+INSERT INTO `races` VALUES(2664, '2019 Hungarian Grand Prix', '2019-08-04', 0, 4);
INSERT INTO `countries` VALUES(9, 'Argentina');
INSERT INTO `countries` VALUES(18, 'Australia');
@@ -60974,6 +60978,86 @@ INSERT INTO `entries` VALUES(57078, '17', 11, 6, 2660);
INSERT INTO `entries` VALUES(57079, 'R', 99, 7, 2660);
INSERT INTO `entries` VALUES(57080, 'R', 8, 7, 2660);
INSERT INTO `entries` VALUES(57081, 'R', 20, 7, 2660);
+INSERT INTO `entries` VALUES(57082, '1', 44, 1, 2661);
+INSERT INTO `entries` VALUES(57083, '2', 33, 2, 2661);
+INSERT INTO `entries` VALUES(57084, '3', 77, 3, 2661);
+INSERT INTO `entries` VALUES(57085, '4', 10, 4, 2661);
+INSERT INTO `entries` VALUES(57086, '5', 7, 5, 2661);
+INSERT INTO `entries` VALUES(57087, '6', 8, 6, 2661);
+INSERT INTO `entries` VALUES(57088, '7', 55, 7, 2661);
+INSERT INTO `entries` VALUES(57089, '8', 11, 8, 2661);
+INSERT INTO `entries` VALUES(57090, '9', 27, 9, 2661);
+INSERT INTO `entries` VALUES(57091, '10', 16, 10, 2661);
+INSERT INTO `entries` VALUES(57092, '11', 99, 11, 2661);
+INSERT INTO `entries` VALUES(57093, '12', 20, 12, 2661);
+INSERT INTO `entries` VALUES(57094, '13', 3, 13, 2661);
+INSERT INTO `entries` VALUES(57095, '14', 26, 14, 2661);
+INSERT INTO `entries` VALUES(57096, '15', 18, 15, 2661);
+INSERT INTO `entries` VALUES(57097, '16', 4, 16, 2661);
+INSERT INTO `entries` VALUES(57098, '17', 23, 17, 2661);
+INSERT INTO `entries` VALUES(57099, '18', 63, 18, 2661);
+INSERT INTO `entries` VALUES(57100, '19', 88, 19, 2661);
+INSERT INTO `entries` VALUES(57101, '20', 5, 20, 2661);
+INSERT INTO `entries` VALUES(57102, '1', 33, 1, 2662);
+INSERT INTO `entries` VALUES(57103, '2', 5, 2, 2662);
+INSERT INTO `entries` VALUES(57104, '3', 26, 2, 2662);
+INSERT INTO `entries` VALUES(57105, '4', 18, 3, 2662);
+INSERT INTO `entries` VALUES(57106, '5', 55, 3, 2662);
+INSERT INTO `entries` VALUES(57107, '6', 23, 4, 2662);
+INSERT INTO `entries` VALUES(57108, '7', 8, 4, 2662);
+INSERT INTO `entries` VALUES(57109, '8', 20, 4, 2662);
+INSERT INTO `entries` VALUES(57110, '9', 44, 4, 2662);
+INSERT INTO `entries` VALUES(57111, '10', 88, 4, 2662);
+INSERT INTO `entries` VALUES(57112, '11', 63, 5, 2662);
+INSERT INTO `entries` VALUES(57113, '12', 7, 5, 2662);
+INSERT INTO `entries` VALUES(57114, '13', 99, 5, 2662);
+INSERT INTO `entries` VALUES(57115, '14', 10, 6, 2662);
+INSERT INTO `entries` VALUES(57116, 'R', 77, 6, 2662);
+INSERT INTO `entries` VALUES(57117, 'R', 27, 6, 2662);
+INSERT INTO `entries` VALUES(57118, 'R', 16, 6, 2662);
+INSERT INTO `entries` VALUES(57119, 'R', 4, 0, 2662);
+INSERT INTO `entries` VALUES(57120, 'R', 3, 0, 2662);
+INSERT INTO `entries` VALUES(57121, 'R', 11, 6, 2662);
+INSERT INTO `entries` VALUES(57122, '1', 33, 1, 2663);
+INSERT INTO `entries` VALUES(57123, '2', 77, 2, 2663);
+INSERT INTO `entries` VALUES(57124, '3', 44, 3, 2663);
+INSERT INTO `entries` VALUES(57125, '4', 16, 4, 2663);
+INSERT INTO `entries` VALUES(57126, '5', 5, 5, 2663);
+INSERT INTO `entries` VALUES(57127, '6', 10, 6, 2663);
+INSERT INTO `entries` VALUES(57128, '7', 4, 7, 2663);
+INSERT INTO `entries` VALUES(57129, '8', 55, 8, 2663);
+INSERT INTO `entries` VALUES(57130, '9', 8, 9, 2663);
+INSERT INTO `entries` VALUES(57131, '10', 7, 10, 2663);
+INSERT INTO `entries` VALUES(57132, '11', 27, 11, 2663);
+INSERT INTO `entries` VALUES(57133, '12', 23, 12, 2663);
+INSERT INTO `entries` VALUES(57134, '13', 26, 13, 2663);
+INSERT INTO `entries` VALUES(57135, '14', 99, 14, 2663);
+INSERT INTO `entries` VALUES(57136, '15', 20, 15, 2663);
+INSERT INTO `entries` VALUES(57137, '16', 63, 16, 2663);
+INSERT INTO `entries` VALUES(57138, '17', 11, 17, 2663);
+INSERT INTO `entries` VALUES(57139, '18', 3, 18, 2663);
+INSERT INTO `entries` VALUES(57140, '19', 18, 19, 2663);
+INSERT INTO `entries` VALUES(57141, '20', 88, 20, 2663);
+INSERT INTO `entries` VALUES(57142, '1', 44, 1, 2664);
+INSERT INTO `entries` VALUES(57143, '2', 33, 2, 2664);
+INSERT INTO `entries` VALUES(57144, '3', 5, 2, 2664);
+INSERT INTO `entries` VALUES(57145, '4', 16, 3, 2664);
+INSERT INTO `entries` VALUES(57146, '5', 55, 4, 2664);
+INSERT INTO `entries` VALUES(57147, '6', 10, 4, 2664);
+INSERT INTO `entries` VALUES(57148, '7', 7, 4, 2664);
+INSERT INTO `entries` VALUES(57149, '8', 77, 4, 2664);
+INSERT INTO `entries` VALUES(57150, '9', 4, 4, 2664);
+INSERT INTO `entries` VALUES(57151, '10', 23, 4, 2664);
+INSERT INTO `entries` VALUES(57152, '11', 11, 4, 2664);
+INSERT INTO `entries` VALUES(57153, '12', 27, 4, 2664);
+INSERT INTO `entries` VALUES(57154, '13', 20, 4, 2664);
+INSERT INTO `entries` VALUES(57155, '14', 3, 4, 2664);
+INSERT INTO `entries` VALUES(57156, '15', 26, 5, 2664);
+INSERT INTO `entries` VALUES(57157, '16', 63, 5, 2664);
+INSERT INTO `entries` VALUES(57158, '17', 18, 5, 2664);
+INSERT INTO `entries` VALUES(57159, '18', 99, 5, 2664);
+INSERT INTO `entries` VALUES(57160, '19', 88, 6, 2664);
+INSERT INTO `entries` VALUES(57161, 'R', 8, 0, 2664);
INSERT INTO `driver_entries` VALUES(1, 1, 1);
INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -118196,3 +118280,83 @@ INSERT INTO `driver_entries` VALUES(1155, 57078, 57218);
INSERT INTO `driver_entries` VALUES(1180, 57079, 57219);
INSERT INTO `driver_entries` VALUES(1144, 57080, 57220);
INSERT INTO `driver_entries` VALUES(1165, 57081, 57221);
+INSERT INTO `driver_entries` VALUES(1140, 57082, 57222);
+INSERT INTO `driver_entries` VALUES(1172, 57083, 57223);
+INSERT INTO `driver_entries` VALUES(1161, 57084, 57224);
+INSERT INTO `driver_entries` VALUES(1182, 57085, 57225);
+INSERT INTO `driver_entries` VALUES(1141, 57086, 57226);
+INSERT INTO `driver_entries` VALUES(1144, 57087, 57227);
+INSERT INTO `driver_entries` VALUES(1170, 57088, 57228);
+INSERT INTO `driver_entries` VALUES(1155, 57089, 57229);
+INSERT INTO `driver_entries` VALUES(1148, 57090, 57230);
+INSERT INTO `driver_entries` VALUES(1184, 57091, 57231);
+INSERT INTO `driver_entries` VALUES(1180, 57092, 57232);
+INSERT INTO `driver_entries` VALUES(1165, 57093, 57233);
+INSERT INTO `driver_entries` VALUES(1157, 57094, 57234);
+INSERT INTO `driver_entries` VALUES(1166, 57095, 57235);
+INSERT INTO `driver_entries` VALUES(1181, 57096, 57236);
+INSERT INTO `driver_entries` VALUES(1186, 57097, 57237);
+INSERT INTO `driver_entries` VALUES(1187, 57098, 57238);
+INSERT INTO `driver_entries` VALUES(1188, 57099, 57239);
+INSERT INTO `driver_entries` VALUES(1136, 57100, 57240);
+INSERT INTO `driver_entries` VALUES(1135, 57101, 57241);
+INSERT INTO `driver_entries` VALUES(1172, 57102, 57242);
+INSERT INTO `driver_entries` VALUES(1135, 57103, 57243);
+INSERT INTO `driver_entries` VALUES(1166, 57104, 57244);
+INSERT INTO `driver_entries` VALUES(1181, 57105, 57245);
+INSERT INTO `driver_entries` VALUES(1170, 57106, 57246);
+INSERT INTO `driver_entries` VALUES(1187, 57107, 57247);
+INSERT INTO `driver_entries` VALUES(1144, 57108, 57248);
+INSERT INTO `driver_entries` VALUES(1165, 57109, 57249);
+INSERT INTO `driver_entries` VALUES(1140, 57110, 57250);
+INSERT INTO `driver_entries` VALUES(1136, 57111, 57251);
+INSERT INTO `driver_entries` VALUES(1188, 57112, 57252);
+INSERT INTO `driver_entries` VALUES(1141, 57113, 57253);
+INSERT INTO `driver_entries` VALUES(1180, 57114, 57254);
+INSERT INTO `driver_entries` VALUES(1182, 57115, 57255);
+INSERT INTO `driver_entries` VALUES(1161, 57116, 57256);
+INSERT INTO `driver_entries` VALUES(1148, 57117, 57257);
+INSERT INTO `driver_entries` VALUES(1184, 57118, 57258);
+INSERT INTO `driver_entries` VALUES(1186, 57119, 57259);
+INSERT INTO `driver_entries` VALUES(1157, 57120, 57260);
+INSERT INTO `driver_entries` VALUES(1155, 57121, 57261);
+INSERT INTO `driver_entries` VALUES(1172, 57122, 57262);
+INSERT INTO `driver_entries` VALUES(1161, 57123, 57263);
+INSERT INTO `driver_entries` VALUES(1140, 57124, 57264);
+INSERT INTO `driver_entries` VALUES(1184, 57125, 57265);
+INSERT INTO `driver_entries` VALUES(1135, 57126, 57266);
+INSERT INTO `driver_entries` VALUES(1182, 57127, 57267);
+INSERT INTO `driver_entries` VALUES(1186, 57128, 57268);
+INSERT INTO `driver_entries` VALUES(1170, 57129, 57269);
+INSERT INTO `driver_entries` VALUES(1144, 57130, 57270);
+INSERT INTO `driver_entries` VALUES(1141, 57131, 57271);
+INSERT INTO `driver_entries` VALUES(1148, 57132, 57272);
+INSERT INTO `driver_entries` VALUES(1187, 57133, 57273);
+INSERT INTO `driver_entries` VALUES(1166, 57134, 57274);
+INSERT INTO `driver_entries` VALUES(1180, 57135, 57275);
+INSERT INTO `driver_entries` VALUES(1165, 57136, 57276);
+INSERT INTO `driver_entries` VALUES(1188, 57137, 57277);
+INSERT INTO `driver_entries` VALUES(1155, 57138, 57278);
+INSERT INTO `driver_entries` VALUES(1157, 57139, 57279);
+INSERT INTO `driver_entries` VALUES(1181, 57140, 57280);
+INSERT INTO `driver_entries` VALUES(1136, 57141, 57281);
+INSERT INTO `driver_entries` VALUES(1140, 57142, 57282);
+INSERT INTO `driver_entries` VALUES(1172, 57143, 57283);
+INSERT INTO `driver_entries` VALUES(1135, 57144, 57284);
+INSERT INTO `driver_entries` VALUES(1184, 57145, 57285);
+INSERT INTO `driver_entries` VALUES(1170, 57146, 57286);
+INSERT INTO `driver_entries` VALUES(1182, 57147, 57287);
+INSERT INTO `driver_entries` VALUES(1141, 57148, 57288);
+INSERT INTO `driver_entries` VALUES(1161, 57149, 57289);
+INSERT INTO `driver_entries` VALUES(1186, 57150, 57290);
+INSERT INTO `driver_entries` VALUES(1187, 57151, 57291);
+INSERT INTO `driver_entries` VALUES(1155, 57152, 57292);
+INSERT INTO `driver_entries` VALUES(1148, 57153, 57293);
+INSERT INTO `driver_entries` VALUES(1165, 57154, 57294);
+INSERT INTO `driver_entries` VALUES(1157, 57155, 57295);
+INSERT INTO `driver_entries` VALUES(1166, 57156, 57296);
+INSERT INTO `driver_entries` VALUES(1188, 57157, 57297);
+INSERT INTO `driver_entries` VALUES(1181, 57158, 57298);
+INSERT INTO `driver_entries` VALUES(1180, 57159, 57299);
+INSERT INTO `driver_entries` VALUES(1136, 57160, 57300);
+INSERT INTO `driver_entries` VALUES(1144, 57161, 57301);