match
114 rows where home_team_id = 923 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: season_id, away_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65474 | 2024-2025 1974 | 2025-05-25 | AFC Bournemouth 923 | Leicester City 746 | 2 | 0 | Premier League | 38 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65458 | 2024-2025 1974 | 2025-05-10 | AFC Bournemouth 923 | Aston Villa 737 | 0 | 1 | Premier League | 36 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65441 | 2024-2025 1974 | 2025-04-27 | AFC Bournemouth 923 | Manchester U 924 | 1 | 1 | Premier League | 34 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65423 | 2024-2025 1974 | 2025-04-14 | AFC Bournemouth 923 | Fulham FC 926 | 1 | 0 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65397 | 2024-2025 1974 | 2025-04-02 | AFC Bournemouth 923 | Ipswich Town 745 | 1 | 2 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65389 | 2024-2025 1974 | 2025-03-15 | AFC Bournemouth 923 | Brentford FC 928 | 1 | 2 | Premier League | 29 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65357 | 2024-2025 1974 | 2025-02-22 | AFC Bournemouth 923 | Wolverhampton Wanderers 754 | 0 | 1 | Premier League | 26 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65335 | 2024-2025 1974 | 2025-02-01 | AFC Bournemouth 923 | Liverpool FC 914 | 0 | 2 | Premier League | 24 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65324 | 2024-2025 1974 | 2025-01-25 | AFC Bournemouth 923 | Nottingham Forest 750 | 5 | 0 | Premier League | 23 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65296 | 2024-2025 1974 | 2025-01-04 | AFC Bournemouth 923 | Everton FC 918 | 1 | 0 | Premier League | 20 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65275 | 2024-2025 1974 | 2024-12-26 | AFC Bournemouth 923 | Crystal Palace 742 | 0 | 0 | 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 | ||||||||||
| 65243 | 2024-2025 1974 | 2024-12-05 | AFC Bournemouth 923 | Tottenham Hotspur 752 | 1 | 0 | Premier League | 14 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65217 | 2024-2025 1974 | 2024-11-23 | AFC Bournemouth 923 | Brighton & Hove Albion 740 | 1 | 2 | Premier League | 12 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65195 | 2024-2025 1974 | 2024-11-02 | AFC Bournemouth 923 | Manchester City 748 | 2 | 1 | Premier League | 10 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65180 | 2024-2025 1974 | 2024-10-19 | AFC Bournemouth 923 | Arsenal FC 912 | 2 | 0 | Premier League | 8 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65163 | 2024-2025 1974 | 2024-09-30 | AFC Bournemouth 923 | Southampton FC 920 | 3 | 1 | Premier League | 6 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65141 | 2024-2025 1974 | 2024-09-14 | AFC Bournemouth 923 | Chelsea FC 915 | 0 | 1 | Premier League | 4 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65121 | 2024-2025 1974 | 2024-08-25 | AFC Bournemouth 923 | Newcastle United 749 | 1 | 1 | Premier League | 2 | 0 | 0 | 0 | 2026-06-11T02:05:55 | 2026-06-11T02:05:55 | International Results CSV 1 | ||||||||||
| 65085 | 2023-2024 1973 | 2024-05-11 | AFC Bournemouth 923 | Brentford FC 928 | 1 | 2 | Premier League | 37 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65071 | 2023-2024 1973 | 2024-04-28 | AFC Bournemouth 923 | Brighton & Hove Albion 740 | 3 | 0 | Premier League | 35 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65049 | 2023-2024 1973 | 2024-04-13 | AFC Bournemouth 923 | Manchester U 924 | 2 | 2 | Premier League | 33 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65026 | 2023-2024 1973 | 2024-04-02 | AFC Bournemouth 923 | Crystal Palace 742 | 1 | 0 | Premier League | 31 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65015 | 2023-2024 1973 | 2024-03-30 | AFC Bournemouth 923 | Everton FC 918 | 2 | 1 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64893 | 2023-2024 1973 | 2024-03-13 | AFC Bournemouth 923 | Luton Town 757 | 4 | 3 | Premier League | 17 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64995 | 2023-2024 1973 | 2024-03-09 | AFC Bournemouth 923 | Sheffield United 758 | 2 | 2 | Premier League | 28 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64979 | 2023-2024 1973 | 2024-02-24 | AFC Bournemouth 923 | Manchester City 748 | 0 | 1 | Premier League | 26 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64949 | 2023-2024 1973 | 2024-02-04 | AFC Bournemouth 923 | Nottingham Forest 750 | 1 | 1 | Premier League | 23 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64932 | 2023-2024 1973 | 2024-01-21 | AFC Bournemouth 923 | Liverpool FC 914 | 0 | 4 | Premier League | 21 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64905 | 2023-2024 1973 | 2023-12-26 | AFC Bournemouth 923 | Fulham FC 926 | 3 | 0 | Premier League | 19 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64858 | 2023-2024 1973 | 2023-12-03 | AFC Bournemouth 923 | Aston Villa 737 | 2 | 2 | Premier League | 14 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64837 | 2023-2024 1973 | 2023-11-11 | AFC Bournemouth 923 | Newcastle United 749 | 2 | 0 | Premier League | 12 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64816 | 2023-2024 1973 | 2023-10-28 | AFC Bournemouth 923 | Burnley FC 916 | 2 | 1 | Premier League | 10 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64804 | 2023-2024 1973 | 2023-10-21 | AFC Bournemouth 923 | Wolverhampton Wanderers 754 | 1 | 2 | Premier League | 9 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64784 | 2023-2024 1973 | 2023-09-30 | AFC Bournemouth 923 | Arsenal FC 912 | 0 | 4 | Premier League | 7 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64770 | 2023-2024 1973 | 2023-09-17 | AFC Bournemouth 923 | Chelsea FC 915 | 0 | 0 | Premier League | 5 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64744 | 2023-2024 1973 | 2023-08-26 | AFC Bournemouth 923 | Tottenham Hotspur 752 | 0 | 2 | 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 | ||||||||||
| 64704 | 2022-2023 1972 | 2023-05-20 | AFC Bournemouth 923 | Manchester U 924 | 0 | 1 | Premier League | 37 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64683 | 2022-2023 1972 | 2023-05-06 | AFC Bournemouth 923 | Chelsea FC 915 | 1 | 3 | Premier League | 35 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64676 | 2022-2023 1972 | 2023-04-30 | AFC Bournemouth 923 | Leeds United 755 | 4 | 1 | 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 | ||||||||||
| 64409 | 2022-2023 1972 | 2023-04-04 | AFC Bournemouth 923 | Brighton & Hove Albion 740 | 0 | 2 | Premier League | 7 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64625 | 2022-2023 1972 | 2023-04-01 | AFC Bournemouth 923 | Fulham FC 926 | 2 | 1 | Premier League | 29 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64603 | 2022-2023 1972 | 2023-03-11 | AFC Bournemouth 923 | Liverpool FC 914 | 1 | 0 | Premier League | 27 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64588 | 2022-2023 1972 | 2023-02-25 | AFC Bournemouth 923 | Manchester City 748 | 1 | 4 | Premier League | 25 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64569 | 2022-2023 1972 | 2023-02-11 | AFC Bournemouth 923 | Newcastle United 749 | 1 | 1 | Premier League | 23 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64544 | 2022-2023 1972 | 2023-01-21 | AFC Bournemouth 923 | Nottingham Forest 750 | 1 | 1 | Premier League | 21 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64516 | 2022-2023 1972 | 2022-12-31 | AFC Bournemouth 923 | Crystal Palace 742 | 0 | 2 | Premier League | 18 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64494 | 2022-2023 1972 | 2022-11-12 | AFC Bournemouth 923 | Everton FC 918 | 3 | 0 | Premier League | 16 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64474 | 2022-2023 1972 | 2022-10-29 | AFC Bournemouth 923 | Tottenham Hotspur 752 | 2 | 3 | Premier League | 14 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64455 | 2022-2023 1972 | 2022-10-19 | AFC Bournemouth 923 | Southampton FC 920 | 0 | 1 | Premier League | 12 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64433 | 2022-2023 1972 | 2022-10-08 | AFC Bournemouth 923 | Leicester City 746 | 2 | 1 | Premier League | 10 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64424 | 2022-2023 1972 | 2022-10-01 | AFC Bournemouth 923 | Brentford FC 928 | 0 | 0 | Premier League | 9 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64388 | 2022-2023 1972 | 2022-08-31 | AFC Bournemouth 923 | Wolverhampton Wanderers 754 | 0 | 0 | Premier League | 5 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64368 | 2022-2023 1972 | 2022-08-20 | AFC Bournemouth 923 | Arsenal FC 912 | 0 | 3 | Premier League | 3 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 64345 | 2022-2023 1972 | 2022-08-06 | AFC Bournemouth 923 | Aston Villa 737 | 2 | 0 | Premier League | 1 | 0 | 0 | 0 | 2026-06-11T02:05:53 | 2026-06-11T02:05:53 | International Results CSV 1 | ||||||||||
| 63498 | 2019-2020 1969 | 2020-06-20 | AFC Bournemouth 923 | Crystal Palace 742 | 0 | 2 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63475 | 2019-2020 1969 | 2020-02-29 | AFC Bournemouth 923 | Chelsea FC 915 | 2 | 2 | Premier League | 28 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63444 | 2019-2020 1969 | 2020-02-01 | AFC Bournemouth 923 | Aston Villa 737 | 2 | 1 | Premier League | 25 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63434 | 2019-2020 1969 | 2020-01-21 | AFC Bournemouth 923 | Brighton & Hove Albion 740 | 3 | 1 | Premier League | 24 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63421 | 2019-2020 1969 | 2020-01-12 | AFC Bournemouth 923 | Watford FC 913 | 0 | 3 | Premier League | 22 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63385 | 2019-2020 1969 | 2019-12-26 | AFC Bournemouth 923 | Arsenal FC 912 | 1 | 1 | Premier League | 19 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63374 | 2019-2020 1969 | 2019-12-21 | AFC Bournemouth 923 | Burnley FC 916 | 0 | 1 | Premier League | 18 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63356 | 2019-2020 1969 | 2019-12-07 | AFC Bournemouth 923 | Liverpool FC 914 | 0 | 3 | Premier League | 16 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63328 | 2019-2020 1969 | 2019-11-23 | AFC Bournemouth 923 | Wolverhampton Wanderers 754 | 1 | 2 | Premier League | 13 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63303 | 2019-2020 1969 | 2019-11-02 | AFC Bournemouth 923 | Manchester U 924 | 1 | 0 | Premier League | 11 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63285 | 2019-2020 1969 | 2019-10-19 | AFC Bournemouth 923 | Norwich City 927 | 0 | 0 | Premier League | 9 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63265 | 2019-2020 1969 | 2019-09-28 | AFC Bournemouth 923 | West Ham United 753 | 2 | 2 | Premier League | 7 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63250 | 2019-2020 1969 | 2019-09-15 | AFC Bournemouth 923 | Everton FC 918 | 3 | 1 | Premier League | 5 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63230 | 2019-2020 1969 | 2019-08-25 | AFC Bournemouth 923 | Manchester City 748 | 1 | 3 | Premier League | 3 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63205 | 2019-2020 1969 | 2019-08-10 | AFC Bournemouth 923 | Sheffield United 758 | 1 | 1 | Premier League | 1 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63564 | 2019-2020 1969 | 2019-07-19 | AFC Bournemouth 923 | Southampton FC 920 | 0 | 2 | Premier League | 37 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63551 | 2019-2020 1969 | 2019-07-12 | AFC Bournemouth 923 | Leicester City 746 | 4 | 1 | Premier League | 35 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63540 | 2019-2020 1969 | 2019-07-09 | AFC Bournemouth 923 | Tottenham Hotspur 752 | 0 | 0 | Premier League | 34 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63518 | 2019-2020 1969 | 2019-07-01 | AFC Bournemouth 923 | Newcastle United 749 | 1 | 4 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63184 | 2018-2019 1968 | 2019-05-04 | AFC Bournemouth 923 | Tottenham Hotspur 752 | 1 | 0 | Premier League | 37 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63164 | 2018-2019 1968 | 2019-04-20 | AFC Bournemouth 923 | Fulham FC 926 | 0 | 1 | Premier League | 35 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63147 | 2018-2019 1968 | 2019-04-06 | AFC Bournemouth 923 | Burnley FC 916 | 1 | 3 | Premier League | 33 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63123 | 2018-2019 1968 | 2019-03-16 | AFC Bournemouth 923 | Newcastle United 749 | 2 | 2 | Premier League | 31 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63104 | 2018-2019 1968 | 2019-03-02 | AFC Bournemouth 923 | Manchester City 748 | 0 | 1 | Premier League | 29 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63087 | 2018-2019 1968 | 2019-02-23 | AFC Bournemouth 923 | Wolverhampton Wanderers 754 | 1 | 1 | Premier League | 27 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63059 | 2018-2019 1968 | 2019-01-30 | AFC Bournemouth 923 | Chelsea FC 915 | 4 | 0 | Premier League | 24 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63044 | 2018-2019 1968 | 2019-01-19 | AFC Bournemouth 923 | West Ham United 753 | 2 | 0 | Premier League | 23 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63026 | 2018-2019 1968 | 2019-01-02 | AFC Bournemouth 923 | Watford FC 913 | 3 | 3 | Premier League | 21 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62995 | 2018-2019 1968 | 2018-12-22 | AFC Bournemouth 923 | Brighton & Hove Albion 740 | 2 | 0 | Premier League | 18 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62973 | 2018-2019 1968 | 2018-12-08 | AFC Bournemouth 923 | Liverpool FC 914 | 0 | 4 | Premier League | 16 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62963 | 2018-2019 1968 | 2018-12-04 | AFC Bournemouth 923 | Huddersfield Town 917 | 2 | 1 | Premier League | 15 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62950 | 2018-2019 1968 | 2018-11-25 | AFC Bournemouth 923 | Arsenal FC 912 | 1 | 2 | Premier League | 13 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62923 | 2018-2019 1968 | 2018-11-03 | AFC Bournemouth 923 | Manchester U 924 | 1 | 2 | Premier League | 11 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62904 | 2018-2019 1968 | 2018-10-20 | AFC Bournemouth 923 | Southampton FC 920 | 0 | 0 | Premier League | 9 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62892 | 2018-2019 1968 | 2018-10-01 | AFC Bournemouth 923 | Crystal Palace 742 | 2 | 1 | Premier League | 7 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62867 | 2018-2019 1968 | 2018-09-15 | AFC Bournemouth 923 | Leicester City 746 | 4 | 2 | Premier League | 5 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62845 | 2018-2019 1968 | 2018-08-25 | AFC Bournemouth 923 | Everton FC 918 | 2 | 2 | Premier League | 3 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62825 | 2018-2019 1968 | 2018-08-11 | AFC Bournemouth 923 | Cardiff City 925 | 2 | 0 | Premier League | 1 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62805 | 2017-2018 1967 | 2018-05-05 | AFC Bournemouth 923 | Swansea City 921 | 1 | 0 | Premier League | 37 | 0 | 0 | 0 | 2026-06-11T02:05:47 | 2026-06-11T02:05:47 | International Results CSV 1 | ||||||||||
| 62784 | 2017-2018 1967 | 2018-04-18 | AFC Bournemouth 923 | Manchester U 924 | 0 | 2 | Premier League | 35 | 0 | 0 | 0 | 2026-06-11T02:05:47 | 2026-06-11T02:05:47 | International Results CSV 1 | ||||||||||
| 62764 | 2017-2018 1967 | 2018-04-07 | AFC Bournemouth 923 | Crystal Palace 742 | 2 | 2 | Premier League | 33 | 0 | 0 | 0 | 2026-06-11T02:05:47 | 2026-06-11T02:05:47 | International Results CSV 1 | ||||||||||
| 62743 | 2017-2018 1967 | 2018-03-17 | AFC Bournemouth 923 | West Bromwich 922 | 2 | 1 | Premier League | 31 | 0 | 0 | 0 | 2026-06-11T02:05:47 | 2026-06-11T02:05:47 | International Results CSV 1 | ||||||||||
| 62741 | 2017-2018 1967 | 2018-03-11 | AFC Bournemouth 923 | Tottenham Hotspur 752 | 1 | 4 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:47 | 2026-06-11T02:05:47 | 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);