match
152 rows where away_team_id = 753 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: season_id, home_team_id, home_score, away_score, created_at, updated_at, date (date), created_at (date), updated_at (date)
| match_id | season_id | date ▲ | kickoff | home_team_id | away_team_id | home_score | away_score | result | round_stage | matchday | venue | city | country | referee | attendance | is_neutral | is_postponed | is_cancelled | created_at | updated_at | created_by_run_id | updated_by_run_id | source_id | source_raw_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65476 | 2024-2025 1974 | 2025-05-25 | Ipswich Town 745 | West Ham United 753 | 1 | 3 | Premier League | 38 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65460 | 2024-2025 1974 | 2025-05-11 | Manchester U 924 | West Ham United 753 | 0 | 2 | Premier League | 36 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65437 | 2024-2025 1974 | 2025-04-26 | Brighton & Hove Albion 740 | West Ham United 753 | 3 | 2 | Premier League | 34 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65420 | 2024-2025 1974 | 2025-04-13 | Liverpool FC 914 | West Ham United 753 | 2 | 1 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65395 | 2024-2025 1974 | 2025-04-01 | Wolverhampton Wanderers 754 | West Ham United 753 | 1 | 0 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65385 | 2024-2025 1974 | 2025-03-15 | Everton FC 918 | West Ham United 753 | 1 | 1 | Premier League | 29 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65356 | 2024-2025 1974 | 2025-02-22 | Arsenal FC 912 | West Ham United 753 | 0 | 1 | Premier League | 26 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65343 | 2024-2025 1974 | 2025-02-03 | Chelsea FC 915 | West Ham United 753 | 2 | 1 | Premier League | 24 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65332 | 2024-2025 1974 | 2025-01-26 | Aston Villa 737 | West Ham United 753 | 1 | 1 | Premier League | 23 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65298 | 2024-2025 1974 | 2025-01-04 | Manchester City 748 | West Ham United 753 | 4 | 1 | Premier League | 20 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65279 | 2024-2025 1974 | 2024-12-26 | Southampton FC 920 | West Ham United 753 | 0 | 1 | Premier League | 18 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65263 | 2024-2025 1974 | 2024-12-16 | AFC Bournemouth 923 | West Ham United 753 | 1 | 1 | Premier League | 16 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65235 | 2024-2025 1974 | 2024-12-03 | Leicester City 746 | West Ham United 753 | 3 | 1 | Premier League | 14 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65223 | 2024-2025 1974 | 2024-11-24 | Newcastle United 749 | West Ham United 753 | 0 | 2 | Premier League | 12 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65198 | 2024-2025 1974 | 2024-11-02 | Nottingham Forest 750 | West Ham United 753 | 3 | 0 | Premier League | 10 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65174 | 2024-2025 1974 | 2024-10-19 | Tottenham Hotspur 752 | West Ham United 753 | 4 | 1 | Premier League | 8 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65156 | 2024-2025 1974 | 2024-09-28 | Brentford FC 928 | West Ham United 753 | 1 | 1 | Premier League | 6 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65137 | 2024-2025 1974 | 2024-09-14 | Fulham FC 926 | West Ham United 753 | 1 | 1 | Premier League | 4 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65115 | 2024-2025 1974 | 2024-08-24 | Crystal Palace 742 | West Ham United 753 | 0 | 2 | Premier League | 2 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65102 | 2023-2024 1973 | 2024-05-19 | Manchester City 748 | West Ham United 753 | 3 | 1 | Premier League | 38 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65081 | 2023-2024 1973 | 2024-05-05 | Chelsea FC 915 | West Ham United 753 | 5 | 0 | Premier League | 36 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65059 | 2023-2024 1973 | 2024-04-21 | Crystal Palace 742 | West Ham United 753 | 5 | 2 | Premier League | 34 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65039 | 2023-2024 1973 | 2024-04-06 | Wolverhampton Wanderers 754 | West Ham United 753 | 1 | 2 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65014 | 2023-2024 1973 | 2024-03-30 | Newcastle United 749 | West Ham United 753 | 4 | 3 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64985 | 2023-2024 1973 | 2024-03-02 | Everton FC 918 | West Ham United 753 | 1 | 3 | Premier League | 27 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64968 | 2023-2024 1973 | 2024-02-17 | Nottingham Forest 750 | West Ham United 753 | 2 | 0 | Premier League | 25 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64951 | 2023-2024 1973 | 2024-02-04 | Manchester U 924 | West Ham United 753 | 3 | 0 | Premier League | 23 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64931 | 2023-2024 1973 | 2024-01-21 | Sheffield United 758 | West Ham United 753 | 2 | 2 | Premier League | 21 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64913 | 2023-2024 1973 | 2023-12-28 | Arsenal FC 912 | West Ham United 753 | 0 | 2 | Premier League | 19 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64880 | 2023-2024 1973 | 2023-12-10 | Fulham FC 926 | West Ham United 753 | 5 | 0 | Premier League | 16 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64872 | 2023-2024 1973 | 2023-12-02 | Tottenham Hotspur 752 | West Ham United 753 | 1 | 2 | Premier League | 15 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64844 | 2023-2024 1973 | 2023-11-25 | Burnley FC 916 | West Ham United 753 | 1 | 2 | Premier League | 13 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64824 | 2023-2024 1973 | 2023-11-04 | Brentford FC 928 | West Ham United 753 | 3 | 2 | Premier League | 11 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64811 | 2023-2024 1973 | 2023-10-22 | Aston Villa 737 | West Ham United 753 | 4 | 1 | Premier League | 9 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64781 | 2023-2024 1973 | 2023-09-24 | Liverpool FC 914 | West Ham United 753 | 3 | 1 | Premier League | 6 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64753 | 2023-2024 1973 | 2023-09-01 | Luton Town 757 | West Ham United 753 | 1 | 2 | Premier League | 4 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64749 | 2023-2024 1973 | 2023-08-26 | Brighton & Hove Albion 740 | West Ham United 753 | 1 | 3 | Premier League | 3 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64725 | 2023-2024 1973 | 2023-08-12 | AFC Bournemouth 923 | West Ham United 753 | 1 | 1 | Premier League | 1 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64720 | 2022-2023 1972 | 2023-05-28 | Leicester City 746 | West Ham United 753 | 2 | 1 | Premier League | 38 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64699 | 2022-2023 1972 | 2023-05-14 | Brentford FC 928 | West Ham United 753 | 2 | 0 | Premier League | 36 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64621 | 2022-2023 1972 | 2023-05-03 | Manchester City 748 | West Ham United 753 | 3 | 0 | Premier League | 28 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64673 | 2022-2023 1972 | 2023-04-29 | Crystal Palace 742 | West Ham United 753 | 4 | 3 | Premier League | 34 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64659 | 2022-2023 1972 | 2023-04-23 | AFC Bournemouth 923 | West Ham United 753 | 0 | 4 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64636 | 2022-2023 1972 | 2023-04-08 | Fulham FC 926 | West Ham United 753 | 0 | 1 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64596 | 2022-2023 1972 | 2023-03-04 | Brighton & Hove Albion 740 | West Ham United 753 | 4 | 0 | Premier League | 26 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64582 | 2022-2023 1972 | 2023-02-19 | Tottenham Hotspur 752 | West Ham United 753 | 2 | 0 | Premier League | 24 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64560 | 2022-2023 1972 | 2023-02-04 | Newcastle United 749 | West Ham United 753 | 1 | 1 | Premier League | 22 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64538 | 2022-2023 1972 | 2023-01-14 | Wolverhampton Wanderers 754 | West Ham United 753 | 1 | 0 | Premier League | 20 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64529 | 2022-2023 1972 | 2023-01-04 | Leeds United 755 | West Ham United 753 | 2 | 2 | Premier League | 19 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64509 | 2022-2023 1972 | 2022-12-26 | Arsenal FC 912 | West Ham United 753 | 3 | 1 | Premier League | 17 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64482 | 2022-2023 1972 | 2022-10-30 | Manchester U 924 | West Ham United 753 | 1 | 0 | Premier League | 14 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64457 | 2022-2023 1972 | 2022-10-19 | Liverpool FC 914 | West Ham United 753 | 1 | 0 | Premier League | 12 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64451 | 2022-2023 1972 | 2022-10-16 | Southampton FC 920 | West Ham United 753 | 1 | 1 | Premier League | 11 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64419 | 2022-2023 1972 | 2022-09-18 | Everton FC 918 | West Ham United 753 | 1 | 0 | Premier League | 8 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64395 | 2022-2023 1972 | 2022-09-03 | Chelsea FC 915 | West Ham United 753 | 2 | 1 | Premier League | 6 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64380 | 2022-2023 1972 | 2022-08-28 | Aston Villa 737 | West Ham United 753 | 0 | 1 | Premier League | 4 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64360 | 2022-2023 1972 | 2022-08-14 | Nottingham Forest 750 | West Ham United 753 | 1 | 0 | Premier League | 2 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64335 | 2021-2022 1971 | 2022-05-22 | Brighton & Hove Albion 740 | West Ham United 753 | 3 | 1 | Premier League | 38 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64321 | 2021-2022 1971 | 2022-05-08 | Norwich City 927 | West Ham United 753 | 0 | 4 | Premier League | 36 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64300 | 2021-2022 1971 | 2022-04-24 | Chelsea FC 915 | West Ham United 753 | 1 | 0 | Premier League | 34 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64279 | 2021-2022 1971 | 2022-04-10 | Brentford FC 928 | West Ham United 753 | 2 | 0 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64257 | 2021-2022 1971 | 2022-03-20 | Tottenham Hotspur 752 | West Ham United 753 | 3 | 1 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64239 | 2021-2022 1971 | 2022-03-05 | Liverpool FC 914 | West Ham United 753 | 1 | 0 | Premier League | 28 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64211 | 2021-2022 1971 | 2022-02-13 | Leicester City 746 | West Ham United 753 | 2 | 2 | Premier League | 25 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64187 | 2021-2022 1971 | 2022-01-22 | Manchester U 924 | West Ham United 753 | 1 | 0 | Premier League | 23 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64165 | 2021-2022 1971 | 2022-01-01 | Crystal Palace 742 | West Ham United 753 | 2 | 3 | Premier League | 21 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64155 | 2021-2022 1971 | 2021-12-28 | Watford FC 913 | West Ham United 753 | 1 | 4 | Premier League | 20 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64127 | 2021-2022 1971 | 2021-12-15 | Arsenal FC 912 | West Ham United 753 | 2 | 0 | Premier League | 17 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64120 | 2021-2022 1971 | 2021-12-12 | Burnley FC 916 | West Ham United 753 | 0 | 0 | Premier League | 16 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64090 | 2021-2022 1971 | 2021-11-28 | Manchester City 748 | West Ham United 753 | 2 | 1 | Premier League | 13 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64075 | 2021-2022 1971 | 2021-11-20 | Wolverhampton Wanderers 754 | West Ham United 753 | 1 | 0 | Premier League | 12 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64061 | 2021-2022 1971 | 2021-10-31 | Aston Villa 737 | West Ham United 753 | 1 | 4 | Premier League | 10 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64040 | 2021-2022 1971 | 2021-10-17 | Everton FC 918 | West Ham United 753 | 0 | 1 | Premier League | 8 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64016 | 2021-2022 1971 | 2021-09-25 | Leeds United 755 | West Ham United 753 | 1 | 2 | Premier League | 6 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 63995 | 2021-2022 1971 | 2021-09-11 | Southampton FC 920 | West Ham United 753 | 0 | 0 | Premier League | 4 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 63971 | 2021-2022 1971 | 2021-08-15 | Newcastle United 749 | West Ham United 753 | 2 | 4 | Premier League | 1 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 63952 | 2020-2021 1970 | 2021-05-19 | West Bromwich 922 | West Ham United 753 | 1 | 3 | Premier League | 37 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63938 | 2020-2021 1970 | 2021-05-15 | Brighton & Hove Albion 740 | West Ham United 753 | 1 | 1 | Premier League | 36 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63921 | 2020-2021 1970 | 2021-05-03 | Burnley FC 916 | West Ham United 753 | 1 | 2 | Premier League | 34 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63894 | 2020-2021 1970 | 2021-04-17 | Newcastle United 749 | West Ham United 753 | 3 | 2 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63882 | 2020-2021 1970 | 2021-04-05 | Wolverhampton Wanderers 754 | West Ham United 753 | 2 | 3 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63861 | 2020-2021 1970 | 2021-03-14 | Manchester U 924 | West Ham United 753 | 1 | 0 | Premier League | 28 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63833 | 2020-2021 1970 | 2021-02-27 | Manchester City 748 | West Ham United 753 | 2 | 1 | Premier League | 26 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63806 | 2020-2021 1970 | 2021-02-06 | Fulham FC 926 | West Ham United 753 | 0 | 0 | Premier League | 23 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63800 | 2020-2021 1970 | 2021-02-03 | Aston Villa 737 | West Ham United 753 | 1 | 3 | Premier League | 22 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63773 | 2020-2021 1970 | 2021-01-26 | Crystal Palace 742 | West Ham United 753 | 2 | 3 | Premier League | 20 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63743 | 2020-2021 1970 | 2021-01-01 | Everton FC 918 | West Ham United 753 | 0 | 1 | Premier League | 17 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63737 | 2020-2021 1970 | 2020-12-29 | Southampton FC 920 | West Ham United 753 | 0 | 0 | Premier League | 16 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63722 | 2020-2021 1970 | 2020-12-21 | Chelsea FC 915 | West Ham United 753 | 3 | 0 | Premier League | 14 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63693 | 2020-2021 1970 | 2020-12-11 | Leeds United 755 | West Ham United 753 | 1 | 2 | Premier League | 12 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63668 | 2020-2021 1970 | 2020-11-22 | Sheffield United 758 | West Ham United 753 | 0 | 1 | Premier League | 9 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63646 | 2020-2021 1970 | 2020-10-31 | Liverpool FC 914 | West Ham United 753 | 2 | 1 | Premier League | 7 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63629 | 2020-2021 1970 | 2020-10-18 | Tottenham Hotspur 752 | West Ham United 753 | 3 | 3 | Premier League | 5 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63618 | 2020-2021 1970 | 2020-10-04 | Leicester City 746 | West Ham United 753 | 0 | 3 | Premier League | 4 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63596 | 2020-2021 1970 | 2020-09-19 | Arsenal FC 912 | West Ham United 753 | 2 | 1 | Premier League | 2 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63504 | 2019-2020 1969 | 2020-06-23 | Tottenham Hotspur 752 | West Ham United 753 | 2 | 0 | Premier League | 31 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63484 | 2019-2020 1969 | 2020-03-07 | Arsenal FC 912 | West Ham United 753 | 1 | 0 | Premier League | 29 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63472 | 2019-2020 1969 | 2020-02-24 | Liverpool FC 914 | West Ham United 753 | 3 | 2 | Premier League | 27 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63462 | 2019-2020 1969 | 2020-02-19 | Manchester City 748 | West Ham United 753 | 2 | 0 | Premier League | 26 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63439 | 2019-2020 1969 | 2020-01-22 | Leicester City 746 | West Ham United 753 | 4 | 1 | Premier League | 24 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE match (
match_id INTEGER NOT NULL,
season_id INTEGER NOT NULL,
date DATE NOT NULL,
kickoff DATETIME,
home_team_id INTEGER NOT NULL,
away_team_id INTEGER NOT NULL,
home_score INTEGER,
away_score INTEGER,
result VARCHAR(1),
round_stage VARCHAR(64),
matchday INTEGER,
venue VARCHAR(256),
city VARCHAR(128),
country VARCHAR(128),
referee VARCHAR(128),
attendance INTEGER,
is_neutral BOOLEAN NOT NULL,
is_postponed BOOLEAN NOT NULL,
is_cancelled BOOLEAN NOT NULL,
created_at DATETIME NOT NULL,
updated_at DATETIME NOT NULL,
created_by_run_id INTEGER,
updated_by_run_id INTEGER,
source_id INTEGER,
source_raw_key VARCHAR(512),
CONSTRAINT pk_match PRIMARY KEY (match_id),
CONSTRAINT fk_match_season FOREIGN KEY(season_id) REFERENCES season (season_id),
CONSTRAINT fk_match_home_team FOREIGN KEY(home_team_id) REFERENCES team (team_id),
CONSTRAINT fk_match_away_team FOREIGN KEY(away_team_id) REFERENCES team (team_id),
CONSTRAINT fk_match_source FOREIGN KEY(source_id) REFERENCES data_source (source_id),
CONSTRAINT fk_match_created_by_run FOREIGN KEY(created_by_run_id) REFERENCES ingestion_run (run_id),
CONSTRAINT fk_match_updated_by_run FOREIGN KEY(updated_by_run_id) REFERENCES ingestion_run (run_id)
);
CREATE INDEX ix_match_away_team_id ON match (away_team_id);
CREATE INDEX ix_match_created_by_run_id ON match (created_by_run_id);
CREATE INDEX ix_match_source_id ON match (source_id);
CREATE INDEX ix_match_updated_by_run_id ON match (updated_by_run_id);
CREATE INDEX ix_match_date ON match (date);
CREATE INDEX ix_match_season_id ON match (season_id);
CREATE INDEX ix_match_source_raw_key ON match (source_raw_key);
CREATE INDEX ix_match_home_team_id ON match (home_team_id);
CREATE UNIQUE INDEX ux_match_season_date_teams ON match(season_id, date, home_team_id, away_team_id);