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
2025-12-12 00:00:00+00	Arsenal	1	33	15	10	3	2	28	9	19	6	1	0	4	2	2	18	2	10	7	Promotion - Champions League (League phase)
2025-12-12 00:00:00+00	Manchester City	2	31	15	10	1	4	35	16	19	7	0	1	3	1	3	22	6	13	10	Promotion - Champions League (League phase)
2025-12-12 00:00:00+00	Aston Villa	3	30	15	9	3	3	22	15	7	6	1	1	3	2	2	13	6	9	9	Promotion - Champions League (League phase)
2025-12-12 00:00:00+00	Crystal Palace	4	26	15	7	5	3	20	12	8	2	4	1	5	1	2	9	7	11	5	Promotion - Champions League (League phase)
2025-12-12 00:00:00+00	Chelsea	5	25	15	7	4	4	25	15	10	3	2	2	4	2	2	10	7	15	8	Promotion - Europa League (League phase)
2025-12-12 00:00:00+00	Manchester United	6	25	15	7	4	4	26	22	4	4	1	2	3	3	2	12	8	14	14	None
2025-12-12 00:00:00+00	Everton	7	24	15	7	3	5	18	17	1	4	2	2	3	1	3	11	9	7	8	None
2025-12-12 00:00:00+00	Brighton	8	23	15	6	5	4	25	21	4	4	3	1	2	2	3	16	11	9	10	None
2025-12-12 00:00:00+00	Sunderland	9	23	15	6	5	4	18	17	1	4	3	0	2	2	4	14	7	4	10	None
2025-12-12 00:00:00+00	Liverpool	10	23	15	7	2	6	24	24	0	4	1	2	3	1	4	11	9	13	15	None
2025-12-12 00:00:00+00	Tottenham	11	22	15	6	4	5	25	18	7	2	2	4	4	2	1	10	9	15	9	None
2025-12-12 00:00:00+00	Newcastle	12	22	15	6	4	5	21	19	2	5	1	2	1	3	3	14	10	7	9	None
2025-12-12 00:00:00+00	Bournemouth	13	20	15	5	5	5	21	24	-3	4	3	1	1	2	4	10	5	11	19	None
2025-12-12 00:00:00+00	Brentford	14	19	15	6	1	8	21	24	-3	5	1	1	1	0	7	15	8	6	16	None
2025-12-12 00:00:00+00	Fulham	15	17	15	5	2	8	20	24	-4	4	1	3	1	1	5	14	10	6	14	None
2025-12-12 00:00:00+00	Leeds	16	15	15	4	3	8	19	29	-10	3	3	2	1	0	6	13	11	6	18	None
2025-12-12 00:00:00+00	Nottingham Forest	17	15	15	4	3	8	14	25	-11	2	1	4	2	2	4	8	13	6	12	None
2025-12-12 00:00:00+00	West Ham	18	13	15	3	4	8	17	29	-12	2	0	5	1	4	3	8	17	9	12	Relegation - Championship
2025-12-12 00:00:00+00	Burnley	19	10	15	3	1	11	16	30	-14	2	1	4	1	0	7	5	7	11	23	Relegation - Championship
2025-12-12 00:00:00+00	Wolves	20	2	15	0	2	13	8	33	-25	0	1	7	0	1	6	7	21	1	12	Relegation - Championship