summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2021-11-02 21:33:18 +0100
committeremkael <emkael@tlen.pl>2021-11-02 21:33:18 +0100
commitab8005dc6b485c68f0fb44c0f7b21768210cdaa5 (patch)
tree545f467a2e9d4d1d234df65b7396da72bbe9d279
parentda29551098d6a2764342468cebf442019e43f03b (diff)
2021 United States GP
-rw-r--r--rate.log54
-rw-r--r--sql/results.sql82
2 files changed, 136 insertions, 0 deletions
diff --git a/rate.log b/rate.log
index d29e08d..3cabe8b 100644
--- a/rate.log
+++ b/rate.log
@@ -78071,3 +78071,57 @@ Podium rating: 6930.5 7157.03
Average rating: 2173.734
Average rating change: 53.0345
+2021 United States Grand Prix - qualifying (2021-10-23)
+
+#33 (<Max Verstappen (#1172)>) 1[1] 2381.73 2388.14
+#44 (<Lewis Hamilton (#1140)>) 2[2] 2395.37 2399.71
+#11 (<Sergio Pérez (#1155)>) 3[3] 2343.41 2348.06
+#77 (<Valtteri Bottas (#1161)>) 4[4] 2431.89 2431.85
+#16 (<Charles Leclerc (#1184)>) 5[5] 2271.4 2275.9
+#55 (<Carlos Sainz (#1170)>) 6[6] 2309.38 2310.62
+#3 (<Daniel Ricciardo (#1157)>) 7[7] 2215.79 2219.65
+#4 (<Lando Norris (#1186)>) 8[8] 2276.73 2276.19
+#10 (<Pierre Gasly (#1182)>) 9[9] 2221.96 2222.33
+#22 (<Yuki Tsunoda (#1192)>) 10[10] 2066.79 2072.86
+#31 (<Esteban Ocon (#1179)>) 11[11] 2103.98 2106.76
+#5 (<Sebastian Vettel (#1135)>) 12[12] 2064.08 2067.07
+#99 (<Antonio Giovinazzi (#1180)>) 13[13] 2039.65 2042.11
+#14 (<Fernando Alonso (#1127)>) 14[14] 2150.15 2145.95
+#63 (<George Russell (#1188)>) 15[15] 2134.73 2129.66
+#18 (<Lance Stroll (#1181)>) 16[16] 2210.94 2200.63
+#6 (<Nicholas Latifi (#1189)>) 17[17] 2021.86 2018.67
+#7 (<Kimi Räikkönen (#1141)>) 18[18] 2092.15 2084.27
+#47 (<Mick Schumacher (#1193)>) 19[19] 1894.0 1890.16
+#9 (<Nikita Mazepin (#1194)>) 20[20] 1848.7 1844.11
+
+Podium rating: 7120.51 7135.91
+Average rating: 2173.7345
+Average rating change: 3.9665
+
+2021 United States Grand Prix (2021-10-24)
+
+#33 (<Max Verstappen (#1172)>) 1[1] 2388.14 2443.04
+#44 (<Lewis Hamilton (#1140)>) 2[2] 2399.71 2427.17
+#11 (<Sergio Pérez (#1155)>) 3[2] 2348.06 2391.67
+#16 (<Charles Leclerc (#1184)>) 4[3] 2275.9 2312.89
+#3 (<Daniel Ricciardo (#1157)>) 5[3] 2219.65 2277.88
+#77 (<Valtteri Bottas (#1161)>) 6[4] 2431.85 2386.34
+#55 (<Carlos Sainz (#1170)>) 7[4] 2310.62 2303.06
+#4 (<Lando Norris (#1186)>) 8[5] 2276.19 2257.07
+#22 (<Yuki Tsunoda (#1192)>) 9[6] 2072.86 2067.19
+#5 (<Sebastian Vettel (#1135)>) 10[6] 2067.07 2063.52
+#99 (<Antonio Giovinazzi (#1180)>) 11[6] 2042.11 2047.52
+#18 (<Lance Stroll (#1181)>) 12[6] 2200.63 2146.2
+#7 (<Kimi Räikkönen (#1141)>) 13[6] 2084.27 2074.39
+#63 (<George Russell (#1188)>) 14[6] 2129.66 2102.64
+#6 (<Nicholas Latifi (#1189)>) 15[6] 2018.67 2032.23
+#47 (<Mick Schumacher (#1193)>) 16[7] 1890.16 1849.36
+#9 (<Nikita Mazepin (#1194)>) 17[7] 1844.11 1817.51
+#14 (<Fernando Alonso (#1127)>) R[0] 2145.95 2145.95
+#31 (<Esteban Ocon (#1179)>) R[0] 2106.76 2106.76
+#10 (<Pierre Gasly (#1182)>) R[0] 2222.33 2222.33
+
+Podium rating: 7135.91 7261.88
+Average rating: 2173.735
+Average rating change: 28.2529411765
+
diff --git a/sql/results.sql b/sql/results.sql
index 676c09f..cbbf335 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2751,6 +2751,8 @@ INSERT INTO `races` VALUES(2745, '2021 Russian Grand Prix - qualifying', '2021-0
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 `races` VALUES(2749, '2021 United States Grand Prix - qualifying', '2021-10-23', 0, 3);
+INSERT INTO `races` VALUES(2750, '2021 United States Grand Prix', '2021-10-24', 0, 4);
INSERT INTO `countries` VALUES(9, 'Argentina');
INSERT INTO `countries` VALUES(18, 'Australia');
@@ -62827,6 +62829,46 @@ 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 `entries` VALUES(58842, '1', 33, 1, 2749);
+INSERT INTO `entries` VALUES(58843, '2', 44, 2, 2749);
+INSERT INTO `entries` VALUES(58844, '3', 11, 3, 2749);
+INSERT INTO `entries` VALUES(58845, '4', 77, 4, 2749);
+INSERT INTO `entries` VALUES(58846, '5', 16, 5, 2749);
+INSERT INTO `entries` VALUES(58847, '6', 55, 6, 2749);
+INSERT INTO `entries` VALUES(58848, '7', 3, 7, 2749);
+INSERT INTO `entries` VALUES(58849, '8', 4, 8, 2749);
+INSERT INTO `entries` VALUES(58850, '9', 10, 9, 2749);
+INSERT INTO `entries` VALUES(58851, '10', 22, 10, 2749);
+INSERT INTO `entries` VALUES(58852, '11', 31, 11, 2749);
+INSERT INTO `entries` VALUES(58853, '12', 5, 12, 2749);
+INSERT INTO `entries` VALUES(58854, '13', 99, 13, 2749);
+INSERT INTO `entries` VALUES(58855, '14', 14, 14, 2749);
+INSERT INTO `entries` VALUES(58856, '15', 63, 15, 2749);
+INSERT INTO `entries` VALUES(58857, '16', 18, 16, 2749);
+INSERT INTO `entries` VALUES(58858, '17', 6, 17, 2749);
+INSERT INTO `entries` VALUES(58859, '18', 7, 18, 2749);
+INSERT INTO `entries` VALUES(58860, '19', 47, 19, 2749);
+INSERT INTO `entries` VALUES(58861, '20', 9, 20, 2749);
+INSERT INTO `entries` VALUES(58862, '1', 33, 1, 2750);
+INSERT INTO `entries` VALUES(58863, '2', 44, 2, 2750);
+INSERT INTO `entries` VALUES(58864, '3', 11, 2, 2750);
+INSERT INTO `entries` VALUES(58865, '4', 16, 3, 2750);
+INSERT INTO `entries` VALUES(58866, '5', 3, 3, 2750);
+INSERT INTO `entries` VALUES(58867, '6', 77, 4, 2750);
+INSERT INTO `entries` VALUES(58868, '7', 55, 4, 2750);
+INSERT INTO `entries` VALUES(58869, '8', 4, 5, 2750);
+INSERT INTO `entries` VALUES(58870, '9', 22, 6, 2750);
+INSERT INTO `entries` VALUES(58871, '10', 5, 6, 2750);
+INSERT INTO `entries` VALUES(58872, '11', 99, 6, 2750);
+INSERT INTO `entries` VALUES(58873, '12', 18, 6, 2750);
+INSERT INTO `entries` VALUES(58874, '13', 7, 6, 2750);
+INSERT INTO `entries` VALUES(58875, '14', 63, 6, 2750);
+INSERT INTO `entries` VALUES(58876, '15', 6, 6, 2750);
+INSERT INTO `entries` VALUES(58877, '16', 47, 7, 2750);
+INSERT INTO `entries` VALUES(58878, '17', 9, 7, 2750);
+INSERT INTO `entries` VALUES(58879, 'R', 14, 0, 2750);
+INSERT INTO `entries` VALUES(58880, 'R', 31, 0, 2750);
+INSERT INTO `entries` VALUES(58881, 'R', 10, 0, 2750);
INSERT INTO `driver_entries` VALUES(1, 1, 1);
INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -121808,3 +121850,43 @@ 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);
+INSERT INTO `driver_entries` VALUES(1172, 58842, 58981);
+INSERT INTO `driver_entries` VALUES(1140, 58843, 58982);
+INSERT INTO `driver_entries` VALUES(1155, 58844, 58983);
+INSERT INTO `driver_entries` VALUES(1161, 58845, 58984);
+INSERT INTO `driver_entries` VALUES(1184, 58846, 58985);
+INSERT INTO `driver_entries` VALUES(1170, 58847, 58986);
+INSERT INTO `driver_entries` VALUES(1157, 58848, 58987);
+INSERT INTO `driver_entries` VALUES(1186, 58849, 58988);
+INSERT INTO `driver_entries` VALUES(1182, 58850, 58989);
+INSERT INTO `driver_entries` VALUES(1192, 58851, 58990);
+INSERT INTO `driver_entries` VALUES(1179, 58852, 58991);
+INSERT INTO `driver_entries` VALUES(1135, 58853, 58992);
+INSERT INTO `driver_entries` VALUES(1180, 58854, 58993);
+INSERT INTO `driver_entries` VALUES(1127, 58855, 58994);
+INSERT INTO `driver_entries` VALUES(1188, 58856, 58995);
+INSERT INTO `driver_entries` VALUES(1181, 58857, 58996);
+INSERT INTO `driver_entries` VALUES(1189, 58858, 58997);
+INSERT INTO `driver_entries` VALUES(1141, 58859, 58998);
+INSERT INTO `driver_entries` VALUES(1193, 58860, 58999);
+INSERT INTO `driver_entries` VALUES(1194, 58861, 59000);
+INSERT INTO `driver_entries` VALUES(1172, 58862, 59001);
+INSERT INTO `driver_entries` VALUES(1140, 58863, 59002);
+INSERT INTO `driver_entries` VALUES(1155, 58864, 59003);
+INSERT INTO `driver_entries` VALUES(1184, 58865, 59004);
+INSERT INTO `driver_entries` VALUES(1157, 58866, 59005);
+INSERT INTO `driver_entries` VALUES(1161, 58867, 59006);
+INSERT INTO `driver_entries` VALUES(1170, 58868, 59007);
+INSERT INTO `driver_entries` VALUES(1186, 58869, 59008);
+INSERT INTO `driver_entries` VALUES(1192, 58870, 59009);
+INSERT INTO `driver_entries` VALUES(1135, 58871, 59010);
+INSERT INTO `driver_entries` VALUES(1180, 58872, 59011);
+INSERT INTO `driver_entries` VALUES(1181, 58873, 59012);
+INSERT INTO `driver_entries` VALUES(1141, 58874, 59013);
+INSERT INTO `driver_entries` VALUES(1188, 58875, 59014);
+INSERT INTO `driver_entries` VALUES(1189, 58876, 59015);
+INSERT INTO `driver_entries` VALUES(1193, 58877, 59016);
+INSERT INTO `driver_entries` VALUES(1194, 58878, 59017);
+INSERT INTO `driver_entries` VALUES(1127, 58879, 59018);
+INSERT INTO `driver_entries` VALUES(1179, 58880, 59019);
+INSERT INTO `driver_entries` VALUES(1182, 58881, 59020);