Query: Soccer Standings - Premier League 2025/2026 - Full table by Paulo Sousa

Loading chart...

1SELECT DISTINCT st.* EXCLUDE (season_id, team_id, season_year, competition_name)
2FROM @blt.ultimate_soccer_dataset.standings st
3INNER JOIN @blt.ultimate_soccer_dataset.seasons s ON (st.season_id = s.season_id)
4INNER JOIN @blt.ultimate_soccer_dataset.competitions c ON (s.competition_id = c.competition_id)
5WHERE c.slug = 'premier-league' and s.season_label = '2025/2026'  and c.country = 'England'
6ORDER BY snapshot_date DESC, st.competition_name, season_year DESC, rank
7LIMIT 20

snapshot_date	team_name	rank	group	form	status	points	played	wins	draws	losses	goals_for	goals_against	goal_difference	home_wins	home_draws	home_losses	away_wins	away_draws	away_losses	home_goals_for	home_goals_against	home_goal_difference	away_goals_for	away_goals_against	away_goal_difference	notes
2026-05-27 00:00:00+00	Arsenal	1	Premier League	WWWWW	same	85	38	26	7	5	71	27	44	15	2	2	11	5	3	41	11	30	30	16	14	Promotion - Champions League (League phase)
2026-05-27 00:00:00+00	Manchester City	2	Premier League	LDWWD	same	78	38	23	9	6	77	35	42	14	3	2	9	6	4	45	14	31	32	21	11	Promotion - Champions League (League phase)
2026-05-27 00:00:00+00	Manchester United	3	Premier League	WWDWW	same	71	38	20	11	7	69	50	19	13	3	3	7	8	4	39	24	15	30	26	4	Promotion - Champions League (League phase)
2026-05-27 00:00:00+00	Aston Villa	4	Premier League	WWDLL	same	65	38	19	8	11	56	49	7	12	2	5	7	6	6	32	22	10	24	27	-3	Promotion - Champions League (League phase)
2026-05-27 00:00:00+00	Liverpool	5	Premier League	DLDLW	same	60	38	17	9	12	63	53	10	10	6	3	7	3	9	34	20	14	29	33	-4	Promotion - Champions League (League phase)
2026-05-27 00:00:00+00	Bournemouth	6	Premier League	DDWWD	same	57	38	13	18	7	58	54	4	7	10	2	6	8	5	29	20	9	29	34	-5	Promotion - Europa League (League phase)
2026-05-27 00:00:00+00	Sunderland	7	Premier League	WWDDL	same	54	38	14	12	12	42	48	-6	9	6	4	5	6	8	25	20	5	17	28	-11	Promotion - Europa League (League phase)
2026-05-27 00:00:00+00	Brighton	8	Premier League	LLWLW	same	53	38	14	11	13	52	46	6	9	6	4	5	5	9	30	20	10	22	26	-4	Promotion - Conference League (Qualification)
2026-05-27 00:00:00+00	Brentford	9	Premier League	DDLWL	same	53	38	14	11	13	55	52	3	8	8	3	6	3	10	33	21	12	22	31	-9	null
2026-05-27 00:00:00+00	Chelsea	10	Premier League	LWDLL	same	52	38	14	10	14	58	52	6	7	5	7	7	5	7	26	25	1	32	27	5	null
2026-05-27 00:00:00+00	Fulham	11	Premier League	WDLLW	same	52	38	15	7	16	47	51	-4	11	2	6	4	5	10	30	20	10	17	31	-14	null
2026-05-27 00:00:00+00	Newcastle	12	Premier League	LWDWL	same	49	38	14	7	17	53	55	-2	10	2	7	4	5	10	36	30	6	17	25	-8	null
2026-05-27 00:00:00+00	Everton	13	Premier League	LLDDL	same	49	38	13	10	15	47	50	-3	6	5	8	7	5	7	26	27	-1	21	23	-2	null
2026-05-27 00:00:00+00	Leeds	14	Premier League	LWDWD	same	47	38	11	14	13	49	56	-7	9	5	5	2	9	8	29	21	8	20	35	-15	null
2026-05-27 00:00:00+00	Crystal Palace	15	Premier League	LDLDL	same	45	38	11	12	15	41	51	-10	4	9	6	7	3	9	19	23	-4	22	28	-6	Promotion - Europa League (League phase)
2026-05-27 00:00:00+00	Nottingham Forest	16	Premier League	DLDWW	same	44	38	11	11	16	48	51	-3	4	8	7	7	3	9	20	23	-3	28	28	0	null
2026-05-27 00:00:00+00	Tottenham	17	Premier League	WLDWW	same	41	38	10	11	17	48	57	-9	3	6	10	7	5	7	22	31	-9	26	26	0	null
2026-05-27 00:00:00+00	West Ham	18	Premier League	WLLLW	same	39	38	10	9	19	46	65	-19	6	4	9	4	5	10	27	30	-3	19	35	-16	Relegation - Championship
2026-05-27 00:00:00+00	Burnley	19	Premier League	DLDLL	same	22	38	4	10	24	38	75	-37	2	7	10	2	3	14	18	29	-11	20	46	-26	Relegation - Championship
2026-05-27 00:00:00+00	Wolves	20	Premier League	DDLDL	same	20	38	3	11	24	27	68	-41	3	5	11	0	6	13	19	34	-15	8	34	-26	Relegation - Championship

Query Result