Throw Competitions Top 100 Marks
Discus, shot and javeline
@kaggle.ricfraga_throw_competition_data
Discus, shot and javeline
@kaggle.ricfraga_throw_competition_data
Throw competitions have always been amazing to me and recently I had a doubt, which throwing competition has the biggest scores? That information was too easy to get, so I decided to get the top 100 sport people from hammer, discus, shot, and, javelin. I found a page that keeps track of all this information but there was no way to download it, so I created a web scraper to get this data.
This dataset contains the information about the top 100 sport people from each discipline, including rank, mark, competitor, day of birth, nationality, position, venue, date, and result score.
All credit for this information belongs to world athletics, check out their page, it has a lot of interesting information about sports.
There are some questions that could be addressed with this information:
An interesting problem that could be addressed by adding information could be to predict an athlete performance based on height, weight and age.
CREATE TABLE discus_throw_men (
"unnamed_0" BIGINT -- Unnamed: 0,
"rank" BIGINT,
"mark" DOUBLE,
"competitor" VARCHAR,
"dob" VARCHAR,
"nationality" VARCHAR,
"position" VARCHAR,
"venue" VARCHAR,
"date" VARCHAR,
"result_score" BIGINT
);
CREATE TABLE discus_trow_women (
"unnamed_0" BIGINT -- Unnamed: 0,
"rank" BIGINT,
"mark" DOUBLE,
"competitor" VARCHAR,
"dob" VARCHAR,
"nationality" VARCHAR,
"position" DOUBLE,
"venue" VARCHAR,
"date" VARCHAR,
"result_score" BIGINT
);
CREATE TABLE hammer_throw_men (
"unnamed_0" BIGINT -- Unnamed: 0,
"rank" BIGINT,
"mark" DOUBLE,
"competitor" VARCHAR,
"dob" VARCHAR,
"nationality" VARCHAR,
"position" BIGINT,
"venue" VARCHAR,
"date" VARCHAR,
"result_score" BIGINT
);
CREATE TABLE hammer_throw_women (
"unnamed_0" BIGINT -- Unnamed: 0,
"rank" BIGINT,
"mark" DOUBLE,
"competitor" VARCHAR,
"dob" VARCHAR,
"nationality" VARCHAR,
"position" VARCHAR,
"venue" VARCHAR,
"date" VARCHAR,
"result_score" BIGINT
);
CREATE TABLE javelin_throw_men (
"unnamed_0" BIGINT -- Unnamed: 0,
"rank" BIGINT,
"mark" DOUBLE,
"competitor" VARCHAR,
"dob" VARCHAR,
"nationality" VARCHAR,
"position" VARCHAR,
"venue" VARCHAR,
"date" VARCHAR,
"result_score" BIGINT
);
CREATE TABLE javelin_throw_women (
"unnamed_0" BIGINT -- Unnamed: 0,
"rank" BIGINT,
"mark" DOUBLE,
"competitor" VARCHAR,
"dob" VARCHAR,
"nationality" VARCHAR,
"position" VARCHAR,
"venue" VARCHAR,
"date" VARCHAR,
"result_score" BIGINT
);
CREATE TABLE shot_put_men (
"unnamed_0" BIGINT -- Unnamed: 0,
"rank" BIGINT,
"mark" DOUBLE,
"competitor" VARCHAR,
"dob" VARCHAR,
"nationality" VARCHAR,
"position" VARCHAR,
"venue" VARCHAR,
"date" VARCHAR,
"result_score" BIGINT
);
CREATE TABLE shot_put_women (
"unnamed_0" BIGINT -- Unnamed: 0,
"rank" BIGINT,
"mark" DOUBLE,
"competitor" VARCHAR,
"dob" VARCHAR,
"nationality" VARCHAR,
"position" DOUBLE,
"venue" VARCHAR,
"date" VARCHAR,
"result_score" BIGINT
);
Anyone who has the link will be able to view this.