match
501 rows where home_team_id = 5 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: home_score, away_score, result, round_stage, country, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49393 | 2026 1937 | 2026-06-25 | United States 5 | Turkey 61 | FIFA World Cup | Inglewood | Inglewood | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.883760 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49393 | |||||||
| 49369 | 2026 1937 | 2026-06-19 | United States 5 | Australia 53 | FIFA World Cup | Seattle | Seattle | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.871651 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49369 | |||||||
| 49342 | 2026 1937 | 2026-06-12 | United States 5 | Paraguay 37 | FIFA World Cup | Inglewood | Inglewood | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.857965 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49342 | |||||||
| 49282 | 2026 1929 | 2026-05-31 | United States 5 | Senegal 166 | 3 | 2 | H | Friendly | Charlotte | Charlotte | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.827580 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49282 | ||||
| 49247 | 2026 1929 | 2026-03-31 | United States 5 | Portugal 50 | 0 | 2 | A | Friendly | Atlanta | Atlanta | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.809810 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49247 | ||||
| 49185 | 2026 1929 | 2026-03-28 | United States 5 | Belgium 12 | 2 | 5 | A | Friendly | Atlanta | Atlanta | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.778435 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49185 | ||||
| 48993 | 2025 1906 | 2025-11-18 | United States 5 | Uruguay 7 | 5 | 1 | H | Friendly | Tampa | Tampa | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.627019 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48993 | ||||
| 48920 | 2025 1906 | 2025-11-15 | United States 5 | Paraguay 37 | 2 | 1 | H | Friendly | Chester | Chester | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.591667 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48920 | ||||
| 48818 | 2025 1906 | 2025-10-14 | United States 5 | Australia 53 | 2 | 1 | H | Friendly | Denver | Denver | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.542248 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48818 | ||||
| 48739 | 2025 1906 | 2025-10-10 | United States 5 | Ecuador 89 | 1 | 1 | D | Friendly | Austin | Austin | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.503913 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48739 | ||||
| 48644 | 2025 1906 | 2025-09-09 | United States 5 | Japan 36 | 2 | 0 | H | Friendly | Columbus | Columbus | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.457345 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48644 | ||||
| 48593 | 2025 1906 | 2025-09-06 | United States 5 | South Korea 114 | 0 | 2 | A | Friendly | Harrison | Harrison | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.432523 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48593 | ||||
| 48504 | 2025 1914 | 2025-07-06 | United States 5 | Mexico 57 | 1 | 2 | A | Gold Cup | Houston | Houston | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.389019 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48504 | ||||
| 48499 | 2025 1914 | 2025-07-02 | United States 5 | Guatemala 48 | 2 | 1 | H | Gold Cup | St. Louis | St. Louis | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.386599 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48499 | ||||
| 48497 | 2025 1914 | 2025-06-29 | United States 5 | Costa Rica 46 | 2 | 2 | D | Gold Cup | Minneapolis | Minneapolis | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.385629 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48497 | ||||
| 48489 | 2025 1914 | 2025-06-22 | United States 5 | Haiti 66 | 2 | 1 | H | Gold Cup | Arlington | Arlington | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.381754 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48489 | ||||
| 48481 | 2025 1914 | 2025-06-19 | United States 5 | Saudi Arabia 179 | 1 | 0 | H | Gold Cup | Austin | Austin | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.377859 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48481 | ||||
| 48472 | 2025 1914 | 2025-06-15 | United States 5 | Trinidad & Tobago 20 | 5 | 0 | H | Gold Cup | San Jose | San Jose | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.373471 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48472 | ||||
| 48434 | 2025 1906 | 2025-06-10 | United States 5 | Switzerland 14 | 0 | 4 | A | Friendly | Nashville | Nashville | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.354969 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48434 | ||||
| 48374 | 2025 1906 | 2025-06-07 | United States 5 | Turkey 61 | 1 | 2 | A | Friendly | East Hartford | East Hartford | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.325844 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48374 | ||||
| 48200 | 2025 1908 | 2025-03-23 | United States 5 | Canada 6 | 1 | 2 | A | CONCACAF Nations League | Inglewood | Inglewood | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.241085 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48200 | ||||
| 48121 | 2025 1908 | 2025-03-20 | United States 5 | Panama 87 | 0 | 1 | A | CONCACAF Nations League | Inglewood | Inglewood | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.202408 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48121 | ||||
| 48102 | 2025 1906 | 2025-01-22 | United States 5 | Costa Rica 46 | 3 | 0 | H | Friendly | Orlando | Orlando | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.193178 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48102 | ||||
| 48101 | 2025 1906 | 2025-01-18 | United States 5 | Venezuela 88 | 3 | 1 | H | Friendly | Fort Lauderdale | Fort Lauderdale | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.192694 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48101 | ||||
| 47979 | 2024 1883 | 2024-11-18 | United States 5 | Jamaica 67 | 4 | 2 | H | CONCACAF Nations League | Saint Louis | Saint Louis | United States | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.089788 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47979 | ||||
| 47747 | 2024 1877 | 2024-10-12 | United States 5 | Panama 87 | 2 | 0 | H | Friendly | Austin | Austin | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.976985 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47747 | ||||
| 47618 | 2024 1877 | 2024-09-10 | United States 5 | New Zealand 52 | 1 | 1 | D | Friendly | Cincinnati | Cincinnati | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.914037 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47618 | ||||
| 47558 | 2024 1877 | 2024-09-07 | United States 5 | Canada 6 | 1 | 2 | A | Friendly | Kansas City | Kansas City | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.884708 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47558 | ||||
| 47450 | 2024 1892 | 2024-07-01 | United States 5 | Uruguay 7 | 0 | 1 | A | Copa América | Kansas City | Kansas City | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.831628 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47450 | ||||
| 47434 | 2024 1892 | 2024-06-27 | United States 5 | Panama 87 | 1 | 2 | A | Copa América | Atlanta | Atlanta | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.823746 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47434 | ||||
| 47414 | 2024 1892 | 2024-06-23 | United States 5 | Bolivia 70 | 2 | 0 | H | Copa América | Arlington | Arlington | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.787217 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47414 | ||||
| 47369 | 2024 1877 | 2024-06-12 | United States 5 | Brazil 34 | 1 | 1 | D | Friendly | Orlando | Orlando | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.765339 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47369 | ||||
| 47283 | 2024 1877 | 2024-06-08 | United States 5 | Colombia 86 | 1 | 5 | A | Friendly | Landover | Landover | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.723411 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47283 | ||||
| 47098 | 2024 1883 | 2024-03-24 | United States 5 | Mexico 57 | 2 | 0 | H | CONCACAF Nations League | Arlington | Arlington | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.633390 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47098 | ||||
| 47021 | 2024 1883 | 2024-03-21 | United States 5 | Jamaica 67 | 3 | 1 | H | CONCACAF Nations League | Arlington | Arlington | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.596127 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47021 | ||||
| 46946 | 2024 1877 | 2024-01-20 | United States 5 | Slovenia 238 | 0 | 1 | A | Friendly | San Antonio | San Antonio | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.505936 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46946 | ||||
| 46661 | 2023 1860 | 2023-11-16 | United States 5 | Trinidad & Tobago 20 | 3 | 0 | H | CONCACAF Nations League | Austin | Austin | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.367101 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46661 | ||||
| 46637 | 2023 1856 | 2023-10-17 | United States 5 | Ghana 124 | 4 | 0 | H | Friendly | Nashville | Nashville | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.355470 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46637 | ||||
| 46552 | 2023 1856 | 2023-10-14 | United States 5 | Germany 22 | 1 | 3 | A | Friendly | East Hartford | East Hartford | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.314246 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46552 | ||||
| 46463 | 2023 1856 | 2023-09-12 | United States 5 | Oman 184 | 4 | 0 | H | Friendly | Saint Paul | Saint Paul | United States | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.270948 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46463 | ||||
| 46382 | 2023 1856 | 2023-09-09 | United States 5 | Uzbekistan 242 | 3 | 0 | H | Friendly | St. Louis | St. Louis | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.231555 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46382 | ||||
| 46272 | 2023 1867 | 2023-07-12 | United States 5 | Panama 87 | 1 | 1 | D | Gold Cup | San Diego | San Diego | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.177937 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46272 | ||||
| 46242 | 2023 1867 | 2023-07-09 | United States 5 | Canada 6 | 2 | 2 | D | Gold Cup | Cincinnati | Cincinnati | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.163406 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46242 | ||||
| 46222 | 2023 1867 | 2023-07-02 | United States 5 | Trinidad & Tobago 20 | 6 | 0 | H | Gold Cup | Charlotte | Charlotte | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.153711 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46222 | ||||
| 46210 | 2023 1867 | 2023-06-28 | United States 5 | Saint Kitts and Nevis 90 | 6 | 0 | H | Gold Cup | St. Louis | St. Louis | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.147778 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46210 | ||||
| 46195 | 2023 1867 | 2023-06-24 | United States 5 | Jamaica 67 | 1 | 1 | D | Gold Cup | Chicago | Chicago | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.140512 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46195 | ||||
| 46123 | 2023 1860 | 2023-06-18 | United States 5 | Canada 6 | 2 | 0 | H | CONCACAF Nations League | Las Vegas | Las Vegas | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.105520 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46123 | ||||
| 46060 | 2023 1860 | 2023-06-15 | United States 5 | Mexico 57 | 3 | 0 | H | CONCACAF Nations League | Las Vegas | Las Vegas | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.075023 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46060 | ||||
| 46031 | 2023 1856 | 2023-04-19 | United States 5 | Mexico 57 | 1 | 1 | D | Friendly | Glendale | Glendale | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.060988 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46031 | ||||
| 45978 | 2023 1860 | 2023-03-27 | United States 5 | El Salvador 47 | 1 | 0 | H | CONCACAF Nations League | Orlando | Orlando | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.990727 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45978 | ||||
| 45836 | 2023 1856 | 2023-01-28 | United States 5 | Colombia 86 | 0 | 0 | D | Friendly | Carson | Carson | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.921870 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45836 | ||||
| 45835 | 2023 1856 | 2023-01-25 | United States 5 | Serbia 122 | 1 | 2 | A | Friendly | Los Angeles | Los Angeles | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.921390 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45835 | ||||
| 45719 | 2022 1853 | 2022-11-21 | United States 5 | Wales 3 | 1 | 1 | D | FIFA World Cup | Al Rayyan | Al Rayyan | Qatar | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.865164 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45719 | ||||
| 45333 | 2022 1841 | 2022-06-10 | United States 5 | Grenada 91 | 5 | 0 | H | CONCACAF Nations League | Austin | Austin | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.677458 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45333 | ||||
| 45250 | 2022 1832 | 2022-06-05 | United States 5 | Uruguay 7 | 0 | 0 | D | Friendly | Kansas City | Kansas City | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.636972 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45250 | ||||
| 45162 | 2022 1832 | 2022-06-01 | United States 5 | Morocco 155 | 3 | 0 | H | Friendly | Cincinnati | Cincinnati | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.593986 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45162 | ||||
| 45047 | 2022 1834 | 2022-03-27 | United States 5 | Panama 87 | 5 | 1 | H | FIFA World Cup qualification | Orlando | Orlando | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.537897 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45047 | ||||
| 44946 | 2022 1834 | 2022-02-02 | United States 5 | Honduras 72 | 3 | 0 | H | FIFA World Cup qualification | Saint Paul | Saint Paul | United States | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.405667 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44946 | ||||
| 44901 | 2022 1834 | 2022-01-27 | United States 5 | El Salvador 47 | 1 | 0 | H | FIFA World Cup qualification | Columbus | Columbus | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.383768 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44901 | ||||
| 44824 | 2021 1812 | 2021-12-18 | United States 5 | Bosnia and Herzegovina 248 | 1 | 0 | H | Friendly | Los Angeles | Los Angeles | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.346389 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44824 | ||||
| 44671 | 2021 1813 | 2021-11-12 | United States 5 | Mexico 57 | 2 | 0 | H | FIFA World Cup qualification | Cincinnati | Cincinnati | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.272232 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44671 | ||||
| 44613 | 2021 1813 | 2021-10-13 | United States 5 | Costa Rica 46 | 2 | 1 | H | FIFA World Cup qualification | Columbus | Columbus | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.243759 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44613 | ||||
| 44481 | 2021 1813 | 2021-10-07 | United States 5 | Jamaica 67 | 2 | 0 | H | FIFA World Cup qualification | Austin | Austin | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.179464 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44481 | ||||
| 44398 | 2021 1813 | 2021-09-05 | United States 5 | Canada 6 | 1 | 1 | D | FIFA World Cup qualification | Nashville | Nashville | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.139164 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44398 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 44077 | 2021 1812 | 2021-06-09 | United States 5 | Costa Rica 46 | 4 | 0 | H | Friendly | Sandy | Sandy | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.982711 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44077 | ||||
| 44026 | 2021 1816 | 2021-06-06 | United States 5 | Mexico 57 | 3 | 2 | H | CONCACAF Nations League | Denver | Denver | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.957957 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44026 | ||||
| 43965 | 2021 1816 | 2021-06-03 | United States 5 | Honduras 72 | 1 | 0 | H | CONCACAF Nations League | Denver | Denver | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.874279 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43965 | ||||
| 43770 | 2021 1812 | 2021-03-25 | United States 5 | Jamaica 67 | 4 | 1 | H | Friendly | Wiener Neustadt | Wiener Neustadt | Austria | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.779564 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43770 | ||||
| 43729 | 2021 1812 | 2021-01-31 | United States 5 | Trinidad & Tobago 20 | 7 | 0 | H | Friendly | Orlando | Orlando | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.759669 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43729 | ||||
| 43721 | 2020 1807 | 2020-12-09 | United States 5 | El Salvador 47 | 6 | 0 | H | Friendly | Fort Lauderdale | Fort Lauderdale | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.755804 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43721 | ||||
| 43662 | 2020 1807 | 2020-11-16 | United States 5 | Panama 87 | 6 | 2 | H | Friendly | Wiener Neustadt | Wiener Neustadt | Austria | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.727160 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43662 | ||||
| 43381 | 2020 1807 | 2020-02-01 | United States 5 | Costa Rica 46 | 1 | 0 | H | Friendly | Carson | Carson | United States | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.589967 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43381 | ||||
| 43235 | 2019 1802 | 2019-11-15 | United States 5 | Canada 6 | 4 | 1 | H | CONCACAF Nations League | Orlando | Orlando | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.519004 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43235 | ||||
| 43053 | 2019 1802 | 2019-10-11 | United States 5 | Cuba 77 | 7 | 0 | H | CONCACAF Nations League | Washington, D.C. | Washington, D.C. | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.430425 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43053 | ||||
| 42950 | 2019 1782 | 2019-09-10 | United States 5 | Uruguay 7 | 1 | 1 | D | Friendly | St. Louis | St. Louis | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.325147 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42950 | ||||
| 42871 | 2019 1782 | 2019-09-06 | United States 5 | Mexico 57 | 0 | 3 | A | Friendly | East Rutherford | East Rutherford | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.284901 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42871 | ||||
| 42732 | 2019 1795 | 2019-07-07 | United States 5 | Mexico 57 | 0 | 1 | A | Gold Cup | Chicago | Chicago | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.214057 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42732 | ||||
| 42723 | 2019 1795 | 2019-07-03 | United States 5 | Jamaica 67 | 3 | 1 | H | Gold Cup | Nashville | Nashville | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.209464 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42723 | ||||
| 42711 | 2019 1795 | 2019-06-30 | United States 5 | Curaçao 63 | 1 | 0 | H | Gold Cup | Philadelphia | Philadelphia | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.202898 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42711 | ||||
| 42690 | 2019 1795 | 2019-06-26 | United States 5 | Panama 87 | 1 | 0 | H | Gold Cup | Kansas City | Kansas City | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.192191 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42690 | ||||
| 42665 | 2019 1795 | 2019-06-22 | United States 5 | Trinidad & Tobago 20 | 6 | 0 | H | Gold Cup | Cleveland | Cleveland | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.179386 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42665 | ||||
| 42639 | 2019 1795 | 2019-06-18 | United States 5 | Guyana 19 | 4 | 0 | H | Gold Cup | Saint Paul | Saint Paul | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.166074 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42639 | ||||
| 42551 | 2019 1782 | 2019-06-09 | United States 5 | Venezuela 88 | 0 | 3 | A | Friendly | Cincinnati | Cincinnati | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.121236 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42551 | ||||
| 42481 | 2019 1782 | 2019-06-05 | United States 5 | Jamaica 67 | 0 | 1 | A | Friendly | Washington, D.C. | Washington, D.C. | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.085545 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42481 | ||||
| 42420 | 2019 1782 | 2019-03-26 | United States 5 | Chile 27 | 1 | 1 | D | Friendly | Houston | Houston | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.054451 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42420 | ||||
| 42302 | 2019 1782 | 2019-03-21 | United States 5 | Ecuador 89 | 1 | 0 | H | Friendly | Orlando | Orlando | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.994479 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42302 | ||||
| 42283 | 2019 1782 | 2019-02-02 | United States 5 | Costa Rica 46 | 2 | 0 | H | Friendly | San Jose | San Jose | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.985252 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42283 | ||||
| 42279 | 2019 1782 | 2019-01-27 | United States 5 | Panama 87 | 3 | 0 | H | Friendly | Glendale | Glendale | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.983313 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42279 | ||||
| 42007 | 2018 1765 | 2018-10-16 | United States 5 | Peru 71 | 1 | 1 | D | Friendly | East Hartford | East Hartford | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.850608 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42007 | ||||
| 41895 | 2018 1765 | 2018-10-11 | United States 5 | Colombia 86 | 2 | 4 | A | Friendly | Tampa | Tampa | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.709317 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41895 | ||||
| 41866 | 2018 1765 | 2018-09-11 | United States 5 | Mexico 57 | 1 | 0 | H | Friendly | Nashville | Nashville | United States | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.694589 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41866 | ||||
| 41769 | 2018 1765 | 2018-09-07 | United States 5 | Brazil 34 | 0 | 2 | A | Friendly | East Rutherford | East Rutherford | United States | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.645422 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41769 | ||||
| 41477 | 2018 1765 | 2018-05-28 | United States 5 | Bolivia 70 | 3 | 0 | H | Friendly | Chester | Chester | United States | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.497060 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41477 | ||||
| 41450 | 2018 1765 | 2018-03-27 | United States 5 | Paraguay 37 | 1 | 0 | H | Friendly | Cary | Cary | United States | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.483352 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41450 |
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);