match
209 rows where home_team_id = 804 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: season_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71167 | 2023-2024 1989 | 2024-05-19 | Sassuolo 804 | Cagliari 784 | 0 | 2 | Serie A | 37 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71146 | 2023-2024 1989 | 2024-05-04 | Sassuolo 804 | Inter Milan 954 | 1 | 0 | Serie A | 35 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71128 | 2023-2024 1989 | 2024-04-21 | Sassuolo 804 | US Lecce 962 | 0 | 3 | Serie A | 33 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71119 | 2023-2024 1989 | 2024-04-14 | Sassuolo 804 | Milan 792 | 3 | 3 | Serie A | 32 | 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 | ||||||||||
| 71076 | 2023-2024 1989 | 2024-03-09 | Sassuolo 804 | Frosinone 806 | 1 | 0 | Serie A | 28 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71012 | 2023-2024 1989 | 2024-02-28 | Sassuolo 804 | Napoli 794 | 1 | 6 | Serie A | 21 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71055 | 2023-2024 1989 | 2024-02-24 | Sassuolo 804 | Empoli 786 | 2 | 3 | Serie A | 26 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 71037 | 2023-2024 1989 | 2024-02-10 | Sassuolo 804 | Torino FC 951 | 1 | 1 | Serie A | 24 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70988 | 2023-2024 1989 | 2024-01-06 | Sassuolo 804 | Fiorentina 787 | 1 | 0 | Serie A | 19 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70965 | 2023-2024 1989 | 2023-12-22 | Sassuolo 804 | Genoa 788 | 1 | 2 | Serie A | 17 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70941 | 2023-2024 1989 | 2023-12-03 | Sassuolo 804 | Roma 796 | 1 | 2 | Serie A | 14 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70914 | 2023-2024 1989 | 2023-11-10 | Sassuolo 804 | Salernitana 802 | 2 | 2 | Serie A | 12 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70895 | 2023-2024 1989 | 2023-10-28 | Sassuolo 804 | Bologna 783 | 1 | 1 | Serie A | 10 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70886 | 2023-2024 1989 | 2023-10-21 | Sassuolo 804 | SS Lazio 956 | 0 | 2 | Serie A | 9 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70871 | 2023-2024 1989 | 2023-10-02 | Sassuolo 804 | Monza 793 | 0 | 1 | Serie A | 7 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70847 | 2023-2024 1989 | 2023-09-23 | Sassuolo 804 | Juventus 341 | 4 | 2 | Serie A | 5 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70824 | 2023-2024 1989 | 2023-09-01 | Sassuolo 804 | Hellas Verona 961 | 3 | 1 | Serie A | 3 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70809 | 2023-2024 1989 | 2023-08-20 | Sassuolo 804 | Atalanta 782 | 0 | 2 | Serie A | 1 | 0 | 0 | 0 | 2026-06-11T02:06:13 | 2026-06-11T02:06:13 | International Results CSV 1 | ||||||||||
| 70794 | 2022-2023 1988 | 2023-06-02 | Sassuolo 804 | Fiorentina 787 | 1 | 3 | Serie A | 38 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70774 | 2022-2023 1988 | 2023-05-19 | Sassuolo 804 | Monza 793 | 1 | 2 | Serie A | 36 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70763 | 2022-2023 1988 | 2023-05-08 | Sassuolo 804 | Bologna 783 | 1 | 1 | Serie A | 34 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70741 | 2022-2023 1988 | 2023-04-30 | Sassuolo 804 | Empoli 786 | 2 | 1 | Serie A | 32 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70721 | 2022-2023 1988 | 2023-04-16 | Sassuolo 804 | Juventus 341 | 1 | 0 | Serie A | 30 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70703 | 2022-2023 1988 | 2023-04-03 | Sassuolo 804 | Torino FC 951 | 1 | 1 | Serie A | 28 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70684 | 2022-2023 1988 | 2023-03-17 | Sassuolo 804 | Spezia Calcio 963 | 1 | 0 | Serie A | 27 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70672 | 2022-2023 1988 | 2023-03-06 | Sassuolo 804 | Cremonese 801 | 3 | 2 | Serie A | 25 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70644 | 2022-2023 1988 | 2023-02-17 | Sassuolo 804 | Napoli 794 | 0 | 2 | Serie A | 23 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70626 | 2022-2023 1988 | 2023-02-04 | Sassuolo 804 | Atalanta 782 | 1 | 0 | Serie A | 21 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70598 | 2022-2023 1988 | 2023-01-15 | Sassuolo 804 | SS Lazio 956 | 0 | 2 | Serie A | 18 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70575 | 2022-2023 1988 | 2023-01-04 | Sassuolo 804 | Sampdoria 803 | 1 | 2 | Serie A | 16 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70558 | 2022-2023 1988 | 2022-11-09 | Sassuolo 804 | Roma 796 | 1 | 1 | Serie A | 14 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70533 | 2022-2023 1988 | 2022-10-24 | Sassuolo 804 | Hellas Verona 961 | 2 | 1 | Serie A | 11 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70504 | 2022-2023 1988 | 2022-10-08 | Sassuolo 804 | Inter Milan 954 | 1 | 2 | Serie A | 9 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70500 | 2022-2023 1988 | 2022-10-02 | Sassuolo 804 | Salernitana 802 | 5 | 0 | 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 | ||||||||||
| 70454 | 2022-2023 1988 | 2022-08-30 | Sassuolo 804 | Milan 792 | 0 | 0 | Serie A | 4 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70437 | 2022-2023 1988 | 2022-08-20 | Sassuolo 804 | US Lecce 962 | 1 | 0 | Serie A | 2 | 0 | 0 | 0 | 2026-06-11T02:06:11 | 2026-06-11T02:06:11 | International Results CSV 1 | ||||||||||
| 70421 | 2021-2022 1987 | 2022-05-22 | Sassuolo 804 | Milan 792 | 0 | 3 | 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 | ||||||||||
| 70383 | 2021-2022 1987 | 2022-04-25 | Sassuolo 804 | Juventus 341 | 1 | 2 | Serie A | 34 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70359 | 2021-2022 1987 | 2022-04-10 | Sassuolo 804 | Atalanta 782 | 2 | 1 | Serie A | 32 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70334 | 2021-2022 1987 | 2022-03-18 | Sassuolo 804 | Spezia Calcio 963 | 4 | 1 | Serie A | 30 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70308 | 2021-2022 1987 | 2022-02-26 | Sassuolo 804 | Fiorentina 787 | 2 | 1 | Serie A | 27 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70291 | 2021-2022 1987 | 2022-02-13 | Sassuolo 804 | Roma 796 | 2 | 2 | Serie A | 25 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70257 | 2021-2022 1987 | 2022-01-16 | Sassuolo 804 | Hellas Verona 961 | 2 | 4 | Serie A | 22 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70237 | 2021-2022 1987 | 2022-01-06 | Sassuolo 804 | Genoa 788 | 1 | 1 | Serie A | 20 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70226 | 2021-2022 1987 | 2021-12-22 | Sassuolo 804 | Bologna 783 | 0 | 3 | Serie A | 19 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70210 | 2021-2022 1987 | 2021-12-12 | Sassuolo 804 | SS Lazio 956 | 2 | 1 | Serie A | 17 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70191 | 2021-2022 1987 | 2021-12-01 | Sassuolo 804 | Napoli 794 | 2 | 2 | Serie A | 15 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70167 | 2021-2022 1987 | 2021-11-21 | Sassuolo 804 | Cagliari 784 | 2 | 2 | Serie A | 13 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70150 | 2021-2022 1987 | 2021-10-31 | Sassuolo 804 | Empoli 786 | 1 | 2 | Serie A | 11 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70127 | 2021-2022 1987 | 2021-10-23 | Sassuolo 804 | Venezia FC 964 | 3 | 1 | Serie A | 9 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70107 | 2021-2022 1987 | 2021-10-02 | Sassuolo 804 | Inter Milan 954 | 1 | 2 | Serie A | 7 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70099 | 2021-2022 1987 | 2021-09-26 | Sassuolo 804 | Salernitana 802 | 1 | 0 | Serie A | 6 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70074 | 2021-2022 1987 | 2021-09-17 | Sassuolo 804 | Torino FC 951 | 0 | 1 | Serie A | 4 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70060 | 2021-2022 1987 | 2021-08-29 | Sassuolo 804 | Sampdoria 803 | 0 | 0 | Serie A | 2 | 0 | 0 | 0 | 2026-06-11T02:06:10 | 2026-06-11T02:06:10 | International Results CSV 1 | ||||||||||
| 70041 | 2020-2021 1986 | 2021-05-23 | Sassuolo 804 | SS Lazio 956 | 2 | 0 | Serie A | 38 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 70020 | 2020-2021 1986 | 2021-05-12 | Sassuolo 804 | Juventus 341 | 1 | 3 | Serie A | 36 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69999 | 2020-2021 1986 | 2021-05-02 | Sassuolo 804 | Atalanta 782 | 1 | 1 | Serie A | 34 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69986 | 2020-2021 1986 | 2021-04-24 | Sassuolo 804 | Sampdoria 803 | 1 | 0 | Serie A | 33 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69966 | 2020-2021 1986 | 2021-04-17 | Sassuolo 804 | Fiorentina 787 | 3 | 1 | Serie A | 31 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69949 | 2020-2021 1986 | 2021-04-03 | Sassuolo 804 | Roma 796 | 2 | 2 | Serie A | 29 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69926 | 2020-2021 1986 | 2021-03-13 | Sassuolo 804 | Hellas Verona 961 | 3 | 2 | Serie A | 27 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69905 | 2020-2021 1986 | 2021-03-03 | Sassuolo 804 | Napoli 794 | 3 | 3 | Serie A | 25 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69888 | 2020-2021 1986 | 2021-02-20 | Sassuolo 804 | Bologna 783 | 1 | 1 | Serie A | 23 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69866 | 2020-2021 1986 | 2021-02-06 | Sassuolo 804 | Spezia Calcio 963 | 1 | 2 | Serie A | 21 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69839 | 2020-2021 1986 | 2021-01-17 | Sassuolo 804 | Parma Calcio 959 | 1 | 1 | Serie A | 18 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69819 | 2020-2021 1986 | 2021-01-06 | Sassuolo 804 | Genoa 788 | 2 | 1 | Serie A | 16 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69789 | 2020-2021 1986 | 2020-12-20 | Sassuolo 804 | Milan 792 | 1 | 2 | Serie A | 13 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69764 | 2020-2021 1986 | 2020-12-11 | Sassuolo 804 | Benevento 955 | 1 | 0 | Serie A | 11 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69744 | 2020-2021 1986 | 2020-11-28 | Sassuolo 804 | Inter Milan 954 | 0 | 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 | ||||||||||
| 69704 | 2020-2021 1986 | 2020-10-23 | Sassuolo 804 | Torino FC 951 | 3 | 3 | Serie A | 5 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69685 | 2020-2021 1986 | 2020-10-03 | Sassuolo 804 | FC Crotone 952 | 4 | 1 | Serie A | 3 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69668 | 2020-2021 1986 | 2020-09-20 | Sassuolo 804 | Cagliari 784 | 1 | 1 | Serie A | 1 | 0 | 0 | 0 | 2026-06-11T02:06:09 | 2026-06-11T02:06:09 | International Results CSV 1 | ||||||||||
| 69561 | 2019-2020 1985 | 2020-06-28 | Sassuolo 804 | Hellas Verona 961 | 3 | 3 | Serie A | 28 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69543 | 2019-2020 1985 | 2020-03-09 | Sassuolo 804 | Brescia Calcio 960 | 3 | 0 | Serie A | 26 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69520 | 2019-2020 1985 | 2020-02-16 | Sassuolo 804 | Parma Calcio 959 | 0 | 1 | Serie A | 24 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69496 | 2019-2020 1985 | 2020-02-01 | Sassuolo 804 | Roma 796 | 4 | 2 | Serie A | 22 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69475 | 2019-2020 1985 | 2020-01-18 | Sassuolo 804 | Torino FC 951 | 2 | 1 | Serie A | 20 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69452 | 2019-2020 1985 | 2019-12-22 | Sassuolo 804 | Napoli 794 | 1 | 2 | Serie A | 17 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69430 | 2019-2020 1985 | 2019-12-08 | Sassuolo 804 | Cagliari 784 | 2 | 2 | Serie A | 15 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69410 | 2019-2020 1985 | 2019-11-24 | Sassuolo 804 | SS Lazio 956 | 1 | 2 | Serie A | 13 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69394 | 2019-2020 1985 | 2019-11-08 | Sassuolo 804 | Bologna 783 | 3 | 1 | Serie A | 12 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69380 | 2019-2020 1985 | 2019-10-30 | Sassuolo 804 | Fiorentina 787 | 1 | 2 | Serie A | 10 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69357 | 2019-2020 1985 | 2019-10-20 | Sassuolo 804 | Inter Milan 954 | 3 | 4 | Serie A | 8 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69336 | 2019-2020 1985 | 2019-09-28 | Sassuolo 804 | Atalanta 782 | 1 | 4 | Serie A | 6 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69318 | 2019-2020 1985 | 2019-09-22 | Sassuolo 804 | SPAL 957 | 3 | 0 | Serie A | 4 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69302 | 2019-2020 1985 | 2019-09-01 | Sassuolo 804 | Sampdoria 803 | 4 | 1 | Serie A | 2 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69663 | 2019-2020 1985 | 2019-08-02 | Sassuolo 804 | Udinese 798 | 0 | 1 | Serie A | 38 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69648 | 2019-2020 1985 | 2019-07-29 | Sassuolo 804 | Genoa 788 | 5 | 0 | Serie A | 37 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69625 | 2019-2020 1985 | 2019-07-21 | Sassuolo 804 | Milan 792 | 1 | 2 | Serie A | 35 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69610 | 2019-2020 1985 | 2019-07-15 | Sassuolo 804 | Juventus 341 | 3 | 3 | Serie A | 33 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69575 | 2019-2020 1985 | 2019-07-04 | Sassuolo 804 | US Lecce 962 | 4 | 2 | Serie A | 30 | 0 | 0 | 0 | 2026-06-11T02:06:08 | 2026-06-11T02:06:08 | International Results CSV 1 | ||||||||||
| 69266 | 2018-2019 1984 | 2019-05-18 | Sassuolo 804 | Roma 796 | 0 | 0 | Serie A | 37 | 0 | 0 | 0 | 2026-06-11T02:06:07 | 2026-06-11T02:06:07 | International Results CSV 1 | ||||||||||
| 69249 | 2018-2019 1984 | 2019-05-05 | Sassuolo 804 | Frosinone 806 | 2 | 2 | Serie A | 35 | 0 | 0 | 0 | 2026-06-11T02:06:07 | 2026-06-11T02:06:07 | International Results CSV 1 | ||||||||||
| 69220 | 2018-2019 1984 | 2019-04-14 | Sassuolo 804 | Parma Calcio 959 | 0 | 0 | Serie A | 32 | 0 | 0 | 0 | 2026-06-11T02:06:07 | 2026-06-11T02:06:07 | International Results CSV 1 | ||||||||||
| 69202 | 2018-2019 1984 | 2019-04-04 | Sassuolo 804 | Chievo Verona 958 | 4 | 0 | Serie A | 30 | 0 | 0 | 0 | 2026-06-11T02:06:07 | 2026-06-11T02:06:07 | International Results CSV 1 | ||||||||||
| 69175 | 2018-2019 1984 | 2019-03-16 | Sassuolo 804 | Sampdoria 803 | 3 | 5 | Serie A | 28 | 0 | 0 | 0 | 2026-06-11T02:06:07 | 2026-06-11T02:06:07 | 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);