blob: a110c721e2294bd378ccc6a0862dc371a94e8e93 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
Tables:
- all-time peak ratings
- top exit ratings (date < 2014)
- peak rating progression
- highest/lowest ranked podiums
- races with biggest changes
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
WISHLIST:
- 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
|
