Baselight
Sign In

Query Result

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'  and c.country = 'England'
15ORDER BY date ASC, m.competition_name, m.home_team_name, m.away_team_name
16LIMIT 100
Kickoff (UTC)CompetitionSeasonHome TeamAway TeamVenue
2026-03-21 12:30:00+00Premier League2025/2026BrightonLiverpoolAmex Stadium
2026-03-21 15:00:00+00Premier League2025/2026FulhamBurnleyCraven Cottage
2026-03-21 17:30:00+00Premier League2025/2026EvertonChelseaHill Dickinson Stadium
2026-03-21 20:00:00+00Premier League2025/2026LeedsBrentfordElland Road
2026-03-22 12:00:00+00Premier League2025/2026NewcastleSunderlandSt. James' Park
2026-03-22 14:15:00+00Premier League2025/2026Aston VillaWest HamVilla Park
2026-03-22 14:15:00+00Premier League2025/2026TottenhamNottingham ForestTottenham Hotspur Stadium
2026-04-10 19:00:00+00Premier League2025/2026West HamWolvesLondon Stadium
2026-04-11 11:30:00+00Premier League2025/2026ArsenalBournemouthEmirates Stadium
2026-04-11 14:00:00+00Premier League2025/2026BrentfordEvertonBrentford Community Stadium
2026-04-11 14:00:00+00Premier League2025/2026BurnleyBrightonTurf Moor
2026-04-11 14:00:00+00Premier League2025/2026Crystal PalaceNewcastleSelhurst Park
2026-04-11 14:00:00+00Premier League2025/2026Nottingham ForestAston VillaCity Ground
2026-04-11 16:30:00+00Premier League2025/2026LiverpoolFulhamAnfield
2026-04-12 13:00:00+00Premier League2025/2026SunderlandTottenhamStadium of Light
2026-04-12 15:30:00+00Premier League2025/2026ChelseaManchester CityStamford Bridge
2026-04-13 19:00:00+00Premier League2025/2026Manchester UnitedLeedsOld Trafford
2026-04-18 11:30:00+00Premier League2025/2026BrentfordFulhamBrentford Community Stadium
2026-04-18 14:00:00+00Premier League2025/2026Aston VillaSunderlandVilla Park
2026-04-18 14:00:00+00Premier League2025/2026LeedsWolvesElland Road
2026-04-18 14:00:00+00Premier League2025/2026NewcastleBournemouthSt. James' Park
2026-04-18 14:00:00+00Premier League2025/2026Nottingham ForestBurnleyCity Ground
2026-04-18 16:30:00+00Premier League2025/2026TottenhamBrightonTottenham Hotspur Stadium
2026-04-18 19:00:00+00Premier League2025/2026ChelseaManchester UnitedStamford Bridge
2026-04-19 13:00:00+00Premier League2025/2026EvertonLiverpoolHill Dickinson Stadium
2026-04-19 15:30:00+00Premier League2025/2026Manchester CityArsenalEtihad Stadium
2026-04-20 19:00:00+00Premier League2025/2026Crystal PalaceWest HamSelhurst Park
2026-04-24 19:00:00+00Premier League2025/2026SunderlandNottingham ForestStadium of Light
2026-04-25 11:30:00+00Premier League2025/2026FulhamAston VillaCraven Cottage
2026-04-25 14:00:00+00Premier League2025/2026BournemouthLeedsVitality Stadium
2026-04-25 14:00:00+00Premier League2025/2026LiverpoolCrystal PalaceAnfield
2026-04-25 14:00:00+00Premier League2025/2026West HamEvertonLondon Stadium
2026-04-25 14:00:00+00Premier League2025/2026WolvesTottenhamMolineux Stadium
2026-04-25 16:30:00+00Premier League2025/2026ArsenalNewcastleEmirates Stadium
2026-04-26 13:00:00+00Premier League2025/2026BurnleyManchester CityTurf Moor
2026-04-26 15:30:00+00Premier League2025/2026BrightonChelseaAmex Stadium
2026-04-27 19:00:00+00Premier League2025/2026Manchester UnitedBrentfordOld Trafford
2026-05-02 14:00:00+00Premier League2025/2026ArsenalFulhamEmirates Stadium
2026-05-02 14:00:00+00Premier League2025/2026Aston VillaTottenhamVilla Park
2026-05-02 14:00:00+00Premier League2025/2026BournemouthCrystal PalaceVitality Stadium
2026-05-02 14:00:00+00Premier League2025/2026BrentfordWest HamBrentford Community Stadium
2026-05-02 14:00:00+00Premier League2025/2026ChelseaNottingham ForestStamford Bridge
2026-05-02 14:00:00+00Premier League2025/2026EvertonManchester CityHill Dickinson Stadium
2026-05-02 14:00:00+00Premier League2025/2026LeedsBurnleyElland Road
2026-05-02 14:00:00+00Premier League2025/2026Manchester UnitedLiverpoolOld Trafford
2026-05-02 14:00:00+00Premier League2025/2026NewcastleBrightonSt. James' Park
2026-05-02 14:00:00+00Premier League2025/2026WolvesSunderlandMolineux Stadium
2026-05-09 14:00:00+00Premier League2025/2026BrightonWolvesAmex Stadium
2026-05-09 14:00:00+00Premier League2025/2026BurnleyAston VillaTurf Moor
2026-05-09 14:00:00+00Premier League2025/2026Crystal PalaceEvertonSelhurst Park
2026-05-09 14:00:00+00Premier League2025/2026FulhamBournemouthCraven Cottage
2026-05-09 14:00:00+00Premier League2025/2026LiverpoolChelseaAnfield
2026-05-09 14:00:00+00Premier League2025/2026Manchester CityBrentfordEtihad Stadium
2026-05-09 14:00:00+00Premier League2025/2026Nottingham ForestNewcastleCity Ground
2026-05-09 14:00:00+00Premier League2025/2026SunderlandManchester UnitedStadium of Light
2026-05-09 14:00:00+00Premier League2025/2026TottenhamLeedsTottenham Hotspur Stadium
2026-05-09 14:00:00+00Premier League2025/2026West HamArsenalLondon Stadium
2026-05-17 14:00:00+00Premier League2025/2026ArsenalBurnleyEmirates Stadium
2026-05-17 14:00:00+00Premier League2025/2026Aston VillaLiverpoolVilla Park
2026-05-17 14:00:00+00Premier League2025/2026BournemouthManchester CityVitality Stadium
2026-05-17 14:00:00+00Premier League2025/2026BrentfordCrystal PalaceBrentford Community Stadium
2026-05-17 14:00:00+00Premier League2025/2026ChelseaTottenhamStamford Bridge
2026-05-17 14:00:00+00Premier League2025/2026EvertonSunderlandHill Dickinson Stadium
2026-05-17 14:00:00+00Premier League2025/2026LeedsBrightonElland Road
2026-05-17 14:00:00+00Premier League2025/2026Manchester UnitedNottingham ForestOld Trafford
2026-05-17 14:00:00+00Premier League2025/2026NewcastleWest HamSt. James' Park
2026-05-17 14:00:00+00Premier League2025/2026WolvesFulhamMolineux Stadium
2026-05-24 15:00:00+00Premier League2025/2026BrightonManchester UnitedAmex Stadium
2026-05-24 15:00:00+00Premier League2025/2026BurnleyWolvesTurf Moor
2026-05-24 15:00:00+00Premier League2025/2026Crystal PalaceArsenalSelhurst Park
2026-05-24 15:00:00+00Premier League2025/2026FulhamNewcastleCraven Cottage
2026-05-24 15:00:00+00Premier League2025/2026LiverpoolBrentfordAnfield
2026-05-24 15:00:00+00Premier League2025/2026Manchester CityAston VillaEtihad Stadium
2026-05-24 15:00:00+00Premier League2025/2026Nottingham ForestBournemouthCity Ground
2026-05-24 15:00:00+00Premier League2025/2026SunderlandChelseaStadium of Light
2026-05-24 15:00:00+00Premier League2025/2026TottenhamEvertonTottenham Hotspur Stadium
2026-05-24 15:00:00+00Premier League2025/2026West HamLeedsLondon Stadium

Share link

Anyone who has the link will be able to view this.