1SELECT
2 date as "Kickoff (UTC)",
3 m.competition_name as "Competition",
4 s.season_label as "Season",
5 home_team_name as "Home Team",
6 away_team_name as "Away Team",
7 venue_name as "Venue"
8FROM @blt.ultimate_soccer_dataset.matches m
9LEFT OUTER JOIN "@blt.ultimate_soccer_dataset.seasons" s
10 ON m.season_id = s.season_id
11LEFT OUTER JOIN "@blt.ultimate_soccer_dataset.competitions" c
12 ON s.competition_id = c.competition_id
13WHERE status = 'Not Started' AND date >= NOW()
14 AND c.slug = 'premier-league' and s.season_label = '2025/2026'
15ORDER BY date ASC, m.competition_name, m.home_team_name, m.away_team_name
16LIMIT 100| Kickoff (UTC) | Competition | Season | Home Team | Away Team | Venue |
|---|---|---|---|---|---|
| 2025-12-13 15:00:00+00 | Premier League | 2025/2026 | Chelsea | Everton | Stamford Bridge |
| 2025-12-13 15:00:00+00 | Premier League | 2025/2026 | Liverpool | Brighton | Anfield |
| 2025-12-13 17:30:00+00 | Premier League | 2025/2026 | Burnley | Fulham | Turf Moor |
| 2025-12-13 20:00:00+00 | Premier League | 2025/2026 | Arsenal | Wolves | Emirates Stadium |
| 2025-12-14 14:00:00+00 | Premier League | 2025/2026 | Crystal Palace | Manchester City | Selhurst Park |
| 2025-12-14 14:00:00+00 | Premier League | 2025/2026 | Nottingham Forest | Tottenham | City Ground |
| 2025-12-14 14:00:00+00 | Premier League | 2025/2026 | Sunderland | Newcastle | Stadium of Light |
| 2025-12-14 14:00:00+00 | Premier League | 2025/2026 | West Ham | Aston Villa | London Stadium |
| 2025-12-14 16:30:00+00 | Premier League | 2025/2026 | Brentford | Leeds | Brentford Community Stadium |
| 2025-12-15 20:00:00+00 | Premier League | 2025/2026 | Manchester United | Bournemouth | Old Trafford |
| 2025-12-20 12:30:00+00 | Premier League | 2025/2026 | Newcastle | Chelsea | St. James' Park |
| 2025-12-20 15:00:00+00 | Premier League | 2025/2026 | Bournemouth | Burnley | Vitality Stadium |
| 2025-12-20 15:00:00+00 | Premier League | 2025/2026 | Brighton | Sunderland | Amex Stadium |
| 2025-12-20 15:00:00+00 | Premier League | 2025/2026 | Manchester City | West Ham | Etihad Stadium |
| 2025-12-20 15:00:00+00 | Premier League | 2025/2026 | Wolves | Brentford | Molineux Stadium |
| 2025-12-20 17:30:00+00 | Premier League | 2025/2026 | Tottenham | Liverpool | Tottenham Hotspur Stadium |
| 2025-12-20 20:00:00+00 | Premier League | 2025/2026 | Everton | Arsenal | Hill Dickinson Stadium |
| 2025-12-20 20:00:00+00 | Premier League | 2025/2026 | Leeds | Crystal Palace | Elland Road |
| 2025-12-21 16:30:00+00 | Premier League | 2025/2026 | Aston Villa | Manchester United | Villa Park |
| 2025-12-22 20:00:00+00 | Premier League | 2025/2026 | Fulham | Nottingham Forest | Craven Cottage |
| 2025-12-26 20:00:00+00 | Premier League | 2025/2026 | Manchester United | Newcastle | Old Trafford |
| 2025-12-27 12:30:00+00 | Premier League | 2025/2026 | Nottingham Forest | Manchester City | City Ground |
| 2025-12-27 15:00:00+00 | Premier League | 2025/2026 | Arsenal | Brighton | Emirates Stadium |
| 2025-12-27 15:00:00+00 | Premier League | 2025/2026 | Brentford | Bournemouth | Brentford Community Stadium |
| 2025-12-27 15:00:00+00 | Premier League | 2025/2026 | Burnley | Everton | Turf Moor |
| 2025-12-27 15:00:00+00 | Premier League | 2025/2026 | Liverpool | Wolves | Anfield |
| 2025-12-27 15:00:00+00 | Premier League | 2025/2026 | West Ham | Fulham | London Stadium |
| 2025-12-27 17:30:00+00 | Premier League | 2025/2026 | Chelsea | Aston Villa | Stamford Bridge |
| 2025-12-28 14:00:00+00 | Premier League | 2025/2026 | Sunderland | Leeds | Stadium of Light |
| 2025-12-28 16:30:00+00 | Premier League | 2025/2026 | Crystal Palace | Tottenham | Selhurst Park |
| 2025-12-30 19:30:00+00 | Premier League | 2025/2026 | Burnley | Newcastle | Turf Moor |
| 2025-12-30 19:30:00+00 | Premier League | 2025/2026 | Chelsea | Bournemouth | Stamford Bridge |
| 2025-12-30 19:30:00+00 | Premier League | 2025/2026 | Nottingham Forest | Everton | City Ground |
| 2025-12-30 19:30:00+00 | Premier League | 2025/2026 | West Ham | Brighton | London Stadium |
| 2025-12-30 20:15:00+00 | Premier League | 2025/2026 | Arsenal | Aston Villa | Emirates Stadium |
| 2025-12-30 20:15:00+00 | Premier League | 2025/2026 | Manchester United | Wolves | Old Trafford |
| 2026-01-01 17:30:00+00 | Premier League | 2025/2026 | Crystal Palace | Fulham | Selhurst Park |
| 2026-01-01 17:30:00+00 | Premier League | 2025/2026 | Liverpool | Leeds | Anfield |
| 2026-01-01 20:00:00+00 | Premier League | 2025/2026 | Brentford | Tottenham | Brentford Community Stadium |
| 2026-01-01 20:00:00+00 | Premier League | 2025/2026 | Sunderland | Manchester City | Stadium of Light |
| 2026-01-03 12:30:00+00 | Premier League | 2025/2026 | Aston Villa | Nottingham Forest | Villa Park |
| 2026-01-03 15:00:00+00 | Premier League | 2025/2026 | Brighton | Burnley | Amex Stadium |
| 2026-01-03 15:00:00+00 | Premier League | 2025/2026 | Wolves | West Ham | Molineux Stadium |
| 2026-01-03 17:30:00+00 | Premier League | 2025/2026 | Bournemouth | Arsenal | Vitality Stadium |
| 2026-01-04 12:30:00+00 | Premier League | 2025/2026 | Leeds | Manchester United | Elland Road |
| 2026-01-04 15:00:00+00 | Premier League | 2025/2026 | Everton | Brentford | Hill Dickinson Stadium |
| 2026-01-04 15:00:00+00 | Premier League | 2025/2026 | Fulham | Liverpool | Craven Cottage |
| 2026-01-04 15:00:00+00 | Premier League | 2025/2026 | Newcastle | Crystal Palace | St. James' Park |
| 2026-01-04 15:00:00+00 | Premier League | 2025/2026 | Tottenham | Sunderland | Tottenham Hotspur Stadium |
| 2026-01-04 17:30:00+00 | Premier League | 2025/2026 | Manchester City | Chelsea | Etihad Stadium |
| 2026-01-06 20:00:00+00 | Premier League | 2025/2026 | West Ham | Nottingham Forest | London Stadium |
| 2026-01-07 19:30:00+00 | Premier League | 2025/2026 | Bournemouth | Tottenham | Vitality Stadium |
| 2026-01-07 19:30:00+00 | Premier League | 2025/2026 | Brentford | Sunderland | Brentford Community Stadium |
| 2026-01-07 19:30:00+00 | Premier League | 2025/2026 | Crystal Palace | Aston Villa | Selhurst Park |
| 2026-01-07 19:30:00+00 | Premier League | 2025/2026 | Everton | Wolves | Hill Dickinson Stadium |
| 2026-01-07 19:30:00+00 | Premier League | 2025/2026 | Fulham | Chelsea | Craven Cottage |
| 2026-01-07 19:30:00+00 | Premier League | 2025/2026 | Manchester City | Brighton | Etihad Stadium |
| 2026-01-07 20:15:00+00 | Premier League | 2025/2026 | Burnley | Manchester United | Turf Moor |
| 2026-01-07 20:15:00+00 | Premier League | 2025/2026 | Newcastle | Leeds | St. James' Park |
| 2026-01-08 20:00:00+00 | Premier League | 2025/2026 | Arsenal | Liverpool | Emirates Stadium |
| 2026-01-17 12:30:00+00 | Premier League | 2025/2026 | Manchester United | Manchester City | Old Trafford |
| 2026-01-17 15:00:00+00 | Premier League | 2025/2026 | Chelsea | Brentford | Stamford Bridge |
| 2026-01-17 15:00:00+00 | Premier League | 2025/2026 | Leeds | Fulham | Elland Road |
| 2026-01-17 15:00:00+00 | Premier League | 2025/2026 | Liverpool | Burnley | Anfield |
| 2026-01-17 15:00:00+00 | Premier League | 2025/2026 | Sunderland | Crystal Palace | Stadium of Light |
| 2026-01-17 15:00:00+00 | Premier League | 2025/2026 | Tottenham | West Ham | Tottenham Hotspur Stadium |
| 2026-01-17 17:30:00+00 | Premier League | 2025/2026 | Nottingham Forest | Arsenal | City Ground |
| 2026-01-18 14:00:00+00 | Premier League | 2025/2026 | Wolves | Newcastle | Molineux Stadium |
| 2026-01-18 16:30:00+00 | Premier League | 2025/2026 | Aston Villa | Everton | Villa Park |
| 2026-01-19 20:00:00+00 | Premier League | 2025/2026 | Brighton | Bournemouth | Amex Stadium |
| 2026-01-24 12:30:00+00 | Premier League | 2025/2026 | West Ham | Sunderland | London Stadium |
| 2026-01-24 15:00:00+00 | Premier League | 2025/2026 | Burnley | Tottenham | Turf Moor |
| 2026-01-24 15:00:00+00 | Premier League | 2025/2026 | Fulham | Brighton | Craven Cottage |
| 2026-01-24 15:00:00+00 | Premier League | 2025/2026 | Manchester City | Wolves | Etihad Stadium |
| 2026-01-24 17:30:00+00 | Premier League | 2025/2026 | Bournemouth | Liverpool | Vitality Stadium |
| 2026-01-25 14:00:00+00 | Premier League | 2025/2026 | Brentford | Nottingham Forest | Brentford Community Stadium |
| 2026-01-25 14:00:00+00 | Premier League | 2025/2026 | Crystal Palace | Chelsea | Selhurst Park |
| 2026-01-25 14:00:00+00 | Premier League | 2025/2026 | Newcastle | Aston Villa | St. James' Park |
| 2026-01-25 16:30:00+00 | Premier League | 2025/2026 | Arsenal | Manchester United | Emirates Stadium |
| 2026-01-26 20:00:00+00 | Premier League | 2025/2026 | Everton | Leeds | Hill Dickinson Stadium |
| 2026-01-31 15:00:00+00 | Premier League | 2025/2026 | Brighton | Everton | Amex Stadium |
| 2026-01-31 15:00:00+00 | Premier League | 2025/2026 | Leeds | Arsenal | Elland Road |
| 2026-01-31 15:00:00+00 | Premier League | 2025/2026 | Wolves | Bournemouth | Molineux Stadium |
| 2026-01-31 17:30:00+00 | Premier League | 2025/2026 | Chelsea | West Ham | Stamford Bridge |
| 2026-01-31 20:00:00+00 | Premier League | 2025/2026 | Liverpool | Newcastle | Anfield |
| 2026-02-01 14:00:00+00 | Premier League | 2025/2026 | Aston Villa | Brentford | Villa Park |
| 2026-02-01 14:00:00+00 | Premier League | 2025/2026 | Manchester United | Fulham | Old Trafford |
| 2026-02-01 14:00:00+00 | Premier League | 2025/2026 | Nottingham Forest | Crystal Palace | City Ground |
| 2026-02-01 16:30:00+00 | Premier League | 2025/2026 | Tottenham | Manchester City | Tottenham Hotspur Stadium |
| 2026-02-02 20:00:00+00 | Premier League | 2025/2026 | Sunderland | Burnley | Stadium of Light |
| 2026-02-07 15:00:00+00 | Premier League | 2025/2026 | Arsenal | Sunderland | Emirates Stadium |
| 2026-02-07 15:00:00+00 | Premier League | 2025/2026 | Bournemouth | Aston Villa | Vitality Stadium |
| 2026-02-07 15:00:00+00 | Premier League | 2025/2026 | Brighton | Crystal Palace | Amex Stadium |
| 2026-02-07 15:00:00+00 | Premier League | 2025/2026 | Burnley | West Ham | Turf Moor |
| 2026-02-07 15:00:00+00 | Premier League | 2025/2026 | Fulham | Everton | Craven Cottage |
| 2026-02-07 15:00:00+00 | Premier League | 2025/2026 | Leeds | Nottingham Forest | Elland Road |
| 2026-02-07 15:00:00+00 | Premier League | 2025/2026 | Liverpool | Manchester City | Anfield |
| 2026-02-07 15:00:00+00 | Premier League | 2025/2026 | Manchester United | Tottenham | Old Trafford |
| 2026-02-07 15:00:00+00 | Premier League | 2025/2026 | Newcastle | Brentford | St. James' Park |
| 2026-02-07 15:00:00+00 | Premier League | 2025/2026 | Wolves | Chelsea | Molineux Stadium |