match
357 rows where away_team_id = 357 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: season_id, home_score, away_score, result, source_id, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49703 | 2024-2025 1938 | 2025-05-10 | Holstein Kiel 356 | SC Freiburg 357 | 1 | 1 | D | 33 | 0 | 0 | 0 | 2026-06-07 23:31:29 | 2026-06-07 23:31:29 | 8 8 | OpenLigaDB 7 | |||||||||
| 49685 | 2024-2025 1938 | 2025-04-26 | VfL Wolfsburg 364 | SC Freiburg 357 | 0 | 0 | D | 31 | 0 | 0 | 0 | 2026-06-07 23:31:28 | 2026-06-07 23:31:28 | 8 8 | OpenLigaDB 7 | |||||||||
| 49666 | 2024-2025 1938 | 2025-04-12 | Borussia Mönchengladbach 351 | SC Freiburg 357 | 1 | 1 | D | 29 | 0 | 0 | 0 | 2026-06-07 23:31:28 | 2026-06-07 23:31:28 | 8 8 | OpenLigaDB 7 | |||||||||
| 49639 | 2024-2025 1938 | 2025-03-15 | 1. FSV Mainz 05 361 | SC Freiburg 357 | 1 | 0 | H | 26 | 0 | 0 | 0 | 2026-06-07 23:31:28 | 2026-06-07 23:31:28 | 8 8 | OpenLigaDB 7 | |||||||||
| 49626 | 2024-2025 1938 | 2025-03-02 | FC Augsburg 359 | SC Freiburg 357 | 0 | 0 | D | 24 | 0 | 0 | 0 | 2026-06-07 23:31:28 | 2026-06-07 23:31:28 | 8 8 | OpenLigaDB 7 | |||||||||
| 49604 | 2024-2025 1938 | 2025-02-15 | St Pauli 811 | SC Freiburg 357 | 0 | 0 | D | 22 | 0 | 0 | 0 | 2026-06-07 23:31:27 | 2026-06-07 23:31:27 | 8 8 | OpenLigaDB 7 | |||||||||
| 49586 | 2024-2025 1938 | 2025-02-01 | VfL Bochum 354 | SC Freiburg 357 | 0 | 1 | A | 20 | 0 | 0 | 0 | 2026-06-07 23:31:27 | 2026-06-07 23:31:27 | 8 8 | OpenLigaDB 7 | |||||||||
| 49565 | 2024-2025 1938 | 2025-01-18 | VfB Stuttgart 358 | SC Freiburg 357 | 3 | 0 | H | 18 | 0 | 0 | 0 | 2026-06-07 23:31:27 | 2026-06-07 23:31:27 | 8 8 | OpenLigaDB 7 | |||||||||
| 49557 | 2024-2025 1938 | 2025-01-14 | Eintracht Frankfurt 363 | SC Freiburg 357 | 1 | 1 | D | 17 | 0 | 0 | 0 | 2026-06-07 23:31:27 | 2026-06-07 23:31:27 | 8 8 | OpenLigaDB 7 | |||||||||
| 49543 | 2024-2025 1938 | 2024-12-21 | Bayer 04 Leverkusen 352 | SC Freiburg 357 | 0 | 0 | D | 15 | 0 | 0 | 0 | 2026-06-07 23:31:27 | 2026-06-07 23:31:27 | 8 8 | OpenLigaDB 7 | |||||||||
| 49527 | 2024-2025 1938 | 2024-12-08 | TSG Hoffenheim 355 | SC Freiburg 357 | 0 | 0 | D | 13 | 0 | 0 | 0 | 2026-06-07 23:31:26 | 2026-06-07 23:31:26 | 8 8 | OpenLigaDB 7 | |||||||||
| 49504 | 2024-2025 1938 | 2024-11-23 | Borussia Mönchengladbach 351 | SC Freiburg 357 | 2 | 0 | H | 11 | 0 | 0 | 0 | 2026-06-07 23:31:26 | 2026-06-07 23:31:26 | 8 8 | OpenLigaDB 7 | |||||||||
| 49492 | 2024-2025 1938 | 2024-11-08 | 1. FC Union Berlin 362 | SC Freiburg 357 | 0 | 0 | D | 10 | 0 | 0 | 0 | 2026-06-07 23:31:26 | 2026-06-07 23:31:26 | 8 8 | OpenLigaDB 7 | |||||||||
| 49476 | 2024-2025 1938 | 2024-10-26 | RB Leipzig 353 | SC Freiburg 357 | 0 | 1 | A | 8 | 0 | 0 | 0 | 2026-06-07 23:31:26 | 2026-06-07 23:31:26 | 8 8 | OpenLigaDB 7 | |||||||||
| 49458 | 2024-2025 1938 | 2024-10-05 | SV Werder Bremen 360 | SC Freiburg 357 | 0 | 0 | D | 6 | 0 | 0 | 0 | 2026-06-07 23:31:25 | 2026-06-07 23:31:25 | 8 8 | OpenLigaDB 7 | |||||||||
| 49439 | 2024-2025 1938 | 2024-09-21 | 1. FC Heidenheim 1846 367 | SC Freiburg 357 | 0 | 0 | D | 4 | 0 | 0 | 0 | 2026-06-07 23:31:25 | 2026-06-07 23:31:25 | 8 8 | OpenLigaDB 7 | |||||||||
| 49428 | 2024-2025 1938 | 2024-09-01 | FC Bayern München 365 | SC Freiburg 357 | 1 | 0 | H | 2 | 0 | 0 | 0 | 2026-06-07 23:31:25 | 2026-06-07 23:31:25 | 8 8 | OpenLigaDB 7 | |||||||||
| 73697 | 2023-2024 1997 | 2024-05-18 | 1. FC Union Berlin 362 | SC Freiburg 357 | 2 | 1 | Bundesliga | 34 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73683 | 2023-2024 1997 | 2024-05-04 | 1. FC Köln 970 | SC Freiburg 357 | 0 | 0 | Bundesliga | 32 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73658 | 2023-2024 1997 | 2024-04-14 | SV Darmstadt 98 817 | SC Freiburg 357 | 0 | 1 | Bundesliga | 29 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73634 | 2023-2024 1997 | 2024-03-30 | Borussia Mönchengladbach 351 | SC Freiburg 357 | 0 | 3 | Bundesliga | 27 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73621 | 2023-2024 1997 | 2024-03-10 | VfL Bochum 354 | SC Freiburg 357 | 1 | 2 | Bundesliga | 25 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73605 | 2023-2024 1997 | 2024-02-25 | FC Augsburg 359 | SC Freiburg 357 | 2 | 1 | Bundesliga | 23 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73579 | 2023-2024 1997 | 2024-02-09 | Borussia Dortmund 730 | SC Freiburg 357 | 3 | 0 | Bundesliga | 21 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73566 | 2023-2024 1997 | 2024-01-27 | SV Werder Bremen 360 | SC Freiburg 357 | 3 | 1 | Bundesliga | 19 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73538 | 2023-2024 1997 | 2023-12-20 | 1. FC Heidenheim 976 | SC Freiburg 357 | 3 | 2 | Bundesliga | 16 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73520 | 2023-2024 1997 | 2023-12-09 | VfL Wolfsburg 364 | SC Freiburg 357 | 0 | 1 | Bundesliga | 14 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73512 | 2023-2024 1997 | 2023-12-03 | 1. FSV Mainz 05 361 | SC Freiburg 357 | 0 | 1 | Bundesliga | 13 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73497 | 2023-2024 1997 | 2023-11-12 | RB Leipzig 353 | SC Freiburg 357 | 3 | 1 | Bundesliga | 11 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73479 | 2023-2024 1997 | 2023-10-29 | Bayer 04 Leverkusen 352 | SC Freiburg 357 | 2 | 1 | Bundesliga | 9 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73460 | 2023-2024 1997 | 2023-10-08 | FC Bayern München 365 | SC Freiburg 357 | 3 | 0 | Bundesliga | 7 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73443 | 2023-2024 1997 | 2023-09-24 | Eintracht Frankfurt 363 | SC Freiburg 357 | 0 | 0 | Bundesliga | 5 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73421 | 2023-2024 1997 | 2023-09-02 | VfB Stuttgart 358 | SC Freiburg 357 | 5 | 0 | Bundesliga | 3 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73402 | 2023-2024 1997 | 2023-08-19 | TSG 1899 Hoffenheim 809 | SC Freiburg 357 | 1 | 2 | Bundesliga | 1 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73394 | 2022-2023 1996 | 2023-05-27 | Eintracht Frankfurt 363 | SC Freiburg 357 | 2 | 1 | Bundesliga | 34 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73373 | 2022-2023 1996 | 2023-05-13 | 1. FC Union Berlin 362 | SC Freiburg 357 | 4 | 2 | Bundesliga | 32 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73355 | 2022-2023 1996 | 2023-04-29 | 1. FC Köln 970 | SC Freiburg 357 | 0 | 1 | Bundesliga | 30 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73342 | 2022-2023 1996 | 2023-04-16 | SV Werder Bremen 360 | SC Freiburg 357 | 1 | 2 | Bundesliga | 28 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73317 | 2022-2023 1996 | 2023-03-19 | 1. FSV Mainz 05 361 | SC Freiburg 357 | 1 | 1 | Bundesliga | 25 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73294 | 2022-2023 1996 | 2023-03-04 | Borussia Mönchengladbach 351 | SC Freiburg 357 | 0 | 0 | Bundesliga | 23 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73276 | 2022-2023 1996 | 2023-02-18 | VfL Bochum 354 | SC Freiburg 357 | 0 | 2 | Bundesliga | 21 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73258 | 2022-2023 1996 | 2023-02-04 | Borussia Dortmund 730 | SC Freiburg 357 | 5 | 1 | Bundesliga | 19 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73233 | 2022-2023 1996 | 2023-01-21 | VfL Wolfsburg 364 | SC Freiburg 357 | 6 | 0 | Bundesliga | 16 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73218 | 2022-2023 1996 | 2022-11-09 | RB Leipzig 353 | SC Freiburg 357 | 3 | 1 | Bundesliga | 14 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73199 | 2022-2023 1996 | 2022-10-30 | FC Schalke 04 816 | SC Freiburg 357 | 0 | 2 | Bundesliga | 12 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73182 | 2022-2023 1996 | 2022-10-16 | FC Bayern München 365 | SC Freiburg 357 | 5 | 0 | Bundesliga | 10 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73172 | 2022-2023 1996 | 2022-10-09 | Hertha BSC 969 | SC Freiburg 357 | 2 | 2 | Bundesliga | 9 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73155 | 2022-2023 1996 | 2022-09-18 | TSG 1899 Hoffenheim 809 | SC Freiburg 357 | 0 | 0 | Bundesliga | 7 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73131 | 2022-2023 1996 | 2022-09-03 | Bayer 04 Leverkusen 352 | SC Freiburg 357 | 2 | 3 | Bundesliga | 5 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73115 | 2022-2023 1996 | 2022-08-20 | VfB Stuttgart 358 | SC Freiburg 357 | 0 | 1 | Bundesliga | 3 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73096 | 2022-2023 1996 | 2022-08-06 | FC Augsburg 359 | SC Freiburg 357 | 0 | 4 | Bundesliga | 1 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73087 | 2021-2022 1995 | 2022-05-14 | Bayer 04 Leverkusen 352 | SC Freiburg 357 | 2 | 1 | Bundesliga | 34 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 73072 | 2021-2022 1995 | 2022-04-30 | TSG 1899 Hoffenheim 809 | SC Freiburg 357 | 3 | 4 | Bundesliga | 32 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 73046 | 2021-2022 1995 | 2022-04-10 | Eintracht Frankfurt 363 | SC Freiburg 357 | 1 | 2 | Bundesliga | 29 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 73024 | 2021-2022 1995 | 2022-03-19 | Greuther Fürth 975 | SC Freiburg 357 | 0 | 0 | Bundesliga | 27 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 73007 | 2021-2022 1995 | 2022-03-05 | RB Leipzig 353 | SC Freiburg 357 | 1 | 1 | Bundesliga | 25 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72988 | 2021-2022 1995 | 2022-02-19 | FC Augsburg 359 | SC Freiburg 357 | 1 | 2 | Bundesliga | 23 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72971 | 2021-2022 1995 | 2022-02-05 | 1. FC Köln 970 | SC Freiburg 357 | 1 | 0 | Bundesliga | 21 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72950 | 2021-2022 1995 | 2022-01-14 | Borussia Dortmund 730 | SC Freiburg 357 | 5 | 1 | Bundesliga | 19 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72928 | 2021-2022 1995 | 2021-12-15 | 1. FC Union Berlin 362 | SC Freiburg 357 | 0 | 0 | Bundesliga | 16 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72913 | 2021-2022 1995 | 2021-12-05 | Borussia Mönchengladbach 351 | SC Freiburg 357 | 0 | 6 | Bundesliga | 14 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72900 | 2021-2022 1995 | 2021-11-27 | VfL Bochum 354 | SC Freiburg 357 | 2 | 1 | Bundesliga | 13 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72879 | 2021-2022 1995 | 2021-11-06 | FC Bayern München 365 | SC Freiburg 357 | 2 | 1 | Bundesliga | 11 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72864 | 2021-2022 1995 | 2021-10-23 | VfL Wolfsburg 364 | SC Freiburg 357 | 0 | 2 | Bundesliga | 9 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72844 | 2021-2022 1995 | 2021-10-02 | Hertha BSC 969 | SC Freiburg 357 | 1 | 2 | Bundesliga | 7 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72828 | 2021-2022 1995 | 2021-09-18 | 1. FSV Mainz 05 361 | SC Freiburg 357 | 0 | 0 | Bundesliga | 5 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72808 | 2021-2022 1995 | 2021-08-28 | VfB Stuttgart 358 | SC Freiburg 357 | 2 | 3 | Bundesliga | 3 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72793 | 2021-2022 1995 | 2021-08-14 | Bielefeld 974 | SC Freiburg 357 | 0 | 0 | Bundesliga | 1 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72782 | 2020-2021 1994 | 2021-05-22 | Eintracht Frankfurt 363 | SC Freiburg 357 | 3 | 1 | Bundesliga | 34 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72767 | 2020-2021 1994 | 2021-05-09 | 1. FC Köln 970 | SC Freiburg 357 | 1 | 4 | Bundesliga | 32 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72751 | 2020-2021 1994 | 2021-05-06 | Hertha BSC 969 | SC Freiburg 357 | 3 | 0 | Bundesliga | 30 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72725 | 2020-2021 1994 | 2021-04-09 | Bielefeld 974 | SC Freiburg 357 | 1 | 0 | Bundesliga | 28 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72722 | 2020-2021 1994 | 2021-04-03 | Borussia Mönchengladbach 351 | SC Freiburg 357 | 2 | 1 | Bundesliga | 27 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72700 | 2020-2021 1994 | 2021-03-13 | 1. FSV Mainz 05 361 | SC Freiburg 357 | 1 | 0 | Bundesliga | 25 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72688 | 2020-2021 1994 | 2021-02-28 | Bayer 04 Leverkusen 352 | SC Freiburg 357 | 1 | 2 | Bundesliga | 23 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72666 | 2020-2021 1994 | 2021-02-13 | SV Werder Bremen 360 | SC Freiburg 357 | 0 | 0 | Bundesliga | 21 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72652 | 2020-2021 1994 | 2021-01-31 | VfL Wolfsburg 364 | SC Freiburg 357 | 3 | 0 | Bundesliga | 19 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72624 | 2020-2021 1994 | 2021-01-17 | FC Bayern München 365 | SC Freiburg 357 | 2 | 1 | Bundesliga | 16 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72599 | 2020-2021 1994 | 2021-01-02 | TSG 1899 Hoffenheim 809 | SC Freiburg 357 | 1 | 3 | Bundesliga | 14 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72585 | 2020-2021 1994 | 2020-12-16 | FC Schalke 04 816 | SC Freiburg 357 | 0 | 2 | Bundesliga | 12 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72555 | 2020-2021 1994 | 2020-11-28 | FC Augsburg 359 | SC Freiburg 357 | 1 | 1 | Bundesliga | 9 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72538 | 2020-2021 1994 | 2020-11-07 | RB Leipzig 353 | SC Freiburg 357 | 3 | 0 | Bundesliga | 7 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72521 | 2020-2021 1994 | 2020-10-24 | 1. FC Union Berlin 362 | SC Freiburg 357 | 1 | 1 | Bundesliga | 5 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72503 | 2020-2021 1994 | 2020-10-03 | Borussia Dortmund 730 | SC Freiburg 357 | 4 | 0 | Bundesliga | 3 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72484 | 2020-2021 1994 | 2020-09-19 | VfB Stuttgart 358 | SC Freiburg 357 | 2 | 3 | Bundesliga | 1 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72466 | 2019-2020 1993 | 2020-06-20 | FC Bayern München 365 | SC Freiburg 357 | 3 | 1 | Bundesliga | 33 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | International Results CSV 1 | ||||||||||
| 72448 | 2019-2020 1993 | 2020-06-13 | VfL Wolfsburg 364 | SC Freiburg 357 | 2 | 2 | Bundesliga | 31 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | International Results CSV 1 | ||||||||||
| 72421 | 2019-2020 1993 | 2020-05-26 | Eintracht Frankfurt 363 | SC Freiburg 357 | 3 | 3 | Bundesliga | 28 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | International Results CSV 1 | ||||||||||
| 72404 | 2019-2020 1993 | 2020-05-16 | RB Leipzig 353 | SC Freiburg 357 | 1 | 1 | Bundesliga | 26 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | International Results CSV 1 | ||||||||||
| 72385 | 2019-2020 1993 | 2020-02-29 | Borussia Dortmund 730 | SC Freiburg 357 | 1 | 0 | Bundesliga | 24 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | International Results CSV 1 | ||||||||||
| 72367 | 2019-2020 1993 | 2020-02-15 | FC Augsburg 359 | SC Freiburg 357 | 1 | 1 | Bundesliga | 22 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | International Results CSV 1 | ||||||||||
| 72354 | 2019-2020 1993 | 2020-02-02 | 1. FC Köln 970 | SC Freiburg 357 | 4 | 0 | Bundesliga | 20 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | International Results CSV 1 | ||||||||||
| 72331 | 2019-2020 1993 | 2020-01-18 | 1. FSV Mainz 05 361 | SC Freiburg 357 | 1 | 2 | Bundesliga | 18 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | International Results CSV 1 | ||||||||||
| 72323 | 2019-2020 1993 | 2019-12-21 | FC Schalke 04 816 | SC Freiburg 357 | 2 | 2 | Bundesliga | 17 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | International Results CSV 1 | ||||||||||
| 72305 | 2019-2020 1993 | 2019-12-14 | Hertha BSC 969 | SC Freiburg 357 | 1 | 0 | Bundesliga | 15 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | International Results CSV 1 | ||||||||||
| 72290 | 2019-2020 1993 | 2019-12-01 | Borussia Mönchengladbach 351 | SC Freiburg 357 | 4 | 2 | Bundesliga | 13 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | International Results CSV 1 | ||||||||||
| 72278 | 2019-2020 1993 | 2019-11-23 | Bayer 04 Leverkusen 352 | SC Freiburg 357 | 1 | 1 | Bundesliga | 12 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | International Results CSV 1 | ||||||||||
| 72261 | 2019-2020 1993 | 2019-11-02 | SV Werder Bremen 360 | SC Freiburg 357 | 2 | 2 | Bundesliga | 10 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | International Results CSV 1 | ||||||||||
| 72240 | 2019-2020 1993 | 2019-10-19 | 1. FC Union Berlin 362 | SC Freiburg 357 | 2 | 0 | Bundesliga | 8 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | International Results CSV 1 | ||||||||||
| 72228 | 2019-2020 1993 | 2019-09-29 | Düsseldorf 971 | SC Freiburg 357 | 1 | 2 | Bundesliga | 6 | 0 | 0 | 0 | 2026-06-11T02:07:49 | 2026-06-11T02:07:49 | 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);