Baselight
Sign In 
1SELECT 
2  m.date,
3  m.home_team_name,
4  m.away_team_name,
5  m.home_score,
6  m.away_score,
7  m.competition_name,
8  m.status
9FROM "@blt.ultimate_soccer_dataset.matches" m
10WHERE (
11  (m.home_team_name = 'Arsenal' AND m.away_team_name = 'Tottenham')
12  OR (m.home_team_name = 'Tottenham' AND m.away_team_name = 'Arsenal')
13)
14ORDER BY m.date DESC
15LIMIT 10
16
datehome_team_nameaway_team_namehome_scoreaway_scorecompetition_namestatus
2026-02-21 00:00:00+00TottenhamArsenalnullnullPremier LeagueNot Started
2025-11-23 00:00:00+00ArsenalTottenhamnullnullPremier LeagueNot Started
2025-01-15 00:00:00+00ArsenalTottenham21Premier LeagueMatch Finished
2024-09-15 00:00:00+00TottenhamArsenal01Premier LeagueMatch Finished
2024-04-28 00:00:00+00TottenhamArsenal23Premier LeagueMatch Finished
2023-09-24 00:00:00+00ArsenalTottenham22Premier LeagueMatch Finished
2023-01-15 00:00:00+00TottenhamArsenal02Premier LeagueMatch Finished
2022-10-01 00:00:00+00ArsenalTottenham31Premier LeagueMatch Finished
2022-05-12 00:00:00+00TottenhamArsenal30Premier LeagueMatch Finished
2021-09-26 00:00:00+00ArsenalTottenham31Premier LeagueMatch Finished

Share link

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