W6N Match Data 2007-22
Match data from the Women's Six Nations (2007-22)
@kaggle.amandamch_w6n_match_data_2007_22
Match data from the Women's Six Nations (2007-22)
@kaggle.amandamch_w6n_match_data_2007_22
Data compiled from a variety of sources covering the matches in the Women's Six Nations, from when Italy replaced Spain in 2007 (bringing the competition in line with the men's) until 2022.
Primarily, this is to explore year-on-year trends for the Women's Six Nations, for example looking at trends in attendance to see how women's rugby has grown since 2007, or looking at who has won the most matches and by what kinds of margins. This is not about the events within individual matches beyond the points that are scored; rather, it gives us an impression of the growth and development of the competition.
To my knowledge, this is the largest collation of Women's Six Nations attendance records, at least that is publicly available. Given the amount of legwork that was required to compile all the numbers, I can say this with a pretty high degree of certainty. We can use the data here to really understand how women's rugby has grown as a sport, with the aid of geographical information to tell us the best kinds of grounds to host matches to draw the most fans.
Data not in this dataset includes things like players, captains, coaches, referees, etc., and there is no details of who scored which points and when. Points difference and overall winners are not included, although should be calculable from the data that's available.
The match IDs should allow you to join with other datasets; for example one with full team sheets for each match, or one that goes into more detail about scoring, cards, subs, etc. in each match. The world is your oyster!
CREATE TABLE w6n_attendance_data_as (
"id" BIGINT,
"year" BIGINT,
"month" VARCHAR,
"month_number" BIGINT,
"day" BIGINT,
"date" TIMESTAMP,
"host_team" VARCHAR,
"away_team" VARCHAR,
"attendance" DOUBLE,
"ground" VARCHAR,
"region" VARCHAR,
"host_points" BIGINT,
"away_points" BIGINT,
"winner" VARCHAR,
"loser" VARCHAR
);Anyone who has the link will be able to view this.