summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2021-10-13 19:27:41 +0200
committeremkael <emkael@tlen.pl>2021-10-13 19:27:41 +0200
commitda29551098d6a2764342468cebf442019e43f03b (patch)
treedd63671b7cde796e9440f9bc3541a47d36cd7191
parent336e62d49034390ac384251ac7e817c7f3d4d05d (diff)
2021 Russian GP
2021 Turkish 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 3876a0f..d29e08d 100644
--- a/rate.log
+++ b/rate.log
@@ -77963,3 +77963,111 @@ Podium rating: 6732.04 6994.51
Average rating: 2170.351
Average rating change: 71.2752941176
+2021 Russian Grand Prix - qualifying (2021-09-25)
+
+#4 (<Lando Norris (#1186)>) 1[1] 2282.01 2292.08
+#55 (<Carlos Sainz (#1170)>) 2[2] 2256.32 2266.04
+#63 (<George Russell (#1188)>) 3[3] 2159.04 2172.19
+#44 (<Lewis Hamilton (#1140)>) 4[4] 2291.0 2295.84
+#3 (<Daniel Ricciardo (#1157)>) 5[5] 2369.22 2369.11
+#14 (<Fernando Alonso (#1127)>) 6[6] 2207.37 2213.19
+#77 (<Valtteri Bottas (#1161)>) 7[7] 2343.28 2341.0
+#18 (<Lance Stroll (#1181)>) 8[8] 2111.82 2119.41
+#11 (<Sergio Pérez (#1155)>) 9[9] 2238.45 2237.87
+#31 (<Esteban Ocon (#1179)>) 10[10] 2246.73 2244.13
+#5 (<Sebastian Vettel (#1135)>) 11[11] 2073.94 2078.62
+#10 (<Pierre Gasly (#1182)>) 12[12] 2269.79 2262.85
+#22 (<Yuki Tsunoda (#1192)>) 13[13] 2084.59 2085.55
+#6 (<Nicholas Latifi (#1189)>) 14[14] 2069.81 2069.89
+#16 (<Charles Leclerc (#1184)>) 15[15] 2277.64 2265.52
+#7 (<Kimi Räikkönen (#1141)>) 16[16] 2026.5 2025.4
+#47 (<Mick Schumacher (#1193)>) 17[17] 1978.8 1976.63
+#99 (<Antonio Giovinazzi (#1180)>) 18[18] 2024.51 2019.5
+#9 (<Nikita Mazepin (#1194)>) 19[19] 1947.26 1941.92
+#33 (<Max Verstappen (#1172)>) 20[20] 2216.61 2197.95
+
+Podium rating: 6697.37 6730.31
+Average rating: 2173.7345
+Average rating change: 5.691
+
+2021 Russian Grand Prix (2021-09-26)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2295.84 2388.13
+#33 (<Max Verstappen (#1172)>) 2[2] 2197.95 2313.42
+#55 (<Carlos Sainz (#1170)>) 3[2] 2266.04 2348.16
+#3 (<Daniel Ricciardo (#1157)>) 4[3] 2369.11 2375.0
+#77 (<Valtteri Bottas (#1161)>) 5[3] 2341.0 2357.86
+#14 (<Fernando Alonso (#1127)>) 6[4] 2213.19 2233.07
+#4 (<Lando Norris (#1186)>) 7[4] 2292.08 2274.08
+#7 (<Kimi Räikkönen (#1141)>) 8[4] 2025.4 2132.99
+#11 (<Sergio Pérez (#1155)>) 9[4] 2237.87 2245.58
+#63 (<George Russell (#1188)>) 10[4] 2172.19 2212.48
+#18 (<Lance Stroll (#1181)>) 11[5] 2119.41 2137.49
+#5 (<Sebastian Vettel (#1135)>) 12[6] 2078.62 2059.61
+#10 (<Pierre Gasly (#1182)>) 13[6] 2262.85 2154.48
+#31 (<Esteban Ocon (#1179)>) 14[6] 2244.13 2144.78
+#16 (<Charles Leclerc (#1184)>) 15[6] 2265.52 2155.88
+#99 (<Antonio Giovinazzi (#1180)>) 16[6] 2019.5 2025.43
+#22 (<Yuki Tsunoda (#1192)>) 17[6] 2085.55 2063.41
+#9 (<Nikita Mazepin (#1194)>) 18[7] 1941.92 1901.43
+#6 (<Nicholas Latifi (#1189)>) 19[8] 2069.89 1974.77
+#47 (<Mick Schumacher (#1193)>) R[0] 1976.63 1976.63
+
+Podium rating: 6759.83 7049.71
+Average rating: 2173.7345
+Average rating change: 53.9068421053
+
+2021 Turkish Grand Prix - qualifying (2021-10-09)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2388.13 2394.09
+#77 (<Valtteri Bottas (#1161)>) 2[2] 2357.86 2363.34
+#33 (<Max Verstappen (#1172)>) 3[3] 2313.42 2319.13
+#16 (<Charles Leclerc (#1184)>) 4[4] 2155.88 2167.63
+#10 (<Pierre Gasly (#1182)>) 5[5] 2154.48 2164.7
+#14 (<Fernando Alonso (#1127)>) 6[6] 2233.07 2237.73
+#11 (<Sergio Pérez (#1155)>) 7[7] 2245.58 2248.03
+#4 (<Lando Norris (#1186)>) 8[8] 2274.08 2273.57
+#18 (<Lance Stroll (#1181)>) 9[9] 2137.49 2142.18
+#22 (<Yuki Tsunoda (#1192)>) 10[10] 2063.41 2070.17
+#5 (<Sebastian Vettel (#1135)>) 11[11] 2059.61 2064.95
+#31 (<Esteban Ocon (#1179)>) 12[12] 2144.78 2144.3
+#63 (<George Russell (#1188)>) 13[13] 2212.48 2206.96
+#47 (<Mick Schumacher (#1193)>) 14[14] 1976.63 1981.32
+#55 (<Carlos Sainz (#1170)>) 15[15] 2348.16 2332.42
+#3 (<Daniel Ricciardo (#1157)>) 16[16] 2375.0 2356.63
+#6 (<Nicholas Latifi (#1189)>) 17[17] 1974.77 1972.36
+#99 (<Antonio Giovinazzi (#1180)>) 18[18] 2025.43 2019.56
+#7 (<Kimi Räikkönen (#1141)>) 19[19] 2132.99 2120.3
+#9 (<Nikita Mazepin (#1194)>) 20[20] 1901.43 1895.31
+
+Podium rating: 7059.41 7076.56
+Average rating: 2173.734
+Average rating change: 6.771
+
+2021 Turkish Grand Prix (2021-10-10)
+
+#77 (<Valtteri Bottas (#1161)>) 1[1] 2363.34 2431.89
+#33 (<Max Verstappen (#1172)>) 2[2] 2319.13 2381.73
+#11 (<Sergio Pérez (#1155)>) 3[2] 2248.03 2343.41
+#16 (<Charles Leclerc (#1184)>) 4[3] 2167.63 2271.4
+#44 (<Lewis Hamilton (#1140)>) 5[3] 2394.09 2395.37
+#10 (<Pierre Gasly (#1182)>) 6[4] 2164.7 2221.96
+#4 (<Lando Norris (#1186)>) 7[4] 2273.57 2276.73
+#55 (<Carlos Sainz (#1170)>) 8[4] 2332.42 2309.38
+#18 (<Lance Stroll (#1181)>) 9[4] 2142.18 2210.94
+#31 (<Esteban Ocon (#1179)>) 10[5] 2144.3 2103.98
+#99 (<Antonio Giovinazzi (#1180)>) 11[5] 2019.56 2039.65
+#7 (<Kimi Räikkönen (#1141)>) 12[5] 2120.3 2092.15
+#3 (<Daniel Ricciardo (#1157)>) 13[5] 2356.63 2215.79
+#22 (<Yuki Tsunoda (#1192)>) 14[5] 2070.17 2066.79
+#63 (<George Russell (#1188)>) 15[5] 2206.96 2134.73
+#14 (<Fernando Alonso (#1127)>) 16[5] 2237.73 2150.15
+#6 (<Nicholas Latifi (#1189)>) 17[5] 1972.36 2021.86
+#5 (<Sebastian Vettel (#1135)>) 18[5] 2064.95 2064.08
+#47 (<Mick Schumacher (#1193)>) 19[6] 1981.32 1894.0
+#9 (<Nikita Mazepin (#1194)>) 20[6] 1895.31 1848.7
+
+Podium rating: 6930.5 7157.03
+Average rating: 2173.734
+Average rating change: 53.0345
+
diff --git a/sql/results.sql b/sql/results.sql
index 3081574..676c09f 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2747,6 +2747,10 @@ INSERT INTO `races` VALUES(2741, '2021 Dutch Grand Prix - qualifying', '2021-09-
INSERT INTO `races` VALUES(2742, '2021 Dutch Grand Prix', '2021-09-05', 0, 4);
INSERT INTO `races` VALUES(2743, '2021 Italian Grand Prix - qualifying', '2021-09-11', 0, 3);
INSERT INTO `races` VALUES(2744, '2021 Italian Grand Prix', '2021-09-12', 0, 4);
+INSERT INTO `races` VALUES(2745, '2021 Russian Grand Prix - qualifying', '2021-09-25', 0, 3);
+INSERT INTO `races` VALUES(2746, '2021 Russian Grand Prix', '2021-09-26', 0, 4);
+INSERT INTO `races` VALUES(2747, '2021 Turkish Grand Prix - qualifying', '2021-10-09', 0, 3);
+INSERT INTO `races` VALUES(2748, '2021 Turkish Grand Prix', '2021-10-10', 0, 4);
INSERT INTO `countries` VALUES(9, 'Argentina');
INSERT INTO `countries` VALUES(18, 'Australia');
@@ -62743,6 +62747,86 @@ INSERT INTO `entries` VALUES(58758, 'R', 44, 6, 2744);
INSERT INTO `entries` VALUES(58759, 'R', 33, 6, 2744);
INSERT INTO `entries` VALUES(58760, 'R', 10, 0, 2744);
INSERT INTO `entries` VALUES(58761, 'W', 22, 0, 2744);
+INSERT INTO `entries` VALUES(58762, '1', 4, 1, 2745);
+INSERT INTO `entries` VALUES(58763, '2', 55, 2, 2745);
+INSERT INTO `entries` VALUES(58764, '3', 63, 3, 2745);
+INSERT INTO `entries` VALUES(58765, '4', 44, 4, 2745);
+INSERT INTO `entries` VALUES(58766, '5', 3, 5, 2745);
+INSERT INTO `entries` VALUES(58767, '6', 14, 6, 2745);
+INSERT INTO `entries` VALUES(58768, '7', 77, 7, 2745);
+INSERT INTO `entries` VALUES(58769, '8', 18, 8, 2745);
+INSERT INTO `entries` VALUES(58770, '9', 11, 9, 2745);
+INSERT INTO `entries` VALUES(58771, '10', 31, 10, 2745);
+INSERT INTO `entries` VALUES(58772, '11', 5, 11, 2745);
+INSERT INTO `entries` VALUES(58773, '12', 10, 12, 2745);
+INSERT INTO `entries` VALUES(58774, '13', 22, 13, 2745);
+INSERT INTO `entries` VALUES(58775, '14', 6, 14, 2745);
+INSERT INTO `entries` VALUES(58776, '15', 16, 15, 2745);
+INSERT INTO `entries` VALUES(58777, '16', 7, 16, 2745);
+INSERT INTO `entries` VALUES(58778, '17', 47, 17, 2745);
+INSERT INTO `entries` VALUES(58779, '18', 99, 18, 2745);
+INSERT INTO `entries` VALUES(58780, '19', 9, 19, 2745);
+INSERT INTO `entries` VALUES(58781, '20', 33, 20, 2745);
+INSERT INTO `entries` VALUES(58782, '1', 44, 1, 2746);
+INSERT INTO `entries` VALUES(58783, '2', 33, 2, 2746);
+INSERT INTO `entries` VALUES(58784, '3', 55, 2, 2746);
+INSERT INTO `entries` VALUES(58785, '4', 3, 3, 2746);
+INSERT INTO `entries` VALUES(58786, '5', 77, 3, 2746);
+INSERT INTO `entries` VALUES(58787, '6', 14, 4, 2746);
+INSERT INTO `entries` VALUES(58788, '7', 4, 4, 2746);
+INSERT INTO `entries` VALUES(58789, '8', 7, 4, 2746);
+INSERT INTO `entries` VALUES(58790, '9', 11, 4, 2746);
+INSERT INTO `entries` VALUES(58791, '10', 63, 4, 2746);
+INSERT INTO `entries` VALUES(58792, '11', 18, 5, 2746);
+INSERT INTO `entries` VALUES(58793, '12', 5, 6, 2746);
+INSERT INTO `entries` VALUES(58794, '13', 10, 6, 2746);
+INSERT INTO `entries` VALUES(58795, '14', 31, 6, 2746);
+INSERT INTO `entries` VALUES(58796, '15', 16, 6, 2746);
+INSERT INTO `entries` VALUES(58797, '16', 99, 6, 2746);
+INSERT INTO `entries` VALUES(58798, '17', 22, 6, 2746);
+INSERT INTO `entries` VALUES(58799, '18', 9, 7, 2746);
+INSERT INTO `entries` VALUES(58800, '19', 6, 8, 2746);
+INSERT INTO `entries` VALUES(58801, 'R', 47, 0, 2746);
+INSERT INTO `entries` VALUES(58802, '1', 44, 1, 2747);
+INSERT INTO `entries` VALUES(58803, '2', 77, 2, 2747);
+INSERT INTO `entries` VALUES(58804, '3', 33, 3, 2747);
+INSERT INTO `entries` VALUES(58805, '4', 16, 4, 2747);
+INSERT INTO `entries` VALUES(58806, '5', 10, 5, 2747);
+INSERT INTO `entries` VALUES(58807, '6', 14, 6, 2747);
+INSERT INTO `entries` VALUES(58808, '7', 11, 7, 2747);
+INSERT INTO `entries` VALUES(58809, '8', 4, 8, 2747);
+INSERT INTO `entries` VALUES(58810, '9', 18, 9, 2747);
+INSERT INTO `entries` VALUES(58811, '10', 22, 10, 2747);
+INSERT INTO `entries` VALUES(58812, '11', 5, 11, 2747);
+INSERT INTO `entries` VALUES(58813, '12', 31, 12, 2747);
+INSERT INTO `entries` VALUES(58814, '13', 63, 13, 2747);
+INSERT INTO `entries` VALUES(58815, '14', 47, 14, 2747);
+INSERT INTO `entries` VALUES(58816, '15', 55, 15, 2747);
+INSERT INTO `entries` VALUES(58817, '16', 3, 16, 2747);
+INSERT INTO `entries` VALUES(58818, '17', 6, 17, 2747);
+INSERT INTO `entries` VALUES(58819, '18', 99, 18, 2747);
+INSERT INTO `entries` VALUES(58820, '19', 7, 19, 2747);
+INSERT INTO `entries` VALUES(58821, '20', 9, 20, 2747);
+INSERT INTO `entries` VALUES(58822, '1', 77, 1, 2748);
+INSERT INTO `entries` VALUES(58823, '2', 33, 2, 2748);
+INSERT INTO `entries` VALUES(58824, '3', 11, 2, 2748);
+INSERT INTO `entries` VALUES(58825, '4', 16, 3, 2748);
+INSERT INTO `entries` VALUES(58826, '5', 44, 3, 2748);
+INSERT INTO `entries` VALUES(58827, '6', 10, 4, 2748);
+INSERT INTO `entries` VALUES(58828, '7', 4, 4, 2748);
+INSERT INTO `entries` VALUES(58829, '8', 55, 4, 2748);
+INSERT INTO `entries` VALUES(58830, '9', 18, 4, 2748);
+INSERT INTO `entries` VALUES(58831, '10', 31, 5, 2748);
+INSERT INTO `entries` VALUES(58832, '11', 99, 5, 2748);
+INSERT INTO `entries` VALUES(58833, '12', 7, 5, 2748);
+INSERT INTO `entries` VALUES(58834, '13', 3, 5, 2748);
+INSERT INTO `entries` VALUES(58835, '14', 22, 5, 2748);
+INSERT INTO `entries` VALUES(58836, '15', 63, 5, 2748);
+INSERT INTO `entries` VALUES(58837, '16', 14, 5, 2748);
+INSERT INTO `entries` VALUES(58838, '17', 6, 5, 2748);
+INSERT INTO `entries` VALUES(58839, '18', 5, 5, 2748);
+INSERT INTO `entries` VALUES(58840, '19', 47, 6, 2748);
+INSERT INTO `entries` VALUES(58841, '20', 9, 6, 2748);
INSERT INTO `driver_entries` VALUES(1, 1, 1);
INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -121644,3 +121728,83 @@ INSERT INTO `driver_entries` VALUES(1140, 58758, 58897);
INSERT INTO `driver_entries` VALUES(1172, 58759, 58898);
INSERT INTO `driver_entries` VALUES(1182, 58760, 58899);
INSERT INTO `driver_entries` VALUES(1192, 58761, 58900);
+INSERT INTO `driver_entries` VALUES(1186, 58762, 58901);
+INSERT INTO `driver_entries` VALUES(1170, 58763, 58902);
+INSERT INTO `driver_entries` VALUES(1188, 58764, 58903);
+INSERT INTO `driver_entries` VALUES(1140, 58765, 58904);
+INSERT INTO `driver_entries` VALUES(1157, 58766, 58905);
+INSERT INTO `driver_entries` VALUES(1127, 58767, 58906);
+INSERT INTO `driver_entries` VALUES(1161, 58768, 58907);
+INSERT INTO `driver_entries` VALUES(1181, 58769, 58908);
+INSERT INTO `driver_entries` VALUES(1155, 58770, 58909);
+INSERT INTO `driver_entries` VALUES(1179, 58771, 58910);
+INSERT INTO `driver_entries` VALUES(1135, 58772, 58911);
+INSERT INTO `driver_entries` VALUES(1182, 58773, 58912);
+INSERT INTO `driver_entries` VALUES(1192, 58774, 58913);
+INSERT INTO `driver_entries` VALUES(1189, 58775, 58914);
+INSERT INTO `driver_entries` VALUES(1184, 58776, 58915);
+INSERT INTO `driver_entries` VALUES(1141, 58777, 58916);
+INSERT INTO `driver_entries` VALUES(1193, 58778, 58917);
+INSERT INTO `driver_entries` VALUES(1180, 58779, 58918);
+INSERT INTO `driver_entries` VALUES(1194, 58780, 58919);
+INSERT INTO `driver_entries` VALUES(1172, 58781, 58920);
+INSERT INTO `driver_entries` VALUES(1140, 58782, 58921);
+INSERT INTO `driver_entries` VALUES(1172, 58783, 58922);
+INSERT INTO `driver_entries` VALUES(1170, 58784, 58923);
+INSERT INTO `driver_entries` VALUES(1157, 58785, 58924);
+INSERT INTO `driver_entries` VALUES(1161, 58786, 58925);
+INSERT INTO `driver_entries` VALUES(1127, 58787, 58926);
+INSERT INTO `driver_entries` VALUES(1186, 58788, 58927);
+INSERT INTO `driver_entries` VALUES(1141, 58789, 58928);
+INSERT INTO `driver_entries` VALUES(1155, 58790, 58929);
+INSERT INTO `driver_entries` VALUES(1188, 58791, 58930);
+INSERT INTO `driver_entries` VALUES(1181, 58792, 58931);
+INSERT INTO `driver_entries` VALUES(1135, 58793, 58932);
+INSERT INTO `driver_entries` VALUES(1182, 58794, 58933);
+INSERT INTO `driver_entries` VALUES(1179, 58795, 58934);
+INSERT INTO `driver_entries` VALUES(1184, 58796, 58935);
+INSERT INTO `driver_entries` VALUES(1180, 58797, 58936);
+INSERT INTO `driver_entries` VALUES(1192, 58798, 58937);
+INSERT INTO `driver_entries` VALUES(1194, 58799, 58938);
+INSERT INTO `driver_entries` VALUES(1189, 58800, 58939);
+INSERT INTO `driver_entries` VALUES(1193, 58801, 58940);
+INSERT INTO `driver_entries` VALUES(1140, 58802, 58941);
+INSERT INTO `driver_entries` VALUES(1161, 58803, 58942);
+INSERT INTO `driver_entries` VALUES(1172, 58804, 58943);
+INSERT INTO `driver_entries` VALUES(1184, 58805, 58944);
+INSERT INTO `driver_entries` VALUES(1182, 58806, 58945);
+INSERT INTO `driver_entries` VALUES(1127, 58807, 58946);
+INSERT INTO `driver_entries` VALUES(1155, 58808, 58947);
+INSERT INTO `driver_entries` VALUES(1186, 58809, 58948);
+INSERT INTO `driver_entries` VALUES(1181, 58810, 58949);
+INSERT INTO `driver_entries` VALUES(1192, 58811, 58950);
+INSERT INTO `driver_entries` VALUES(1135, 58812, 58951);
+INSERT INTO `driver_entries` VALUES(1179, 58813, 58952);
+INSERT INTO `driver_entries` VALUES(1188, 58814, 58953);
+INSERT INTO `driver_entries` VALUES(1193, 58815, 58954);
+INSERT INTO `driver_entries` VALUES(1170, 58816, 58955);
+INSERT INTO `driver_entries` VALUES(1157, 58817, 58956);
+INSERT INTO `driver_entries` VALUES(1189, 58818, 58957);
+INSERT INTO `driver_entries` VALUES(1180, 58819, 58958);
+INSERT INTO `driver_entries` VALUES(1141, 58820, 58959);
+INSERT INTO `driver_entries` VALUES(1194, 58821, 58960);
+INSERT INTO `driver_entries` VALUES(1161, 58822, 58961);
+INSERT INTO `driver_entries` VALUES(1172, 58823, 58962);
+INSERT INTO `driver_entries` VALUES(1155, 58824, 58963);
+INSERT INTO `driver_entries` VALUES(1184, 58825, 58964);
+INSERT INTO `driver_entries` VALUES(1140, 58826, 58965);
+INSERT INTO `driver_entries` VALUES(1182, 58827, 58966);
+INSERT INTO `driver_entries` VALUES(1186, 58828, 58967);
+INSERT INTO `driver_entries` VALUES(1170, 58829, 58968);
+INSERT INTO `driver_entries` VALUES(1181, 58830, 58969);
+INSERT INTO `driver_entries` VALUES(1179, 58831, 58970);
+INSERT INTO `driver_entries` VALUES(1180, 58832, 58971);
+INSERT INTO `driver_entries` VALUES(1141, 58833, 58972);
+INSERT INTO `driver_entries` VALUES(1157, 58834, 58973);
+INSERT INTO `driver_entries` VALUES(1192, 58835, 58974);
+INSERT INTO `driver_entries` VALUES(1188, 58836, 58975);
+INSERT INTO `driver_entries` VALUES(1127, 58837, 58976);
+INSERT INTO `driver_entries` VALUES(1189, 58838, 58977);
+INSERT INTO `driver_entries` VALUES(1135, 58839, 58978);
+INSERT INTO `driver_entries` VALUES(1193, 58840, 58979);
+INSERT INTO `driver_entries` VALUES(1194, 58841, 58980);