From a8b29e5ab593dfa8056e15492ace0932d7a816b3 Mon Sep 17 00:00:00 2001 From: emkael Date: Sat, 27 Oct 2018 01:04:08 +0200 Subject: 2018 USGP --- rate.log | 54 +++++++++++++++++++++++++++++++++++++ sql/results.sql | 82 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 136 insertions(+) diff --git a/rate.log b/rate.log index 943efb8..4e66c65 100644 --- a/rate.log +++ b/rate.log @@ -74943,3 +74943,57 @@ Podium rating: 7658.43 7722.65 Average rating: 2181.1625 Average rating change: 39.8366666667 +2018 United States Grand Prix - qualifying (2018-10-20) + +#44 () 1[1] 2694.14 2695.59 +#5 () 2[2] 2445.33 2449.85 +#7 () 3[3] 2498.23 2499.91 +#77 () 4[4] 2528.88 2528.3 +#3 () 5[5] 2361.72 2363.64 +#31 () 6[6] 2125.71 2134.55 +#27 () 7[7] 2049.92 2060.69 +#8 () 8[8] 2136.51 2141.67 +#16 () 9[9] 2145.28 2148.46 +#11 () 10[10] 2176.07 2176.34 +#55 () 11[11] 1991.35 1999.99 +#20 () 12[12] 1937.53 1946.87 +#10 () 13[13] 2046.78 2046.49 +#28 () 14[14] 2005.54 2005.6 +#33 () 15[15] 2499.63 2480.48 +#14 () 16[16] 2069.59 2063.42 +#35 () 17[17] 1913.28 1911.89 +#18 () 18[18] 2019.37 2011.58 +#9 () 19[19] 2016.5 2007.25 +#2 () 20[20] 1961.89 1950.67 + +Podium rating: 7637.7 7645.35 +Average rating: 2181.1625 +Average rating change: 5.5835 + +2018 United States Grand Prix (2018-10-21) + +#7 () 1[1] 2499.91 2543.95 +#33 () 2[2] 2480.48 2504.47 +#44 () 3[2] 2695.59 2684.55 +#5 () 4[3] 2449.85 2448.33 +#77 () 5[3] 2528.3 2510.83 +#27 () 6[4] 2060.69 2144.99 +#55 () 7[4] 1999.99 2154.83 +#11 () 8[4] 2176.34 2210.38 +#28 () 9[5] 2005.6 2039.4 +#9 () 10[5] 2007.25 2040.29 +#2 () 11[5] 1950.67 2037.93 +#10 () 12[5] 2046.49 2061.37 +#35 () 13[5] 1911.89 2019.53 +#18 () 14[6] 2011.58 1986.63 +#3 () R[0] 2363.64 2363.64 +#16 () R[7] 2148.46 2029.81 +#8 () R[7] 2141.67 2025.87 +#14 () R[7] 2063.42 1982.46 +#31 () D[8] 2134.55 1977.77 +#20 () D[8] 1946.87 1856.21 + +Podium rating: 7675.98 7732.97 +Average rating: 2181.162 +Average rating change: 65.0347368421 + diff --git a/sql/results.sql b/sql/results.sql index a5c8129..c08c265 100644 --- a/sql/results.sql +++ b/sql/results.sql @@ -2635,6 +2635,8 @@ INSERT INTO `races` VALUES(2629, '2018 Russian Grand Prix - qualifying', '2018-0 INSERT INTO `races` VALUES(2630, '2018 Russian Grand Prix', '2018-09-30', 0, 4); INSERT INTO `races` VALUES(2631, '2018 Japanese Grand Prix - qualifying', '2018-10-06', 0, 3); INSERT INTO `races` VALUES(2632, '2018 Japanese Grand Prix', '2018-10-07', 0, 4); +INSERT INTO `races` VALUES(2633, '2018 United States Grand Prix - qualifying', '2018-10-20', 0, 3); +INSERT INTO `races` VALUES(2634, '2018 United States Grand Prix', '2018-10-21', 0, 4); INSERT INTO `countries` VALUES(9, 'Argentina'); INSERT INTO `countries` VALUES(18, 'Australia'); @@ -60385,6 +60387,46 @@ INSERT INTO `entries` VALUES(56520, '17', 18, 5, 2632); INSERT INTO `entries` VALUES(56521, 'R', 16, 0, 2632); INSERT INTO `entries` VALUES(56522, 'R', 27, 0, 2632); INSERT INTO `entries` VALUES(56523, 'R', 20, 6, 2632); +INSERT INTO `entries` VALUES(56524, '1', 44, 1, 2633); +INSERT INTO `entries` VALUES(56525, '2', 5, 2, 2633); +INSERT INTO `entries` VALUES(56526, '3', 7, 3, 2633); +INSERT INTO `entries` VALUES(56527, '4', 77, 4, 2633); +INSERT INTO `entries` VALUES(56528, '5', 3, 5, 2633); +INSERT INTO `entries` VALUES(56529, '6', 31, 6, 2633); +INSERT INTO `entries` VALUES(56530, '7', 27, 7, 2633); +INSERT INTO `entries` VALUES(56531, '8', 8, 8, 2633); +INSERT INTO `entries` VALUES(56532, '9', 16, 9, 2633); +INSERT INTO `entries` VALUES(56533, '10', 11, 10, 2633); +INSERT INTO `entries` VALUES(56534, '11', 55, 11, 2633); +INSERT INTO `entries` VALUES(56535, '12', 20, 12, 2633); +INSERT INTO `entries` VALUES(56536, '13', 10, 13, 2633); +INSERT INTO `entries` VALUES(56537, '14', 28, 14, 2633); +INSERT INTO `entries` VALUES(56538, '15', 33, 15, 2633); +INSERT INTO `entries` VALUES(56539, '16', 14, 16, 2633); +INSERT INTO `entries` VALUES(56540, '17', 35, 17, 2633); +INSERT INTO `entries` VALUES(56541, '18', 18, 18, 2633); +INSERT INTO `entries` VALUES(56542, '19', 9, 19, 2633); +INSERT INTO `entries` VALUES(56543, '20', 2, 20, 2633); +INSERT INTO `entries` VALUES(56544, '1', 7, 1, 2634); +INSERT INTO `entries` VALUES(56545, '2', 33, 2, 2634); +INSERT INTO `entries` VALUES(56546, '3', 44, 2, 2634); +INSERT INTO `entries` VALUES(56547, '4', 5, 3, 2634); +INSERT INTO `entries` VALUES(56548, '5', 77, 3, 2634); +INSERT INTO `entries` VALUES(56549, '6', 27, 4, 2634); +INSERT INTO `entries` VALUES(56550, '7', 55, 4, 2634); +INSERT INTO `entries` VALUES(56551, '8', 11, 4, 2634); +INSERT INTO `entries` VALUES(56552, '9', 28, 5, 2634); +INSERT INTO `entries` VALUES(56553, '10', 9, 5, 2634); +INSERT INTO `entries` VALUES(56554, '11', 2, 5, 2634); +INSERT INTO `entries` VALUES(56555, '12', 10, 5, 2634); +INSERT INTO `entries` VALUES(56556, '13', 35, 5, 2634); +INSERT INTO `entries` VALUES(56557, '14', 18, 6, 2634); +INSERT INTO `entries` VALUES(56558, 'R', 16, 7, 2634); +INSERT INTO `entries` VALUES(56559, 'R', 3, 0, 2634); +INSERT INTO `entries` VALUES(56560, 'R', 8, 7, 2634); +INSERT INTO `entries` VALUES(56561, 'R', 14, 7, 2634); +INSERT INTO `entries` VALUES(56562, 'D', 31, 8, 2634); +INSERT INTO `entries` VALUES(56563, 'D', 20, 8, 2634); INSERT INTO `driver_entries` VALUES(1, 1, 1); INSERT INTO `driver_entries` VALUES(2, 2, 2); @@ -117049,3 +117091,43 @@ INSERT INTO `driver_entries` VALUES(1181, 56520, 56660); INSERT INTO `driver_entries` VALUES(1184, 56521, 56661); INSERT INTO `driver_entries` VALUES(1148, 56522, 56662); INSERT INTO `driver_entries` VALUES(1165, 56523, 56663); +INSERT INTO `driver_entries` VALUES(1140, 56524, 56664); +INSERT INTO `driver_entries` VALUES(1135, 56525, 56665); +INSERT INTO `driver_entries` VALUES(1141, 56526, 56666); +INSERT INTO `driver_entries` VALUES(1161, 56527, 56667); +INSERT INTO `driver_entries` VALUES(1157, 56528, 56668); +INSERT INTO `driver_entries` VALUES(1179, 56529, 56669); +INSERT INTO `driver_entries` VALUES(1148, 56530, 56670); +INSERT INTO `driver_entries` VALUES(1144, 56531, 56671); +INSERT INTO `driver_entries` VALUES(1184, 56532, 56672); +INSERT INTO `driver_entries` VALUES(1155, 56533, 56673); +INSERT INTO `driver_entries` VALUES(1170, 56534, 56674); +INSERT INTO `driver_entries` VALUES(1165, 56535, 56675); +INSERT INTO `driver_entries` VALUES(1182, 56536, 56676); +INSERT INTO `driver_entries` VALUES(1183, 56537, 56677); +INSERT INTO `driver_entries` VALUES(1172, 56538, 56678); +INSERT INTO `driver_entries` VALUES(1127, 56539, 56679); +INSERT INTO `driver_entries` VALUES(1185, 56540, 56680); +INSERT INTO `driver_entries` VALUES(1181, 56541, 56681); +INSERT INTO `driver_entries` VALUES(1167, 56542, 56682); +INSERT INTO `driver_entries` VALUES(1178, 56543, 56683); +INSERT INTO `driver_entries` VALUES(1141, 56544, 56684); +INSERT INTO `driver_entries` VALUES(1172, 56545, 56685); +INSERT INTO `driver_entries` VALUES(1140, 56546, 56686); +INSERT INTO `driver_entries` VALUES(1135, 56547, 56687); +INSERT INTO `driver_entries` VALUES(1161, 56548, 56688); +INSERT INTO `driver_entries` VALUES(1148, 56549, 56689); +INSERT INTO `driver_entries` VALUES(1170, 56550, 56690); +INSERT INTO `driver_entries` VALUES(1155, 56551, 56691); +INSERT INTO `driver_entries` VALUES(1183, 56552, 56692); +INSERT INTO `driver_entries` VALUES(1167, 56553, 56693); +INSERT INTO `driver_entries` VALUES(1178, 56554, 56694); +INSERT INTO `driver_entries` VALUES(1182, 56555, 56695); +INSERT INTO `driver_entries` VALUES(1185, 56556, 56696); +INSERT INTO `driver_entries` VALUES(1181, 56557, 56697); +INSERT INTO `driver_entries` VALUES(1184, 56558, 56698); +INSERT INTO `driver_entries` VALUES(1157, 56559, 56699); +INSERT INTO `driver_entries` VALUES(1144, 56560, 56700); +INSERT INTO `driver_entries` VALUES(1127, 56561, 56701); +INSERT INTO `driver_entries` VALUES(1179, 56562, 56702); +INSERT INTO `driver_entries` VALUES(1165, 56563, 56703); -- cgit v1.2.3