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

Loading chart...

1SELECT 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'
6ORDER BY snapshot_date DESC, st.competition_name, season_year DESC, rank
7LIMIT 20

snapshot_date	team_name	rank	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	away_goals_for	away_goals_against	notes
2026-02-02 00:00:00+00	Arsenal	1	53	24	16	5	3	46	17	29	9	2	1	7	3	2	28	8	18	9	Promotion - Champions League (League phase)
2026-02-02 00:00:00+00	Manchester City	2	47	24	14	5	5	49	23	26	9	2	1	5	3	4	29	8	20	15	Promotion - Champions League (League phase)
2026-02-02 00:00:00+00	Aston Villa	3	46	24	14	4	6	35	26	9	8	1	3	6	3	3	18	10	17	16	Promotion - Champions League (League phase)
2026-02-02 00:00:00+00	Manchester United	4	41	24	11	8	5	44	36	8	7	3	2	4	5	3	23	15	21	21	Promotion - Champions League (League phase)
2026-02-02 00:00:00+00	Chelsea	5	40	24	11	7	6	42	27	15	6	3	3	5	4	3	20	13	22	14	Promotion - Europa League (League phase)
2026-02-02 00:00:00+00	Liverpool	6	39	24	11	6	7	39	33	6	7	3	2	4	3	5	20	12	19	21	None
2026-02-02 00:00:00+00	Brentford	7	36	24	11	3	10	36	32	4	7	3	2	4	0	8	23	12	13	20	None
2026-02-02 00:00:00+00	Sunderland	8	36	24	9	9	6	27	26	1	7	5	0	2	4	6	21	9	6	17	None
2026-02-02 00:00:00+00	Fulham	9	34	24	10	4	10	34	35	-1	7	2	3	3	2	7	21	14	13	21	None
2026-02-02 00:00:00+00	Everton	10	34	24	9	7	8	26	27	-1	4	4	4	5	3	4	15	16	11	11	None
2026-02-02 00:00:00+00	Newcastle	11	33	24	9	6	9	33	33	0	7	2	3	2	4	6	22	17	11	16	None
2026-02-02 00:00:00+00	Bournemouth	12	33	24	8	9	7	40	43	-3	6	4	2	2	5	5	19	13	21	30	None
2026-02-02 00:00:00+00	Brighton	13	31	24	7	10	7	34	32	2	5	6	1	2	4	6	20	13	14	19	None
2026-02-02 00:00:00+00	Tottenham	14	29	24	7	8	9	35	33	2	2	4	6	5	4	3	15	16	20	17	None
2026-02-02 00:00:00+00	Crystal Palace	15	29	24	7	8	9	25	29	-4	2	6	4	5	2	5	11	15	14	14	None
2026-02-02 00:00:00+00	Leeds	16	26	24	6	8	10	31	42	-11	5	4	3	1	4	7	19	17	12	25	None
2026-02-02 00:00:00+00	Nottingham Forest	17	26	24	7	5	12	24	35	-11	3	3	6	4	2	6	13	18	11	17	None
2026-02-02 00:00:00+00	West Ham	18	20	24	5	5	14	29	48	-19	3	1	8	2	4	6	16	26	13	22	Relegation - Championship
2026-02-02 00:00:00+00	Burnley	19	15	24	3	6	15	25	47	-22	2	4	6	1	2	9	12	17	13	30	Relegation - Championship
2026-02-02 00:00:00+00	Wolves	20	8	24	1	5	18	15	45	-30	1	2	9	0	3	9	10	25	5	20	Relegation - Championship