diff options
| -rw-r--r-- | rate.log | 108 | ||||
| -rw-r--r-- | sql/results.sql | 164 |
2 files changed, 272 insertions, 0 deletions
@@ -75694,3 +75694,111 @@ Podium rating: 7784.18 7847.65 Average rating: 2196.7245 Average rating change: 64.528 +2019 German Grand Prix - qualifying (2019-07-27) + +#44 (<Lewis Hamilton (#1140)>) 1[1] 2742.14 2743.37 +#33 (<Max Verstappen (#1172)>) 2[2] 2542.7 2545.33 +#77 (<Valtteri Bottas (#1161)>) 3[3] 2625.34 2624.92 +#10 (<Pierre Gasly (#1182)>) 4[4] 2270.5 2277.48 +#7 (<Kimi Räikkönen (#1141)>) 5[5] 2182.38 2191.36 +#8 (<Romain Grosjean (#1144)>) 6[6] 1994.1 2015.56 +#55 (<Carlos Sainz (#1170)>) 7[7] 2226.48 2229.6 +#11 (<Sergio Pérez (#1155)>) 8[8] 2042.95 2052.59 +#27 (<Nico Hülkenberg (#1148)>) 9[9] 2179.94 2181.82 +#16 (<Charles Leclerc (#1184)>) 10[10] 2480.17 2470.51 +#99 (<Antonio Giovinazzi (#1180)>) 11[11] 1975.15 1985.61 +#20 (<Kevin Magnussen (#1165)>) 12[12] 1881.7 1894.11 +#3 (<Daniel Ricciardo (#1157)>) 13[13] 2194.05 2187.33 +#26 (<Daniil Kvyat (#1166)>) 14[14] 2182.84 2175.0 +#18 (<Lance Stroll (#1181)>) 15[15] 2104.16 2098.23 +#4 (<Lando Norris (#1186)>) 16[16] 2123.74 2115.32 +#23 (<Alexander Albon (#1187)>) 17[17] 2103.36 2094.27 +#63 (<George Russell (#1188)>) 18[18] 1884.84 1882.72 +#88 (<Robert Kubica (#1136)>) 19[19] 1872.28 1868.27 +#5 (<Sebastian Vettel (#1135)>) 20[20] 2325.65 2301.07 + +Podium rating: 7910.18 7913.62 +Average rating: 2196.7235 +Average rating change: 7.879 + +2019 German Grand Prix (2019-07-28) + +#33 (<Max Verstappen (#1172)>) 1[1] 2545.33 2585.01 +#5 (<Sebastian Vettel (#1135)>) 2[2] 2301.07 2374.62 +#26 (<Daniil Kvyat (#1166)>) 3[2] 2175.0 2291.74 +#18 (<Lance Stroll (#1181)>) 4[3] 2098.23 2212.35 +#55 (<Carlos Sainz (#1170)>) 5[3] 2229.6 2294.61 +#23 (<Alexander Albon (#1187)>) 6[4] 2094.27 2145.93 +#8 (<Romain Grosjean (#1144)>) 7[4] 2015.56 2097.65 +#20 (<Kevin Magnussen (#1165)>) 8[4] 1894.11 2068.22 +#44 (<Lewis Hamilton (#1140)>) 9[4] 2743.37 2635.02 +#88 (<Robert Kubica (#1136)>) 10[4] 1868.27 2051.9 +#63 (<George Russell (#1188)>) 11[5] 1882.72 1965.12 +#7 (<Kimi Räikkönen (#1141)>) 12[5] 2191.36 2126.05 +#99 (<Antonio Giovinazzi (#1180)>) 13[5] 1985.61 2024.39 +#10 (<Pierre Gasly (#1182)>) 14[6] 2277.48 2110.43 +#4 (<Lando Norris (#1186)>) R[0] 2115.32 2115.32 +#3 (<Daniel Ricciardo (#1157)>) R[0] 2187.33 2187.33 +#77 (<Valtteri Bottas (#1161)>) R[6] 2624.92 2379.57 +#27 (<Nico Hülkenberg (#1148)>) R[6] 2181.82 2048.02 +#16 (<Charles Leclerc (#1184)>) R[6] 2470.51 2252.72 +#11 (<Sergio Pérez (#1155)>) R[6] 2052.59 1968.46 + +Podium rating: 7021.4 7251.37 +Average rating: 2196.7235 +Average rating change: 113.530555556 + +2019 Hungarian Grand Prix - qualifying (2019-08-03) + +#33 (<Max Verstappen (#1172)>) 1[1] 2585.01 2587.45 +#77 (<Valtteri Bottas (#1161)>) 2[2] 2379.57 2385.28 +#44 (<Lewis Hamilton (#1140)>) 3[3] 2635.02 2633.51 +#16 (<Charles Leclerc (#1184)>) 4[4] 2252.72 2260.06 +#5 (<Sebastian Vettel (#1135)>) 5[5] 2374.62 2375.69 +#10 (<Pierre Gasly (#1182)>) 6[6] 2110.43 2121.27 +#4 (<Lando Norris (#1186)>) 7[7] 2115.32 2124.32 +#55 (<Carlos Sainz (#1170)>) 8[8] 2294.61 2293.8 +#8 (<Romain Grosjean (#1144)>) 9[9] 2097.65 2104.31 +#7 (<Kimi Räikkönen (#1141)>) 10[10] 2126.05 2129.73 +#27 (<Nico Hülkenberg (#1148)>) 11[11] 2048.02 2053.82 +#23 (<Alexander Albon (#1187)>) 12[12] 2145.93 2145.45 +#26 (<Daniil Kvyat (#1166)>) 13[13] 2291.74 2283.05 +#99 (<Antonio Giovinazzi (#1180)>) 14[14] 2024.39 2026.45 +#20 (<Kevin Magnussen (#1165)>) 15[15] 2068.22 2066.68 +#63 (<George Russell (#1188)>) 16[16] 1965.12 1965.88 +#11 (<Sergio Pérez (#1155)>) 17[17] 1968.46 1966.64 +#3 (<Daniel Ricciardo (#1157)>) 18[18] 2187.33 2173.66 +#18 (<Lance Stroll (#1181)>) 19[19] 2212.35 2195.91 +#88 (<Robert Kubica (#1136)>) 20[20] 2051.9 2041.52 + +Podium rating: 7599.6 7606.24 +Average rating: 2196.723 +Average rating change: 5.535 + +2019 Hungarian Grand Prix (2019-08-04) + +#44 (<Lewis Hamilton (#1140)>) 1[1] 2633.51 2650.41 +#33 (<Max Verstappen (#1172)>) 2[2] 2587.45 2587.07 +#5 (<Sebastian Vettel (#1135)>) 3[2] 2375.69 2424.15 +#16 (<Charles Leclerc (#1184)>) 4[3] 2260.06 2326.46 +#55 (<Carlos Sainz (#1170)>) 5[4] 2293.8 2254.84 +#10 (<Pierre Gasly (#1182)>) 6[4] 2121.27 2156.9 +#7 (<Kimi Räikkönen (#1141)>) 7[4] 2129.73 2161.5 +#77 (<Valtteri Bottas (#1161)>) 8[4] 2385.28 2314.77 +#4 (<Lando Norris (#1186)>) 9[4] 2124.32 2158.55 +#23 (<Alexander Albon (#1187)>) 10[4] 2145.45 2170.04 +#11 (<Sergio Pérez (#1155)>) 11[4] 1966.64 2111.73 +#27 (<Nico Hülkenberg (#1148)>) 12[4] 2053.82 2119.63 +#20 (<Kevin Magnussen (#1165)>) 13[4] 2066.68 2126.87 +#3 (<Daniel Ricciardo (#1157)>) 14[4] 2173.66 2185.44 +#26 (<Daniil Kvyat (#1166)>) 15[5] 2283.05 2128.26 +#63 (<George Russell (#1188)>) 16[5] 1965.88 1943.34 +#18 (<Lance Stroll (#1181)>) 17[5] 2195.91 2077.73 +#99 (<Antonio Giovinazzi (#1180)>) 18[5] 2026.45 1983.88 +#88 (<Robert Kubica (#1136)>) 19[6] 2041.52 1948.61 +#8 (<Romain Grosjean (#1144)>) R[0] 2104.31 2104.31 + +Podium rating: 7596.65 7661.63 +Average rating: 2196.724 +Average rating change: 56.9310526316 + diff --git a/sql/results.sql b/sql/results.sql index 511ba29..2a4862c 100644 --- a/sql/results.sql +++ b/sql/results.sql @@ -2663,6 +2663,10 @@ INSERT INTO `races` VALUES(2657, '2019 Austrian Grand Prix - qualifying', '2019- INSERT INTO `races` VALUES(2658, '2019 Austrian Grand Prix', '2019-06-30', 0, 4); INSERT INTO `races` VALUES(2659, '2019 British Grand Prix - qualifying', '2019-07-13', 0, 3); INSERT INTO `races` VALUES(2660, '2019 British Grand Prix', '2019-07-14', 0, 4); +INSERT INTO `races` VALUES(2661, '2019 German Grand Prix - qualifying', '2019-07-27', 0, 3); +INSERT INTO `races` VALUES(2662, '2019 German Grand Prix', '2019-07-28', 0, 4); +INSERT INTO `races` VALUES(2663, '2019 Hungarian Grand Prix - qualifying', '2019-08-03', 0, 3); +INSERT INTO `races` VALUES(2664, '2019 Hungarian Grand Prix', '2019-08-04', 0, 4); INSERT INTO `countries` VALUES(9, 'Argentina'); INSERT INTO `countries` VALUES(18, 'Australia'); @@ -60974,6 +60978,86 @@ INSERT INTO `entries` VALUES(57078, '17', 11, 6, 2660); INSERT INTO `entries` VALUES(57079, 'R', 99, 7, 2660); INSERT INTO `entries` VALUES(57080, 'R', 8, 7, 2660); INSERT INTO `entries` VALUES(57081, 'R', 20, 7, 2660); +INSERT INTO `entries` VALUES(57082, '1', 44, 1, 2661); +INSERT INTO `entries` VALUES(57083, '2', 33, 2, 2661); +INSERT INTO `entries` VALUES(57084, '3', 77, 3, 2661); +INSERT INTO `entries` VALUES(57085, '4', 10, 4, 2661); +INSERT INTO `entries` VALUES(57086, '5', 7, 5, 2661); +INSERT INTO `entries` VALUES(57087, '6', 8, 6, 2661); +INSERT INTO `entries` VALUES(57088, '7', 55, 7, 2661); +INSERT INTO `entries` VALUES(57089, '8', 11, 8, 2661); +INSERT INTO `entries` VALUES(57090, '9', 27, 9, 2661); +INSERT INTO `entries` VALUES(57091, '10', 16, 10, 2661); +INSERT INTO `entries` VALUES(57092, '11', 99, 11, 2661); +INSERT INTO `entries` VALUES(57093, '12', 20, 12, 2661); +INSERT INTO `entries` VALUES(57094, '13', 3, 13, 2661); +INSERT INTO `entries` VALUES(57095, '14', 26, 14, 2661); +INSERT INTO `entries` VALUES(57096, '15', 18, 15, 2661); +INSERT INTO `entries` VALUES(57097, '16', 4, 16, 2661); +INSERT INTO `entries` VALUES(57098, '17', 23, 17, 2661); +INSERT INTO `entries` VALUES(57099, '18', 63, 18, 2661); +INSERT INTO `entries` VALUES(57100, '19', 88, 19, 2661); +INSERT INTO `entries` VALUES(57101, '20', 5, 20, 2661); +INSERT INTO `entries` VALUES(57102, '1', 33, 1, 2662); +INSERT INTO `entries` VALUES(57103, '2', 5, 2, 2662); +INSERT INTO `entries` VALUES(57104, '3', 26, 2, 2662); +INSERT INTO `entries` VALUES(57105, '4', 18, 3, 2662); +INSERT INTO `entries` VALUES(57106, '5', 55, 3, 2662); +INSERT INTO `entries` VALUES(57107, '6', 23, 4, 2662); +INSERT INTO `entries` VALUES(57108, '7', 8, 4, 2662); +INSERT INTO `entries` VALUES(57109, '8', 20, 4, 2662); +INSERT INTO `entries` VALUES(57110, '9', 44, 4, 2662); +INSERT INTO `entries` VALUES(57111, '10', 88, 4, 2662); +INSERT INTO `entries` VALUES(57112, '11', 63, 5, 2662); +INSERT INTO `entries` VALUES(57113, '12', 7, 5, 2662); +INSERT INTO `entries` VALUES(57114, '13', 99, 5, 2662); +INSERT INTO `entries` VALUES(57115, '14', 10, 6, 2662); +INSERT INTO `entries` VALUES(57116, 'R', 77, 6, 2662); +INSERT INTO `entries` VALUES(57117, 'R', 27, 6, 2662); +INSERT INTO `entries` VALUES(57118, 'R', 16, 6, 2662); +INSERT INTO `entries` VALUES(57119, 'R', 4, 0, 2662); +INSERT INTO `entries` VALUES(57120, 'R', 3, 0, 2662); +INSERT INTO `entries` VALUES(57121, 'R', 11, 6, 2662); +INSERT INTO `entries` VALUES(57122, '1', 33, 1, 2663); +INSERT INTO `entries` VALUES(57123, '2', 77, 2, 2663); +INSERT INTO `entries` VALUES(57124, '3', 44, 3, 2663); +INSERT INTO `entries` VALUES(57125, '4', 16, 4, 2663); +INSERT INTO `entries` VALUES(57126, '5', 5, 5, 2663); +INSERT INTO `entries` VALUES(57127, '6', 10, 6, 2663); +INSERT INTO `entries` VALUES(57128, '7', 4, 7, 2663); +INSERT INTO `entries` VALUES(57129, '8', 55, 8, 2663); +INSERT INTO `entries` VALUES(57130, '9', 8, 9, 2663); +INSERT INTO `entries` VALUES(57131, '10', 7, 10, 2663); +INSERT INTO `entries` VALUES(57132, '11', 27, 11, 2663); +INSERT INTO `entries` VALUES(57133, '12', 23, 12, 2663); +INSERT INTO `entries` VALUES(57134, '13', 26, 13, 2663); +INSERT INTO `entries` VALUES(57135, '14', 99, 14, 2663); +INSERT INTO `entries` VALUES(57136, '15', 20, 15, 2663); +INSERT INTO `entries` VALUES(57137, '16', 63, 16, 2663); +INSERT INTO `entries` VALUES(57138, '17', 11, 17, 2663); +INSERT INTO `entries` VALUES(57139, '18', 3, 18, 2663); +INSERT INTO `entries` VALUES(57140, '19', 18, 19, 2663); +INSERT INTO `entries` VALUES(57141, '20', 88, 20, 2663); +INSERT INTO `entries` VALUES(57142, '1', 44, 1, 2664); +INSERT INTO `entries` VALUES(57143, '2', 33, 2, 2664); +INSERT INTO `entries` VALUES(57144, '3', 5, 2, 2664); +INSERT INTO `entries` VALUES(57145, '4', 16, 3, 2664); +INSERT INTO `entries` VALUES(57146, '5', 55, 4, 2664); +INSERT INTO `entries` VALUES(57147, '6', 10, 4, 2664); +INSERT INTO `entries` VALUES(57148, '7', 7, 4, 2664); +INSERT INTO `entries` VALUES(57149, '8', 77, 4, 2664); +INSERT INTO `entries` VALUES(57150, '9', 4, 4, 2664); +INSERT INTO `entries` VALUES(57151, '10', 23, 4, 2664); +INSERT INTO `entries` VALUES(57152, '11', 11, 4, 2664); +INSERT INTO `entries` VALUES(57153, '12', 27, 4, 2664); +INSERT INTO `entries` VALUES(57154, '13', 20, 4, 2664); +INSERT INTO `entries` VALUES(57155, '14', 3, 4, 2664); +INSERT INTO `entries` VALUES(57156, '15', 26, 5, 2664); +INSERT INTO `entries` VALUES(57157, '16', 63, 5, 2664); +INSERT INTO `entries` VALUES(57158, '17', 18, 5, 2664); +INSERT INTO `entries` VALUES(57159, '18', 99, 5, 2664); +INSERT INTO `entries` VALUES(57160, '19', 88, 6, 2664); +INSERT INTO `entries` VALUES(57161, 'R', 8, 0, 2664); INSERT INTO `driver_entries` VALUES(1, 1, 1); INSERT INTO `driver_entries` VALUES(2, 2, 2); @@ -118196,3 +118280,83 @@ INSERT INTO `driver_entries` VALUES(1155, 57078, 57218); INSERT INTO `driver_entries` VALUES(1180, 57079, 57219); INSERT INTO `driver_entries` VALUES(1144, 57080, 57220); INSERT INTO `driver_entries` VALUES(1165, 57081, 57221); +INSERT INTO `driver_entries` VALUES(1140, 57082, 57222); +INSERT INTO `driver_entries` VALUES(1172, 57083, 57223); +INSERT INTO `driver_entries` VALUES(1161, 57084, 57224); +INSERT INTO `driver_entries` VALUES(1182, 57085, 57225); +INSERT INTO `driver_entries` VALUES(1141, 57086, 57226); +INSERT INTO `driver_entries` VALUES(1144, 57087, 57227); +INSERT INTO `driver_entries` VALUES(1170, 57088, 57228); +INSERT INTO `driver_entries` VALUES(1155, 57089, 57229); +INSERT INTO `driver_entries` VALUES(1148, 57090, 57230); +INSERT INTO `driver_entries` VALUES(1184, 57091, 57231); +INSERT INTO `driver_entries` VALUES(1180, 57092, 57232); +INSERT INTO `driver_entries` VALUES(1165, 57093, 57233); +INSERT INTO `driver_entries` VALUES(1157, 57094, 57234); +INSERT INTO `driver_entries` VALUES(1166, 57095, 57235); +INSERT INTO `driver_entries` VALUES(1181, 57096, 57236); +INSERT INTO `driver_entries` VALUES(1186, 57097, 57237); +INSERT INTO `driver_entries` VALUES(1187, 57098, 57238); +INSERT INTO `driver_entries` VALUES(1188, 57099, 57239); +INSERT INTO `driver_entries` VALUES(1136, 57100, 57240); +INSERT INTO `driver_entries` VALUES(1135, 57101, 57241); +INSERT INTO `driver_entries` VALUES(1172, 57102, 57242); +INSERT INTO `driver_entries` VALUES(1135, 57103, 57243); +INSERT INTO `driver_entries` VALUES(1166, 57104, 57244); +INSERT INTO `driver_entries` VALUES(1181, 57105, 57245); +INSERT INTO `driver_entries` VALUES(1170, 57106, 57246); +INSERT INTO `driver_entries` VALUES(1187, 57107, 57247); +INSERT INTO `driver_entries` VALUES(1144, 57108, 57248); +INSERT INTO `driver_entries` VALUES(1165, 57109, 57249); +INSERT INTO `driver_entries` VALUES(1140, 57110, 57250); +INSERT INTO `driver_entries` VALUES(1136, 57111, 57251); +INSERT INTO `driver_entries` VALUES(1188, 57112, 57252); +INSERT INTO `driver_entries` VALUES(1141, 57113, 57253); +INSERT INTO `driver_entries` VALUES(1180, 57114, 57254); +INSERT INTO `driver_entries` VALUES(1182, 57115, 57255); +INSERT INTO `driver_entries` VALUES(1161, 57116, 57256); +INSERT INTO `driver_entries` VALUES(1148, 57117, 57257); +INSERT INTO `driver_entries` VALUES(1184, 57118, 57258); +INSERT INTO `driver_entries` VALUES(1186, 57119, 57259); +INSERT INTO `driver_entries` VALUES(1157, 57120, 57260); +INSERT INTO `driver_entries` VALUES(1155, 57121, 57261); +INSERT INTO `driver_entries` VALUES(1172, 57122, 57262); +INSERT INTO `driver_entries` VALUES(1161, 57123, 57263); +INSERT INTO `driver_entries` VALUES(1140, 57124, 57264); +INSERT INTO `driver_entries` VALUES(1184, 57125, 57265); +INSERT INTO `driver_entries` VALUES(1135, 57126, 57266); +INSERT INTO `driver_entries` VALUES(1182, 57127, 57267); +INSERT INTO `driver_entries` VALUES(1186, 57128, 57268); +INSERT INTO `driver_entries` VALUES(1170, 57129, 57269); +INSERT INTO `driver_entries` VALUES(1144, 57130, 57270); +INSERT INTO `driver_entries` VALUES(1141, 57131, 57271); +INSERT INTO `driver_entries` VALUES(1148, 57132, 57272); +INSERT INTO `driver_entries` VALUES(1187, 57133, 57273); +INSERT INTO `driver_entries` VALUES(1166, 57134, 57274); +INSERT INTO `driver_entries` VALUES(1180, 57135, 57275); +INSERT INTO `driver_entries` VALUES(1165, 57136, 57276); +INSERT INTO `driver_entries` VALUES(1188, 57137, 57277); +INSERT INTO `driver_entries` VALUES(1155, 57138, 57278); +INSERT INTO `driver_entries` VALUES(1157, 57139, 57279); +INSERT INTO `driver_entries` VALUES(1181, 57140, 57280); +INSERT INTO `driver_entries` VALUES(1136, 57141, 57281); +INSERT INTO `driver_entries` VALUES(1140, 57142, 57282); +INSERT INTO `driver_entries` VALUES(1172, 57143, 57283); +INSERT INTO `driver_entries` VALUES(1135, 57144, 57284); +INSERT INTO `driver_entries` VALUES(1184, 57145, 57285); +INSERT INTO `driver_entries` VALUES(1170, 57146, 57286); +INSERT INTO `driver_entries` VALUES(1182, 57147, 57287); +INSERT INTO `driver_entries` VALUES(1141, 57148, 57288); +INSERT INTO `driver_entries` VALUES(1161, 57149, 57289); +INSERT INTO `driver_entries` VALUES(1186, 57150, 57290); +INSERT INTO `driver_entries` VALUES(1187, 57151, 57291); +INSERT INTO `driver_entries` VALUES(1155, 57152, 57292); +INSERT INTO `driver_entries` VALUES(1148, 57153, 57293); +INSERT INTO `driver_entries` VALUES(1165, 57154, 57294); +INSERT INTO `driver_entries` VALUES(1157, 57155, 57295); +INSERT INTO `driver_entries` VALUES(1166, 57156, 57296); +INSERT INTO `driver_entries` VALUES(1188, 57157, 57297); +INSERT INTO `driver_entries` VALUES(1181, 57158, 57298); +INSERT INTO `driver_entries` VALUES(1180, 57159, 57299); +INSERT INTO `driver_entries` VALUES(1136, 57160, 57300); +INSERT INTO `driver_entries` VALUES(1144, 57161, 57301); |