match
498 rows where home_team_id = 748 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: season_id, home_score, away_score, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 89179 | 2015-2016 2020 | 3916-05-08 | Manchester City 748 | Arsenal 736 | 2 | 2 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:30.425383 | 2026-06-11T09:31:30.425383 | |||||||||||
| 96036 | 2015-2016 2020 | 3916-04-23 | Manchester City 748 | Stoke 1285 | 4 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:42:12.670444 | 2026-06-11T09:42:12.670444 | |||||||||||
| 89176 | 2015-2016 2020 | 3916-04-09 | Manchester City 748 | West Bromwich 922 | 2 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:30.425383 | 2026-06-11T09:31:30.425383 | |||||||||||
| 89174 | 2015-2016 2020 | 3916-03-20 | Manchester City 748 | Manchester United 338 | 0 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:30.425383 | 2026-06-11T09:31:30.425383 | |||||||||||
| 89172 | 2015-2016 2020 | 3916-03-05 | Manchester City 748 | Aston Villa 737 | 4 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:30.425383 | 2026-06-11T09:31:30.425383 | |||||||||||
| 96000 | 2015-2016 2020 | 3916-02-14 | Manchester City 748 | Tottenham 1273 | 1 | 2 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:42:12.670444 | 2026-06-11T09:42:12.670444 | |||||||||||
| 89170 | 2015-2016 2020 | 3916-02-06 | Manchester City 748 | Leicester City 746 | 1 | 3 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:30.425383 | 2026-06-11T09:31:30.425383 | |||||||||||
| 89169 | 2015-2016 2020 | 3916-01-16 | Manchester City 748 | Crystal Palace 742 | 4 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:30.425383 | 2026-06-11T09:31:30.425383 | |||||||||||
| 89168 | 2015-2016 2020 | 3916-01-13 | Manchester City 748 | Everton 743 | 0 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:30.425383 | 2026-06-11T09:31:30.425383 | |||||||||||
| 95959 | 2015-2016 2020 | 3915-12-26 | Manchester City 748 | Sunderland 1279 | 4 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:42:12.670444 | 2026-06-11T09:42:12.670444 | |||||||||||
| 89164 | 2015-2016 2020 | 3915-12-12 | Manchester City 748 | Swansea City 921 | 2 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:30.425383 | 2026-06-11T09:31:30.425383 | |||||||||||
| 89163 | 2015-2016 2020 | 3915-11-28 | Manchester City 748 | Southampton 751 | 3 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:30.425383 | 2026-06-11T09:31:30.425383 | |||||||||||
| 89162 | 2015-2016 2020 | 3915-11-21 | Manchester City 748 | Liverpool 747 | 1 | 4 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:30.425383 | 2026-06-11T09:31:30.425383 | |||||||||||
| 89160 | 2015-2016 2020 | 3915-10-31 | Manchester City 748 | Norwich City 927 | 2 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:30.425383 | 2026-06-11T09:31:30.425383 | |||||||||||
| 89158 | 2015-2016 2020 | 3915-10-17 | Manchester City 748 | Bournemouth 738 | 5 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:30.425383 | 2026-06-11T09:31:30.425383 | |||||||||||
| 95916 | 2015-2016 2020 | 3915-10-03 | Manchester City 748 | Newcastle 1272 | 6 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:42:12.670444 | 2026-06-11T09:42:12.670444 | |||||||||||
| 95906 | 2015-2016 2020 | 3915-09-19 | Manchester City 748 | West Ham 1275 | 1 | 2 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:42:12.670444 | 2026-06-11T09:42:12.670444 | |||||||||||
| 89156 | 2015-2016 2020 | 3915-08-29 | Manchester City 748 | Watford FC 913 | 2 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:30.425383 | 2026-06-11T09:31:30.425383 | |||||||||||
| 89154 | 2015-2016 2020 | 3915-08-16 | Manchester City 748 | Chelsea 741 | 3 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:30.425383 | 2026-06-11T09:31:30.425383 | |||||||||||
| 88760 | 2002-2003 2008 | 3903-05-11 | Manchester City 748 | Southampton 751 | 0 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:30:13.188743 | 2026-06-11T09:30:13.188743 | |||||||||||
| 93169 | 2002-2003 2008 | 3903-04-27 | Manchester City 748 | West Ham 1275 | 0 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:41:39.188031 | 2026-06-11T09:41:39.188031 | |||||||||||
| 93160 | 2002-2003 2008 | 3903-04-21 | Manchester City 748 | Sunderland 1279 | 3 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:41:39.188031 | 2026-06-11T09:41:39.188031 | |||||||||||
| 93146 | 2002-2003 2008 | 3903-04-12 | Manchester City 748 | Middlesbrough 1277 | 0 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:41:39.188031 | 2026-06-11T09:41:39.188031 | |||||||||||
| 93128 | 2002-2003 2008 | 3903-03-16 | Manchester City 748 | Birmingham 1282 | 1 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:41:39.188031 | 2026-06-11T09:41:39.188031 | |||||||||||
| 88756 | 2002-2003 2008 | 3903-02-22 | Manchester City 748 | Arsenal 736 | 1 | 5 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:30:13.188743 | 2026-06-11T09:30:13.188743 | |||||||||||
| 88754 | 2002-2003 2008 | 3903-02-01 | Manchester City 748 | West Bromwich 922 | 1 | 2 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:30:13.188743 | 2026-06-11T09:30:13.188743 | |||||||||||
| 88753 | 2002-2003 2008 | 3903-01-29 | Manchester City 748 | Fulham 744 | 4 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:30:13.188743 | 2026-06-11T09:30:13.188743 | |||||||||||
| 93071 | 2002-2003 2008 | 3903-01-11 | Manchester City 748 | Leeds 1271 | 2 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:41:39.188031 | 2026-06-11T09:41:39.188031 | |||||||||||
| 88750 | 2002-2003 2008 | 3902-12-26 | Manchester City 748 | Aston Villa 737 | 3 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:30:13.188743 | 2026-06-11T09:30:13.188743 | |||||||||||
| 93050 | 2002-2003 2008 | 3902-12-23 | Manchester City 748 | Tottenham 1273 | 2 | 3 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:41:39.188031 | 2026-06-11T09:41:39.188031 | |||||||||||
| 88749 | 2002-2003 2008 | 3902-11-30 | Manchester City 748 | Bologna 783 | 2 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:30:13.188743 | 2026-06-11T09:30:13.188743 | |||||||||||
| 93006 | 2002-2003 2008 | 3902-11-16 | Manchester City 748 | Charlton 1280 | 0 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:41:39.188031 | 2026-06-11T09:41:39.188031 | |||||||||||
| 88748 | 2002-2003 2008 | 3902-11-09 | Manchester City 748 | Manchester United 338 | 3 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:30:13.188743 | 2026-06-11T09:30:13.188743 | |||||||||||
| 88746 | 2002-2003 2008 | 3902-10-19 | Manchester City 748 | Chelsea 741 | 0 | 3 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:30:13.188743 | 2026-06-11T09:30:13.188743 | |||||||||||
| 88744 | 2002-2003 2008 | 3902-09-28 | Manchester City 748 | Liverpool 747 | 0 | 3 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:30:13.188743 | 2026-06-11T09:30:13.188743 | |||||||||||
| 92953 | 2002-2003 2008 | 3902-09-15 | Manchester City 748 | Blackburn 1270 | 2 | 2 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:41:39.188031 | 2026-06-11T09:41:39.188031 | |||||||||||
| 88742 | 2002-2003 2008 | 3902-08-31 | Manchester City 748 | Everton 743 | 3 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:30:13.188743 | 2026-06-11T09:30:13.188743 | |||||||||||
| 92924 | 2002-2003 2008 | 3902-08-24 | Manchester City 748 | Newcastle 1272 | 1 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:41:39.188031 | 2026-06-11T09:41:39.188031 | |||||||||||
| 65473 | 2024-2025 1974 | 2025-05-20 | Manchester City 748 | AFC Bournemouth 923 | 3 | 1 | Premier League | 37 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65444 | 2024-2025 1974 | 2025-05-02 | Manchester City 748 | Wolverhampton Wanderers 754 | 1 | 0 | Premier League | 35 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65434 | 2024-2025 1974 | 2025-04-22 | Manchester City 748 | Aston Villa 737 | 2 | 1 | Premier League | 34 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65414 | 2024-2025 1974 | 2025-04-12 | Manchester City 748 | Crystal Palace 742 | 5 | 2 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65399 | 2024-2025 1974 | 2025-04-02 | Manchester City 748 | Leicester City 746 | 2 | 0 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65387 | 2024-2025 1974 | 2025-03-15 | Manchester City 748 | Brighton & Hove Albion 740 | 2 | 2 | Premier League | 29 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65363 | 2024-2025 1974 | 2025-02-23 | Manchester City 748 | Liverpool FC 914 | 0 | 2 | Premier League | 26 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65348 | 2024-2025 1974 | 2025-02-15 | Manchester City 748 | Newcastle United 749 | 4 | 0 | Premier League | 25 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65329 | 2024-2025 1974 | 2025-01-25 | Manchester City 748 | Chelsea FC 915 | 3 | 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 | ||||||||||
| 65274 | 2024-2025 1974 | 2024-12-26 | Manchester City 748 | Everton FC 918 | 1 | 1 | Premier League | 18 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65260 | 2024-2025 1974 | 2024-12-15 | Manchester City 748 | Manchester U 924 | 1 | 2 | Premier League | 16 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65237 | 2024-2025 1974 | 2024-12-04 | Manchester City 748 | Nottingham Forest 750 | 3 | 0 | Premier League | 14 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65220 | 2024-2025 1974 | 2024-11-23 | Manchester City 748 | Tottenham Hotspur 752 | 0 | 4 | Premier League | 12 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65188 | 2024-2025 1974 | 2024-10-26 | Manchester City 748 | Southampton FC 920 | 1 | 0 | Premier League | 9 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65168 | 2024-2025 1974 | 2024-10-05 | Manchester City 748 | Fulham FC 926 | 3 | 2 | Premier League | 7 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65153 | 2024-2025 1974 | 2024-09-22 | Manchester City 748 | Arsenal FC 912 | 2 | 2 | Premier League | 5 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65139 | 2024-2025 1974 | 2024-09-14 | Manchester City 748 | Brentford FC 928 | 2 | 1 | Premier League | 4 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65117 | 2024-2025 1974 | 2024-08-24 | Manchester City 748 | Ipswich Town 745 | 4 | 1 | 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 | ||||||||||
| 65079 | 2023-2024 1973 | 2024-05-04 | Manchester City 748 | Wolverhampton Wanderers 754 | 5 | 1 | Premier League | 36 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65047 | 2023-2024 1973 | 2024-04-13 | Manchester City 748 | Luton Town 757 | 5 | 1 | Premier League | 33 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65031 | 2023-2024 1973 | 2024-04-03 | Manchester City 748 | Aston Villa 737 | 4 | 1 | Premier League | 31 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65023 | 2023-2024 1973 | 2024-03-31 | Manchester City 748 | Arsenal FC 912 | 0 | 0 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64992 | 2023-2024 1973 | 2024-03-03 | Manchester City 748 | Manchester U 924 | 3 | 1 | Premier League | 27 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64903 | 2023-2024 1973 | 2024-02-20 | Manchester City 748 | Brentford FC 928 | 1 | 0 | Premier League | 18 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64970 | 2023-2024 1973 | 2024-02-17 | Manchester City 748 | Chelsea FC 915 | 1 | 1 | Premier League | 25 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64954 | 2023-2024 1973 | 2024-02-10 | Manchester City 748 | Everton FC 918 | 2 | 0 | Premier League | 24 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64939 | 2023-2024 1973 | 2024-01-31 | Manchester City 748 | Burnley FC 916 | 3 | 1 | Premier League | 22 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64917 | 2023-2024 1973 | 2023-12-30 | Manchester City 748 | Sheffield United 758 | 2 | 0 | Premier League | 20 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64886 | 2023-2024 1973 | 2023-12-16 | Manchester City 748 | Crystal Palace 742 | 2 | 2 | Premier League | 17 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64862 | 2023-2024 1973 | 2023-12-03 | Manchester City 748 | Tottenham Hotspur 752 | 3 | 3 | Premier League | 14 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64843 | 2023-2024 1973 | 2023-11-25 | Manchester City 748 | Liverpool FC 914 | 1 | 1 | Premier League | 13 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64827 | 2023-2024 1973 | 2023-11-04 | Manchester City 748 | AFC Bournemouth 923 | 6 | 1 | Premier League | 11 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64806 | 2023-2024 1973 | 2023-10-21 | Manchester City 748 | Brighton & Hove Albion 740 | 2 | 1 | Premier League | 9 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64775 | 2023-2024 1973 | 2023-09-23 | Manchester City 748 | Nottingham Forest 750 | 2 | 0 | Premier League | 6 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64758 | 2023-2024 1973 | 2023-09-02 | Manchester City 748 | Fulham FC 926 | 5 | 1 | Premier League | 4 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64738 | 2023-2024 1973 | 2023-08-19 | Manchester City 748 | Newcastle United 749 | 1 | 0 | Premier League | 2 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64711 | 2022-2023 1972 | 2023-05-21 | Manchester City 748 | Chelsea FC 915 | 1 | 0 | Premier League | 37 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64684 | 2022-2023 1972 | 2023-05-06 | Manchester City 748 | Leeds United 755 | 2 | 1 | Premier League | 35 | 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 | ||||||||||
| 64669 | 2022-2023 1972 | 2023-04-26 | Manchester City 748 | Arsenal FC 912 | 4 | 1 | Premier League | 33 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64649 | 2022-2023 1972 | 2023-04-15 | Manchester City 748 | Leicester City 746 | 3 | 1 | Premier League | 31 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64623 | 2022-2023 1972 | 2023-04-01 | Manchester City 748 | Liverpool FC 914 | 4 | 1 | Premier League | 29 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64593 | 2022-2023 1972 | 2023-03-04 | Manchester City 748 | Newcastle United 749 | 2 | 0 | Premier League | 26 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64571 | 2022-2023 1972 | 2023-02-12 | Manchester City 748 | Aston Villa 737 | 3 | 1 | Premier League | 23 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64550 | 2022-2023 1972 | 2023-01-22 | Manchester City 748 | Wolverhampton Wanderers 754 | 3 | 0 | Premier League | 21 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64405 | 2022-2023 1972 | 2023-01-19 | Manchester City 748 | Tottenham Hotspur 752 | 4 | 2 | Premier League | 7 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64518 | 2022-2023 1972 | 2022-12-31 | Manchester City 748 | Everton FC 918 | 1 | 1 | Premier League | 18 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64493 | 2022-2023 1972 | 2022-11-12 | Manchester City 748 | Brentford FC 928 | 1 | 2 | Premier League | 16 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64484 | 2022-2023 1972 | 2022-11-05 | Manchester City 748 | Fulham FC 926 | 2 | 1 | Premier League | 15 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64465 | 2022-2023 1972 | 2022-10-22 | Manchester City 748 | Brighton & Hove Albion 740 | 3 | 1 | Premier League | 13 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64435 | 2022-2023 1972 | 2022-10-08 | Manchester City 748 | Southampton FC 920 | 4 | 0 | Premier League | 10 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64430 | 2022-2023 1972 | 2022-10-02 | Manchester City 748 | Manchester U 924 | 6 | 3 | Premier League | 9 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64389 | 2022-2023 1972 | 2022-08-31 | Manchester City 748 | Nottingham Forest 750 | 6 | 0 | Premier League | 5 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64378 | 2022-2023 1972 | 2022-08-27 | Manchester City 748 | Crystal Palace 742 | 4 | 2 | Premier League | 4 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64356 | 2022-2023 1972 | 2022-08-13 | Manchester City 748 | AFC Bournemouth 923 | 4 | 0 | Premier League | 2 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64341 | 2021-2022 1971 | 2022-05-22 | Manchester City 748 | Aston Villa 737 | 3 | 2 | Premier League | 38 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64322 | 2021-2022 1971 | 2022-05-08 | Manchester City 748 | Newcastle United 749 | 5 | 0 | Premier League | 36 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64295 | 2021-2022 1971 | 2022-04-23 | Manchester City 748 | Watford FC 913 | 5 | 1 | Premier League | 34 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64260 | 2021-2022 1971 | 2022-04-20 | Manchester City 748 | Brighton & Hove Albion 740 | 3 | 0 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64282 | 2021-2022 1971 | 2022-04-10 | Manchester City 748 | Liverpool FC 914 | 2 | 2 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | 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);