summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2018-09-11 00:53:18 +0200
committeremkael <emkael@tlen.pl>2018-09-11 00:53:18 +0200
commit55e179240486db891a6517c248fdec3fa7e2f33e (patch)
tree08abdafef6e682d8dd826c8c1dbc6bca9a482b5e
parentfaf8e641b5de598a356e26ef79cbdbb69687c621 (diff)
2018 Belgian GP
2018 Italian 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 fe60691..2e2c152 100644
--- a/rate.log
+++ b/rate.log
@@ -74674,3 +74674,111 @@ Podium rating: 7477.73 7555.28
Average rating: 2181.164
Average rating change: 35.7135294118
+2018 Belgian Grand Prix - qualifying (2018-08-25)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2628.24 2630.23
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2388.24 2394.02
+#31 (<Esteban Ocon (#1179)>) 3[3] 2093.46 2108.77
+#11 (<Sergio Pérez (#1155)>) 4[4] 2109.97 2122.94
+#8 (<Romain Grosjean (#1144)>) 5[5] 2073.67 2086.67
+#7 (<Kimi Räikkönen (#1141)>) 6[6] 2538.8 2534.41
+#33 (<Max Verstappen (#1172)>) 7[7] 2430.05 2426.66
+#3 (<Daniel Ricciardo (#1157)>) 8[8] 2397.07 2392.99
+#20 (<Kevin Magnussen (#1165)>) 9[9] 2134.55 2138.43
+#77 (<Valtteri Bottas (#1161)>) 10[10] 2473.34 2464.04
+#10 (<Pierre Gasly (#1182)>) 11[11] 2149.01 2149.06
+#28 (<Brendon Hartley (#1183)>) 12[12] 2042.02 2045.24
+#16 (<Charles Leclerc (#1184)>) 13[13] 2022.44 2024.92
+#9 (<Marcus Ericsson (#1167)>) 14[14] 1959.06 1962.96
+#27 (<Nico Hülkenberg (#1148)>) 15[15] 2192.03 2183.06
+#55 (<Carlos Sainz (#1170)>) 16[16] 2085.25 2079.33
+#14 (<Fernando Alonso (#1127)>) 17[17] 2145.07 2134.89
+#35 (<Sergey Sirotkin (#1185)>) 18[18] 1885.45 1883.33
+#18 (<Lance Stroll (#1181)>) 19[19] 1868.92 1865.09
+#2 (<Stoffel Vandoorne (#1178)>) 20[20] 2006.63 1996.2
+
+Podium rating: 7109.94 7133.02
+Average rating: 2181.1635
+Average rating change: 6.2595
+
+2018 Belgian Grand Prix (2018-08-26)
+
+#5 (<Sebastian Vettel (#1135)>) 1[1] 2394.02 2446.34
+#44 (<Lewis Hamilton (#1140)>) 2[2] 2630.23 2618.22
+#33 (<Max Verstappen (#1172)>) 3[2] 2426.66 2447.53
+#77 (<Valtteri Bottas (#1161)>) 4[3] 2464.04 2445.19
+#11 (<Sergio Pérez (#1155)>) 5[3] 2122.94 2211.96
+#31 (<Esteban Ocon (#1179)>) 6[4] 2108.77 2156.06
+#8 (<Romain Grosjean (#1144)>) 7[4] 2086.67 2143.85
+#20 (<Kevin Magnussen (#1165)>) 8[4] 2138.43 2172.7
+#10 (<Pierre Gasly (#1182)>) 9[4] 2149.06 2178.76
+#9 (<Marcus Ericsson (#1167)>) 10[5] 1962.96 1989.52
+#55 (<Carlos Sainz (#1170)>) 11[5] 2079.33 2043.82
+#35 (<Sergey Sirotkin (#1185)>) 12[5] 1883.33 1947.94
+#18 (<Lance Stroll (#1181)>) 13[5] 1865.09 1937.14
+#28 (<Brendon Hartley (#1183)>) 14[5] 2045.24 2025.1
+#2 (<Stoffel Vandoorne (#1178)>) 15[5] 1996.2 2004.53
+#3 (<Daniel Ricciardo (#1157)>) R[0] 2392.99 2392.99
+#7 (<Kimi Räikkönen (#1141)>) R[0] 2534.41 2534.41
+#16 (<Charles Leclerc (#1184)>) R[6] 2024.92 1925.87
+#14 (<Fernando Alonso (#1127)>) R[6] 2134.89 1986.69
+#27 (<Nico Hülkenberg (#1148)>) R[6] 2183.06 2014.62
+
+Podium rating: 7450.91 7512.09
+Average rating: 2181.162
+Average rating change: 55.8
+
+2018 Italian Grand Prix - qualifying (2018-09-01)
+
+#7 (<Kimi Räikkönen (#1141)>) 1[1] 2534.41 2538.24
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2446.34 2450.72
+#44 (<Lewis Hamilton (#1140)>) 3[3] 2618.22 2617.24
+#77 (<Valtteri Bottas (#1161)>) 4[4] 2445.19 2446.4
+#33 (<Max Verstappen (#1172)>) 5[5] 2447.53 2447.08
+#8 (<Romain Grosjean (#1144)>) 6[6] 2143.85 2152.49
+#55 (<Carlos Sainz (#1170)>) 7[7] 2043.82 2055.5
+#31 (<Esteban Ocon (#1179)>) 8[8] 2156.06 2160.96
+#10 (<Pierre Gasly (#1182)>) 9[9] 2178.76 2181.08
+#18 (<Lance Stroll (#1181)>) 10[10] 1937.14 1951.52
+#20 (<Kevin Magnussen (#1165)>) 11[11] 2172.7 2171.28
+#35 (<Sergey Sirotkin (#1185)>) 12[12] 1947.94 1956.95
+#14 (<Fernando Alonso (#1127)>) 13[13] 1986.69 1991.15
+#27 (<Nico Hülkenberg (#1148)>) 14[14] 2014.62 2014.08
+#3 (<Daniel Ricciardo (#1157)>) 15[15] 2392.99 2375.67
+#11 (<Sergio Pérez (#1155)>) 16[16] 2211.96 2199.31
+#16 (<Charles Leclerc (#1184)>) 17[17] 1925.87 1924.03
+#28 (<Brendon Hartley (#1183)>) 18[18] 2025.1 2016.86
+#9 (<Marcus Ericsson (#1167)>) 19[19] 1989.52 1979.42
+#2 (<Stoffel Vandoorne (#1178)>) 20[20] 2004.53 1993.26
+
+Podium rating: 7598.97 7606.2
+Average rating: 2181.162
+Average rating change: 6.481
+
+2018 Italian Grand Prix (2018-09-02)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2617.24 2636.91
+#7 (<Kimi Räikkönen (#1141)>) 2[2] 2538.24 2547.31
+#77 (<Valtteri Bottas (#1161)>) 3[2] 2446.4 2474.84
+#5 (<Sebastian Vettel (#1135)>) 4[3] 2450.72 2446.17
+#33 (<Max Verstappen (#1172)>) 5[3] 2447.08 2443.36
+#8 (<Romain Grosjean (#1144)>) 6[4] 2152.49 2189.79
+#31 (<Esteban Ocon (#1179)>) 7[4] 2160.96 2195.04
+#11 (<Sergio Pérez (#1155)>) 8[4] 2199.31 2219.25
+#55 (<Carlos Sainz (#1170)>) 9[4] 2055.5 2131.56
+#18 (<Lance Stroll (#1181)>) 10[5] 1951.52 1952.49
+#35 (<Sergey Sirotkin (#1185)>) 11[5] 1956.95 1955.48
+#16 (<Charles Leclerc (#1184)>) 12[5] 1924.03 1936.87
+#2 (<Stoffel Vandoorne (#1178)>) 13[5] 1993.26 1974.81
+#27 (<Nico Hülkenberg (#1148)>) 14[5] 2014.08 1991.0
+#10 (<Pierre Gasly (#1182)>) 15[5] 2181.08 2091.64
+#9 (<Marcus Ericsson (#1167)>) 16[5] 1979.42 1967.57
+#20 (<Kevin Magnussen (#1165)>) 17[5] 2171.28 2085.47
+#3 (<Daniel Ricciardo (#1157)>) R[0] 2375.67 2375.67
+#14 (<Fernando Alonso (#1127)>) R[0] 1991.15 1991.15
+#28 (<Brendon Hartley (#1183)>) R[0] 2016.86 2016.86
+
+Podium rating: 7601.88 7659.06
+Average rating: 2181.162
+Average rating change: 28.0435294118
+
diff --git a/sql/results.sql b/sql/results.sql
index 0e07d09..1b88098 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2625,6 +2625,10 @@ INSERT INTO `races` VALUES(2619, '2018 German Grand Prix - qualifying', '2018-07
INSERT INTO `races` VALUES(2620, '2018 German Grand Prix', '2018-07-22', 0, 4);
INSERT INTO `races` VALUES(2621, '2018 Hungarian Grand Prix - qualifying', '2018-07-28', 0, 3);
INSERT INTO `races` VALUES(2622, '2018 Hungarian Grand Prix', '2018-07-29', 0, 4);
+INSERT INTO `races` VALUES(2623, '2018 Belgian Grand Prix - qualifying', '2018-08-25', 0, 3);
+INSERT INTO `races` VALUES(2624, '2018 Belgian Grand Prix', '2018-08-26', 0, 4);
+INSERT INTO `races` VALUES(2625, '2018 Italian Grand Prix - qualifying', '2018-09-01', 0, 3);
+INSERT INTO `races` VALUES(2626, '2018 Italian Grand Prix', '2018-09-02', 0, 4);
INSERT INTO `countries` VALUES(9, 'Argentina');
INSERT INTO `countries` VALUES(18, 'Australia');
@@ -60175,6 +60179,86 @@ INSERT INTO `entries` VALUES(56320, '17', 18, 6, 2622);
INSERT INTO `entries` VALUES(56321, 'R', 2, 0, 2622);
INSERT INTO `entries` VALUES(56322, 'R', 33, 0, 2622);
INSERT INTO `entries` VALUES(56323, 'R', 16, 0, 2622);
+INSERT INTO `entries` VALUES(56324, '1', 44, 1, 2623);
+INSERT INTO `entries` VALUES(56325, '2', 5, 2, 2623);
+INSERT INTO `entries` VALUES(56326, '3', 31, 3, 2623);
+INSERT INTO `entries` VALUES(56327, '4', 11, 4, 2623);
+INSERT INTO `entries` VALUES(56328, '5', 8, 5, 2623);
+INSERT INTO `entries` VALUES(56329, '6', 7, 6, 2623);
+INSERT INTO `entries` VALUES(56330, '7', 33, 7, 2623);
+INSERT INTO `entries` VALUES(56331, '8', 3, 8, 2623);
+INSERT INTO `entries` VALUES(56332, '9', 20, 9, 2623);
+INSERT INTO `entries` VALUES(56333, '10', 77, 10, 2623);
+INSERT INTO `entries` VALUES(56334, '11', 10, 11, 2623);
+INSERT INTO `entries` VALUES(56335, '12', 28, 12, 2623);
+INSERT INTO `entries` VALUES(56336, '13', 16, 13, 2623);
+INSERT INTO `entries` VALUES(56337, '14', 9, 14, 2623);
+INSERT INTO `entries` VALUES(56338, '15', 27, 15, 2623);
+INSERT INTO `entries` VALUES(56339, '16', 55, 16, 2623);
+INSERT INTO `entries` VALUES(56340, '17', 14, 17, 2623);
+INSERT INTO `entries` VALUES(56341, '18', 35, 18, 2623);
+INSERT INTO `entries` VALUES(56342, '19', 18, 19, 2623);
+INSERT INTO `entries` VALUES(56343, '20', 2, 20, 2623);
+INSERT INTO `entries` VALUES(56344, '1', 5, 1, 2624);
+INSERT INTO `entries` VALUES(56345, '2', 44, 2, 2624);
+INSERT INTO `entries` VALUES(56346, '3', 33, 2, 2624);
+INSERT INTO `entries` VALUES(56347, '4', 77, 3, 2624);
+INSERT INTO `entries` VALUES(56348, '5', 11, 3, 2624);
+INSERT INTO `entries` VALUES(56349, '6', 31, 4, 2624);
+INSERT INTO `entries` VALUES(56350, '7', 8, 4, 2624);
+INSERT INTO `entries` VALUES(56351, '8', 20, 4, 2624);
+INSERT INTO `entries` VALUES(56352, '9', 10, 4, 2624);
+INSERT INTO `entries` VALUES(56353, '10', 9, 5, 2624);
+INSERT INTO `entries` VALUES(56354, '11', 55, 5, 2624);
+INSERT INTO `entries` VALUES(56355, '12', 35, 5, 2624);
+INSERT INTO `entries` VALUES(56356, '13', 18, 5, 2624);
+INSERT INTO `entries` VALUES(56357, '14', 28, 5, 2624);
+INSERT INTO `entries` VALUES(56358, '15', 2, 5, 2624);
+INSERT INTO `entries` VALUES(56359, 'R', 3, 0, 2624);
+INSERT INTO `entries` VALUES(56360, 'R', 7, 0, 2624);
+INSERT INTO `entries` VALUES(56361, 'R', 16, 6, 2624);
+INSERT INTO `entries` VALUES(56362, 'R', 14, 6, 2624);
+INSERT INTO `entries` VALUES(56363, 'R', 27, 6, 2624);
+INSERT INTO `entries` VALUES(56364, '1', 7, 1, 2625);
+INSERT INTO `entries` VALUES(56365, '2', 5, 2, 2625);
+INSERT INTO `entries` VALUES(56366, '3', 44, 3, 2625);
+INSERT INTO `entries` VALUES(56367, '4', 77, 4, 2625);
+INSERT INTO `entries` VALUES(56368, '5', 33, 5, 2625);
+INSERT INTO `entries` VALUES(56369, '6', 8, 6, 2625);
+INSERT INTO `entries` VALUES(56370, '7', 55, 7, 2625);
+INSERT INTO `entries` VALUES(56371, '8', 31, 8, 2625);
+INSERT INTO `entries` VALUES(56372, '9', 10, 9, 2625);
+INSERT INTO `entries` VALUES(56373, '10', 18, 10, 2625);
+INSERT INTO `entries` VALUES(56374, '11', 20, 11, 2625);
+INSERT INTO `entries` VALUES(56375, '12', 35, 12, 2625);
+INSERT INTO `entries` VALUES(56376, '13', 14, 13, 2625);
+INSERT INTO `entries` VALUES(56377, '14', 27, 14, 2625);
+INSERT INTO `entries` VALUES(56378, '15', 3, 15, 2625);
+INSERT INTO `entries` VALUES(56379, '16', 11, 16, 2625);
+INSERT INTO `entries` VALUES(56380, '17', 16, 17, 2625);
+INSERT INTO `entries` VALUES(56381, '18', 28, 18, 2625);
+INSERT INTO `entries` VALUES(56382, '19', 9, 19, 2625);
+INSERT INTO `entries` VALUES(56383, '20', 2, 20, 2625);
+INSERT INTO `entries` VALUES(56384, '1', 44, 1, 2626);
+INSERT INTO `entries` VALUES(56385, '2', 7, 2, 2626);
+INSERT INTO `entries` VALUES(56386, '3', 77, 2, 2626);
+INSERT INTO `entries` VALUES(56387, '4', 5, 3, 2626);
+INSERT INTO `entries` VALUES(56388, '5', 33, 3, 2626);
+INSERT INTO `entries` VALUES(56389, '6', 8, 4, 2626);
+INSERT INTO `entries` VALUES(56390, '7', 31, 4, 2626);
+INSERT INTO `entries` VALUES(56391, '8', 11, 4, 2626);
+INSERT INTO `entries` VALUES(56392, '9', 55, 4, 2626);
+INSERT INTO `entries` VALUES(56393, '10', 18, 5, 2626);
+INSERT INTO `entries` VALUES(56394, '11', 35, 5, 2626);
+INSERT INTO `entries` VALUES(56395, '12', 16, 5, 2626);
+INSERT INTO `entries` VALUES(56396, '13', 2, 5, 2626);
+INSERT INTO `entries` VALUES(56397, '14', 27, 5, 2626);
+INSERT INTO `entries` VALUES(56398, '15', 10, 5, 2626);
+INSERT INTO `entries` VALUES(56399, '16', 9, 5, 2626);
+INSERT INTO `entries` VALUES(56400, '17', 20, 5, 2626);
+INSERT INTO `entries` VALUES(56401, 'R', 3, 0, 2626);
+INSERT INTO `entries` VALUES(56402, 'R', 14, 0, 2626);
+INSERT INTO `entries` VALUES(56403, 'R', 28, 0, 2626);
INSERT INTO `driver_entries` VALUES(1, 1, 1);
INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -116639,3 +116723,83 @@ INSERT INTO `driver_entries` VALUES(1181, 56320, 56460);
INSERT INTO `driver_entries` VALUES(1178, 56321, 56461);
INSERT INTO `driver_entries` VALUES(1172, 56322, 56462);
INSERT INTO `driver_entries` VALUES(1184, 56323, 56463);
+INSERT INTO `driver_entries` VALUES(1140, 56324, 56464);
+INSERT INTO `driver_entries` VALUES(1135, 56325, 56465);
+INSERT INTO `driver_entries` VALUES(1179, 56326, 56466);
+INSERT INTO `driver_entries` VALUES(1155, 56327, 56467);
+INSERT INTO `driver_entries` VALUES(1144, 56328, 56468);
+INSERT INTO `driver_entries` VALUES(1141, 56329, 56469);
+INSERT INTO `driver_entries` VALUES(1172, 56330, 56470);
+INSERT INTO `driver_entries` VALUES(1157, 56331, 56471);
+INSERT INTO `driver_entries` VALUES(1165, 56332, 56472);
+INSERT INTO `driver_entries` VALUES(1161, 56333, 56473);
+INSERT INTO `driver_entries` VALUES(1182, 56334, 56474);
+INSERT INTO `driver_entries` VALUES(1183, 56335, 56475);
+INSERT INTO `driver_entries` VALUES(1184, 56336, 56476);
+INSERT INTO `driver_entries` VALUES(1167, 56337, 56477);
+INSERT INTO `driver_entries` VALUES(1148, 56338, 56478);
+INSERT INTO `driver_entries` VALUES(1170, 56339, 56479);
+INSERT INTO `driver_entries` VALUES(1127, 56340, 56480);
+INSERT INTO `driver_entries` VALUES(1185, 56341, 56481);
+INSERT INTO `driver_entries` VALUES(1181, 56342, 56482);
+INSERT INTO `driver_entries` VALUES(1178, 56343, 56483);
+INSERT INTO `driver_entries` VALUES(1135, 56344, 56484);
+INSERT INTO `driver_entries` VALUES(1140, 56345, 56485);
+INSERT INTO `driver_entries` VALUES(1172, 56346, 56486);
+INSERT INTO `driver_entries` VALUES(1161, 56347, 56487);
+INSERT INTO `driver_entries` VALUES(1155, 56348, 56488);
+INSERT INTO `driver_entries` VALUES(1179, 56349, 56489);
+INSERT INTO `driver_entries` VALUES(1144, 56350, 56490);
+INSERT INTO `driver_entries` VALUES(1165, 56351, 56491);
+INSERT INTO `driver_entries` VALUES(1182, 56352, 56492);
+INSERT INTO `driver_entries` VALUES(1167, 56353, 56493);
+INSERT INTO `driver_entries` VALUES(1170, 56354, 56494);
+INSERT INTO `driver_entries` VALUES(1185, 56355, 56495);
+INSERT INTO `driver_entries` VALUES(1181, 56356, 56496);
+INSERT INTO `driver_entries` VALUES(1183, 56357, 56497);
+INSERT INTO `driver_entries` VALUES(1178, 56358, 56498);
+INSERT INTO `driver_entries` VALUES(1157, 56359, 56499);
+INSERT INTO `driver_entries` VALUES(1141, 56360, 56500);
+INSERT INTO `driver_entries` VALUES(1184, 56361, 56501);
+INSERT INTO `driver_entries` VALUES(1127, 56362, 56502);
+INSERT INTO `driver_entries` VALUES(1148, 56363, 56503);
+INSERT INTO `driver_entries` VALUES(1141, 56364, 56504);
+INSERT INTO `driver_entries` VALUES(1135, 56365, 56505);
+INSERT INTO `driver_entries` VALUES(1140, 56366, 56506);
+INSERT INTO `driver_entries` VALUES(1161, 56367, 56507);
+INSERT INTO `driver_entries` VALUES(1172, 56368, 56508);
+INSERT INTO `driver_entries` VALUES(1144, 56369, 56509);
+INSERT INTO `driver_entries` VALUES(1170, 56370, 56510);
+INSERT INTO `driver_entries` VALUES(1179, 56371, 56511);
+INSERT INTO `driver_entries` VALUES(1182, 56372, 56512);
+INSERT INTO `driver_entries` VALUES(1181, 56373, 56513);
+INSERT INTO `driver_entries` VALUES(1165, 56374, 56514);
+INSERT INTO `driver_entries` VALUES(1185, 56375, 56515);
+INSERT INTO `driver_entries` VALUES(1127, 56376, 56516);
+INSERT INTO `driver_entries` VALUES(1148, 56377, 56517);
+INSERT INTO `driver_entries` VALUES(1157, 56378, 56518);
+INSERT INTO `driver_entries` VALUES(1155, 56379, 56519);
+INSERT INTO `driver_entries` VALUES(1184, 56380, 56520);
+INSERT INTO `driver_entries` VALUES(1183, 56381, 56521);
+INSERT INTO `driver_entries` VALUES(1167, 56382, 56522);
+INSERT INTO `driver_entries` VALUES(1178, 56383, 56523);
+INSERT INTO `driver_entries` VALUES(1140, 56384, 56524);
+INSERT INTO `driver_entries` VALUES(1141, 56385, 56525);
+INSERT INTO `driver_entries` VALUES(1161, 56386, 56526);
+INSERT INTO `driver_entries` VALUES(1135, 56387, 56527);
+INSERT INTO `driver_entries` VALUES(1172, 56388, 56528);
+INSERT INTO `driver_entries` VALUES(1144, 56389, 56529);
+INSERT INTO `driver_entries` VALUES(1179, 56390, 56530);
+INSERT INTO `driver_entries` VALUES(1155, 56391, 56531);
+INSERT INTO `driver_entries` VALUES(1170, 56392, 56532);
+INSERT INTO `driver_entries` VALUES(1181, 56393, 56533);
+INSERT INTO `driver_entries` VALUES(1185, 56394, 56534);
+INSERT INTO `driver_entries` VALUES(1184, 56395, 56535);
+INSERT INTO `driver_entries` VALUES(1178, 56396, 56536);
+INSERT INTO `driver_entries` VALUES(1148, 56397, 56537);
+INSERT INTO `driver_entries` VALUES(1182, 56398, 56538);
+INSERT INTO `driver_entries` VALUES(1167, 56399, 56539);
+INSERT INTO `driver_entries` VALUES(1165, 56400, 56540);
+INSERT INTO `driver_entries` VALUES(1157, 56401, 56541);
+INSERT INTO `driver_entries` VALUES(1127, 56402, 56542);
+INSERT INTO `driver_entries` VALUES(1183, 56403, 56543);