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-05-02 00:00:00+00	Arsenal	1	76	35	23	7	5	67	26	41	14	2	2	9	5	3	40	11	27	15	Promotion - Champions League (League phase)
2026-05-02 00:00:00+00	Manchester City	2	70	33	21	7	5	66	29	37	12	3	1	9	4	4	38	12	28	17	Promotion - Champions League (League phase)
2026-05-02 00:00:00+00	Manchester United	3	61	34	17	10	7	60	46	14	11	3	3	6	7	4	33	20	27	26	Promotion - Champions League (League phase)
2026-05-02 00:00:00+00	Liverpool	4	58	34	17	7	10	57	44	13	10	4	3	7	3	7	32	18	25	26	Promotion - Champions League (League phase)
2026-05-02 00:00:00+00	Aston Villa	5	58	34	17	7	10	47	42	5	11	2	4	6	5	6	27	18	20	24	Promotion - Champions League (League phase)
2026-05-02 00:00:00+00	Brentford	6	51	35	14	9	12	52	46	6	8	7	3	6	2	9	31	19	21	27	Promotion - Europa League (League phase)
2026-05-02 00:00:00+00	Brighton	7	50	35	13	11	11	49	42	7	8	6	3	5	5	8	27	17	22	25	Promotion - Conference League (Play Offs)
2026-05-02 00:00:00+00	Bournemouth	8	49	34	11	16	7	52	52	0	6	9	2	5	7	5	25	19	27	33	null
2026-05-02 00:00:00+00	Chelsea	9	48	34	13	9	12	53	45	8	6	5	6	7	4	6	23	21	30	24	null
2026-05-02 00:00:00+00	Fulham	10	48	35	14	6	15	44	49	-5	10	2	5	4	4	10	28	19	16	30	null
2026-05-02 00:00:00+00	Everton	11	47	34	13	8	13	41	41	0	6	4	7	7	4	6	22	21	19	20	null
2026-05-02 00:00:00+00	Sunderland	12	47	35	12	11	12	37	46	-9	8	5	4	4	6	8	23	19	14	27	null
2026-05-02 00:00:00+00	Newcastle	13	45	35	13	6	16	49	51	-2	9	2	7	4	4	9	33	29	16	22	null
2026-05-02 00:00:00+00	Crystal Palace	14	43	33	11	10	12	36	39	-3	4	8	5	7	2	7	16	19	20	20	null
2026-05-02 00:00:00+00	Leeds	15	43	35	10	13	12	47	52	-5	8	5	5	2	8	7	28	21	19	31	null
2026-05-02 00:00:00+00	Nottingham Forest	16	39	34	10	9	15	41	45	-4	4	6	7	6	3	8	18	21	23	24	null
2026-05-02 00:00:00+00	West Ham	17	36	35	9	9	17	42	61	-19	5	4	8	4	5	9	24	29	18	32	null
2026-05-02 00:00:00+00	Tottenham	18	34	34	8	10	16	43	53	-10	2	5	10	6	5	6	20	30	23	23	Relegation - Championship
2026-05-02 00:00:00+00	Burnley	19	20	35	4	8	23	35	71	-36	2	5	10	2	3	13	15	26	20	45	Relegation - Championship
2026-05-02 00:00:00+00	Wolves	20	18	35	3	9	23	25	63	-38	3	4	11	0	5	12	18	33	7	30	Relegation - Championship

Query Result