EPL Weekly Review

Premier League Match Update - Week __

@kaggle.willianoliveiragibin_epl_weekly_review

Table List

1 table(29.15 KB)

Epl Woman Matches New

@kaggle.willianoliveiragibin_epl_weekly_review.epl_woman_matches_new

29.15 KB
456 rows
29 columns

order Order	date Date	time Time	comp Comp	round Round	day Day	venue Venue	result Result	gf GF	ga GA	opponent Opponent	xg XG	xga XGA	poss Poss	attendance Attendance	captain Captain	formation Formation	referee Referee	match_report Match Report	sh Sh	sot SoT	dist Dist	fk FK	pk PK	pkatt PKatt	season Season	team Team	longitude Longitude	latitude Latitude
	Sun Aug 13 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	16:30	Premier League	Matchweek 1	Sun	Away	D	1	1	Chelsea	1.3	1.4	35	40096	Virgil van Dijk	4-3-2003	Anthony Taylor	Match Report	13	1	17.8				2024	Liverpool	-29.886	534.084
1	Sat Aug 19 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00	Premier League	Matchweek 2	Sat	Home	W	3	1	Bournemouth	3	1.3	64	53145	Virgil van Dijk	4-3-2003	Thomas Bramall	Match Report	25	9	16.8	1		1	2024	Liverpool	-22.426	534.808
2	Sun Aug 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	16:30	Premier League	Matchweek 3	Sun	Away	W	2	1	Newcastle Utd	0.9	2	41	52214	Virgil van Dijk	4-3-2003	John Brooks	Match Report	9	4	17.2	1			2024	Liverpool	-1.278	515.074
3	Sun Sep 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	14:00	Premier League	Matchweek 4	Sun	Home	W	3		Aston Villa	2.5	0.7	63	50109	Trent Alexander-Arnold	4-3-2003	Simon Hooper	Match Report	17	4	14.7				2024	Liverpool	-18.904	524.862
4	Sat Sep 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	12:30	Premier League	Matchweek 5	Sat	Away	W	3	1	Wolves	2.5	0.6	65	31257	Andrew Robertson	4-3-2003	Michael Oliver	Match Report	16	5	15.8				2024	Liverpool	-1.372	508.225
6	Sun Sep 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	14:00	Premier League	Matchweek 6	Sun	Home	W	3	1	West Ham	3	1.1	63	50136	Virgil van Dijk	4-3-2003	Chris Kavanagh	Match Report	21	6	19.3	2	1	1	2024	Liverpool	-16.174	549.783
8	Sat Sep 30 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	17:30	Premier League	Matchweek 7	Sat	Away	L	1	2	Tottenham	1.3	2.2	36	62001	Virgil van Dijk	4-3-2003	Simon Hooper	Match Report	12	4	14.9				2024	Liverpool	-21.296	525.862
10	Sun Oct 08 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	14:00	Premier League	Matchweek 8	Sun	Away	D	2	2	Brighton	2.3	2.3	54	31752	Virgil van Dijk	4-3-2003	Anthony Taylor	Match Report	13	3	18.8		1	1	2024	Liverpool	-18.795	507.208
11	Sat Oct 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	12:30	Premier League	Matchweek 9	Sat	Home	W	2		Everton	2.2	0.1	77	50201	Virgil van Dijk	4-3-2003	Craig Pawson	Match Report	25	5	22.4	1	1	1	2024	Liverpool	-22.307	537.893
13	Sun Oct 29 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	14:00	Premier League	Matchweek 10	Sun	Home	W	3		Nott'ham Forest	3.2	0.4	72	50143	Virgil van Dijk	4-3-2003	Chris Kavanagh	Match Report	21	8	19.5	2			2024	Liverpool	-14.709	533.811


CREATE TABLE epl_woman_matches_new (
  "order" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "comp" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" DOUBLE,
  "ga" DOUBLE,
  "opponent" VARCHAR,
  "xg" DOUBLE,
  "xga" DOUBLE,
  "poss" DOUBLE,
  "attendance" DOUBLE,
  "captain" VARCHAR,
  "formation" VARCHAR,
  "referee" VARCHAR,
  "match_report" VARCHAR,
  "sh" DOUBLE,
  "sot" DOUBLE,
  "dist" DOUBLE,
  "fk" DOUBLE,
  "pk" BIGINT,
  "pkatt" BIGINT,
  "season" BIGINT,
  "team" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE
);