blob: f11e8b2c8b198ff5533c9006cf1d124e1f97f673 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
Tables:
- all-time peak ratings
- top exit ratings (date < 2014)
- peak rating progression
Charts:
- rolling average and deviation of rankings
- average ranking at the beginning of each championship season
- peak season ranking (MAX, MIN, AVG, STDDEV GROUP BY YEAR(date))
- top 5 of every season (on average) by decade
Calculation:
- modifying disparity by time of year (or by ranking deviation from last 3-4 months)
TODO:
- detect grid penalties (ergast.races.grid != eragst.qualifying.position) -> ergast-qualifying.csv
- non-ergast.qualifying.position != ergast.races.grid (chicane-results.csv -> temp db -> chicane-results.csv)
- detect multi-heat (NC) races on chicanef1
|
