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.

Longest Jumps

The longest jumps recorded in rated competition rounds, ordered by distance regardless of their style scores.

Rules

  • Only jumps from rated competition rounds are included.
  • Style scores are ignored, so the list may contain jumps that are not officially recognized as records because of a fall or hand contact on landing.

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,
	distance
from results
join jumpers j using (jumper_id)
join competitions c using (race_id)
order by distance desc

Results

First 100 longest jumps returned by PostgreSQL100 rows
datehilljumperdistance
Mar 03 2025Planica HS240PREVC Domen254.5
Mar 03 2019Planica HS240KOBAYASHI Ryoyu252
Mar 03 2021Planica HS240PAVLOVCIC Bor249.5
Mar 03 2019Planica HS240ZYLA Piotr248
Mar 03 2024Vikersund HS240HUBER Daniel247.5
Mar 03 2025Planica HS240LANISEK Anze247.5
Mar 03 2024Planica HS240HUBER Daniel247
Mar 03 2025Vikersund HS240PREVC Domen247
Mar 03 2023Vikersund HS240KRAFT Stefan246.5
Mar 03 2018Vikersund HS240JOHANSSON Robert246
Mar 03 2022Planica HS240PREVC Cene246
Mar 03 2026Kulm HS235PREVC Domen245.5
Mar 03 2022Planica HS240LINDVIK Marius245.5
Mar 03 2018Planica HS240STOCH Kamil245
Mar 03 2018Planica HS240STOCH Kamil245
Mar 03 2021Planica HS240HAYBOECK Michael245
Mar 03 2025Planica HS240PREVC Domen245
Mar 03 2018Planica HS240JOHANSSON Robert245
Mar 03 2022Planica HS240LANISEK Anze244.5
Mar 03 2024Vikersund HS240KRAFT Stefan244.5
Mar 03 2021Planica HS240KOBAYASHI Ryoyu244.5
Mar 03 2022Planica HS240HAYBOECK Michael244.5
Mar 03 2024Vikersund HS240HUBER Daniel244
Mar 03 2022Planica HS240GRANERUD Halvor Egner243.5
Mar 03 2018Planica HS240TANDE Daniel Andre243.5
Mar 03 2024Vikersund HS240PREVC Peter243.5
Mar 03 2018Vikersund HS240TANDE Daniel Andre243
Jan 01 2023Kulm Mitterndorf HS235ZAJC Timi243
Mar 03 2018Planica HS240KRAFT Stefan243
Mar 03 2024Vikersund HS240ZNISZCZOL Aleksander243
Mar 03 2022Planica HS240SATO Yukiya242.5
Mar 03 2024Planica HS240HUBER Daniel242.5
Feb 02 2020Tauplitz/ Bad Mitterndorf HS235KOBAYASHI Ryoyu242.5
Mar 03 2025Planica HS240HOERL Jan242.5
Mar 03 2026Kulm HS235NAITO Tomofumi242.5
Mar 03 2025Planica HS240LANISEK Anze242
Mar 03 2021Planica HS240KOBAYASHI Ryoyu242
Apr 04 2023Planica HS240LANISEK Anze242
Mar 03 2019Planica HS240KOBAYASHI Ryoyu242
Mar 03 2022Planica HS240GEIGER Karl242
Mar 03 2019Planica HS240ZYLA Piotr242
Mar 03 2018Planica HS240FORFANG Johann Andre242
Feb 02 2020Tauplitz/ Bad Mitterndorf HS235LINDVIK Marius242
Mar 03 2022Planica HS240WELLINGER Andreas241.5
Mar 03 2025Planica HS240LANISEK Anze241.5
Apr 04 2023Planica HS240ZYLA Piotr241.5
Mar 03 2022Planica HS240LINDVIK Marius241.5
Mar 03 2019Vikersund HS240PREVC Domen241
Mar 03 2022Planica HS240PREVC Cene241
Mar 03 2019Planica HS240SEMENIC Anze241
Mar 03 2026Planica HS240PREVC Domen240.5
Apr 04 2023Planica HS240EISENBICHLER Markus240.5
Mar 03 2018Planica HS240FORFANG Johann Andre240.5
Mar 03 2023Vikersund HS240PREVC Domen240.5
Mar 03 2024Vikersund HS240HUBER Daniel240.5
Mar 03 2026Kulm HS235EMBACHER Stephan240.5
Apr 04 2023Planica HS240WELLINGER Andreas240.5
Jan 01 2018Tauplitz/ Bad Mitterndorf HS235TANDE Daniel Andre240.5
Mar 03 2019Planica HS240ZAJC Timi240
Mar 03 2022Planica HS240PREVC Peter240
Mar 03 2022Planica HS240ZAJC Timi240
Mar 03 2026Vikersund HS240NAITO Tomofumi240
Mar 03 2026Planica HS240EMBACHER Stephan240
Mar 03 2024Planica HS240JOHANSSON Robert240
Apr 04 2023Planica HS240HOERL Jan240
Mar 03 2024Planica HS240ZYLA Piotr240
Mar 03 2024Vikersund HS240KRAFT Stefan240
Apr 04 2023Planica HS240LANISEK Anze239.5
Mar 03 2024Planica HS240KRAFT Stefan239.5
Mar 03 2018Vikersund HS240PREVC Domen239.5
Mar 03 2019Planica HS240PREVC Domen239.5
Apr 04 2023Planica HS240KRAFT Stefan239.5
Mar 03 2023Vikersund HS240KRAFT Stefan239.5
Mar 03 2025Planica HS240KOBAYASHI Ryoyu239.5
Mar 03 2021Planica HS240GRANERUD Halvor Egner239
Mar 03 2018Vikersund HS240STJERNEN Andreas239
Mar 03 2026Planica HS240FOUBERT Valentin239
Mar 03 2022Planica HS240JELAR Ziga239
Mar 03 2019Vikersund HS240KOBAYASHI Ryoyu239
Mar 03 2026Vikersund HS240FORFANG Johann Andre239
Mar 03 2024Planica HS240JOHANSSON Robert239
Mar 03 2025Vikersund HS240PREVC Domen239
Mar 03 2021Planica HS240ZYLA Piotr239
Mar 03 2022Planica HS240JELAR Ziga239
Apr 04 2023Planica HS240KOBAYASHI Ryoyu239
Mar 03 2019Planica HS240GEIGER Karl238.5
Mar 03 2019Planica HS240EISENBICHLER Markus238.5
Mar 03 2021Planica HS240EISENBICHLER Markus238.5
Mar 03 2022Planica HS240SATO Yukiya238.5
Apr 04 2023Planica HS240KRAFT Stefan238.5
Mar 03 2026Planica HS240LINDVIK Marius238.5
Mar 03 2026Planica HS240WELLINGER Andreas238.5
Jan 01 2023Kulm Mitterndorf HS235GRANERUD Halvor Egner238
Mar 03 2026Planica HS240TSCHOFENIG Daniel238
Mar 03 2024Planica HS240PREVC Domen238
Mar 03 2021Planica HS240GEIGER Karl238
Mar 03 2025Planica HS240ZNISZCZOL Aleksander238
Mar 03 2019Planica HS240AMMANN Simon238
Mar 03 2026Kulm HS235PREVC Domen238
Mar 03 2018Planica HS240KRAFT Stefan238