match
442 rows where away_team_id = 358 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49708 | 2024-2025 1938 | 2025-05-17 | RB Leipzig 353 | VfB Stuttgart 358 | 2 | 1 | H | 34 | 0 | 0 | 0 | 2026-06-07 23:31:29 | 2026-06-07 23:31:29 | 8 8 | OpenLigaDB 7 | |||||||||
| 49694 | 2024-2025 1938 | 2025-05-03 | St Pauli 811 | VfB Stuttgart 358 | 0 | 0 | D | 32 | 0 | 0 | 0 | 2026-06-07 23:31:29 | 2026-06-07 23:31:29 | 8 8 | OpenLigaDB 7 | |||||||||
| 49677 | 2024-2025 1938 | 2025-04-19 | 1. FC Union Berlin 362 | VfB Stuttgart 358 | 4 | 4 | D | 30 | 0 | 0 | 0 | 2026-06-07 23:31:28 | 2026-06-07 23:31:28 | 8 8 | OpenLigaDB 7 | |||||||||
| 49659 | 2024-2025 1938 | 2025-04-05 | VfL Bochum 354 | VfB Stuttgart 358 | 0 | 2 | A | 28 | 0 | 0 | 0 | 2026-06-07 23:31:28 | 2026-06-07 23:31:28 | 8 8 | OpenLigaDB 7 | |||||||||
| 49651 | 2024-2025 1938 | 2025-03-29 | Eintracht Frankfurt 363 | VfB Stuttgart 358 | 0 | 0 | D | 27 | 0 | 0 | 0 | 2026-06-07 23:31:28 | 2026-06-07 23:31:28 | 8 8 | OpenLigaDB 7 | |||||||||
| 49632 | 2024-2025 1938 | 2025-03-08 | Holstein Kiel 356 | VfB Stuttgart 358 | 1 | 1 | D | 25 | 0 | 0 | 0 | 2026-06-07 23:31:28 | 2026-06-07 23:31:28 | 8 8 | OpenLigaDB 7 | |||||||||
| 49617 | 2024-2025 1938 | 2025-02-23 | TSG Hoffenheim 355 | VfB Stuttgart 358 | 0 | 1 | A | 23 | 0 | 0 | 0 | 2026-06-07 23:31:28 | 2026-06-07 23:31:28 | 8 8 | OpenLigaDB 7 | |||||||||
| 49592 | 2024-2025 1938 | 2025-02-08 | Borussia Mönchengladbach 351 | VfB Stuttgart 358 | 0 | 0 | D | 21 | 0 | 0 | 0 | 2026-06-07 23:31:27 | 2026-06-07 23:31:27 | 8 8 | OpenLigaDB 7 | |||||||||
| 49578 | 2024-2025 1938 | 2025-01-25 | 1. FSV Mainz 05 361 | VfB Stuttgart 358 | 1 | 0 | H | 19 | 0 | 0 | 0 | 2026-06-07 23:31:27 | 2026-06-07 23:31:27 | 8 8 | OpenLigaDB 7 | |||||||||
| 49554 | 2024-2025 1938 | 2025-01-12 | FC Augsburg 359 | VfB Stuttgart 358 | 0 | 0 | D | 16 | 0 | 0 | 0 | 2026-06-07 23:31:27 | 2026-06-07 23:31:27 | 8 8 | OpenLigaDB 7 | |||||||||
| 49534 | 2024-2025 1938 | 2024-12-15 | 1. FC Heidenheim 1846 367 | VfB Stuttgart 358 | 1 | 2 | A | 14 | 0 | 0 | 0 | 2026-06-07 23:31:26 | 2026-06-07 23:31:26 | 8 8 | OpenLigaDB 7 | |||||||||
| 49512 | 2024-2025 1938 | 2024-11-30 | SV Werder Bremen 360 | VfB Stuttgart 358 | 1 | 1 | D | 12 | 0 | 0 | 0 | 2026-06-07 23:31:26 | 2026-06-07 23:31:26 | 8 8 | OpenLigaDB 7 | |||||||||
| 49483 | 2024-2025 1938 | 2024-11-01 | Bayer 04 Leverkusen 352 | VfB Stuttgart 358 | 0 | 0 | D | 9 | 0 | 0 | 0 | 2026-06-07 23:31:26 | 2026-06-07 23:31:26 | 8 8 | OpenLigaDB 7 | |||||||||
| 49471 | 2024-2025 1938 | 2024-10-19 | FC Bayern München 365 | VfB Stuttgart 358 | 0 | 0 | D | 7 | 0 | 0 | 0 | 2026-06-07 23:31:26 | 2026-06-07 23:31:26 | 8 8 | OpenLigaDB 7 | |||||||||
| 49450 | 2024-2025 1938 | 2024-09-28 | VfL Wolfsburg 364 | VfB Stuttgart 358 | 1 | 1 | D | 5 | 0 | 0 | 0 | 2026-06-07 23:31:25 | 2026-06-07 23:31:25 | 8 8 | OpenLigaDB 7 | |||||||||
| 49434 | 2024-2025 1938 | 2024-09-14 | Borussia Mönchengladbach 351 | VfB Stuttgart 358 | 1 | 1 | D | 3 | 0 | 0 | 0 | 2026-06-07 23:31:25 | 2026-06-07 23:31:25 | 8 8 | OpenLigaDB 7 | |||||||||
| 49414 | 2024-2025 1938 | 2024-08-24 | SC Freiburg 357 | VfB Stuttgart 358 | 1 | 1 | D | 1 | 0 | 0 | 0 | 2026-06-07 23:31:25 | 2026-06-07 23:31:25 | 8 8 | OpenLigaDB 7 | |||||||||
| 73687 | 2023-2024 1997 | 2024-05-10 | FC Augsburg 359 | VfB Stuttgart 358 | 0 | 1 | Bundesliga | 33 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73674 | 2023-2024 1997 | 2024-04-27 | Bayer 04 Leverkusen 352 | VfB Stuttgart 358 | 2 | 2 | Bundesliga | 31 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73666 | 2023-2024 1997 | 2024-04-21 | SV Werder Bremen 360 | VfB Stuttgart 358 | 2 | 1 | Bundesliga | 30 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73648 | 2023-2024 1997 | 2024-04-06 | Borussia Dortmund 730 | VfB Stuttgart 358 | 0 | 1 | Bundesliga | 28 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73630 | 2023-2024 1997 | 2024-03-16 | TSG 1899 Hoffenheim 809 | VfB Stuttgart 358 | 0 | 3 | Bundesliga | 26 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73612 | 2023-2024 1997 | 2024-03-02 | VfL Wolfsburg 364 | VfB Stuttgart 358 | 2 | 3 | Bundesliga | 24 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73591 | 2023-2024 1997 | 2024-02-17 | SV Darmstadt 98 817 | VfB Stuttgart 358 | 1 | 2 | Bundesliga | 22 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73573 | 2023-2024 1997 | 2024-02-03 | SC Freiburg 357 | VfB Stuttgart 358 | 1 | 3 | Bundesliga | 20 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73556 | 2023-2024 1997 | 2024-01-20 | VfL Bochum 354 | VfB Stuttgart 358 | 1 | 0 | Bundesliga | 18 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73551 | 2023-2024 1997 | 2024-01-14 | Borussia Mönchengladbach 351 | VfB Stuttgart 358 | 3 | 1 | Bundesliga | 17 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73533 | 2023-2024 1997 | 2023-12-17 | FC Bayern München 365 | VfB Stuttgart 358 | 3 | 0 | Bundesliga | 15 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73504 | 2023-2024 1997 | 2023-11-25 | Eintracht Frankfurt 363 | VfB Stuttgart 358 | 1 | 2 | Bundesliga | 12 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73488 | 2023-2024 1997 | 2023-11-05 | 1. FC Heidenheim 976 | VfB Stuttgart 358 | 2 | 0 | Bundesliga | 10 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73463 | 2023-2024 1997 | 2023-10-21 | 1. FC Union Berlin 362 | VfB Stuttgart 358 | 0 | 3 | Bundesliga | 8 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73446 | 2023-2024 1997 | 2023-09-30 | 1. FC Köln 970 | VfB Stuttgart 358 | 0 | 2 | Bundesliga | 6 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73428 | 2023-2024 1997 | 2023-09-16 | 1. FSV Mainz 05 361 | VfB Stuttgart 358 | 1 | 3 | Bundesliga | 4 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73408 | 2023-2024 1997 | 2023-08-25 | RB Leipzig 353 | VfB Stuttgart 358 | 5 | 1 | Bundesliga | 2 | 0 | 0 | 0 | 2026-06-11T02:07:54 | 2026-06-11T02:07:54 | International Results CSV 1 | ||||||||||
| 73387 | 2022-2023 1996 | 2023-05-21 | 1. FSV Mainz 05 361 | VfB Stuttgart 358 | 1 | 4 | Bundesliga | 33 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73367 | 2022-2023 1996 | 2023-05-06 | Hertha BSC 969 | VfB Stuttgart 358 | 2 | 1 | Bundesliga | 31 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73345 | 2022-2023 1996 | 2023-04-21 | FC Augsburg 359 | VfB Stuttgart 358 | 1 | 1 | Bundesliga | 29 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73334 | 2022-2023 1996 | 2023-04-09 | VfL Bochum 354 | VfB Stuttgart 358 | 2 | 3 | Bundesliga | 27 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73319 | 2022-2023 1996 | 2023-04-01 | 1. FC Union Berlin 362 | VfB Stuttgart 358 | 3 | 0 | Bundesliga | 26 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73301 | 2022-2023 1996 | 2023-03-11 | Eintracht Frankfurt 363 | VfB Stuttgart 358 | 1 | 1 | Bundesliga | 24 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73288 | 2022-2023 1996 | 2023-02-25 | FC Schalke 04 816 | VfB Stuttgart 358 | 2 | 1 | Bundesliga | 22 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73267 | 2022-2023 1996 | 2023-02-11 | SC Freiburg 357 | VfB Stuttgart 358 | 2 | 1 | Bundesliga | 20 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73246 | 2022-2023 1996 | 2023-01-27 | RB Leipzig 353 | VfB Stuttgart 358 | 2 | 1 | Bundesliga | 18 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73240 | 2022-2023 1996 | 2023-01-24 | TSG 1899 Hoffenheim 809 | VfB Stuttgart 358 | 2 | 2 | Bundesliga | 17 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73220 | 2022-2023 1996 | 2022-11-12 | Bayer 04 Leverkusen 352 | VfB Stuttgart 358 | 2 | 0 | Bundesliga | 15 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73201 | 2022-2023 1996 | 2022-11-04 | Borussia Mönchengladbach 351 | VfB Stuttgart 358 | 3 | 1 | Bundesliga | 13 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73185 | 2022-2023 1996 | 2022-10-22 | Borussia Dortmund 730 | VfB Stuttgart 358 | 5 | 0 | Bundesliga | 11 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73161 | 2022-2023 1996 | 2022-10-01 | VfL Wolfsburg 364 | VfB Stuttgart 358 | 3 | 2 | Bundesliga | 8 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73140 | 2022-2023 1996 | 2022-09-10 | FC Bayern München 365 | VfB Stuttgart 358 | 2 | 2 | Bundesliga | 6 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73127 | 2022-2023 1996 | 2022-08-28 | 1. FC Köln 970 | VfB Stuttgart 358 | 0 | 0 | Bundesliga | 4 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73107 | 2022-2023 1996 | 2022-08-13 | SV Werder Bremen 360 | VfB Stuttgart 358 | 2 | 2 | Bundesliga | 2 | 0 | 0 | 0 | 2026-06-11T02:07:53 | 2026-06-11T02:07:53 | International Results CSV 1 | ||||||||||
| 73082 | 2021-2022 1995 | 2022-05-08 | FC Bayern München 365 | VfB Stuttgart 358 | 2 | 2 | Bundesliga | 33 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 73065 | 2021-2022 1995 | 2022-04-24 | Hertha BSC 969 | VfB Stuttgart 358 | 2 | 0 | Bundesliga | 31 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 73048 | 2021-2022 1995 | 2022-04-16 | 1. FSV Mainz 05 361 | VfB Stuttgart 358 | 0 | 0 | Bundesliga | 30 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 73031 | 2021-2022 1995 | 2022-04-02 | Bielefeld 974 | VfB Stuttgart 358 | 1 | 1 | Bundesliga | 28 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 73013 | 2021-2022 1995 | 2022-03-12 | 1. FC Union Berlin 362 | VfB Stuttgart 358 | 1 | 1 | Bundesliga | 26 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72995 | 2021-2022 1995 | 2022-02-25 | TSG 1899 Hoffenheim 809 | VfB Stuttgart 358 | 2 | 1 | Bundesliga | 24 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72983 | 2021-2022 1995 | 2022-02-12 | Bayer 04 Leverkusen 352 | VfB Stuttgart 358 | 4 | 2 | Bundesliga | 22 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72961 | 2021-2022 1995 | 2022-01-22 | SC Freiburg 357 | VfB Stuttgart 358 | 2 | 0 | Bundesliga | 20 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72944 | 2021-2022 1995 | 2022-01-08 | Greuther Fürth 975 | VfB Stuttgart 358 | 0 | 0 | Bundesliga | 18 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72940 | 2021-2022 1995 | 2021-12-19 | 1. FC Köln 970 | VfB Stuttgart 358 | 1 | 0 | Bundesliga | 17 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72920 | 2021-2022 1995 | 2021-12-11 | VfL Wolfsburg 364 | VfB Stuttgart 358 | 0 | 2 | Bundesliga | 15 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72891 | 2021-2022 1995 | 2021-11-20 | Borussia Dortmund 730 | VfB Stuttgart 358 | 2 | 1 | Bundesliga | 12 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72876 | 2021-2022 1995 | 2021-10-31 | FC Augsburg 359 | VfB Stuttgart 358 | 4 | 1 | Bundesliga | 10 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72857 | 2021-2022 1995 | 2021-10-16 | Borussia Mönchengladbach 351 | VfB Stuttgart 358 | 1 | 1 | Bundesliga | 8 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72840 | 2021-2022 1995 | 2021-09-26 | VfL Bochum 354 | VfB Stuttgart 358 | 0 | 0 | Bundesliga | 6 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72821 | 2021-2022 1995 | 2021-09-12 | Eintracht Frankfurt 363 | VfB Stuttgart 358 | 1 | 1 | Bundesliga | 4 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72797 | 2021-2022 1995 | 2021-08-20 | RB Leipzig 353 | VfB Stuttgart 358 | 4 | 0 | Bundesliga | 2 | 0 | 0 | 0 | 2026-06-11T02:07:52 | 2026-06-11T02:07:52 | International Results CSV 1 | ||||||||||
| 72772 | 2020-2021 1994 | 2021-05-15 | Borussia Mönchengladbach 351 | VfB Stuttgart 358 | 1 | 2 | Bundesliga | 33 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72758 | 2020-2021 1994 | 2021-04-25 | RB Leipzig 353 | VfB Stuttgart 358 | 2 | 0 | Bundesliga | 31 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72739 | 2020-2021 1994 | 2021-04-17 | 1. FC Union Berlin 362 | VfB Stuttgart 358 | 2 | 1 | Bundesliga | 29 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72710 | 2020-2021 1994 | 2021-03-20 | FC Bayern München 365 | VfB Stuttgart 358 | 4 | 0 | Bundesliga | 26 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72691 | 2020-2021 1994 | 2021-03-06 | Eintracht Frankfurt 363 | VfB Stuttgart 358 | 1 | 1 | Bundesliga | 24 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72672 | 2020-2021 1994 | 2021-02-20 | 1. FC Köln 970 | VfB Stuttgart 358 | 0 | 1 | Bundesliga | 22 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72655 | 2020-2021 1994 | 2021-02-06 | Bayer 04 Leverkusen 352 | VfB Stuttgart 358 | 5 | 2 | Bundesliga | 20 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72638 | 2020-2021 1994 | 2021-01-23 | SC Freiburg 357 | VfB Stuttgart 358 | 2 | 1 | Bundesliga | 18 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72631 | 2020-2021 1994 | 2021-01-20 | Bielefeld 974 | VfB Stuttgart 358 | 3 | 0 | Bundesliga | 17 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72615 | 2020-2021 1994 | 2021-01-10 | FC Augsburg 359 | VfB Stuttgart 358 | 1 | 4 | Bundesliga | 15 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72598 | 2020-2021 1994 | 2020-12-20 | VfL Wolfsburg 364 | VfB Stuttgart 358 | 1 | 0 | Bundesliga | 13 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72574 | 2020-2021 1994 | 2020-12-12 | Borussia Dortmund 730 | VfB Stuttgart 358 | 1 | 5 | Bundesliga | 11 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72569 | 2020-2021 1994 | 2020-12-06 | SV Werder Bremen 360 | VfB Stuttgart 358 | 1 | 2 | Bundesliga | 10 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72549 | 2020-2021 1994 | 2020-11-21 | TSG 1899 Hoffenheim 809 | VfB Stuttgart 358 | 3 | 3 | Bundesliga | 8 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72527 | 2020-2021 1994 | 2020-10-30 | FC Schalke 04 816 | VfB Stuttgart 358 | 1 | 1 | Bundesliga | 6 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72511 | 2020-2021 1994 | 2020-10-17 | Hertha BSC 969 | VfB Stuttgart 358 | 0 | 2 | Bundesliga | 4 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72492 | 2020-2021 1994 | 2020-09-26 | 1. FSV Mainz 05 361 | VfB Stuttgart 358 | 1 | 4 | Bundesliga | 2 | 0 | 0 | 0 | 2026-06-11T02:07:51 | 2026-06-11T02:07:51 | International Results CSV 1 | ||||||||||
| 72170 | 2018-2019 1992 | 2019-05-18 | FC Schalke 04 816 | VfB Stuttgart 358 | 0 | 0 | Bundesliga | 34 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | International Results CSV 1 | ||||||||||
| 72152 | 2018-2019 1992 | 2019-05-04 | Hertha BSC 969 | VfB Stuttgart 358 | 3 | 1 | Bundesliga | 32 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | International Results CSV 1 | ||||||||||
| 72133 | 2018-2019 1992 | 2019-04-20 | FC Augsburg 359 | VfB Stuttgart 358 | 6 | 0 | Bundesliga | 30 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | International Results CSV 1 | ||||||||||
| 72112 | 2018-2019 1992 | 2019-03-31 | Eintracht Frankfurt 363 | VfB Stuttgart 358 | 3 | 0 | Bundesliga | 27 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | International Results CSV 1 | ||||||||||
| 72087 | 2018-2019 1992 | 2019-03-09 | Borussia Dortmund 730 | VfB Stuttgart 358 | 3 | 1 | Bundesliga | 25 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | International Results CSV 1 | ||||||||||
| 72068 | 2018-2019 1992 | 2019-02-22 | SV Werder Bremen 360 | VfB Stuttgart 358 | 1 | 1 | Bundesliga | 23 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | International Results CSV 1 | ||||||||||
| 72058 | 2018-2019 1992 | 2019-02-10 | Düsseldorf 971 | VfB Stuttgart 358 | 3 | 0 | Bundesliga | 21 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | International Results CSV 1 | ||||||||||
| 72039 | 2018-2019 1992 | 2019-01-27 | FC Bayern München 365 | VfB Stuttgart 358 | 4 | 1 | Bundesliga | 19 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | International Results CSV 1 | ||||||||||
| 72008 | 2018-2019 1992 | 2018-12-18 | VfL Wolfsburg 364 | VfB Stuttgart 358 | 2 | 0 | Bundesliga | 16 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | International Results CSV 1 | ||||||||||
| 71995 | 2018-2019 1992 | 2018-12-09 | Borussia Mönchengladbach 351 | VfB Stuttgart 358 | 3 | 0 | Bundesliga | 14 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | International Results CSV 1 | ||||||||||
| 71969 | 2018-2019 1992 | 2018-11-23 | Bayer 04 Leverkusen 352 | VfB Stuttgart 358 | 2 | 0 | Bundesliga | 12 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | International Results CSV 1 | ||||||||||
| 71961 | 2018-2019 1992 | 2018-11-10 | 1. FC Nürnberg 972 | VfB Stuttgart 358 | 0 | 2 | Bundesliga | 11 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | International Results CSV 1 | ||||||||||
| 71947 | 2018-2019 1992 | 2018-10-27 | TSG 1899 Hoffenheim 809 | VfB Stuttgart 358 | 4 | 0 | Bundesliga | 9 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | International Results CSV 1 | ||||||||||
| 71928 | 2018-2019 1992 | 2018-10-06 | Hannover 96 967 | VfB Stuttgart 358 | 3 | 1 | Bundesliga | 7 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | International Results CSV 1 | ||||||||||
| 71914 | 2018-2019 1992 | 2018-09-26 | RB Leipzig 353 | VfB Stuttgart 358 | 2 | 0 | Bundesliga | 5 | 0 | 0 | 0 | 2026-06-11T02:07:48 | 2026-06-11T02:07:48 | 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);