match
31 rows where season_id = 1823 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date, home_team_id, away_team_id, home_score, away_score, result, venue, city, is_neutral, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44282 | 2021 1823 | 2021-08-01 | United States 5 | Mexico 57 | 1 | 0 | H | Gold Cup | Las Vegas | Las Vegas | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.082858 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44282 | ||||
| 44280 | 2021 1823 | 2021-07-29 | Mexico 57 | Canada 6 | 2 | 1 | H | Gold Cup | Houston | Houston | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.081894 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44280 | ||||
| 44281 | 2021 1823 | 2021-07-29 | United States 5 | Qatar 190 | 1 | 0 | H | Gold Cup | Austin | Austin | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.082381 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44281 | ||||
| 44278 | 2021 1823 | 2021-07-25 | Costa Rica 46 | Canada 6 | 0 | 2 | A | Gold Cup | Arlington | Arlington | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.080930 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44278 | ||||
| 44279 | 2021 1823 | 2021-07-25 | United States 5 | Jamaica 67 | 1 | 0 | H | Gold Cup | Arlington | Arlington | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.081418 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44279 | ||||
| 44277 | 2021 1823 | 2021-07-24 | Qatar 190 | El Salvador 47 | 3 | 2 | H | Gold Cup | Glendale | Glendale | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.080453 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44277 | ||||
| 44276 | 2021 1823 | 2021-07-24 | Mexico 57 | Honduras 72 | 3 | 0 | H | Gold Cup | Glendale | Glendale | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.079969 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44276 | ||||
| 44274 | 2021 1823 | 2021-07-20 | Panama 87 | Grenada 91 | 3 | 1 | H | Gold Cup | Orlando | Orlando | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.079006 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44274 | ||||
| 44275 | 2021 1823 | 2021-07-20 | Honduras 72 | Qatar 190 | 0 | 2 | A | Gold Cup | Houston | Houston | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.079491 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44275 | ||||
| 44273 | 2021 1823 | 2021-07-20 | Costa Rica 46 | Jamaica 67 | 1 | 0 | H | Gold Cup | Orlando | Orlando | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.078528 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44273 | ||||
| 44272 | 2021 1823 | 2021-07-20 | Suriname 44 | Guadeloupe 81 | 2 | 1 | H | Gold Cup | Houston | Houston | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.078043 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44272 | ||||
| 44270 | 2021 1823 | 2021-07-18 | Martinique 78 | Haiti 66 | 1 | 2 | A | Gold Cup | Frisco | Frisco | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.077074 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44270 | ||||
| 44269 | 2021 1823 | 2021-07-18 | Mexico 57 | El Salvador 47 | 1 | 0 | H | Gold Cup | Dallas | Dallas | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.076593 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44269 | ||||
| 44268 | 2021 1823 | 2021-07-18 | Guatemala 48 | Trinidad & Tobago 20 | 1 | 1 | D | Gold Cup | Frisco | Frisco | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.076107 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44268 | ||||
| 44271 | 2021 1823 | 2021-07-18 | United States 5 | Canada 6 | 1 | 0 | H | Gold Cup | Kansas City | Kansas City | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.077564 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44271 | ||||
| 44264 | 2021 1823 | 2021-07-17 | Grenada 91 | Qatar 190 | 0 | 4 | A | Gold Cup | Houston | Houston | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.074174 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44264 | ||||
| 44265 | 2021 1823 | 2021-07-17 | Panama 87 | Honduras 72 | 2 | 3 | A | Gold Cup | Houston | Houston | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.074657 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44265 | ||||
| 44262 | 2021 1823 | 2021-07-16 | Guadeloupe 81 | Jamaica 67 | 1 | 2 | A | Gold Cup | Orlando | Orlando | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.073206 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44262 | ||||
| 44263 | 2021 1823 | 2021-07-16 | Suriname 44 | Costa Rica 46 | 1 | 2 | A | Gold Cup | Orlando | Orlando | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.073688 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44263 | ||||
| 44258 | 2021 1823 | 2021-07-15 | Haiti 66 | Canada 6 | 1 | 4 | A | Gold Cup | Kansas City | Kansas City | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.071273 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44258 | ||||
| 44259 | 2021 1823 | 2021-07-15 | United States 5 | Martinique 78 | 6 | 1 | H | Gold Cup | Kansas City | Kansas City | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.071751 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44259 | ||||
| 44257 | 2021 1823 | 2021-07-14 | Guatemala 48 | Mexico 57 | 0 | 3 | A | Gold Cup | Dallas | Dallas | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.070789 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44257 | ||||
| 44256 | 2021 1823 | 2021-07-14 | Trinidad & Tobago 20 | El Salvador 47 | 0 | 2 | A | Gold Cup | Frisco | Frisco | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.070310 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44256 | ||||
| 44250 | 2021 1823 | 2021-07-13 | Qatar 190 | Panama 87 | 3 | 3 | D | Gold Cup | Houston | Houston | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.067419 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44250 | ||||
| 44251 | 2021 1823 | 2021-07-13 | Honduras 72 | Grenada 91 | 4 | 0 | H | Gold Cup | Houston | Houston | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.067898 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44251 | ||||
| 44244 | 2021 1823 | 2021-07-12 | Jamaica 67 | Suriname 44 | 2 | 0 | H | Gold Cup | Orlando | Orlando | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.064513 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44244 | ||||
| 44245 | 2021 1823 | 2021-07-12 | Costa Rica 46 | Guadeloupe 81 | 3 | 1 | H | Gold Cup | Orlando | Orlando | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.064996 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44245 | ||||
| 44241 | 2021 1823 | 2021-07-11 | El Salvador 47 | Guatemala 48 | 2 | 0 | H | Gold Cup | Frisco | Frisco | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.063034 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44241 | ||||
| 44242 | 2021 1823 | 2021-07-11 | Canada 6 | Martinique 78 | 4 | 1 | H | Gold Cup | Kansas City | Kansas City | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.063521 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44242 | ||||
| 44243 | 2021 1823 | 2021-07-11 | United States 5 | Haiti 66 | 1 | 0 | H | Gold Cup | Kansas City | Kansas City | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.064003 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44243 | ||||
| 44237 | 2021 1823 | 2021-07-10 | Mexico 57 | Trinidad & Tobago 20 | 0 | 0 | D | Gold Cup | Arlington | Arlington | United States | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.061096 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44237 |
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);