summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2016-10-24 13:27:22 +0200
committeremkael <emkael@tlen.pl>2016-10-24 13:27:22 +0200
commit5fca9624e4274b78f0b30ae1fe82bb99615780ec (patch)
tree4326e12b0e27cfb37e57bb3f289616fd5ebcb51e
parent9e5085fdbca7ff3f62af1b7acc4c8239115d0415 (diff)
* 2016 US GP
-rw-r--r--rate.log58
-rw-r--r--sql/results.sql90
2 files changed, 148 insertions, 0 deletions
diff --git a/rate.log b/rate.log
index 198d59a..c074880 100644
--- a/rate.log
+++ b/rate.log
@@ -72717,3 +72717,61 @@ Podium rating: 7612.19 7702.55
Average rating: 2197.23454545
Average rating change: 49.8945454545
+2016 United States Grand Prix - qualifying (2016-10-22)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2606.26 2609.31
+#6 (<Nico Rosberg (#1128)>) 2[2] 2645.92 2646.66
+#3 (<Daniel Ricciardo (#1157)>) 3[3] 2483.59 2486.27
+#33 (<Max Verstappen (#1172)>) 4[4] 2450.37 2452.39
+#7 (<Kimi Räikkönen (#1141)>) 5[5] 2442.6 2443.25
+#5 (<Sebastian Vettel (#1135)>) 6[6] 2316.3 2319.66
+#27 (<Nico Hülkenberg (#1148)>) 7[7] 2229.07 2234.45
+#77 (<Valtteri Bottas (#1161)>) 8[8] 2307.93 2308.42
+#19 (<Felipe Massa (#1142)>) 9[9] 2185.68 2189.84
+#55 (<Carlos Sainz (#1170)>) 10[10] 2036.13 2046.06
+#11 (<Sergio Pérez (#1155)>) 11[11] 2292.13 2288.44
+#14 (<Fernando Alonso (#1127)>) 12[12] 2088.41 2092.52
+#26 (<Daniil Kvyat (#1166)>) 13[13] 2040.9 2045.79
+#21 (<Esteban Gutiérrez (#1160)>) 14[14] 2031.22 2034.99
+#30 (<Jolyon Palmer (#1175)>) 15[15] 2044.31 2045.83
+#9 (<Marcus Ericsson (#1167)>) 16[16] 1983.02 1985.08
+#8 (<Romain Grosjean (#1144)>) 17[17] 2163.65 2155.25
+#20 (<Kevin Magnussen (#1165)>) 18[18] 2053.51 2048.97
+#22 (<Jenson Button (#1123)>) 19[19] 2051.76 2045.71
+#94 (<Pascal Wehrlein (#1177)>) 20[20] 1960.73 1954.52
+#12 (<Felipe Nasr (#1171)>) 21[21] 1981.41 1971.57
+#31 (<Esteban Ocon (#1179)>) 22[22] 1944.24 1934.16
+
+Podium rating: 7735.77 7742.24
+Average rating: 2197.23363636
+Average rating change: 4.43727272727
+
+2016 United States Grand Prix (2016-10-23)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2609.31 2631.84
+#6 (<Nico Rosberg (#1128)>) 2[2] 2646.66 2640.07
+#3 (<Daniel Ricciardo (#1157)>) 3[2] 2486.27 2506.38
+#5 (<Sebastian Vettel (#1135)>) 4[3] 2319.66 2351.33
+#14 (<Fernando Alonso (#1127)>) 5[3] 2092.52 2214.97
+#55 (<Carlos Sainz (#1170)>) 6[4] 2046.06 2165.69
+#19 (<Felipe Massa (#1142)>) 7[5] 2189.84 2137.57
+#11 (<Sergio Pérez (#1155)>) 8[5] 2288.44 2198.52
+#22 (<Jenson Button (#1123)>) 9[5] 2045.71 2057.5
+#8 (<Romain Grosjean (#1144)>) 10[5] 2155.25 2117.69
+#26 (<Daniil Kvyat (#1166)>) 11[5] 2045.79 2057.55
+#20 (<Kevin Magnussen (#1165)>) 12[5] 2048.97 2059.28
+#30 (<Jolyon Palmer (#1175)>) 13[5] 2045.83 2057.57
+#9 (<Marcus Ericsson (#1167)>) 14[5] 1985.08 2039.24
+#12 (<Felipe Nasr (#1171)>) 15[5] 1971.57 2033.12
+#77 (<Valtteri Bottas (#1161)>) 16[5] 2308.42 2211.75
+#94 (<Pascal Wehrlein (#1177)>) 17[5] 1954.52 2025.1
+#31 (<Esteban Ocon (#1179)>) 18[6] 1934.16 1871.04
+#7 (<Kimi Räikkönen (#1141)>) Ret[0] 2443.25 2443.25
+#33 (<Max Verstappen (#1172)>) Ret[0] 2452.39 2452.39
+#21 (<Esteban Gutiérrez (#1160)>) Ret[0] 2034.99 2034.99
+#27 (<Nico Hülkenberg (#1148)>) Ret[7] 2234.45 2032.29
+
+Podium rating: 7742.24 7778.29
+Average rating: 2197.23363636
+Average rating change: 49.8440909091
+
diff --git a/sql/results.sql b/sql/results.sql
index dde36ac..b96bb5a 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2553,6 +2553,8 @@ INSERT INTO `races` VALUES(2547, '2016 Malaysian Grand Prix - qualifying', '2016
INSERT INTO `races` VALUES(2548, '2016 Malaysian Grand Prix', '2016-10-02', 0, 4);
INSERT INTO `races` VALUES(2549, '2016 Japanese Grand Prix - qualifying', '2016-10-08', 0, 3);
INSERT INTO `races` VALUES(2550, '2016 Japanese Grand Prix', '2016-10-09', 0, 4);
+INSERT INTO `races` VALUES(2551, '2016 United States Grand Prix - qualifying', '2016-10-22', 0, 3);
+INSERT INTO `races` VALUES(2552, '2016 United States Grand Prix', '2016-10-23', 0, 4);
INSERT INTO `countries` VALUES(9, 'Argentina');
INSERT INTO `countries` VALUES(18, 'Australia');
@@ -58643,6 +58645,50 @@ INSERT INTO `entries` VALUES(54866, '19', 12, 6, 2550);
INSERT INTO `entries` VALUES(54867, '20', 21, 6, 2550);
INSERT INTO `entries` VALUES(54868, '21', 31, 6, 2550);
INSERT INTO `entries` VALUES(54869, '22', 94, 6, 2550);
+INSERT INTO `entries` VALUES(54870, '1', 44, 1, 2551);
+INSERT INTO `entries` VALUES(54871, '2', 6, 2, 2551);
+INSERT INTO `entries` VALUES(54872, '3', 3, 3, 2551);
+INSERT INTO `entries` VALUES(54873, '4', 33, 4, 2551);
+INSERT INTO `entries` VALUES(54874, '5', 7, 5, 2551);
+INSERT INTO `entries` VALUES(54875, '6', 5, 6, 2551);
+INSERT INTO `entries` VALUES(54876, '7', 27, 7, 2551);
+INSERT INTO `entries` VALUES(54877, '8', 77, 8, 2551);
+INSERT INTO `entries` VALUES(54878, '9', 19, 9, 2551);
+INSERT INTO `entries` VALUES(54879, '10', 55, 10, 2551);
+INSERT INTO `entries` VALUES(54880, '11', 11, 11, 2551);
+INSERT INTO `entries` VALUES(54881, '12', 14, 12, 2551);
+INSERT INTO `entries` VALUES(54882, '13', 26, 13, 2551);
+INSERT INTO `entries` VALUES(54883, '14', 21, 14, 2551);
+INSERT INTO `entries` VALUES(54884, '15', 30, 15, 2551);
+INSERT INTO `entries` VALUES(54885, '16', 9, 16, 2551);
+INSERT INTO `entries` VALUES(54886, '17', 8, 17, 2551);
+INSERT INTO `entries` VALUES(54887, '18', 20, 18, 2551);
+INSERT INTO `entries` VALUES(54888, '19', 22, 19, 2551);
+INSERT INTO `entries` VALUES(54889, '20', 94, 20, 2551);
+INSERT INTO `entries` VALUES(54890, '21', 12, 21, 2551);
+INSERT INTO `entries` VALUES(54891, '22', 31, 22, 2551);
+INSERT INTO `entries` VALUES(54892, '1', 44, 1, 2552);
+INSERT INTO `entries` VALUES(54893, '2', 6, 2, 2552);
+INSERT INTO `entries` VALUES(54894, '3', 3, 2, 2552);
+INSERT INTO `entries` VALUES(54895, '4', 5, 3, 2552);
+INSERT INTO `entries` VALUES(54896, '5', 14, 3, 2552);
+INSERT INTO `entries` VALUES(54897, '6', 55, 4, 2552);
+INSERT INTO `entries` VALUES(54898, '7', 19, 5, 2552);
+INSERT INTO `entries` VALUES(54899, '8', 11, 5, 2552);
+INSERT INTO `entries` VALUES(54900, '9', 22, 5, 2552);
+INSERT INTO `entries` VALUES(54901, '10', 8, 5, 2552);
+INSERT INTO `entries` VALUES(54902, '11', 26, 5, 2552);
+INSERT INTO `entries` VALUES(54903, '12', 20, 5, 2552);
+INSERT INTO `entries` VALUES(54904, '13', 30, 5, 2552);
+INSERT INTO `entries` VALUES(54905, '14', 9, 5, 2552);
+INSERT INTO `entries` VALUES(54906, '15', 12, 5, 2552);
+INSERT INTO `entries` VALUES(54907, '16', 77, 5, 2552);
+INSERT INTO `entries` VALUES(54908, '17', 94, 5, 2552);
+INSERT INTO `entries` VALUES(54909, '18', 31, 6, 2552);
+INSERT INTO `entries` VALUES(54910, 'Ret', 7, 0, 2552);
+INSERT INTO `entries` VALUES(54911, 'Ret', 33, 0, 2552);
+INSERT INTO `entries` VALUES(54912, 'Ret', 21, 0, 2552);
+INSERT INTO `entries` VALUES(54913, 'Ret', 27, 7, 2552);
INSERT INTO `driver_entries` VALUES(1, 1, 1);
INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -113653,3 +113699,47 @@ INSERT INTO `driver_entries` VALUES(1171, 54866, 55006);
INSERT INTO `driver_entries` VALUES(1160, 54867, 55007);
INSERT INTO `driver_entries` VALUES(1179, 54868, 55008);
INSERT INTO `driver_entries` VALUES(1177, 54869, 55009);
+INSERT INTO `driver_entries` VALUES(1140, 54870, 55010);
+INSERT INTO `driver_entries` VALUES(1128, 54871, 55011);
+INSERT INTO `driver_entries` VALUES(1157, 54872, 55012);
+INSERT INTO `driver_entries` VALUES(1172, 54873, 55013);
+INSERT INTO `driver_entries` VALUES(1141, 54874, 55014);
+INSERT INTO `driver_entries` VALUES(1135, 54875, 55015);
+INSERT INTO `driver_entries` VALUES(1148, 54876, 55016);
+INSERT INTO `driver_entries` VALUES(1161, 54877, 55017);
+INSERT INTO `driver_entries` VALUES(1142, 54878, 55018);
+INSERT INTO `driver_entries` VALUES(1170, 54879, 55019);
+INSERT INTO `driver_entries` VALUES(1155, 54880, 55020);
+INSERT INTO `driver_entries` VALUES(1127, 54881, 55021);
+INSERT INTO `driver_entries` VALUES(1166, 54882, 55022);
+INSERT INTO `driver_entries` VALUES(1160, 54883, 55023);
+INSERT INTO `driver_entries` VALUES(1175, 54884, 55024);
+INSERT INTO `driver_entries` VALUES(1167, 54885, 55025);
+INSERT INTO `driver_entries` VALUES(1144, 54886, 55026);
+INSERT INTO `driver_entries` VALUES(1165, 54887, 55027);
+INSERT INTO `driver_entries` VALUES(1123, 54888, 55028);
+INSERT INTO `driver_entries` VALUES(1177, 54889, 55029);
+INSERT INTO `driver_entries` VALUES(1171, 54890, 55030);
+INSERT INTO `driver_entries` VALUES(1179, 54891, 55031);
+INSERT INTO `driver_entries` VALUES(1140, 54892, 55032);
+INSERT INTO `driver_entries` VALUES(1128, 54893, 55033);
+INSERT INTO `driver_entries` VALUES(1157, 54894, 55034);
+INSERT INTO `driver_entries` VALUES(1135, 54895, 55035);
+INSERT INTO `driver_entries` VALUES(1127, 54896, 55036);
+INSERT INTO `driver_entries` VALUES(1170, 54897, 55037);
+INSERT INTO `driver_entries` VALUES(1142, 54898, 55038);
+INSERT INTO `driver_entries` VALUES(1155, 54899, 55039);
+INSERT INTO `driver_entries` VALUES(1123, 54900, 55040);
+INSERT INTO `driver_entries` VALUES(1144, 54901, 55041);
+INSERT INTO `driver_entries` VALUES(1166, 54902, 55042);
+INSERT INTO `driver_entries` VALUES(1165, 54903, 55043);
+INSERT INTO `driver_entries` VALUES(1175, 54904, 55044);
+INSERT INTO `driver_entries` VALUES(1167, 54905, 55045);
+INSERT INTO `driver_entries` VALUES(1171, 54906, 55046);
+INSERT INTO `driver_entries` VALUES(1161, 54907, 55047);
+INSERT INTO `driver_entries` VALUES(1177, 54908, 55048);
+INSERT INTO `driver_entries` VALUES(1179, 54909, 55049);
+INSERT INTO `driver_entries` VALUES(1141, 54910, 55050);
+INSERT INTO `driver_entries` VALUES(1172, 54911, 55051);
+INSERT INTO `driver_entries` VALUES(1160, 54912, 55052);
+INSERT INTO `driver_entries` VALUES(1148, 54913, 55053);