diff options
| -rw-r--r-- | rate.log | 116 | ||||
| -rw-r--r-- | sql/results.sql | 180 |
2 files changed, 296 insertions, 0 deletions
@@ -72311,3 +72311,119 @@ Podium rating: 7351.05 7463.36 Average rating: 2191.45363636 Average rating change: 30.3563636364 +2016 Hungarian Grand Prix - qualifying (2016-07-23) + +#6 (<Nico Rosberg (#1128)>) 1[1] 2489.71 2494.36 +#44 (<Lewis Hamilton (#1140)>) 2[2] 2550.48 2552.04 +#3 (<Daniel Ricciardo (#1157)>) 3[3] 2399.59 2403.86 +#33 (<Max Verstappen (#1172)>) 4[4] 2423.17 2425.03 +#5 (<Sebastian Vettel (#1135)>) 5[5] 2395.64 2396.84 +#55 (<Carlos Sainz (#1170)>) 6[6] 2263.2 2268.18 +#14 (<Fernando Alonso (#1127)>) 7[7] 2051.04 2065.11 +#22 (<Jenson Button (#1123)>) 8[8] 2155.46 2162.53 +#27 (<Nico Hülkenberg (#1148)>) 9[9] 2149.46 2155.24 +#77 (<Valtteri Bottas (#1161)>) 10[10] 2155.73 2159.59 +#8 (<Romain Grosjean (#1144)>) 11[11] 2164.71 2166.5 +#26 (<Daniil Kvyat (#1166)>) 12[12] 2177.07 2176.63 +#11 (<Sergio Pérez (#1155)>) 13[13] 2196.01 2193.02 +#7 (<Kimi Räikkönen (#1141)>) 14[14] 2414.58 2400.73 +#21 (<Esteban Gutiérrez (#1160)>) 15[15] 2056.93 2057.9 +#12 (<Felipe Nasr (#1171)>) 16[16] 2039.51 2039.75 +#30 (<Jolyon Palmer (#1175)>) —[17] 2046.78 2045.06 +#19 (<Felipe Massa (#1142)>) —[18] 2048.76 2045.34 +#20 (<Kevin Magnussen (#1165)>) —[19] 2048.18 2043.19 +#9 (<Marcus Ericsson (#1167)>) —[20] 2044.67 2038.26 +#94 (<Pascal Wehrlein (#1177)>) —[21] 1983.59 1974.77 +#88 (<Rio Haryanto (#1176)>) —[22] 1957.73 1948.05 + +Podium rating: 7439.78 7450.26 +Average rating: 2191.45454545 +Average rating change: 4.75545454545 + +2016 Hungarian Grand Prix (2016-07-24) + +#44 (<Lewis Hamilton (#1140)>) 1[1] 2552.04 2582.61 +#6 (<Nico Rosberg (#1128)>) 2[2] 2494.36 2514.62 +#3 (<Daniel Ricciardo (#1157)>) 3[2] 2403.86 2451.02 +#5 (<Sebastian Vettel (#1135)>) 4[3] 2396.84 2414.36 +#33 (<Max Verstappen (#1172)>) 5[3] 2425.03 2433.33 +#7 (<Kimi Räikkönen (#1141)>) 6[4] 2400.73 2392.94 +#14 (<Fernando Alonso (#1127)>) 7[5] 2065.11 2107.54 +#55 (<Carlos Sainz (#1170)>) 8[5] 2268.18 2214.99 +#77 (<Valtteri Bottas (#1161)>) 9[5] 2159.59 2156.1 +#27 (<Nico Hülkenberg (#1148)>) 10[5] 2155.24 2153.85 +#11 (<Sergio Pérez (#1155)>) 11[5] 2193.02 2173.61 +#30 (<Jolyon Palmer (#1175)>) 12[5] 2045.06 2097.01 +#21 (<Esteban Gutiérrez (#1160)>) 13[5] 2057.9 2103.78 +#8 (<Romain Grosjean (#1144)>) 14[5] 2166.5 2159.69 +#20 (<Kevin Magnussen (#1165)>) 15[5] 2043.19 2096.02 +#26 (<Daniil Kvyat (#1166)>) 16[5] 2176.63 2164.98 +#12 (<Felipe Nasr (#1171)>) 17[5] 2039.75 2094.18 +#19 (<Felipe Massa (#1142)>) 18[6] 2045.34 1969.16 +#94 (<Pascal Wehrlein (#1177)>) 19[6] 1974.77 1908.13 +#9 (<Marcus Ericsson (#1167)>) 20[6] 2038.26 1965.39 +#88 (<Rio Haryanto (#1176)>) 21[6] 1948.05 1896.15 +#22 (<Jenson Button (#1123)>) Ret[0] 2162.53 2162.53 + +Podium rating: 7450.26 7548.25 +Average rating: 2191.45363636 +Average rating change: 33.7568181818 + +2016 German Grand Prix - qualifying (2016-07-30) + +#6 (<Nico Rosberg (#1128)>) 1[1] 2514.62 2518.93 +#44 (<Lewis Hamilton (#1140)>) 2[2] 2582.61 2583.78 +#3 (<Daniel Ricciardo (#1157)>) 3[3] 2451.02 2453.9 +#33 (<Max Verstappen (#1172)>) 4[4] 2433.33 2435.16 +#7 (<Kimi Räikkönen (#1141)>) 5[5] 2392.94 2394.52 +#5 (<Sebastian Vettel (#1135)>) 6[6] 2414.36 2413.61 +#27 (<Nico Hülkenberg (#1148)>) 7[7] 2153.85 2162.82 +#77 (<Valtteri Bottas (#1161)>) 8[8] 2156.1 2163.35 +#11 (<Sergio Pérez (#1155)>) 9[9] 2173.61 2178.36 +#19 (<Felipe Massa (#1142)>) 10[10] 1969.16 1987.18 +#21 (<Esteban Gutiérrez (#1160)>) 11[11] 2103.78 2108.16 +#22 (<Jenson Button (#1123)>) 12[12] 2162.53 2162.25 +#55 (<Carlos Sainz (#1170)>) 13[13] 2214.99 2210.46 +#14 (<Fernando Alonso (#1127)>) 14[14] 2107.54 2106.92 +#8 (<Romain Grosjean (#1144)>) 15[15] 2159.69 2154.75 +#30 (<Jolyon Palmer (#1175)>) 16[16] 2097.01 2093.74 +#20 (<Kevin Magnussen (#1165)>) 17[17] 2096.02 2091.21 +#94 (<Pascal Wehrlein (#1177)>) 18[18] 1908.13 1910.14 +#26 (<Daniil Kvyat (#1166)>) 19[19] 2164.98 2152.57 +#88 (<Rio Haryanto (#1176)>) 20[20] 1896.15 1893.91 +#12 (<Felipe Nasr (#1171)>) 21[21] 2094.18 2081.46 +#9 (<Marcus Ericsson (#1167)>) 22[22] 1965.39 1954.82 + +Podium rating: 7548.25 7556.61 +Average rating: 2191.45409091 +Average rating change: 5.195 + +2016 German Grand Prix (2016-07-31) + +#44 (<Lewis Hamilton (#1140)>) 1[1] 2583.78 2610.94 +#3 (<Daniel Ricciardo (#1157)>) 2[2] 2453.9 2488.53 +#33 (<Max Verstappen (#1172)>) 3[2] 2435.16 2475.34 +#6 (<Nico Rosberg (#1128)>) 4[3] 2518.93 2504.24 +#5 (<Sebastian Vettel (#1135)>) 5[3] 2413.61 2428.47 +#7 (<Kimi Räikkönen (#1141)>) 6[4] 2394.52 2383.55 +#27 (<Nico Hülkenberg (#1148)>) 7[4] 2162.82 2245.14 +#22 (<Jenson Button (#1123)>) 8[5] 2162.25 2156.83 +#77 (<Valtteri Bottas (#1161)>) 9[5] 2163.35 2157.43 +#11 (<Sergio Pérez (#1155)>) 10[5] 2178.36 2165.6 +#21 (<Esteban Gutiérrez (#1160)>) 11[5] 2108.16 2127.51 +#14 (<Fernando Alonso (#1127)>) 12[5] 2106.92 2126.84 +#8 (<Romain Grosjean (#1144)>) 13[5] 2154.75 2152.76 +#55 (<Carlos Sainz (#1170)>) 14[5] 2210.46 2183.28 +#26 (<Daniil Kvyat (#1166)>) 15[5] 2152.57 2151.58 +#20 (<Kevin Magnussen (#1165)>) 16[5] 2091.21 2118.24 +#94 (<Pascal Wehrlein (#1177)>) 17[6] 1910.14 1882.72 +#9 (<Marcus Ericsson (#1167)>) 18[6] 1954.82 1907.89 +#30 (<Jolyon Palmer (#1175)>) 19[6] 2093.74 2003.63 +#88 (<Rio Haryanto (#1176)>) 20[6] 1893.91 1872.84 +#12 (<Felipe Nasr (#1171)>) Ret[0] 2081.46 2081.46 +#19 (<Felipe Massa (#1142)>) Ret[0] 1987.18 1987.18 + +Podium rating: 7472.84 7574.81 +Average rating: 2191.45454545 +Average rating change: 24.1318181818 + diff --git a/sql/results.sql b/sql/results.sql index 4e14fa1..0f41be7 100644 --- a/sql/results.sql +++ b/sql/results.sql @@ -2539,6 +2539,10 @@ INSERT INTO `races` VALUES(2533, '2016 Austrian Grand Prix - qualifying', '2016- INSERT INTO `races` VALUES(2534, '2016 Austrian Grand Prix', '2016-07-03', 0, 4); INSERT INTO `races` VALUES(2535, '2016 British Grand Prix - qualifying', '2016-07-09', 0, 3); INSERT INTO `races` VALUES(2536, '2016 British Grand Prix', '2016-07-10', 0, 4); +INSERT INTO `races` VALUES(2537, '2016 Hungarian Grand Prix - qualifying', '2016-07-23', 0, 3); +INSERT INTO `races` VALUES(2538, '2016 Hungarian Grand Prix', '2016-07-24', 0, 4); +INSERT INTO `races` VALUES(2539, '2016 German Grand Prix - qualifying', '2016-07-30', 0, 3); +INSERT INTO `races` VALUES(2540, '2016 German Grand Prix', '2016-07-31', 0, 4); INSERT INTO `countries` VALUES(9, 'Argentina'); INSERT INTO `countries` VALUES(18, 'Australia'); @@ -58320,6 +58324,94 @@ INSERT INTO `entries` VALUES(54558, 'Ret', 88, 6, 2536); INSERT INTO `entries` VALUES(54559, 'Ret', 8, 0, 2536); INSERT INTO `entries` VALUES(54560, 'Ret', 9, 0, 2536); INSERT INTO `entries` VALUES(54561, 'Ret', 94, 6, 2536); +INSERT INTO `entries` VALUES(54562, '1', 6, 1, 2537); +INSERT INTO `entries` VALUES(54563, '2', 44, 2, 2537); +INSERT INTO `entries` VALUES(54564, '3', 3, 3, 2537); +INSERT INTO `entries` VALUES(54565, '4', 33, 4, 2537); +INSERT INTO `entries` VALUES(54566, '5', 5, 5, 2537); +INSERT INTO `entries` VALUES(54567, '6', 55, 6, 2537); +INSERT INTO `entries` VALUES(54568, '7', 14, 7, 2537); +INSERT INTO `entries` VALUES(54569, '8', 22, 8, 2537); +INSERT INTO `entries` VALUES(54570, '9', 27, 9, 2537); +INSERT INTO `entries` VALUES(54571, '10', 77, 10, 2537); +INSERT INTO `entries` VALUES(54572, '11', 8, 11, 2537); +INSERT INTO `entries` VALUES(54573, '12', 26, 12, 2537); +INSERT INTO `entries` VALUES(54574, '13', 11, 13, 2537); +INSERT INTO `entries` VALUES(54575, '14', 7, 14, 2537); +INSERT INTO `entries` VALUES(54576, '15', 21, 15, 2537); +INSERT INTO `entries` VALUES(54577, '16', 12, 16, 2537); +INSERT INTO `entries` VALUES(54578, '—', 30, 17, 2537); +INSERT INTO `entries` VALUES(54579, '—', 19, 18, 2537); +INSERT INTO `entries` VALUES(54580, '—', 20, 19, 2537); +INSERT INTO `entries` VALUES(54581, '—', 9, 20, 2537); +INSERT INTO `entries` VALUES(54582, '—', 94, 21, 2537); +INSERT INTO `entries` VALUES(54583, '—', 88, 22, 2537); +INSERT INTO `entries` VALUES(54584, '1', 44, 1, 2538); +INSERT INTO `entries` VALUES(54585, '2', 6, 2, 2538); +INSERT INTO `entries` VALUES(54586, '3', 3, 2, 2538); +INSERT INTO `entries` VALUES(54587, '4', 5, 3, 2538); +INSERT INTO `entries` VALUES(54588, '5', 33, 3, 2538); +INSERT INTO `entries` VALUES(54589, '6', 7, 4, 2538); +INSERT INTO `entries` VALUES(54590, '7', 14, 5, 2538); +INSERT INTO `entries` VALUES(54591, '8', 55, 5, 2538); +INSERT INTO `entries` VALUES(54592, '9', 77, 5, 2538); +INSERT INTO `entries` VALUES(54593, '10', 27, 5, 2538); +INSERT INTO `entries` VALUES(54594, '11', 11, 5, 2538); +INSERT INTO `entries` VALUES(54595, '12', 30, 5, 2538); +INSERT INTO `entries` VALUES(54596, '13', 21, 5, 2538); +INSERT INTO `entries` VALUES(54597, '14', 8, 5, 2538); +INSERT INTO `entries` VALUES(54598, '15', 20, 5, 2538); +INSERT INTO `entries` VALUES(54599, '16', 26, 5, 2538); +INSERT INTO `entries` VALUES(54600, '17', 12, 5, 2538); +INSERT INTO `entries` VALUES(54601, '18', 19, 6, 2538); +INSERT INTO `entries` VALUES(54602, '19', 94, 6, 2538); +INSERT INTO `entries` VALUES(54603, '20', 9, 6, 2538); +INSERT INTO `entries` VALUES(54604, '21', 88, 6, 2538); +INSERT INTO `entries` VALUES(54605, 'Ret', 22, 0, 2538); +INSERT INTO `entries` VALUES(54606, '1', 6, 1, 2539); +INSERT INTO `entries` VALUES(54607, '2', 44, 2, 2539); +INSERT INTO `entries` VALUES(54608, '3', 3, 3, 2539); +INSERT INTO `entries` VALUES(54609, '4', 33, 4, 2539); +INSERT INTO `entries` VALUES(54610, '5', 7, 5, 2539); +INSERT INTO `entries` VALUES(54611, '6', 5, 6, 2539); +INSERT INTO `entries` VALUES(54612, '7', 27, 7, 2539); +INSERT INTO `entries` VALUES(54613, '8', 77, 8, 2539); +INSERT INTO `entries` VALUES(54614, '9', 11, 9, 2539); +INSERT INTO `entries` VALUES(54615, '10', 19, 10, 2539); +INSERT INTO `entries` VALUES(54616, '11', 21, 11, 2539); +INSERT INTO `entries` VALUES(54617, '12', 22, 12, 2539); +INSERT INTO `entries` VALUES(54618, '13', 55, 13, 2539); +INSERT INTO `entries` VALUES(54619, '14', 14, 14, 2539); +INSERT INTO `entries` VALUES(54620, '15', 8, 15, 2539); +INSERT INTO `entries` VALUES(54621, '16', 30, 16, 2539); +INSERT INTO `entries` VALUES(54622, '17', 20, 17, 2539); +INSERT INTO `entries` VALUES(54623, '18', 94, 18, 2539); +INSERT INTO `entries` VALUES(54624, '19', 26, 19, 2539); +INSERT INTO `entries` VALUES(54625, '20', 88, 20, 2539); +INSERT INTO `entries` VALUES(54626, '21', 12, 21, 2539); +INSERT INTO `entries` VALUES(54627, '22', 9, 22, 2539); +INSERT INTO `entries` VALUES(54628, '1', 44, 1, 2540); +INSERT INTO `entries` VALUES(54629, '2', 3, 2, 2540); +INSERT INTO `entries` VALUES(54630, '3', 33, 2, 2540); +INSERT INTO `entries` VALUES(54631, '4', 6, 3, 2540); +INSERT INTO `entries` VALUES(54632, '5', 5, 3, 2540); +INSERT INTO `entries` VALUES(54633, '6', 7, 4, 2540); +INSERT INTO `entries` VALUES(54634, '7', 27, 4, 2540); +INSERT INTO `entries` VALUES(54635, '8', 22, 5, 2540); +INSERT INTO `entries` VALUES(54636, '9', 77, 5, 2540); +INSERT INTO `entries` VALUES(54637, '10', 11, 5, 2540); +INSERT INTO `entries` VALUES(54638, '11', 21, 5, 2540); +INSERT INTO `entries` VALUES(54639, '12', 14, 5, 2540); +INSERT INTO `entries` VALUES(54640, '13', 8, 5, 2540); +INSERT INTO `entries` VALUES(54641, '14', 55, 5, 2540); +INSERT INTO `entries` VALUES(54642, '15', 26, 5, 2540); +INSERT INTO `entries` VALUES(54643, '16', 20, 5, 2540); +INSERT INTO `entries` VALUES(54644, '17', 94, 6, 2540); +INSERT INTO `entries` VALUES(54645, '18', 9, 6, 2540); +INSERT INTO `entries` VALUES(54646, '19', 30, 6, 2540); +INSERT INTO `entries` VALUES(54647, '20', 88, 6, 2540); +INSERT INTO `entries` VALUES(54648, 'Ret', 12, 0, 2540); +INSERT INTO `entries` VALUES(54649, 'Ret', 19, 0, 2540); INSERT INTO `driver_entries` VALUES(1, 1, 1); INSERT INTO `driver_entries` VALUES(2, 2, 2); @@ -113022,3 +113114,91 @@ INSERT INTO `driver_entries` VALUES(1176, 54558, 54698); INSERT INTO `driver_entries` VALUES(1144, 54559, 54699); INSERT INTO `driver_entries` VALUES(1167, 54560, 54700); INSERT INTO `driver_entries` VALUES(1177, 54561, 54701); +INSERT INTO `driver_entries` VALUES(1128, 54562, 54702); +INSERT INTO `driver_entries` VALUES(1140, 54563, 54703); +INSERT INTO `driver_entries` VALUES(1157, 54564, 54704); +INSERT INTO `driver_entries` VALUES(1172, 54565, 54705); +INSERT INTO `driver_entries` VALUES(1135, 54566, 54706); +INSERT INTO `driver_entries` VALUES(1170, 54567, 54707); +INSERT INTO `driver_entries` VALUES(1127, 54568, 54708); +INSERT INTO `driver_entries` VALUES(1123, 54569, 54709); +INSERT INTO `driver_entries` VALUES(1148, 54570, 54710); +INSERT INTO `driver_entries` VALUES(1161, 54571, 54711); +INSERT INTO `driver_entries` VALUES(1144, 54572, 54712); +INSERT INTO `driver_entries` VALUES(1166, 54573, 54713); +INSERT INTO `driver_entries` VALUES(1155, 54574, 54714); +INSERT INTO `driver_entries` VALUES(1141, 54575, 54715); +INSERT INTO `driver_entries` VALUES(1160, 54576, 54716); +INSERT INTO `driver_entries` VALUES(1171, 54577, 54717); +INSERT INTO `driver_entries` VALUES(1175, 54578, 54718); +INSERT INTO `driver_entries` VALUES(1142, 54579, 54719); +INSERT INTO `driver_entries` VALUES(1165, 54580, 54720); +INSERT INTO `driver_entries` VALUES(1167, 54581, 54721); +INSERT INTO `driver_entries` VALUES(1177, 54582, 54722); +INSERT INTO `driver_entries` VALUES(1176, 54583, 54723); +INSERT INTO `driver_entries` VALUES(1140, 54584, 54724); +INSERT INTO `driver_entries` VALUES(1128, 54585, 54725); +INSERT INTO `driver_entries` VALUES(1157, 54586, 54726); +INSERT INTO `driver_entries` VALUES(1135, 54587, 54727); +INSERT INTO `driver_entries` VALUES(1172, 54588, 54728); +INSERT INTO `driver_entries` VALUES(1141, 54589, 54729); +INSERT INTO `driver_entries` VALUES(1127, 54590, 54730); +INSERT INTO `driver_entries` VALUES(1170, 54591, 54731); +INSERT INTO `driver_entries` VALUES(1161, 54592, 54732); +INSERT INTO `driver_entries` VALUES(1148, 54593, 54733); +INSERT INTO `driver_entries` VALUES(1155, 54594, 54734); +INSERT INTO `driver_entries` VALUES(1175, 54595, 54735); +INSERT INTO `driver_entries` VALUES(1160, 54596, 54736); +INSERT INTO `driver_entries` VALUES(1144, 54597, 54737); +INSERT INTO `driver_entries` VALUES(1165, 54598, 54738); +INSERT INTO `driver_entries` VALUES(1166, 54599, 54739); +INSERT INTO `driver_entries` VALUES(1171, 54600, 54740); +INSERT INTO `driver_entries` VALUES(1142, 54601, 54741); +INSERT INTO `driver_entries` VALUES(1177, 54602, 54742); +INSERT INTO `driver_entries` VALUES(1167, 54603, 54743); +INSERT INTO `driver_entries` VALUES(1176, 54604, 54744); +INSERT INTO `driver_entries` VALUES(1123, 54605, 54745); +INSERT INTO `driver_entries` VALUES(1128, 54606, 54746); +INSERT INTO `driver_entries` VALUES(1140, 54607, 54747); +INSERT INTO `driver_entries` VALUES(1157, 54608, 54748); +INSERT INTO `driver_entries` VALUES(1172, 54609, 54749); +INSERT INTO `driver_entries` VALUES(1141, 54610, 54750); +INSERT INTO `driver_entries` VALUES(1135, 54611, 54751); +INSERT INTO `driver_entries` VALUES(1148, 54612, 54752); +INSERT INTO `driver_entries` VALUES(1161, 54613, 54753); +INSERT INTO `driver_entries` VALUES(1155, 54614, 54754); +INSERT INTO `driver_entries` VALUES(1142, 54615, 54755); +INSERT INTO `driver_entries` VALUES(1160, 54616, 54756); +INSERT INTO `driver_entries` VALUES(1123, 54617, 54757); +INSERT INTO `driver_entries` VALUES(1170, 54618, 54758); +INSERT INTO `driver_entries` VALUES(1127, 54619, 54759); +INSERT INTO `driver_entries` VALUES(1144, 54620, 54760); +INSERT INTO `driver_entries` VALUES(1175, 54621, 54761); +INSERT INTO `driver_entries` VALUES(1165, 54622, 54762); +INSERT INTO `driver_entries` VALUES(1177, 54623, 54763); +INSERT INTO `driver_entries` VALUES(1166, 54624, 54764); +INSERT INTO `driver_entries` VALUES(1176, 54625, 54765); +INSERT INTO `driver_entries` VALUES(1171, 54626, 54766); +INSERT INTO `driver_entries` VALUES(1167, 54627, 54767); +INSERT INTO `driver_entries` VALUES(1140, 54628, 54768); +INSERT INTO `driver_entries` VALUES(1157, 54629, 54769); +INSERT INTO `driver_entries` VALUES(1172, 54630, 54770); +INSERT INTO `driver_entries` VALUES(1128, 54631, 54771); +INSERT INTO `driver_entries` VALUES(1135, 54632, 54772); +INSERT INTO `driver_entries` VALUES(1141, 54633, 54773); +INSERT INTO `driver_entries` VALUES(1148, 54634, 54774); +INSERT INTO `driver_entries` VALUES(1123, 54635, 54775); +INSERT INTO `driver_entries` VALUES(1161, 54636, 54776); +INSERT INTO `driver_entries` VALUES(1155, 54637, 54777); +INSERT INTO `driver_entries` VALUES(1160, 54638, 54778); +INSERT INTO `driver_entries` VALUES(1127, 54639, 54779); +INSERT INTO `driver_entries` VALUES(1144, 54640, 54780); +INSERT INTO `driver_entries` VALUES(1170, 54641, 54781); +INSERT INTO `driver_entries` VALUES(1166, 54642, 54782); +INSERT INTO `driver_entries` VALUES(1165, 54643, 54783); +INSERT INTO `driver_entries` VALUES(1177, 54644, 54784); +INSERT INTO `driver_entries` VALUES(1167, 54645, 54785); +INSERT INTO `driver_entries` VALUES(1175, 54646, 54786); +INSERT INTO `driver_entries` VALUES(1176, 54647, 54787); +INSERT INTO `driver_entries` VALUES(1171, 54648, 54788); +INSERT INTO `driver_entries` VALUES(1142, 54649, 54789); |