International Mathematical Olympiad (IMO) Data
The Annual World Championship Mathematics Competition for High School students
@kaggle.joebeachcapital_international_mathematical_olympiad_imo_data
The Annual World Championship Mathematics Competition for High School students
@kaggle.joebeachcapital_international_mathematical_olympiad_imo_data
CREATE TABLE country_results_df (
"year" BIGINT,
"country" VARCHAR,
"team_size_all" BIGINT,
"team_size_male" DOUBLE,
"team_size_female" DOUBLE,
"p1" DOUBLE,
"p2" DOUBLE,
"p3" DOUBLE,
"p4" DOUBLE,
"p5" DOUBLE,
"p6" DOUBLE,
"p7" DOUBLE,
"awards_gold" DOUBLE,
"awards_silver" DOUBLE,
"awards_bronze" DOUBLE,
"awards_honorable_mentions" DOUBLE,
"leader" VARCHAR,
"deputy_leader" VARCHAR
);
CREATE TABLE individual_results_df (
"year" BIGINT,
"contestant" VARCHAR,
"country" VARCHAR,
"p1" DOUBLE,
"p2" DOUBLE,
"p3" DOUBLE,
"p4" DOUBLE,
"p5" DOUBLE,
"p6" DOUBLE,
"p7" DOUBLE,
"total" BIGINT,
"individual_rank" DOUBLE,
"award" VARCHAR
);
CREATE TABLE timeline_df (
"edition" BIGINT,
"year" BIGINT,
"country" VARCHAR,
"city" VARCHAR,
"countries" BIGINT,
"all_contestant" BIGINT,
"male_contestant" BIGINT,
"female_contestant" DOUBLE,
"start_date" TIMESTAMP,
"end_date" TIMESTAMP
);
Anyone who has the link will be able to view this.