home / football

match

51 rows where away_team_id = 817 sorted by date descending

✎ View and edit SQL

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
73699 2023-2024 1997 2024-05-18   Borussia Dortmund 730 SV Darmstadt 98 817 4 0   Bundesliga 34           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73681 2023-2024 1997 2024-05-04   VfL Wolfsburg 364 SV Darmstadt 98 817 3 0   Bundesliga 32           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73662 2023-2024 1997 2024-04-20   1. FC Köln 970 SV Darmstadt 98 817 0 2   Bundesliga 30           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73646 2023-2024 1997 2024-04-06   1. FSV Mainz 05 361 SV Darmstadt 98 817 4 0   Bundesliga 28           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73641 2023-2024 1997 2024-03-31   VfL Bochum 354 SV Darmstadt 98 817 2 2   Bundesliga 27           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73619 2023-2024 1997 2024-03-09   RB Leipzig 353 SV Darmstadt 98 817 2 0   Bundesliga 25           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73600 2023-2024 1997 2024-02-24   SV Werder Bremen 360 SV Darmstadt 98 817 1 1   Bundesliga 23           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73581 2023-2024 1997 2024-02-10   Borussia Mönchengladbach 351 SV Darmstadt 98 817 0 0   Bundesliga 21           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73568 2023-2024 1997 2024-01-28   1. FC Union Berlin 362 SV Darmstadt 98 817 1 0   Bundesliga 19           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73536 2023-2024 1997 2023-12-19   TSG 1899 Hoffenheim 809 SV Darmstadt 98 817 3 3   Bundesliga 16           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73517 2023-2024 1997 2023-12-09   1. FC Heidenheim 976 SV Darmstadt 98 817 3 2   Bundesliga 14           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73501 2023-2024 1997 2023-11-25   SC Freiburg 357 SV Darmstadt 98 817 1 1   Bundesliga 12           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73474 2023-2024 1997 2023-10-28   FC Bayern München 365 SV Darmstadt 98 817 8 0   Bundesliga 9           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73455 2023-2024 1997 2023-10-07   FC Augsburg 359 SV Darmstadt 98 817 1 2   Bundesliga 7           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73435 2023-2024 1997 2023-09-22   VfB Stuttgart 358 SV Darmstadt 98 817 3 1   Bundesliga 5           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73418 2023-2024 1997 2023-09-02   Bayer 04 Leverkusen 352 SV Darmstadt 98 817 5 1   Bundesliga 3           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
73407 2023-2024 1997 2023-08-21   Eintracht Frankfurt 363 SV Darmstadt 98 817 1 0   Bundesliga 1           0 0 0 2026-06-11T02:07:54 2026-06-11T02:07:54     International Results CSV 1  
90456 2016-2017 2084 2017-05-20   Borussia Mönchengladbach 351 SV Darmstadt 98 817 2 2   Bundesliga   home         0 0 0 2026-06-11T09:37:46.541219 2026-06-11T09:37:46.541219        
88565 2016-2017 2084 2017-05-06   Bayern Munich 340 SV Darmstadt 98 817 1 0   Bundesliga   home         0 0 0 2026-06-11T09:07:26.540397 2026-06-11T09:07:26.540397        
88556 2016-2017 2084 2017-04-22   Hamburger SV 968 SV Darmstadt 98 817 1 2   Bundesliga   home         0 0 0 2026-06-11T09:07:26.540397 2026-06-11T09:07:26.540397        
105107 2016-2017 2084 2017-04-09   Ingolstadt 1333 SV Darmstadt 98 817 3 2   Bundesliga   home         0 0 0 2026-06-11T09:46:36.299886 2026-06-11T09:46:36.299886        
88541 2016-2017 2084 2017-04-01   RB Leipzig 353 SV Darmstadt 98 817 4 0   Bundesliga   home         0 0 0 2026-06-11T09:07:26.540397 2026-06-11T09:07:26.540397        
88536 2016-2017 2084 2017-03-18   VfL Wolfsburg 364 SV Darmstadt 98 817 1 0   Bundesliga   home         0 0 0 2026-06-11T09:07:26.540397 2026-06-11T09:07:26.540397        
88525 2016-2017 2084 2017-03-04   Werder Bremen 813 SV Darmstadt 98 817 2 0   Bundesliga   home         0 0 0 2026-06-11T09:07:26.540397 2026-06-11T09:07:26.540397        
88515 2016-2017 2084 2017-02-18   TSG Hoffenheim 355 SV Darmstadt 98 817 2 0   Bundesliga   home         0 0 0 2026-06-11T09:07:26.540397 2026-06-11T09:07:26.540397        
88508 2016-2017 2084 2017-02-05   Eintracht Frankfurt 363 SV Darmstadt 98 817 2 0   Bundesliga   home         0 0 0 2026-06-11T09:07:26.540397 2026-06-11T09:07:26.540397        
88493 2016-2017 2084 2016-12-21   Hertha BSC 969 SV Darmstadt 98 817 2 0   Bundesliga   home         0 0 0 2026-06-11T09:07:26.540397 2026-06-11T09:07:26.540397        
88483 2016-2017 2084 2016-12-10   SC Freiburg 357 SV Darmstadt 98 817 1 0   Bundesliga   home         0 0 0 2026-06-11T09:07:26.540397 2026-06-11T09:07:26.540397        
88475 2016-2017 2084 2016-11-27   FC Schalke 04 816 SV Darmstadt 98 817 3 1   Bundesliga   home         0 0 0 2026-06-11T09:07:26.540397 2026-06-11T09:07:26.540397        
105040 2016-2017 2084 2016-11-05   Leverkusen 1323 SV Darmstadt 98 817 3 2   Bundesliga   home         0 0 0 2026-06-11T09:46:36.299886 2026-06-11T09:46:36.299886        
105031 2016-2017 2084 2016-10-16   Mainz 1330 SV Darmstadt 98 817 2 1   Bundesliga   home         0 0 0 2026-06-11T09:46:36.299886 2026-06-11T09:46:36.299886        
88439 2016-2017 2084 2016-09-24   FC Augsburg 359 SV Darmstadt 98 817 1 0   Bundesliga   home         0 0 0 2026-06-11T09:07:26.540397 2026-06-11T09:07:26.540397        
105015 2016-2017 2084 2016-09-17   Dortmund 1318 SV Darmstadt 98 817 6 0   Bundesliga   home         0 0 0 2026-06-11T09:46:36.299886 2026-06-11T09:46:36.299886        
88424 2016-2017 2084 2016-08-27   1.FC Köln 815 SV Darmstadt 98 817 2 0   Bundesliga   home         0 0 0 2026-06-11T09:07:26.540397 2026-06-11T09:07:26.540397        
88414 2015-2016 2083 2016-05-07   Hertha BSC 969 SV Darmstadt 98 817 1 2   Bundesliga   home         0 0 0 2026-06-11T09:07:18.134779 2026-06-11T09:07:18.134779        
88404 2015-2016 2083 2016-04-23   1.FC Köln 815 SV Darmstadt 98 817 4 1   Bundesliga   home         0 0 0 2026-06-11T09:07:18.134779 2026-06-11T09:07:18.134779        
88396 2015-2016 2083 2016-04-09   Hamburger SV 968 SV Darmstadt 98 817 1 2   Bundesliga   home         0 0 0 2026-06-11T09:07:18.134779 2026-06-11T09:07:18.134779        
88389 2015-2016 2083 2016-03-19   VfL Wolfsburg 364 SV Darmstadt 98 817 1 1   Bundesliga   home         0 0 0 2026-06-11T09:07:18.134779 2026-06-11T09:07:18.134779        
104972 2015-2016 2083 2016-03-06   Mainz 1330 SV Darmstadt 98 817 0 0   Bundesliga   home         0 0 0 2026-06-11T09:46:30.061849 2026-06-11T09:46:30.061849        
88370 2015-2016 2083 2016-02-27   Werder Bremen 813 SV Darmstadt 98 817 2 2   Bundesliga   home         0 0 0 2026-06-11T09:07:18.134779 2026-06-11T09:07:18.134779        
88364 2015-2016 2083 2016-02-20   Bayern Munich 340 SV Darmstadt 98 817 3 1   Bundesliga   home         0 0 0 2026-06-11T09:07:18.134779 2026-06-11T09:07:18.134779        
88358 2015-2016 2083 2016-02-07   TSG Hoffenheim 355 SV Darmstadt 98 817 0 2   Bundesliga   home         0 0 0 2026-06-11T09:07:18.134779 2026-06-11T09:07:18.134779        
88345 2015-2016 2083 2016-01-23   Hannover 96 967 SV Darmstadt 98 817 1 2   Bundesliga   home         0 0 0 2026-06-11T09:07:18.134779 2026-06-11T09:07:18.134779        
90417 2015-2016 2083 2015-12-20   Borussia Mönchengladbach 351 SV Darmstadt 98 817 3 2   Bundesliga   home         0 0 0 2026-06-11T09:37:39.201064 2026-06-11T09:37:39.201064        
88331 2015-2016 2083 2015-12-06   Eintracht Frankfurt 363 SV Darmstadt 98 817 0 1   Bundesliga   home         0 0 0 2026-06-11T09:07:18.134779 2026-06-11T09:07:18.134779        
104929 2015-2016 2083 2015-11-22   Ingolstadt 1333 SV Darmstadt 98 817 3 1   Bundesliga   home         0 0 0 2026-06-11T09:46:30.061849 2026-06-11T09:46:30.061849        
88315 2015-2016 2083 2015-11-01   VfB Stuttgart 358 SV Darmstadt 98 817 2 0   Bundesliga   home         0 0 0 2026-06-11T09:07:18.134779 2026-06-11T09:07:18.134779        
88303 2015-2016 2083 2015-10-17   FC Augsburg 359 SV Darmstadt 98 817 0 2   Bundesliga   home         0 0 0 2026-06-11T09:07:18.134779 2026-06-11T09:07:18.134779        
104906 2015-2016 2083 2015-09-27   Dortmund 1318 SV Darmstadt 98 817 2 2   Bundesliga   home         0 0 0 2026-06-11T09:46:30.061849 2026-06-11T09:46:30.061849        
104895 2015-2016 2083 2015-09-12   Leverkusen 1323 SV Darmstadt 98 817 0 1   Bundesliga   home         0 0 0 2026-06-11T09:46:30.061849 2026-06-11T09:46:30.061849        
88276 2015-2016 2083 2015-08-22   FC Schalke 04 816 SV Darmstadt 98 817 1 1   Bundesliga   home         0 0 0 2026-06-11T09:07:18.134779 2026-06-11T09:07:18.134779        

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 28.951ms