match
171 rows where home_team_id = 52 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49400 | 2026 1937 | 2026-06-26 | New Zealand 52 | Belgium 12 | FIFA World Cup | Vancouver | Vancouver | Canada | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.887272 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49400 | |||||||
| 49376 | 2026 1937 | 2026-06-21 | New Zealand 52 | Egypt 42 | FIFA World Cup | Vancouver | Vancouver | Canada | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.875193 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49376 | |||||||
| 49208 | 2026 1930 | 2026-03-30 | New Zealand 52 | Chile 27 | 4 | 1 | H | FIFA Series | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.790035 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49208 | ||||
| 49169 | 2026 1930 | 2026-03-27 | New Zealand 52 | Finland 29 | 0 | 2 | A | FIFA Series | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.770341 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49169 | ||||
| 48641 | 2025 1919 | 2025-09-09 | New Zealand 52 | Australia 53 | 1 | 3 | A | Soccer Ashes | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.455894 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48641 | ||||
| 48455 | 2025 1913 | 2025-06-10 | New Zealand 52 | Ukraine 74 | 1 | 2 | A | Canadian Shield | Toronto | Toronto | Canada | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.365206 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48455 | ||||
| 48216 | 2025 1907 | 2025-03-24 | New Zealand 52 | New Caledonia 126 | 3 | 0 | H | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.248928 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48216 | ||||
| 48172 | 2025 1907 | 2025-03-21 | New Zealand 52 | Fiji 128 | 7 | 0 | H | FIFA World Cup qualification | Wellington | Wellington | New Zealand | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.227350 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48172 | ||||
| 47983 | 2024 1886 | 2024-11-18 | New Zealand 52 | Samoa 218 | 8 | 0 | H | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.091729 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47983 | ||||
| 47920 | 2024 1886 | 2024-11-15 | New Zealand 52 | Vanuatu 127 | 8 | 1 | H | FIFA World Cup qualification | Hamilton | Hamilton | New Zealand | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:11.061230 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47920 | ||||
| 47778 | 2024 1877 | 2024-10-14 | New Zealand 52 | Malaysia 136 | 4 | 0 | H | Friendly | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.992160 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47778 | ||||
| 47744 | 2024 1886 | 2024-10-11 | New Zealand 52 | Tahiti 132 | 3 | 0 | H | FIFA World Cup qualification | Port Vila | Port Vila | Vanuatu | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.975518 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47744 | ||||
| 47433 | 2024 1891 | 2024-06-27 | New Zealand 52 | Tahiti 132 | 5 | 0 | H | Oceania Nations Cup | Port Vila | Port Vila | Vanuatu | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.823255 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47433 | ||||
| 47390 | 2024 1891 | 2024-06-18 | New Zealand 52 | Solomon Islands 177 | 3 | 0 | H | Oceania Nations Cup | Port Vila | Port Vila | Vanuatu | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.775532 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47390 | ||||
| 47119 | 2024 1882 | 2024-03-26 | New Zealand 52 | Tunisia 152 | 0 | 0 | D | FIFA Series | Cairo | Cairo | Egypt | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.643630 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47119 | ||||
| 45943 | 2023 1856 | 2023-03-26 | New Zealand 52 | China 33 | 2 | 1 | H | Friendly | Wellington | Wellington | New Zealand | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.973801 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45943 | ||||
| 45862 | 2023 1856 | 2023-03-23 | New Zealand 52 | China 33 | 0 | 0 | D | Friendly | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.934463 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45862 | ||||
| 45552 | 2022 1832 | 2022-09-25 | New Zealand 52 | Australia 53 | 0 | 2 | A | Friendly | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.783988 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45552 | ||||
| 45330 | 2022 1832 | 2022-06-09 | New Zealand 52 | Oman 184 | 0 | 0 | D | Friendly | Al Rayyan | Al Rayyan | Qatar | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.675993 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45330 | ||||
| 45048 | 2022 1834 | 2022-03-27 | New Zealand 52 | Tahiti 132 | 1 | 0 | H | FIFA World Cup qualification | Doha | Doha | Qatar | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.538436 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45048 | ||||
| 44984 | 2022 1834 | 2022-03-24 | New Zealand 52 | New Caledonia 126 | 7 | 1 | H | FIFA World Cup qualification | Doha | Doha | Qatar | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.424195 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44984 | ||||
| 44959 | 2022 1834 | 2022-03-21 | New Zealand 52 | Fiji 128 | 4 | 0 | H | FIFA World Cup qualification | Doha | Doha | Qatar | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.412037 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44959 | ||||
| 44734 | 2021 1812 | 2021-11-16 | New Zealand 52 | Gambia 133 | 2 | 0 | H | Friendly | Dubai | Dubai | United Arab Emirates | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.302738 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44734 | ||||
| 41167 | 2017 1747 | 2017-11-11 | New Zealand 52 | Peru 71 | 0 | 0 | D | FIFA World Cup qualification | Wellington | Wellington | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.339283 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41167 | ||||
| 40921 | 2017 1747 | 2017-09-01 | New Zealand 52 | Solomon Islands 177 | 6 | 1 | H | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.161982 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40921 | ||||
| 40765 | 2017 1753 | 2017-06-24 | New Zealand 52 | Portugal 50 | 0 | 4 | A | Confederations Cup | Saint Petersburg | Saint Petersburg | Russia | 1 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.082711 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40765 | ||||
| 40559 | 2017 1747 | 2017-03-28 | New Zealand 52 | Fiji 128 | 2 | 0 | H | FIFA World Cup qualification | Wellington | Wellington | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:06.978100 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40559 | ||||
| 40288 | 2016 1724 | 2016-11-12 | New Zealand 52 | New Caledonia 126 | 2 | 0 | H | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.846332 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40288 | ||||
| 39849 | 2016 1726 | 2016-06-08 | New Zealand 52 | New Caledonia 126 | 1 | 0 | H | Oceania Nations Cup | Port Moresby | Port Moresby | Papua New Guinea | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.577424 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39849 | ||||
| 39788 | 2016 1726 | 2016-06-04 | New Zealand 52 | Solomon Islands 177 | 1 | 0 | H | Oceania Nations Cup | Port Moresby | Port Moresby | Papua New Guinea | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.547594 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39788 | ||||
| 39683 | 2016 1726 | 2016-05-28 | New Zealand 52 | Fiji 128 | 3 | 1 | H | Oceania Nations Cup | Port Moresby | Port Moresby | Papua New Guinea | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.495893 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39683 | ||||
| 37754 | 2014 1675 | 2014-05-30 | New Zealand 52 | South Africa 21 | 0 | 0 | D | Friendly | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.426645 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37754 | ||||
| 37512 | 2013 1655 | 2013-11-20 | New Zealand 52 | Mexico 57 | 2 | 4 | A | FIFA World Cup qualification | Wellington | Wellington | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.308251 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37512 | ||||
| 36806 | 2013 1655 | 2013-03-22 | New Zealand 52 | New Caledonia 126 | 2 | 1 | H | FIFA World Cup qualification | Dunedin | Dunedin | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.882192 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36806 | ||||
| 36386 | 2012 1627 | 2012-10-16 | New Zealand 52 | Tahiti 132 | 3 | 0 | H | FIFA World Cup qualification | Christchurch | Christchurch | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.677891 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36386 | ||||
| 36219 | 2012 1627 | 2012-09-11 | New Zealand 52 | Solomon Islands 177 | 6 | 1 | H | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.596889 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36219 | ||||
| 35919 | 2012 1633 | 2012-06-08 | New Zealand 52 | New Caledonia 126 | 0 | 2 | A | Oceania Nations Cup | Honiara | Honiara | Solomon Islands | 1 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.397818 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35919 | ||||
| 35685 | 2012 1623 | 2012-02-29 | New Zealand 52 | Jamaica 67 | 2 | 3 | A | Friendly | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.283661 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35685 | ||||
| 34252 | 2010 1575 | 2010-10-12 | New Zealand 52 | Paraguay 37 | 0 | 2 | A | Friendly | Wellington | Wellington | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.531670 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34252 | ||||
| 34200 | 2010 1575 | 2010-10-09 | New Zealand 52 | Honduras 72 | 1 | 1 | D | Friendly | North Shore | North Shore | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.506294 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34200 | ||||
| 33877 | 2010 1584 | 2010-06-15 | New Zealand 52 | Slovakia 93 | 1 | 1 | D | FIFA World Cup | Rustenburg | Rustenburg | South Africa | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.264221 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33877 | ||||
| 33801 | 2010 1575 | 2010-05-29 | New Zealand 52 | Serbia 122 | 1 | 0 | H | Friendly | Klagenfurt | Klagenfurt | Austria | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.226212 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33801 | ||||
| 33486 | 2009 1562 | 2009-11-14 | New Zealand 52 | Bahrain 183 | 1 | 0 | H | FIFA World Cup qualification | Wellington | Wellington | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.073246 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33486 | ||||
| 33049 | 2009 1567 | 2009-06-14 | New Zealand 52 | Spain 41 | 0 | 5 | A | Confederations Cup | Rustenburg | Rustenburg | South Africa | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.860396 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33049 | ||||
| 32368 | 2008 1541 | 2008-09-10 | New Zealand 52 | New Caledonia 126 | 3 | 0 | H | Oceania Nations Cup | North Shore | North Shore | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.465194 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32368 | ||||
| 31503 | 2007 1525 | 2007-11-21 | New Zealand 52 | Vanuatu 127 | 4 | 1 | H | Oceania Nations Cup | Wellington | Wellington | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.954077 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31503 | ||||
| 29825 | 2006 1479 | 2006-02-23 | New Zealand 52 | Malaysia 136 | 2 | 1 | H | Friendly | North Shore | North Shore | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.028787 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29825 | ||||
| 29811 | 2006 1479 | 2006-02-19 | New Zealand 52 | Malaysia 136 | 1 | 0 | H | Friendly | Christchurch | Christchurch | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.021977 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29811 | ||||
| 28242 | 2004 1446 | 2004-06-04 | New Zealand 52 | Tahiti 132 | 10 | 0 | H | Oceania Nations Cup | Adelaide | Adelaide | Australia | 1 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.175718 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28242 | ||||
| 28230 | 2004 1446 | 2004-06-02 | New Zealand 52 | Vanuatu 127 | 2 | 4 | A | Oceania Nations Cup | Adelaide | Adelaide | Australia | 1 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.169882 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28230 | ||||
| 28211 | 2004 1446 | 2004-05-31 | New Zealand 52 | Solomon Islands 177 | 3 | 0 | H | Oceania Nations Cup | Adelaide | Adelaide | Australia | 1 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.160606 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28211 | ||||
| 27293 | 2003 1425 | 2003-06-18 | New Zealand 52 | Japan 36 | 0 | 3 | A | Confederations Cup | Saint-Denis | Saint-Denis | France | 1 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.663116 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27293 | ||||
| 26532 | 2002 1401 | 2002-07-14 | New Zealand 52 | Australia 53 | 1 | 0 | H | Oceania Nations Cup | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.238736 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26532 | ||||
| 26530 | 2002 1401 | 2002-07-12 | New Zealand 52 | Vanuatu 127 | 3 | 0 | H | Oceania Nations Cup | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.237764 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26530 | ||||
| 26525 | 2002 1401 | 2002-07-09 | New Zealand 52 | Solomon Islands 177 | 6 | 1 | H | Oceania Nations Cup | North Shore | North Shore | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.235336 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26525 | ||||
| 26520 | 2002 1401 | 2002-07-07 | New Zealand 52 | Papua New Guinea 176 | 9 | 1 | H | Oceania Nations Cup | North Shore | North Shore | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.232905 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26520 | ||||
| 26509 | 2002 1401 | 2002-07-05 | New Zealand 52 | Tahiti 132 | 4 | 0 | H | Oceania Nations Cup | North Shore | North Shore | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:59.227503 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26509 | ||||
| 25717 | 2001 1360 | 2001-06-20 | New Zealand 52 | Australia 53 | 0 | 2 | A | FIFA World Cup qualification | Wellington | Wellington | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.756118 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25717 | ||||
| 25697 | 2001 1360 | 2001-06-13 | New Zealand 52 | Vanuatu 127 | 7 | 0 | H | FIFA World Cup qualification | North Shore | North Shore | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.746422 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25697 | ||||
| 25696 | 2001 1360 | 2001-06-11 | New Zealand 52 | Solomon Islands 177 | 5 | 1 | H | FIFA World Cup qualification | North Shore | North Shore | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.745935 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25696 | ||||
| 25686 | 2001 1360 | 2001-06-08 | New Zealand 52 | Cook Islands 194 | 2 | 0 | H | FIFA World Cup qualification | North Shore | North Shore | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.741092 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25686 | ||||
| 25675 | 2001 1360 | 2001-06-06 | New Zealand 52 | Tahiti 132 | 5 | 0 | H | FIFA World Cup qualification | North Shore | North Shore | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.735771 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25675 | ||||
| 24821 | 2000 1354 | 2000-08-17 | New Zealand 52 | Oman 184 | 1 | 0 | H | Merdeka Tournament | Kuala Lumpur | Kuala Lumpur | Malaysia | 1 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.266592 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24821 | ||||
| 24677 | 2000 1352 | 2000-06-25 | New Zealand 52 | Solomon Islands 177 | 2 | 0 | H | Oceania Nations Cup | Papeete | Papeete | Tahiti | 1 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.193933 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24677 | ||||
| 24660 | 2000 1352 | 2000-06-21 | New Zealand 52 | Vanuatu 127 | 3 | 1 | H | Oceania Nations Cup | Papeete | Papeete | Tahiti | 1 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.185410 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24660 | ||||
| 24085 | 2000 1331 | 2000-01-23 | New Zealand 52 | South Korea 114 | 0 | 0 | D | Friendly | Palmerston North | Palmerston North | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:57.898185 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24085 | ||||
| 24081 | 2000 1331 | 2000-01-21 | New Zealand 52 | South Korea 114 | 0 | 1 | A | Friendly | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:57.896250 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24081 | ||||
| 23761 | 1999 1322 | 1999-07-30 | New Zealand 52 | Brazil 34 | 0 | 2 | A | Confederations Cup | Guadalajara | Guadalajara | Mexico | 1 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:57.657377 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23761 | ||||
| 23740 | 1999 1322 | 1999-07-24 | New Zealand 52 | United States 5 | 1 | 2 | A | Confederations Cup | Guadalajara | Guadalajara | Mexico | 1 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:57.647195 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23740 | ||||
| 23639 | 1999 1318 | 1999-06-19 | New Zealand 52 | Poland 49 | 0 | 0 | D | Four Nations' Cup | Bangkok | Bangkok | Thailand | 1 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:57.598008 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23639 | ||||
| 23104 | 1998 1299 | 1998-10-02 | New Zealand 52 | Fiji 128 | 1 | 0 | H | Oceania Nations Cup | Brisbane | Brisbane | Australia | 1 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.337451 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23104 | ||||
| 23095 | 1998 1299 | 1998-09-28 | New Zealand 52 | Vanuatu 127 | 8 | 1 | H | Oceania Nations Cup | Brisbane | Brisbane | Australia | 1 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.333089 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23095 | ||||
| 23087 | 1998 1299 | 1998-09-25 | New Zealand 52 | Tahiti 132 | 1 | 0 | H | Oceania Nations Cup | Brisbane | Brisbane | Australia | 1 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.329219 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23087 | ||||
| 22586 | 1998 1272 | 1998-02-07 | New Zealand 52 | South Korea 114 | 0 | 1 | A | Friendly | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.024491 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22586 | ||||
| 22573 | 1998 1272 | 1998-02-04 | New Zealand 52 | Chile 27 | 0 | 0 | D | Friendly | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.017808 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22573 | ||||
| 22131 | 1997 1246 | 1997-06-28 | New Zealand 52 | Australia 53 | 0 | 3 | A | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:56.801685 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22131 | ||||
| 22090 | 1997 1246 | 1997-06-18 | New Zealand 52 | Fiji 128 | 5 | 0 | H | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:56.781853 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22090 | ||||
| 22057 | 1997 1246 | 1997-06-11 | New Zealand 52 | Papua New Guinea 176 | 7 | 0 | H | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:56.765850 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22057 | ||||
| 21649 | 1997 1245 | 1997-01-22 | New Zealand 52 | Norway 24 | 0 | 3 | A | Friendly | Brisbane | Brisbane | Australia | 1 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:56.497555 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:21649 | ||||
| 20638 | 1995 1213 | 1995-11-10 | New Zealand 52 | Australia 53 | 0 | 0 | D | Trans-Tasman Cup | Christchurch | Christchurch | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:55.920097 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20638 | ||||
| 20404 | 1995 1191 | 1995-06-20 | New Zealand 52 | Turkey 61 | 1 | 2 | A | Friendly | Coquimbo | Coquimbo | Chile | 1 | 0 | 0 | 2026-06-07 06:58:43 | 2026-06-07 21:03:55.805997 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20404 | ||||
| 20169 | 1995 1191 | 1995-02-21 | New Zealand 52 | Singapore 135 | 3 | 0 | H | Friendly | Tauranga | Tauranga | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:43 | 2026-06-07 21:03:55.691825 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20169 | ||||
| 19080 | 1993 1145 | 1993-05-30 | New Zealand 52 | Australia 53 | 0 | 1 | A | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:43 | 2026-06-07 21:03:55.107255 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:19080 | ||||
| 19054 | 1993 1144 | 1993-05-24 | New Zealand 52 | Fiji 128 | 5 | 0 | H | Friendly | Palmerston North | Palmerston North | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:43 | 2026-06-07 21:03:55.094617 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:19054 | ||||
| 19045 | 1993 1144 | 1993-05-22 | New Zealand 52 | Fiji 128 | 2 | 0 | H | Friendly | Napier | Napier | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:43 | 2026-06-07 21:03:55.090259 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:19045 | ||||
| 18344 | 1992 1125 | 1992-07-01 | New Zealand 52 | Vanuatu 127 | 8 | 0 | H | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:42 | 2026-06-07 21:03:54.693664 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:18344 | ||||
| 18294 | 1992 1125 | 1992-06-07 | New Zealand 52 | Fiji 128 | 3 | 0 | H | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:42 | 2026-06-07 21:03:54.669252 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:18294 | ||||
| 17800 | 1991 1095 | 1991-06-08 | New Zealand 52 | England 2 | 0 | 2 | A | Friendly | Wellington | Wellington | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:42 | 2026-06-07 21:03:54.345818 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:17800 | ||||
| 17789 | 1991 1095 | 1991-06-03 | New Zealand 52 | England 2 | 0 | 1 | A | Friendly | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:42 | 2026-06-07 21:03:54.340490 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:17789 | ||||
| 17738 | 1991 1106 | 1991-05-12 | New Zealand 52 | Australia 53 | 0 | 1 | A | Trans-Tasman Cup | Christchurch | Christchurch | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:42 | 2026-06-07 21:03:54.315723 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:17738 | ||||
| 17422 | 1990 1075 | 1990-08-24 | New Zealand 52 | China 33 | 1 | 0 | H | Friendly | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:42 | 2026-06-07 21:03:54.161570 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:17422 | ||||
| 17402 | 1990 1075 | 1990-08-16 | New Zealand 52 | China 33 | 2 | 1 | H | Friendly | Lower Hutt | Lower Hutt | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:42 | 2026-06-07 21:03:54.151812 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:17402 | ||||
| 16636 | 1989 1054 | 1989-04-09 | New Zealand 52 | Israel 82 | 2 | 2 | D | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:41 | 2026-06-07 21:03:53.719567 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16636 | ||||
| 16625 | 1989 1054 | 1989-04-02 | New Zealand 52 | Australia 53 | 2 | 0 | H | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:41 | 2026-06-07 21:03:53.714197 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16625 | ||||
| 16485 | 1988 1035 | 1988-12-15 | New Zealand 52 | Taiwan 123 | 4 | 1 | H | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:41 | 2026-06-07 21:03:53.645862 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16485 | ||||
| 16476 | 1988 1035 | 1988-12-11 | New Zealand 52 | Taiwan 123 | 4 | 0 | H | FIFA World Cup qualification | Wellington | Wellington | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:41 | 2026-06-07 21:03:53.641478 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16476 | ||||
| 16337 | 1988 1045 | 1988-10-12 | New Zealand 52 | Australia 53 | 1 | 2 | A | Trans-Tasman Cup | Dunedin | Dunedin | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:41 | 2026-06-07 21:03:53.573534 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16337 | ||||
| 15808 | 1987 1012 | 1987-09-09 | New Zealand 52 | Australia 53 | 1 | 0 | H | Trans-Tasman Cup | Lower Hutt | Lower Hutt | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:40 | 2026-06-07 21:03:53.241354 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:15808 | ||||
| 15513 | 1986 995 | 1986-10-25 | New Zealand 52 | Australia 53 | 1 | 1 | D | Trans-Tasman Cup | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:40 | 2026-06-07 21:03:53.097508 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:15513 | ||||
| 15040 | 1985 953 | 1985-10-26 | New Zealand 52 | Israel 82 | 3 | 1 | H | FIFA World Cup qualification | Auckland | Auckland | New Zealand | 0 | 0 | 0 | 2026-06-07 06:58:40 | 2026-06-07 21:03:52.867250 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:15040 |
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);