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.

Jumpers by Country

A country-by-country count of jumpers represented in the dataset, based on competitions recorded since the 2017/18 season.

Rules

  • Each jumper is counted once for the country assigned to them in the dataset.
  • The dataset covers competitions recorded from the 2017/18 season onward.

Code

select
	jumper_country as country,
	count(*) as number_of_jumpers
from jumpers
group by jumper_country
order by number_of_jumpers desc

Results

Jumpers by country returned by PostgreSQL23 rows
countrynumber_of_jumpers
AUT35
NOR26
SLO25
FIN20
GER19
JPN19
POL17
RUS17
SUI12
USA9
CZE8
KAZ8
FRA8
ITA7
EST4
ROU4
TUR3
UKR2
KOR2
CHN2
CAN2
SVK1
BUL1