Back to feed

Project docs

Ski Jumping Statistics

PostgreSQL analysis of men's Ski Jumping World Cup results, supported by a Python data collection pipeline.

Biggest Second-Round Climbs

The largest gains in position between the end of the first round and the final competition standings.

Rules

  • Each athlete’s position after the first round is compared with their final position in the competition.
  • The improvement is calculated by subtracting the final position from the first-round position. For example, an athlete who moves from 30th after the first round to 5th overall records an advancement of 25 positions.
  • Results are ordered by the size of the improvement, from the largest climb downward.

Reusing competition rankings

This analysis combines the round_results view with the competition_results materialized view created earlier.

Code

select
	to_char(c.competition_started, 'Mon MM YYYY') as date,
	c.hill_city || ' HS' || c.hill_size as hill,
	j.jumper_name as jumper,
    rr.pos - cr.pos as climb,
	rr.pos as first_round_position,
	cr.pos as final_position
from competition_results cr
join round_results rr on
	cr.race_id = rr.race_id
	and cr.jumper_id = rr.jumper_id
	and rr.round_no = 1
join competitions c on cr.race_id = c.race_id
join jumpers j on cr.jumper_id = j.jumper_id
order by climb desc
limit 20

Results

20 biggest second-round climbs20 rows
datehilljumperclimbfirst_round_positionfinal_position
Jan 01 2026Zakopane HS140FORFANG Johann Andre24306
Dec 12 2020Nizhny Tagil HS134JOHANSSON Robert22253
Dec 12 2020Oberstdorf HS137EISENBICHLER Markus22275
Jan 01 2021Innsbruck HS128GEIGER Karl213716
Jan 01 2022Bischofshofen HS142KOS Lovro204525
Jan 01 2021Innsbruck HS128GRANERUD Halvor Egner203515
Nov 11 2021Ruka HS142KRAFT Stefan19267
Dec 12 2017Oberstdorf HS137FORFANG Johann Andre18257
Jan 01 2026Zakopane HS140EMBACHER Stephan18235
Feb 02 2021Zakopane HS140JOHANSSON Robert17203
Dec 12 2017Nizhny Tagil HS134WELLINGER Andreas17214
Jan 01 2026Zakopane HS140FOUBERT Valentin172912
Dec 12 2021Oberstdorf HS137TROFIMOV Roman174124
Nov 11 2021Ruka HS142PREVC Peter172811
Jan 01 2026Zakopane HS140BICKNER Kevin172710
Feb 02 2024Willingen HS147HOERL Jan172912
Jan 01 2024Innsbruck HS128KOBAYASHI Junshiro164630
Nov 11 2024Lillehammer HS140WELLINGER Andreas162812
Jan 01 2020Innsbruck HS130ASCHENWALD Philipp162913
Dec 12 2018Nizhny Tagil HS134AALTO Antti162812