diff options
| -rw-r--r-- | rate.log | 54 | ||||
| -rw-r--r-- | sql/results.sql | 83 |
2 files changed, 137 insertions, 0 deletions
@@ -73810,3 +73810,57 @@ Podium rating: 7370.36 7472.27 Average rating: 2189.0045 Average rating change: 36.3741176471 +2017 United States Grand Prix - qualifying (2017-10-21) + +#44 (<Lewis Hamilton (#1140)>) 1[1] 2643.82 2645.65 +#5 (<Sebastian Vettel (#1135)>) 2[2] 2373.78 2380.08 +#77 (<Valtteri Bottas (#1161)>) 3[3] 2498.01 2499.31 +#3 (<Daniel Ricciardo (#1157)>) 4[4] 2478.24 2478.4 +#7 (<Kimi Räikkönen (#1141)>) 5[5] 2308.16 2311.9 +#33 (<Max Verstappen (#1172)>) 6[6] 2350.21 2350.88 +#31 (<Esteban Ocon (#1179)>) 7[7] 2191.8 2196.99 +#55 (<Carlos Sainz (#1170)>) 8[8] 2051.58 2061.41 +#14 (<Fernando Alonso (#1127)>) 9[9] 2059.17 2067.07 +#11 (<Sergio Pérez (#1155)>) 10[10] 2269.71 2266.9 +#19 (<Felipe Massa (#1142)>) 11[11] 2091.93 2095.16 +#26 (<Daniil Kvyat (#1166)>) 12[12] 1976.59 1984.44 +#2 (<Stoffel Vandoorne (#1178)>) 13[13] 2086.64 2086.11 +#8 (<Romain Grosjean (#1144)>) 14[14] 2156.38 2151.12 +#27 (<Nico Hülkenberg (#1148)>) 15[15] 2117.44 2112.32 +#9 (<Marcus Ericsson (#1167)>) 16[16] 1812.34 1817.46 +#18 (<Lance Stroll (#1181)>) 17[17] 2111.88 2103.02 +#39 (<Brendon Hartley (#1183)>) 18[18] 2000.0 1992.2 +#94 (<Pascal Wehrlein (#1177)>) 19[19] 1941.79 1934.59 +#20 (<Kevin Magnussen (#1165)>) 20[20] 2118.2 2102.65 + +Podium rating: 7515.61 7525.04 +Average rating: 2181.8835 +Average rating change: 5.3125 + +2017 United States Grand Prix (2017-10-22) + +#44 (<Lewis Hamilton (#1140)>) 1[1] 2645.65 2659.92 +#7 (<Sebastian Vettel (#1135)>) 2[2] 2380.08 2419.39 +#5 (<Kimi Räikkönen (#1141)>) 3[2] 2311.9 2370.65 +#33 (<Max Verstappen (#1172)>) 4[3] 2350.88 2366.16 +#77 (<Valtteri Bottas (#1161)>) 5[3] 2499.31 2479.59 +#31 (<Esteban Ocon (#1179)>) 6[4] 2196.99 2230.45 +#55 (<Carlos Sainz (#1170)>) 7[4] 2061.41 2146.11 +#11 (<Sergio Pérez (#1155)>) 8[5] 2266.9 2176.0 +#19 (<Felipe Massa (#1142)>) 9[5] 2095.16 2066.97 +#26 (<Daniil Kvyat (#1166)>) 10[5] 1984.44 2002.03 +#18 (<Lance Stroll (#1181)>) 11[5] 2103.02 2071.82 +#2 (<Stoffel Vandoorne (#1178)>) 12[5] 2086.11 2061.39 +#39 (<Brendon Hartley (#1183)>) 13[5] 1992.2 2006.26 +#8 (<Romain Grosjean (#1144)>) 14[5] 2151.12 2101.6 +#9 (<Marcus Ericsson (#1167)>) 15[5] 1817.46 1896.38 +#20 (<Kevin Magnussen (#1165)>) 16[5] 2102.65 2071.6 +#14 (<Fernando Alonso (#1127)>) R[0] 2067.07 2067.07 +#3 (<Daniel Ricciardo (#1157)>) R[0] 2478.4 2478.4 +#27 (<Nico Hülkenberg (#1148)>) R[0] 2112.32 2112.32 +#94 (<Pascal Wehrlein (#1177)>) R[6] 1934.59 1853.55 + +Podium rating: 7337.63 7449.96 +Average rating: 2181.883 +Average rating change: 41.9223529412 + diff --git a/sql/results.sql b/sql/results.sql index 7ff7af1..cb667db 100644 --- a/sql/results.sql +++ b/sql/results.sql @@ -2593,6 +2593,8 @@ INSERT INTO `races` VALUES(2587, '2017 Malaysian Grand Prix - qualifying', '2017 INSERT INTO `races` VALUES(2588, '2017 Malaysian Grand Prix', '2017-10-01', 0, 4); INSERT INTO `races` VALUES(2589, '2017 Japanese Grand Prix - qualifying', '2017-10-07', 0, 3); INSERT INTO `races` VALUES(2590, '2017 Japanese Grand Prix', '2017-10-08', 0, 4); +INSERT INTO `races` VALUES(2591, '2017 United States Grand Prix - qualifying', '2017-10-21', 0, 3); +INSERT INTO `races` VALUES(2592, '2017 United States Grand Prix', '2017-10-22', 0, 4); INSERT INTO `countries` VALUES(9, 'Argentina'); INSERT INTO `countries` VALUES(18, 'Australia'); @@ -3816,6 +3818,7 @@ INSERT INTO `drivers` VALUES(1179, 'Esteban Ocon', 1); INSERT INTO `drivers` VALUES(1180, 'Antonio Giovinazzi', 3); INSERT INTO `drivers` VALUES(1181, 'Lance Stroll', 24); INSERT INTO `drivers` VALUES(1182, 'Pierre Gasly', 1); +INSERT INTO `drivers` VALUES(1183, 'Brendon Hartley', 20); INSERT INTO `entries` VALUES(1, '1', 3, 1, 1); INSERT INTO `entries` VALUES(2, '2', 6, 2, 1); @@ -59501,6 +59504,46 @@ INSERT INTO `entries` VALUES(55681, 'R', 27, 0, 2590); INSERT INTO `entries` VALUES(55682, 'R', 9, 7, 2590); INSERT INTO `entries` VALUES(55683, 'R', 5, 0, 2590); INSERT INTO `entries` VALUES(55684, 'R', 55, 7, 2590); +INSERT INTO `entries` VALUES(55685, '1', 44, 1, 2591); +INSERT INTO `entries` VALUES(55686, '2', 5, 2, 2591); +INSERT INTO `entries` VALUES(55687, '3', 77, 3, 2591); +INSERT INTO `entries` VALUES(55688, '4', 3, 4, 2591); +INSERT INTO `entries` VALUES(55689, '5', 7, 5, 2591); +INSERT INTO `entries` VALUES(55690, '6', 33, 6, 2591); +INSERT INTO `entries` VALUES(55691, '7', 31, 7, 2591); +INSERT INTO `entries` VALUES(55692, '8', 55, 8, 2591); +INSERT INTO `entries` VALUES(55693, '9', 14, 9, 2591); +INSERT INTO `entries` VALUES(55694, '10', 11, 10, 2591); +INSERT INTO `entries` VALUES(55695, '11', 19, 11, 2591); +INSERT INTO `entries` VALUES(55696, '12', 26, 12, 2591); +INSERT INTO `entries` VALUES(55697, '13', 2, 13, 2591); +INSERT INTO `entries` VALUES(55698, '14', 8, 14, 2591); +INSERT INTO `entries` VALUES(55699, '15', 27, 15, 2591); +INSERT INTO `entries` VALUES(55700, '16', 9, 16, 2591); +INSERT INTO `entries` VALUES(55701, '17', 18, 17, 2591); +INSERT INTO `entries` VALUES(55702, '18', 39, 18, 2591); +INSERT INTO `entries` VALUES(55703, '19', 94, 19, 2591); +INSERT INTO `entries` VALUES(55704, '20', 20, 20, 2591); +INSERT INTO `entries` VALUES(55705, '1', 44, 1, 2592); +INSERT INTO `entries` VALUES(55706, '2', 7, 2, 2592); +INSERT INTO `entries` VALUES(55707, '3', 5, 2, 2592); +INSERT INTO `entries` VALUES(55708, '4', 33, 3, 2592); +INSERT INTO `entries` VALUES(55709, '5', 77, 3, 2592); +INSERT INTO `entries` VALUES(55710, '6', 31, 4, 2592); +INSERT INTO `entries` VALUES(55711, '7', 55, 4, 2592); +INSERT INTO `entries` VALUES(55712, '8', 11, 5, 2592); +INSERT INTO `entries` VALUES(55713, '9', 19, 5, 2592); +INSERT INTO `entries` VALUES(55714, '10', 26, 5, 2592); +INSERT INTO `entries` VALUES(55715, '11', 18, 5, 2592); +INSERT INTO `entries` VALUES(55716, '12', 2, 5, 2592); +INSERT INTO `entries` VALUES(55717, '13', 39, 5, 2592); +INSERT INTO `entries` VALUES(55718, '14', 8, 5, 2592); +INSERT INTO `entries` VALUES(55719, '15', 9, 5, 2592); +INSERT INTO `entries` VALUES(55720, '16', 20, 5, 2592); +INSERT INTO `entries` VALUES(55721, 'R', 14, 0, 2592); +INSERT INTO `entries` VALUES(55722, 'R', 3, 0, 2592); +INSERT INTO `entries` VALUES(55723, 'R', 94, 6, 2592); +INSERT INTO `entries` VALUES(55724, 'R', 27, 0, 2592); INSERT INTO `driver_entries` VALUES(1, 1, 1); INSERT INTO `driver_entries` VALUES(2, 2, 2); @@ -115326,3 +115369,43 @@ INSERT INTO `driver_entries` VALUES(1148, 55681, 55821); INSERT INTO `driver_entries` VALUES(1167, 55682, 55822); INSERT INTO `driver_entries` VALUES(1135, 55683, 55823); INSERT INTO `driver_entries` VALUES(1170, 55684, 55824); +INSERT INTO `driver_entries` VALUES(1140, 55685, 55825); +INSERT INTO `driver_entries` VALUES(1135, 55686, 55826); +INSERT INTO `driver_entries` VALUES(1161, 55687, 55827); +INSERT INTO `driver_entries` VALUES(1157, 55688, 55828); +INSERT INTO `driver_entries` VALUES(1141, 55689, 55829); +INSERT INTO `driver_entries` VALUES(1172, 55690, 55830); +INSERT INTO `driver_entries` VALUES(1179, 55691, 55831); +INSERT INTO `driver_entries` VALUES(1170, 55692, 55832); +INSERT INTO `driver_entries` VALUES(1127, 55693, 55833); +INSERT INTO `driver_entries` VALUES(1155, 55694, 55834); +INSERT INTO `driver_entries` VALUES(1142, 55695, 55835); +INSERT INTO `driver_entries` VALUES(1166, 55696, 55836); +INSERT INTO `driver_entries` VALUES(1178, 55697, 55837); +INSERT INTO `driver_entries` VALUES(1144, 55698, 55838); +INSERT INTO `driver_entries` VALUES(1148, 55699, 55839); +INSERT INTO `driver_entries` VALUES(1167, 55700, 55840); +INSERT INTO `driver_entries` VALUES(1181, 55701, 55841); +INSERT INTO `driver_entries` VALUES(1183, 55702, 55842); +INSERT INTO `driver_entries` VALUES(1177, 55703, 55843); +INSERT INTO `driver_entries` VALUES(1165, 55704, 55844); +INSERT INTO `driver_entries` VALUES(1140, 55705, 55845); +INSERT INTO `driver_entries` VALUES(1135, 55706, 55846); +INSERT INTO `driver_entries` VALUES(1141, 55707, 55847); +INSERT INTO `driver_entries` VALUES(1172, 55708, 55848); +INSERT INTO `driver_entries` VALUES(1161, 55709, 55849); +INSERT INTO `driver_entries` VALUES(1179, 55710, 55850); +INSERT INTO `driver_entries` VALUES(1170, 55711, 55851); +INSERT INTO `driver_entries` VALUES(1155, 55712, 55852); +INSERT INTO `driver_entries` VALUES(1142, 55713, 55853); +INSERT INTO `driver_entries` VALUES(1166, 55714, 55854); +INSERT INTO `driver_entries` VALUES(1181, 55715, 55855); +INSERT INTO `driver_entries` VALUES(1178, 55716, 55856); +INSERT INTO `driver_entries` VALUES(1183, 55717, 55857); +INSERT INTO `driver_entries` VALUES(1144, 55718, 55858); +INSERT INTO `driver_entries` VALUES(1167, 55719, 55859); +INSERT INTO `driver_entries` VALUES(1165, 55720, 55860); +INSERT INTO `driver_entries` VALUES(1127, 55721, 55861); +INSERT INTO `driver_entries` VALUES(1157, 55722, 55862); +INSERT INTO `driver_entries` VALUES(1177, 55723, 55863); +INSERT INTO `driver_entries` VALUES(1148, 55724, 55864); |