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'  and c.country = 'England'
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-03-20 00:00:00+00	Arsenal	1	70	31	21	7	3	61	22	39	12	2	1	9	5	2	35	9	26	13	Promotion - Champions League (League phase)
2026-03-20 00:00:00+00	Manchester City	2	61	30	18	7	5	60	28	32	11	3	1	7	4	4	36	11	24	17	Promotion - Champions League (League phase)
2026-03-20 00:00:00+00	Manchester United	3	55	31	15	10	6	56	43	13	10	3	2	5	7	4	30	17	26	26	Promotion - Champions League (League phase)
2026-03-20 00:00:00+00	Aston Villa	4	51	30	15	6	9	40	37	3	9	2	4	6	4	5	21	15	19	22	Promotion - Champions League (League phase)
2026-03-20 00:00:00+00	Liverpool	5	49	30	14	7	9	49	40	9	8	4	3	6	3	6	27	17	22	23	Promotion - Europa League (League phase)
2026-03-20 00:00:00+00	Chelsea	6	48	30	13	9	8	53	35	18	6	5	4	7	4	4	23	17	30	18	None
2026-03-20 00:00:00+00	Brentford	7	45	30	13	6	11	46	42	4	7	5	3	6	1	8	26	17	20	25	None
2026-03-20 00:00:00+00	Everton	8	43	30	12	7	11	34	35	-1	5	4	6	7	3	5	18	19	16	16	None
2026-03-20 00:00:00+00	Newcastle	9	42	30	12	6	12	43	43	0	8	2	5	4	4	7	28	24	15	19	None
2026-03-20 00:00:00+00	Bournemouth	10	42	31	9	15	7	46	48	-2	6	8	2	3	7	5	23	17	23	31	None
2026-03-20 00:00:00+00	Fulham	11	41	30	12	5	13	40	43	-3	8	2	5	4	3	8	24	18	16	25	None
2026-03-20 00:00:00+00	Brighton	12	40	30	10	10	10	39	36	3	6	6	3	4	4	7	22	16	17	20	None
2026-03-20 00:00:00+00	Sunderland	13	40	30	10	10	10	30	35	-5	7	5	3	3	5	7	22	14	8	21	None
2026-03-20 00:00:00+00	Crystal Palace	14	39	30	10	9	11	33	35	-2	3	7	5	7	2	6	14	18	19	17	None
2026-03-20 00:00:00+00	Leeds	15	32	30	7	11	12	37	48	-11	6	4	5	1	7	7	22	20	15	28	None
2026-03-20 00:00:00+00	Tottenham	16	30	30	7	9	14	40	47	-7	2	4	9	5	5	5	18	25	22	22	None
2026-03-20 00:00:00+00	Nottingham Forest	17	29	30	7	8	15	28	43	-15	3	5	7	4	3	8	13	19	15	24	None
2026-03-20 00:00:00+00	West Ham	18	29	30	7	8	15	36	55	-19	3	4	8	4	4	7	18	28	18	27	Relegation - Championship
2026-03-20 00:00:00+00	Burnley	19	20	30	4	8	18	32	58	-26	2	5	8	2	3	10	15	23	17	35	Relegation - Championship
2026-03-20 00:00:00+00	Wolves	20	17	31	3	8	20	24	54	-30	3	3	10	0	5	10	17	31	7	23	Relegation - Championship

Query Result