Baselight

6 Nations Rugby Files

6 Nations game logs with team ranking points

@kaggle.danieljorna_6_nations_rugby_files

Home Matches With Weather
@kaggle.danieljorna_6_nations_rugby_files.home_matches_with_weather

  • 13.04 KB
  • 255 rows
  • 12 columns
team

Team

diff

Diff

opposition

Opposition

ground

Ground

match_date

Match Date

year

Year

opponnents

Opponnents

home_standing

Home Standing

away_standing

Away Standing

temp

Temp

pressure

Pressure

wind

Wind

Wales8v ItalyMillennium StadiumSat Feb 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)2014Italy80.1973.133101914
France2v EnglandStade de FranceSat Feb 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)2014England80.8785.710175
France-5v WalesStade de FranceFri Feb 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)2019Wales77.3487.2610175
Ireland7v ScotlandLansdowne RoadSat Feb 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)2020Scotland84.2481.21102029
Wales42v ItalyMillennium StadiumSat Feb 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)2020Italy79.7770.883101914
Ireland10v EnglandLansdowne RoadSun Mar 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)2015England82.1385.68102029
Scotland12v WalesMurrayfieldSat Feb 10 2007 00:00:00 GMT+0000 (Coordinated Universal Time)2007Wales76.7376.87410177
England13v ItalyTwickenhamSat Feb 10 2007 00:00:00 GMT+0000 (Coordinated Universal Time)2007Italy78.6172.792101711
Italy-4v EnglandRomeSun Feb 10 2008 00:00:00 GMT+0000 (Coordinated Universal Time)2008England73.2985.578100417
Ireland-6v EnglandLansdowne RoadSun Feb 10 2013 00:00:00 GMT+0000 (Coordinated Universal Time)2013England80.2283.9102029

CREATE TABLE home_matches_with_weather (
  "team" VARCHAR,
  "diff" BIGINT,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "match_date" TIMESTAMP,
  "year" BIGINT,
  "opponnents" VARCHAR,
  "home_standing" DOUBLE,
  "away_standing" DOUBLE,
  "temp" BIGINT,
  "pressure" BIGINT,
  "wind" BIGINT
);

Share link

Anyone who has the link will be able to view this.