match
114 rows where away_team_id = 916 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65088 | 2023-2024 1973 | 2024-05-11 | Tottenham Hotspur 752 | Burnley FC 916 | 2 | 1 | Premier League | 37 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65066 | 2023-2024 1973 | 2024-04-27 | Manchester U 924 | Burnley FC 916 | 1 | 1 | Premier League | 35 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65055 | 2023-2024 1973 | 2024-04-20 | Sheffield United 758 | Burnley FC 916 | 1 | 4 | Premier League | 34 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65036 | 2023-2024 1973 | 2024-04-06 | Everton FC 918 | Burnley FC 916 | 1 | 0 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65016 | 2023-2024 1973 | 2024-03-30 | Chelsea FC 915 | Burnley FC 916 | 2 | 2 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 65001 | 2023-2024 1973 | 2024-03-10 | West Ham United 753 | Burnley FC 916 | 2 | 2 | Premier League | 28 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64977 | 2023-2024 1973 | 2024-02-24 | Crystal Palace 742 | Burnley FC 916 | 3 | 0 | Premier League | 26 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64956 | 2023-2024 1973 | 2024-02-10 | Liverpool FC 914 | Burnley FC 916 | 3 | 1 | 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 | ||||||||||
| 64915 | 2023-2024 1973 | 2023-12-30 | Aston Villa 737 | Burnley FC 916 | 3 | 2 | Premier League | 20 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64897 | 2023-2024 1973 | 2023-12-23 | Fulham FC 926 | Burnley FC 916 | 0 | 2 | Premier League | 18 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64874 | 2023-2024 1973 | 2023-12-09 | Brighton & Hove Albion 740 | Burnley FC 916 | 1 | 1 | Premier League | 16 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64863 | 2023-2024 1973 | 2023-12-05 | Wolverhampton Wanderers 754 | Burnley FC 916 | 1 | 0 | Premier League | 15 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64834 | 2023-2024 1973 | 2023-11-11 | Arsenal FC 912 | Burnley FC 916 | 3 | 1 | 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 | ||||||||||
| 64805 | 2023-2024 1973 | 2023-10-21 | Brentford FC 928 | Burnley FC 916 | 3 | 0 | Premier League | 9 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64742 | 2023-2024 1973 | 2023-10-03 | Luton Town 757 | Burnley FC 916 | 1 | 2 | Premier League | 2 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64787 | 2023-2024 1973 | 2023-09-30 | Newcastle United 749 | Burnley FC 916 | 2 | 0 | Premier League | 7 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64772 | 2023-2024 1973 | 2023-09-18 | Nottingham Forest 750 | Burnley FC 916 | 1 | 1 | Premier League | 5 | 0 | 0 | 0 | 2026-06-11T02:05:54 | 2026-06-11T02:05:54 | International Results CSV 1 | ||||||||||
| 64142 | 2021-2022 1971 | 2022-05-19 | Aston Villa 737 | Burnley FC 916 | 1 | 1 | Premier League | 18 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64324 | 2021-2022 1971 | 2022-05-15 | Tottenham Hotspur 752 | Burnley FC 916 | 1 | 0 | Premier League | 37 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64306 | 2021-2022 1971 | 2022-04-30 | Watford FC 913 | Burnley FC 916 | 1 | 2 | Premier League | 35 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64288 | 2021-2022 1971 | 2022-04-17 | West Ham United 753 | Burnley FC 916 | 1 | 1 | Premier League | 33 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64281 | 2021-2022 1971 | 2022-04-10 | Norwich City 927 | Burnley FC 916 | 2 | 0 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64244 | 2021-2022 1971 | 2022-03-12 | Brentford FC 928 | Burnley FC 916 | 2 | 0 | Premier League | 29 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64226 | 2021-2022 1971 | 2022-02-26 | Crystal Palace 742 | Burnley FC 916 | 1 | 1 | Premier League | 27 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64216 | 2021-2022 1971 | 2022-02-19 | Brighton & Hove Albion 740 | Burnley FC 916 | 0 | 3 | Premier League | 26 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64189 | 2021-2022 1971 | 2022-01-23 | Arsenal FC 912 | Burnley FC 916 | 0 | 0 | Premier League | 23 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64168 | 2021-2022 1971 | 2022-01-02 | Leeds United 755 | Burnley FC 916 | 3 | 1 | Premier League | 21 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64159 | 2021-2022 1971 | 2021-12-30 | Manchester U 924 | Burnley FC 916 | 3 | 1 | Premier League | 20 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64105 | 2021-2022 1971 | 2021-12-04 | Newcastle United 749 | Burnley FC 916 | 1 | 0 | Premier League | 15 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64095 | 2021-2022 1971 | 2021-12-01 | Wolverhampton Wanderers 754 | Burnley FC 916 | 0 | 0 | Premier League | 14 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64066 | 2021-2022 1971 | 2021-11-06 | Chelsea FC 915 | Burnley FC 916 | 1 | 1 | Premier League | 11 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64048 | 2021-2022 1971 | 2021-10-23 | Southampton FC 920 | Burnley FC 916 | 2 | 2 | Premier League | 9 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64036 | 2021-2022 1971 | 2021-10-16 | Manchester City 748 | Burnley FC 916 | 2 | 0 | Premier League | 8 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64017 | 2021-2022 1971 | 2021-09-25 | Leicester City 746 | Burnley FC 916 | 2 | 2 | Premier League | 6 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 64002 | 2021-2022 1971 | 2021-09-13 | Everton FC 918 | Burnley FC 916 | 3 | 1 | Premier League | 4 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 63973 | 2021-2022 1971 | 2021-08-21 | Liverpool FC 914 | Burnley FC 916 | 2 | 0 | Premier League | 2 | 0 | 0 | 0 | 2026-06-11T02:05:51 | 2026-06-11T02:05:51 | International Results CSV 1 | ||||||||||
| 63960 | 2020-2021 1970 | 2021-05-23 | Sheffield United 758 | Burnley FC 916 | 1 | 0 | Premier League | 38 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63932 | 2020-2021 1970 | 2021-05-10 | Fulham FC 926 | Burnley FC 916 | 0 | 2 | Premier League | 35 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63909 | 2020-2021 1970 | 2021-04-25 | Wolverhampton Wanderers 754 | Burnley FC 916 | 0 | 4 | Premier League | 33 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63897 | 2020-2021 1970 | 2021-04-18 | Manchester U 924 | Burnley FC 916 | 3 | 1 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63877 | 2020-2021 1970 | 2021-04-04 | Southampton FC 920 | Burnley FC 916 | 3 | 2 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63856 | 2020-2021 1970 | 2021-03-13 | Everton FC 918 | Burnley FC 916 | 1 | 2 | Premier League | 28 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63839 | 2020-2021 1970 | 2021-02-28 | Tottenham Hotspur 752 | Burnley FC 916 | 4 | 0 | Premier League | 26 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63814 | 2020-2021 1970 | 2021-02-13 | Crystal Palace 742 | Burnley FC 916 | 0 | 3 | Premier League | 24 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63789 | 2020-2021 1970 | 2021-01-31 | Chelsea FC 915 | Burnley FC 916 | 2 | 0 | Premier League | 21 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63760 | 2020-2021 1970 | 2021-01-21 | Liverpool FC 914 | Burnley FC 916 | 0 | 1 | Premier League | 18 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63764 | 2020-2021 1970 | 2021-01-16 | West Ham United 753 | Burnley FC 916 | 1 | 0 | Premier League | 19 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63729 | 2020-2021 1970 | 2020-12-27 | Leeds United 755 | Burnley FC 916 | 1 | 0 | Premier League | 15 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63711 | 2020-2021 1970 | 2020-12-17 | Aston Villa 737 | Burnley FC 916 | 0 | 0 | Premier League | 13 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63702 | 2020-2021 1970 | 2020-12-13 | Arsenal FC 912 | Burnley FC 916 | 0 | 1 | Premier League | 12 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63675 | 2020-2021 1970 | 2020-11-28 | Manchester City 748 | Burnley FC 916 | 5 | 0 | Premier League | 10 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63653 | 2020-2021 1970 | 2020-11-06 | Brighton & Hove Albion 740 | Burnley FC 916 | 0 | 0 | Premier League | 8 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63631 | 2020-2021 1970 | 2020-10-19 | West Bromwich 922 | Burnley FC 916 | 0 | 0 | Premier League | 5 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63616 | 2020-2021 1970 | 2020-10-03 | Newcastle United 749 | Burnley FC 916 | 3 | 1 | Premier League | 4 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63600 | 2020-2021 1970 | 2020-09-20 | Leicester City 746 | Burnley FC 916 | 4 | 2 | Premier League | 2 | 0 | 0 | 0 | 2026-06-11T02:05:50 | 2026-06-11T02:05:50 | International Results CSV 1 | ||||||||||
| 63515 | 2019-2020 1969 | 2020-06-29 | Crystal Palace 742 | Burnley FC 916 | 0 | 1 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63502 | 2019-2020 1969 | 2020-06-22 | Manchester City 748 | Burnley FC 916 | 5 | 0 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63476 | 2019-2020 1969 | 2020-02-29 | Newcastle United 749 | Burnley FC 916 | 0 | 0 | Premier League | 28 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63457 | 2019-2020 1969 | 2020-02-15 | Southampton FC 920 | Burnley FC 916 | 1 | 2 | Premier League | 26 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63441 | 2019-2020 1969 | 2020-01-22 | Manchester U 924 | Burnley FC 916 | 0 | 2 | Premier League | 24 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63415 | 2019-2020 1969 | 2020-01-11 | Chelsea FC 915 | Burnley FC 916 | 3 | 0 | Premier League | 22 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63388 | 2019-2020 1969 | 2019-12-26 | Everton FC 918 | Burnley FC 916 | 1 | 0 | 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 | ||||||||||
| 63355 | 2019-2020 1969 | 2019-12-07 | Tottenham Hotspur 752 | Burnley FC 916 | 5 | 0 | Premier League | 16 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63325 | 2019-2020 1969 | 2019-11-23 | Watford FC 913 | Burnley FC 916 | 0 | 3 | Premier League | 13 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63307 | 2019-2020 1969 | 2019-11-02 | Sheffield United 758 | Burnley FC 916 | 3 | 0 | Premier League | 11 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63287 | 2019-2020 1969 | 2019-10-19 | Leicester City 746 | Burnley FC 916 | 2 | 1 | Premier League | 9 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63264 | 2019-2020 1969 | 2019-09-28 | Aston Villa 737 | Burnley FC 916 | 2 | 2 | Premier League | 7 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63244 | 2019-2020 1969 | 2019-09-14 | Brighton & Hove Albion 740 | Burnley FC 916 | 1 | 1 | Premier League | 5 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63232 | 2019-2020 1969 | 2019-08-25 | Wolverhampton Wanderers 754 | Burnley FC 916 | 1 | 1 | Premier League | 3 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63213 | 2019-2020 1969 | 2019-08-17 | Arsenal FC 912 | Burnley FC 916 | 2 | 1 | Premier League | 2 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63563 | 2019-2020 1969 | 2019-07-18 | Norwich City 927 | Burnley FC 916 | 0 | 2 | Premier League | 37 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63545 | 2019-2020 1969 | 2019-07-11 | Liverpool FC 914 | Burnley FC 916 | 1 | 1 | Premier League | 35 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63538 | 2019-2020 1969 | 2019-07-08 | West Ham United 753 | Burnley FC 916 | 0 | 1 | Premier League | 34 | 0 | 0 | 0 | 2026-06-11T02:05:49 | 2026-06-11T02:05:49 | International Results CSV 1 | ||||||||||
| 63183 | 2018-2019 1968 | 2019-05-03 | Everton FC 918 | Burnley FC 916 | 2 | 0 | Premier League | 37 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63172 | 2018-2019 1968 | 2019-04-22 | Chelsea FC 915 | Burnley FC 916 | 2 | 2 | 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 | ||||||||||
| 63120 | 2018-2019 1968 | 2019-03-10 | Liverpool FC 914 | Burnley FC 916 | 4 | 2 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63096 | 2018-2019 1968 | 2019-02-26 | Newcastle United 749 | Burnley FC 916 | 2 | 0 | Premier League | 28 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63079 | 2018-2019 1968 | 2019-02-09 | Brighton & Hove Albion 740 | Burnley FC 916 | 1 | 3 | Premier League | 26 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63057 | 2018-2019 1968 | 2019-01-29 | Manchester U 924 | Burnley FC 916 | 2 | 2 | Premier League | 24 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63049 | 2018-2019 1968 | 2019-01-19 | Watford FC 913 | Burnley FC 916 | 0 | 0 | Premier League | 23 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63028 | 2018-2019 1968 | 2019-01-02 | Huddersfield Town 917 | Burnley FC 916 | 1 | 2 | Premier League | 21 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62994 | 2018-2019 1968 | 2018-12-22 | Arsenal FC 912 | Burnley FC 916 | 3 | 1 | Premier League | 18 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62986 | 2018-2019 1968 | 2018-12-15 | Tottenham Hotspur 752 | Burnley FC 916 | 1 | 0 | Premier League | 17 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62954 | 2018-2019 1968 | 2018-12-01 | Crystal Palace 742 | Burnley FC 916 | 2 | 0 | Premier League | 14 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62935 | 2018-2019 1968 | 2018-11-10 | Leicester City 746 | Burnley FC 916 | 0 | 0 | Premier League | 12 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62927 | 2018-2019 1968 | 2018-11-03 | West Ham United 753 | Burnley FC 916 | 4 | 2 | Premier League | 11 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62906 | 2018-2019 1968 | 2018-10-20 | Manchester City 748 | Burnley FC 916 | 5 | 0 | Premier League | 9 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62891 | 2018-2019 1968 | 2018-09-30 | Cardiff City 925 | Burnley FC 916 | 1 | 2 | Premier League | 7 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62870 | 2018-2019 1968 | 2018-09-16 | Wolverhampton Wanderers 754 | Burnley FC 916 | 1 | 0 | Premier League | 5 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62850 | 2018-2019 1968 | 2018-08-26 | Fulham FC 926 | Burnley FC 916 | 4 | 2 | Premier League | 3 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62831 | 2018-2019 1968 | 2018-08-12 | Southampton FC 920 | Burnley FC 916 | 0 | 0 | Premier League | 1 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62811 | 2017-2018 1967 | 2018-05-06 | Arsenal FC 912 | Burnley FC 916 | 5 | 0 | Premier League | 37 | 0 | 0 | 0 | 2026-06-11T02:05:47 | 2026-06-11T02:05:47 | International Results CSV 1 | ||||||||||
| 62789 | 2017-2018 1967 | 2018-04-22 | Stoke City 919 | Burnley FC 916 | 1 | 1 | Premier League | 35 | 0 | 0 | 0 | 2026-06-11T02:05:47 | 2026-06-11T02:05:47 | International Results CSV 1 | ||||||||||
| 62768 | 2017-2018 1967 | 2018-04-07 | Watford FC 913 | Burnley FC 916 | 1 | 2 | Premier League | 33 | 0 | 0 | 0 | 2026-06-11T02:05:47 | 2026-06-11T02:05:47 | International Results CSV 1 | ||||||||||
| 62758 | 2017-2018 1967 | 2018-03-31 | West Bromwich 922 | Burnley FC 916 | 1 | 2 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:47 | 2026-06-11T02:05:47 | International Results CSV 1 | ||||||||||
| 62738 | 2017-2018 1967 | 2018-03-10 | West Ham United 753 | Burnley FC 916 | 0 | 3 | 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);