match
38 rows where home_team_id = 925 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63187 | 2018-2019 1968 | 2019-05-04 | Cardiff City 925 | Crystal Palace 742 | 2 | 3 | Premier League | 37 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63171 | 2018-2019 1968 | 2019-04-21 | Cardiff City 925 | Liverpool FC 914 | 0 | 2 | Premier League | 35 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63140 | 2018-2019 1968 | 2019-03-31 | Cardiff City 925 | Chelsea FC 915 | 1 | 2 | Premier League | 32 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63114 | 2018-2019 1968 | 2019-03-09 | Cardiff City 925 | West Ham United 753 | 2 | 0 | Premier League | 30 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63093 | 2018-2019 1968 | 2019-02-26 | Cardiff City 925 | Everton FC 918 | 0 | 3 | Premier League | 28 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63084 | 2018-2019 1968 | 2019-02-22 | Cardiff City 925 | Watford FC 913 | 1 | 5 | Premier League | 27 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63069 | 2018-2019 1968 | 2019-02-02 | Cardiff City 925 | AFC Bournemouth 923 | 2 | 0 | Premier League | 25 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63036 | 2018-2019 1968 | 2019-01-12 | Cardiff City 925 | Huddersfield Town 917 | 0 | 0 | Premier League | 22 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63025 | 2018-2019 1968 | 2019-01-01 | Cardiff City 925 | Tottenham Hotspur 752 | 0 | 3 | Premier League | 21 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 63001 | 2018-2019 1968 | 2018-12-22 | Cardiff City 925 | Manchester U 924 | 1 | 5 | Premier League | 18 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62976 | 2018-2019 1968 | 2018-12-08 | Cardiff City 925 | Southampton FC 920 | 1 | 0 | Premier League | 16 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62953 | 2018-2019 1968 | 2018-11-30 | Cardiff City 925 | Wolverhampton Wanderers 754 | 2 | 1 | Premier League | 14 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62933 | 2018-2019 1968 | 2018-11-10 | Cardiff City 925 | Brighton & Hove Albion 740 | 2 | 1 | Premier League | 12 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62924 | 2018-2019 1968 | 2018-11-03 | Cardiff City 925 | Leicester City 746 | 0 | 1 | Premier League | 11 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62905 | 2018-2019 1968 | 2018-10-20 | Cardiff City 925 | Fulham FC 926 | 4 | 2 | Premier League | 9 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62891 | 2018-2019 1968 | 2018-09-30 | Cardiff City 925 | Burnley FC 916 | 1 | 2 | Premier League | 7 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62875 | 2018-2019 1968 | 2018-09-22 | Cardiff City 925 | Manchester City 748 | 0 | 5 | Premier League | 6 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62860 | 2018-2019 1968 | 2018-09-02 | Cardiff City 925 | Arsenal FC 912 | 2 | 3 | Premier League | 4 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 62833 | 2018-2019 1968 | 2018-08-18 | Cardiff City 925 | Newcastle United 749 | 0 | 0 | Premier League | 2 | 0 | 0 | 0 | 2026-06-11T02:05:48 | 2026-06-11T02:05:48 | International Results CSV 1 | ||||||||||
| 75789 | 2013-2014 2018 | 2014-05-11 | Cardiff City 925 | Chelsea 741 | 1 | 2 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:00:03.778758 | 2026-06-11T09:00:03.778758 | |||||||||||
| 95661 | 2013-2014 2018 | 2014-04-19 | Cardiff City 925 | Stoke 1285 | 1 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:42:06.989909 | 2026-06-11T09:42:06.989909 | |||||||||||
| 75770 | 2013-2014 2018 | 2014-04-05 | Cardiff City 925 | Crystal Palace 742 | 0 | 3 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:00:03.778758 | 2026-06-11T09:00:03.778758 | |||||||||||
| 75760 | 2013-2014 2018 | 2014-03-22 | Cardiff City 925 | Liverpool 747 | 3 | 6 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:00:03.778758 | 2026-06-11T09:00:03.778758 | |||||||||||
| 75752 | 2013-2014 2018 | 2014-03-08 | Cardiff City 925 | Fulham 744 | 3 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:00:03.778758 | 2026-06-11T09:00:03.778758 | |||||||||||
| 95622 | 2013-2014 2018 | 2014-02-22 | Cardiff City 925 | Hull 1286 | 0 | 4 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:42:06.989909 | 2026-06-11T09:42:06.989909 | |||||||||||
| 75740 | 2013-2014 2018 | 2014-02-11 | Cardiff City 925 | Aston Villa 737 | 0 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:00:03.778758 | 2026-06-11T09:00:03.778758 | |||||||||||
| 75731 | 2013-2014 2018 | 2014-02-01 | Cardiff City 925 | Norwich City 927 | 2 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:00:03.778758 | 2026-06-11T09:00:03.778758 | |||||||||||
| 95592 | 2013-2014 2018 | 2014-01-11 | Cardiff City 925 | West Ham 1275 | 0 | 2 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:42:06.989909 | 2026-06-11T09:42:06.989909 | |||||||||||
| 95581 | 2013-2014 2018 | 2013-12-28 | Cardiff City 925 | Sunderland 1279 | 2 | 2 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:42:06.989909 | 2026-06-11T09:42:06.989909 | |||||||||||
| 75708 | 2013-2014 2018 | 2013-12-26 | Cardiff City 925 | Southampton 751 | 0 | 3 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:00:03.778758 | 2026-06-11T09:00:03.778758 | |||||||||||
| 75699 | 2013-2014 2018 | 2013-12-14 | Cardiff City 925 | West Bromwich 922 | 1 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:00:03.778758 | 2026-06-11T09:00:03.778758 | |||||||||||
| 75689 | 2013-2014 2018 | 2013-11-30 | Cardiff City 925 | Arsenal 736 | 0 | 3 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:00:03.778758 | 2026-06-11T09:00:03.778758 | |||||||||||
| 75687 | 2013-2014 2018 | 2013-11-24 | Cardiff City 925 | Manchester United 338 | 2 | 2 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:00:03.778758 | 2026-06-11T09:00:03.778758 | |||||||||||
| 75678 | 2013-2014 2018 | 2013-11-03 | Cardiff City 925 | Swansea City 921 | 1 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:00:03.778758 | 2026-06-11T09:00:03.778758 | |||||||||||
| 95519 | 2013-2014 2018 | 2013-10-05 | Cardiff City 925 | Newcastle 1272 | 1 | 2 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:42:06.989909 | 2026-06-11T09:42:06.989909 | |||||||||||
| 95513 | 2013-2014 2018 | 2013-09-22 | Cardiff City 925 | Tottenham 1273 | 0 | 1 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:42:06.989909 | 2026-06-11T09:42:06.989909 | |||||||||||
| 75646 | 2013-2014 2018 | 2013-08-31 | Cardiff City 925 | Everton 743 | 0 | 0 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:00:03.778758 | 2026-06-11T09:00:03.778758 | |||||||||||
| 89077 | 2013-2014 2018 | 2013-08-25 | Cardiff City 925 | Manchester City 748 | 3 | 2 | Premier League | home | 0 | 0 | 0 | 2026-06-11T09:31:19.476847 | 2026-06-11T09:31:19.476847 |
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);