match
552 rows where away_team_id = 798 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71550 | 2024-2025 1990 | 2025-05-18 | Juventus 341 | Udinese 798 | 2 | 0 | Serie A | 37 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71525 | 2024-2025 1990 | 2025-05-03 | Cagliari 784 | Udinese 798 | 1 | 2 | Serie A | 35 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71513 | 2024-2025 1990 | 2025-04-23 | Torino FC 951 | Udinese 798 | 2 | 0 | Serie A | 33 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71484 | 2024-2025 1990 | 2025-04-04 | Genoa 788 | Udinese 798 | 1 | 0 | Serie A | 31 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71480 | 2024-2025 1990 | 2025-03-30 | Inter Milan 954 | Udinese 798 | 2 | 1 | Serie A | 30 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71463 | 2024-2025 1990 | 2025-03-10 | SS Lazio 956 | Udinese 798 | 1 | 1 | Serie A | 28 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71434 | 2024-2025 1990 | 2025-02-21 | US Lecce 962 | Udinese 798 | 0 | 1 | Serie A | 26 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71422 | 2024-2025 1990 | 2025-02-09 | Napoli 794 | Udinese 798 | 1 | 1 | Serie A | 24 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71393 | 2024-2025 1990 | 2025-01-20 | Como 1907 965 | Udinese 798 | 4 | 1 | Serie A | 21 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71366 | 2024-2025 1990 | 2025-01-04 | Hellas Verona 961 | Udinese 798 | 0 | 0 | Serie A | 19 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71352 | 2024-2025 1990 | 2024-12-23 | Fiorentina 787 | Udinese 798 | 1 | 2 | Serie A | 17 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71333 | 2024-2025 1990 | 2024-12-09 | Monza 793 | Udinese 798 | 1 | 2 | Serie A | 15 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71312 | 2024-2025 1990 | 2024-11-25 | Empoli 786 | Udinese 798 | 1 | 1 | Serie A | 13 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71299 | 2024-2025 1990 | 2024-11-10 | Atalanta 782 | Udinese 798 | 2 | 1 | Serie A | 12 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71278 | 2024-2025 1990 | 2024-10-30 | Venezia FC 964 | Udinese 798 | 3 | 2 | Serie A | 10 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71256 | 2024-2025 1990 | 2024-10-19 | Milan 792 | Udinese 798 | 1 | 0 | Serie A | 8 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71231 | 2024-2025 1990 | 2024-09-22 | Roma 796 | Udinese 798 | 3 | 0 | Serie A | 5 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71222 | 2024-2025 1990 | 2024-09-16 | Parma Calcio 959 | Udinese 798 | 2 | 3 | Serie A | 4 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71188 | 2024-2025 1990 | 2024-08-18 | Bologna 783 | Udinese 798 | 1 | 1 | Serie A | 1 | 0 | 0 | 0 | 2026-06-11T02:06:14 | 2026-06-11T02:06:14 | International Results CSV 1 | ||||||||||
| 71181 | 2023-2024 1989 | 2024-05-26 | Frosinone 806 | Udinese 798 | 0 | 1 | Serie A | 38 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71162 | 2023-2024 1989 | 2024-05-13 | US Lecce 962 | Udinese 798 | 0 | 2 | Serie A | 36 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71139 | 2023-2024 1989 | 2024-04-28 | Bologna 783 | Udinese 798 | 1 | 1 | Serie A | 34 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71127 | 2023-2024 1989 | 2024-04-20 | Hellas Verona 961 | Udinese 798 | 1 | 0 | Serie A | 33 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71101 | 2023-2024 1989 | 2024-04-01 | Sassuolo 804 | Udinese 798 | 1 | 1 | Serie A | 30 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71083 | 2023-2024 1989 | 2024-03-11 | SS Lazio 956 | Udinese 798 | 1 | 2 | Serie A | 28 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71057 | 2023-2024 1989 | 2024-02-24 | Genoa 788 | Udinese 798 | 2 | 0 | Serie A | 26 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71043 | 2023-2024 1989 | 2024-02-12 | Juventus 341 | Udinese 798 | 0 | 1 | Serie A | 24 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71015 | 2023-2024 1989 | 2024-01-27 | Atalanta 782 | Udinese 798 | 2 | 0 | Serie A | 22 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71000 | 2023-2024 1989 | 2024-01-14 | Fiorentina 787 | Udinese 798 | 2 | 2 | Serie A | 20 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70970 | 2023-2024 1989 | 2023-12-23 | Torino FC 951 | Udinese 798 | 1 | 1 | Serie A | 17 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70947 | 2023-2024 1989 | 2023-12-09 | Inter Milan 954 | Udinese 798 | 4 | 0 | Serie A | 15 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70930 | 2023-2024 1989 | 2023-11-26 | Roma 796 | Udinese 798 | 3 | 1 | Serie A | 13 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70907 | 2023-2024 1989 | 2023-11-04 | Milan 792 | Udinese 798 | 0 | 1 | Serie A | 11 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70899 | 2023-2024 1989 | 2023-10-29 | Monza 793 | Udinese 798 | 1 | 1 | Serie A | 10 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70874 | 2023-2024 1989 | 2023-10-06 | Empoli 786 | Udinese 798 | 0 | 0 | Serie A | 8 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70859 | 2023-2024 1989 | 2023-09-27 | Napoli 794 | Udinese 798 | 4 | 1 | Serie A | 6 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70837 | 2023-2024 1989 | 2023-09-17 | Cagliari 784 | Udinese 798 | 0 | 0 | Serie A | 4 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70822 | 2023-2024 1989 | 2023-08-28 | Salernitana 802 | Udinese 798 | 1 | 1 | Serie A | 2 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70785 | 2022-2023 1988 | 2023-05-27 | Salernitana 802 | Udinese 798 | 3 | 2 | Serie A | 37 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70769 | 2022-2023 1988 | 2023-05-14 | Fiorentina 787 | Udinese 798 | 2 | 0 | Serie A | 35 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70734 | 2022-2023 1988 | 2023-04-28 | US Lecce 962 | Udinese 798 | 1 | 0 | Serie A | 32 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70722 | 2022-2023 1988 | 2023-04-16 | Roma 796 | Udinese 798 | 3 | 0 | Serie A | 30 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70697 | 2022-2023 1988 | 2023-04-02 | Bologna 783 | Udinese 798 | 3 | 0 | Serie A | 28 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70675 | 2022-2023 1988 | 2023-03-11 | Empoli 786 | Udinese 798 | 0 | 1 | Serie A | 26 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70666 | 2022-2023 1988 | 2023-03-04 | Atalanta 782 | Udinese 798 | 0 | 0 | Serie A | 25 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70647 | 2022-2023 1988 | 2023-02-18 | Inter Milan 954 | Udinese 798 | 3 | 1 | Serie A | 23 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70628 | 2022-2023 1988 | 2023-02-05 | Torino FC 951 | Udinese 798 | 1 | 0 | Serie A | 21 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70607 | 2022-2023 1988 | 2023-01-22 | Sampdoria 803 | Udinese 798 | 0 | 1 | Serie A | 19 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70585 | 2022-2023 1988 | 2023-01-07 | Juventus 341 | Udinese 798 | 1 | 0 | Serie A | 17 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70565 | 2022-2023 1988 | 2022-11-12 | Napoli 794 | Udinese 798 | 3 | 2 | Serie A | 15 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70555 | 2022-2023 1988 | 2022-11-08 | Spezia Calcio 963 | Udinese 798 | 1 | 1 | Serie A | 14 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70538 | 2022-2023 1988 | 2022-10-30 | Cremonese 801 | Udinese 798 | 0 | 0 | Serie A | 12 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70519 | 2022-2023 1988 | 2022-10-16 | SS Lazio 956 | Udinese 798 | 0 | 0 | Serie A | 10 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70503 | 2022-2023 1988 | 2022-10-03 | Hellas Verona 961 | Udinese 798 | 1 | 2 | Serie A | 8 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70480 | 2022-2023 1988 | 2022-09-11 | Sassuolo 804 | Udinese 798 | 1 | 3 | Serie A | 6 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70444 | 2022-2023 1988 | 2022-08-26 | Monza 793 | Udinese 798 | 1 | 2 | Serie A | 3 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70424 | 2022-2023 1988 | 2022-08-13 | Milan 792 | Udinese 798 | 4 | 2 | Serie A | 1 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70422 | 2021-2022 1987 | 2022-05-22 | Salernitana 802 | Udinese 798 | 0 | 4 | Serie A | 38 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70397 | 2021-2022 1987 | 2022-05-07 | Sassuolo 804 | Udinese 798 | 1 | 1 | Serie A | 36 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70240 | 2021-2022 1987 | 2022-04-27 | Fiorentina 787 | Udinese 798 | 0 | 4 | Serie A | 20 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70379 | 2021-2022 1987 | 2022-04-24 | Bologna 783 | Udinese 798 | 2 | 2 | Serie A | 34 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70360 | 2021-2022 1987 | 2022-04-10 | Venezia FC 964 | Udinese 798 | 1 | 2 | Serie A | 32 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70336 | 2021-2022 1987 | 2022-03-19 | Napoli 794 | Udinese 798 | 2 | 1 | Serie A | 30 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70304 | 2021-2022 1987 | 2022-02-25 | Milan 792 | Udinese 798 | 1 | 1 | Serie A | 27 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70288 | 2021-2022 1987 | 2022-02-13 | Hellas Verona 961 | Udinese 798 | 4 | 0 | Serie A | 25 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70265 | 2021-2022 1987 | 2022-01-22 | Genoa 788 | Udinese 798 | 0 | 0 | Serie A | 23 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70256 | 2021-2022 1987 | 2022-01-15 | Juventus 341 | Udinese 798 | 2 | 0 | Serie A | 22 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70218 | 2021-2022 1987 | 2021-12-18 | Cagliari 784 | Udinese 798 | 0 | 4 | Serie A | 18 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70202 | 2021-2022 1987 | 2021-12-06 | Empoli 786 | Udinese 798 | 3 | 1 | Serie A | 16 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70193 | 2021-2022 1987 | 2021-12-02 | SS Lazio 956 | Udinese 798 | 4 | 4 | Serie A | 15 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70173 | 2021-2022 1987 | 2021-11-22 | Torino FC 951 | Udinese 798 | 2 | 1 | Serie A | 13 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70147 | 2021-2022 1987 | 2021-10-31 | Inter Milan 954 | Udinese 798 | 2 | 0 | Serie A | 11 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70129 | 2021-2022 1987 | 2021-10-24 | Atalanta 782 | Udinese 798 | 1 | 1 | Serie A | 9 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70110 | 2021-2022 1987 | 2021-10-03 | Sampdoria 803 | Udinese 798 | 3 | 3 | Serie A | 7 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70093 | 2021-2022 1987 | 2021-09-23 | Roma 796 | Udinese 798 | 1 | 0 | Serie A | 5 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70068 | 2021-2022 1987 | 2021-09-12 | Spezia Calcio 963 | Udinese 798 | 0 | 1 | Serie A | 3 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70037 | 2020-2021 1986 | 2021-05-23 | Inter Milan 954 | Udinese 798 | 5 | 1 | Serie A | 38 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 70014 | 2020-2021 1986 | 2021-05-11 | Napoli 794 | Udinese 798 | 5 | 1 | Serie A | 36 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69987 | 2020-2021 1986 | 2021-04-25 | Benevento 955 | Udinese 798 | 2 | 4 | Serie A | 33 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69965 | 2020-2021 1986 | 2021-04-17 | FC Crotone 952 | Udinese 798 | 1 | 2 | Serie A | 31 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69948 | 2020-2021 1986 | 2021-04-03 | Atalanta 782 | Udinese 798 | 3 | 2 | Serie A | 29 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69928 | 2020-2021 1986 | 2021-03-13 | Genoa 788 | Udinese 798 | 1 | 1 | Serie A | 27 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69906 | 2020-2021 1986 | 2021-03-03 | Milan 792 | Udinese 798 | 1 | 1 | Serie A | 25 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69889 | 2020-2021 1986 | 2021-02-21 | Parma Calcio 959 | Udinese 798 | 2 | 2 | Serie A | 23 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69878 | 2020-2021 1986 | 2021-02-14 | Roma 796 | Udinese 798 | 3 | 0 | Serie A | 22 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69858 | 2020-2021 1986 | 2021-01-31 | Spezia Calcio 963 | Udinese 798 | 0 | 1 | Serie A | 20 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69837 | 2020-2021 1986 | 2021-01-16 | Sampdoria 803 | Udinese 798 | 2 | 1 | Serie A | 18 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69816 | 2020-2021 1986 | 2021-01-06 | Bologna 783 | Udinese 798 | 2 | 2 | Serie A | 16 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69813 | 2020-2021 1986 | 2021-01-03 | Juventus 341 | Udinese 798 | 4 | 1 | Serie A | 15 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69790 | 2020-2021 1986 | 2020-12-20 | Cagliari 784 | Udinese 798 | 1 | 1 | Serie A | 13 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69766 | 2020-2021 1986 | 2020-12-12 | Torino FC 951 | Udinese 798 | 2 | 3 | Serie A | 11 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69747 | 2020-2021 1986 | 2020-11-29 | SS Lazio 956 | Udinese 798 | 1 | 3 | Serie A | 9 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69724 | 2020-2021 1986 | 2020-11-06 | Sassuolo 804 | Udinese 798 | 0 | 0 | Serie A | 7 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69711 | 2020-2021 1986 | 2020-10-25 | Fiorentina 787 | Udinese 798 | 3 | 2 | Serie A | 5 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69679 | 2020-2021 1986 | 2020-09-27 | Hellas Verona 961 | Udinese 798 | 1 | 0 | Serie A | 2 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69550 | 2019-2020 1985 | 2020-06-23 | Torino FC 951 | Udinese 798 | 1 | 0 | Serie A | 27 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69525 | 2019-2020 1985 | 2020-02-22 | Bologna 783 | Udinese 798 | 1 | 1 | Serie A | 25 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69509 | 2019-2020 1985 | 2020-02-09 | Brescia Calcio 960 | Udinese 798 | 1 | 1 | Serie A | 23 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69490 | 2019-2020 1985 | 2020-01-26 | Parma Calcio 959 | Udinese 798 | 2 | 0 | Serie A | 21 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69477 | 2019-2020 1985 | 2020-01-19 | Milan 792 | Udinese 798 | 3 | 2 | Serie A | 20 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | 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);