match
25 rows where season_id = 1570 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33167 | 2009 1570 | 2009-07-26 | United States 5 | Mexico 57 | 0 | 5 | A | Gold Cup | East Rutherford | East Rutherford | United States | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.917721 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33167 | ||||
| 33164 | 2009 1570 | 2009-07-23 | Costa Rica 46 | Mexico 57 | 1 | 1 | D | Gold Cup | Chicago | Chicago | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.916268 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33164 | ||||
| 33165 | 2009 1570 | 2009-07-23 | United States 5 | Honduras 72 | 2 | 0 | H | Gold Cup | Chicago | Chicago | United States | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.916752 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33165 | ||||
| 33162 | 2009 1570 | 2009-07-19 | Guadeloupe 81 | Costa Rica 46 | 1 | 5 | A | Gold Cup | Arlington | Arlington | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.915298 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33162 | ||||
| 33163 | 2009 1570 | 2009-07-19 | Mexico 57 | Haiti 66 | 4 | 0 | H | Gold Cup | Arlington | Arlington | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.915781 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33163 | ||||
| 33159 | 2009 1570 | 2009-07-18 | Canada 6 | Honduras 72 | 0 | 1 | A | Gold Cup | Philadelphia | Philadelphia | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.913841 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33159 | ||||
| 33161 | 2009 1570 | 2009-07-18 | United States 5 | Panama 87 | 2 | 1 | H | Gold Cup | Philadelphia | Philadelphia | United States | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.914810 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33161 | ||||
| 33156 | 2009 1570 | 2009-07-12 | Panama 87 | Nicaragua 76 | 4 | 0 | H | Gold Cup | Glendale | Glendale | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.912331 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33156 | ||||
| 33155 | 2009 1570 | 2009-07-12 | Mexico 57 | Guadeloupe 81 | 2 | 0 | H | Gold Cup | Glendale | Glendale | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.911844 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33155 | ||||
| 33152 | 2009 1570 | 2009-07-11 | Honduras 72 | Grenada 91 | 4 | 0 | H | Gold Cup | Foxborough | Foxborough | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.910398 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33152 | ||||
| 33153 | 2009 1570 | 2009-07-11 | United States 5 | Haiti 66 | 2 | 2 | D | Gold Cup | Foxborough | Foxborough | United States | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.910879 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33153 | ||||
| 33150 | 2009 1570 | 2009-07-10 | El Salvador 47 | Jamaica 67 | 0 | 1 | A | Gold Cup | Miami | Miami | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.909424 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33150 | ||||
| 33149 | 2009 1570 | 2009-07-10 | Costa Rica 46 | Canada 6 | 2 | 2 | D | Gold Cup | Miami | Miami | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.908937 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33149 | ||||
| 33147 | 2009 1570 | 2009-07-09 | Guadeloupe 81 | Nicaragua 76 | 2 | 0 | H | Gold Cup | Houston | Houston | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.907970 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33147 | ||||
| 33148 | 2009 1570 | 2009-07-09 | Mexico 57 | Panama 87 | 1 | 1 | D | Gold Cup | Houston | Houston | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.908457 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33148 | ||||
| 33145 | 2009 1570 | 2009-07-08 | Haiti 66 | Grenada 91 | 2 | 0 | H | Gold Cup | Washington, D.C. | Washington, D.C. | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.907002 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33145 | ||||
| 33146 | 2009 1570 | 2009-07-08 | United States 5 | Honduras 72 | 2 | 0 | H | Gold Cup | Washington, D.C. | Washington, D.C. | United States | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.907488 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33146 | ||||
| 33144 | 2009 1570 | 2009-07-07 | Jamaica 67 | Costa Rica 46 | 0 | 1 | A | Gold Cup | Columbus | Columbus | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.906520 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33144 | ||||
| 33143 | 2009 1570 | 2009-07-07 | El Salvador 47 | Canada 6 | 0 | 1 | A | Gold Cup | Columbus | Columbus | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.906029 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33143 | ||||
| 33141 | 2009 1570 | 2009-07-05 | Panama 87 | Guadeloupe 81 | 1 | 2 | A | Gold Cup | Oakland | Oakland | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.905064 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33141 | ||||
| 33140 | 2009 1570 | 2009-07-05 | Nicaragua 76 | Mexico 57 | 0 | 2 | A | Gold Cup | Oakland | Oakland | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.904583 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33140 | ||||
| 33136 | 2009 1570 | 2009-07-04 | Honduras 72 | Haiti 66 | 1 | 0 | H | Gold Cup | Seattle | Seattle | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.902643 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33136 | ||||
| 33137 | 2009 1570 | 2009-07-04 | United States 5 | Grenada 91 | 4 | 0 | H | Gold Cup | Seattle | Seattle | United States | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.903121 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33137 | ||||
| 33130 | 2009 1570 | 2009-07-03 | Costa Rica 46 | El Salvador 47 | 1 | 2 | A | Gold Cup | Carson | Carson | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.899727 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33130 | ||||
| 33129 | 2009 1570 | 2009-07-03 | Canada 6 | Jamaica 67 | 1 | 0 | H | Gold Cup | Carson | Carson | United States | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.899249 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33129 |
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);