match
268 rows where home_team_id = 134 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: home_score, away_score, result, round_stage, country, is_neutral, created_at, date (date), created_at (date), updated_at (date)
| match_id | season_id | date ▲ | kickoff | home_team_id | away_team_id | home_score | away_score | result | round_stage | matchday | venue | city | country | referee | attendance | is_neutral | is_postponed | is_cancelled | created_at | updated_at | created_by_run_id | updated_by_run_id | source_id | source_raw_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49324 | 2026 1929 | 2026-06-05 | Hong Kong 134 | Mongolia 100 | 2 | 0 | H | Friendly | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.848868 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49324 | ||||
| 48979 | 2025 1911 | 2025-11-18 | Hong Kong 134 | Singapore 135 | 1 | 2 | A | AFC Asian Cup qualification | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.620288 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48979 | ||||
| 48870 | 2025 1906 | 2025-11-13 | Hong Kong 134 | Cambodia 142 | 1 | 1 | D | Friendly | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.567420 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48870 | ||||
| 48845 | 2025 1911 | 2025-10-14 | Hong Kong 134 | Bangladesh 200 | 1 | 1 | D | AFC Asian Cup qualification | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.555312 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48845 | ||||
| 48413 | 2025 1911 | 2025-06-10 | Hong Kong 134 | India 92 | 1 | 0 | H | AFC Asian Cup qualification | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.344762 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48413 | ||||
| 48325 | 2025 1906 | 2025-06-05 | Hong Kong 134 | Nepal 198 | 0 | 0 | D | Friendly | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.302059 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48325 | ||||
| 48112 | 2025 1906 | 2025-03-19 | Hong Kong 134 | Macau 116 | 2 | 0 | H | Friendly | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.198030 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48112 | ||||
| 48063 | 2024 1900 | 2024-12-17 | Hong Kong 134 | Guam 204 | 5 | 0 | H | EAFF Championship qualification | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.174277 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48063 | ||||
| 48057 | 2024 1900 | 2024-12-14 | Hong Kong 134 | Taiwan 123 | 2 | 1 | H | EAFF Championship qualification | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.171364 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48057 | ||||
| 48044 | 2024 1900 | 2024-12-08 | Hong Kong 134 | Mongolia 100 | 3 | 0 | H | EAFF Championship qualification | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.164988 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48044 | ||||
| 48010 | 2024 1877 | 2024-11-19 | Hong Kong 134 | Mauritius 108 | 1 | 0 | H | Friendly | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.148465 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48010 | ||||
| 47873 | 2024 1877 | 2024-11-14 | Hong Kong 134 | Philippines 32 | 3 | 1 | H | Friendly | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:11.038440 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47873 | ||||
| 47805 | 2024 1877 | 2024-10-15 | Hong Kong 134 | Cambodia 142 | 3 | 0 | H | Friendly | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:11.005298 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47805 | ||||
| 47488 | 2024 1893 | 2024-09-05 | Hong Kong 134 | Solomon Islands 177 | 3 | 0 | H | Tri-Nations Series | Suva | Suva | Fiji | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.850410 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47488 | ||||
| 47235 | 2024 1886 | 2024-06-06 | Hong Kong 134 | Iran 99 | 2 | 4 | A | FIFA World Cup qualification | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.700115 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47235 | ||||
| 47038 | 2024 1886 | 2024-03-21 | Hong Kong 134 | Uzbekistan 242 | 0 | 2 | A | FIFA World Cup qualification | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.604328 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47038 | ||||
| 46960 | 2024 1878 | 2024-01-23 | Hong Kong 134 | Palestine 181 | 0 | 3 | A | AFC Asian Cup | Doha | Doha | Qatar | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.512785 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46960 | ||||
| 46934 | 2024 1878 | 2024-01-19 | Hong Kong 134 | Iran 99 | 0 | 1 | A | AFC Asian Cup | Al Rayyan | Al Rayyan | Qatar | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.500091 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46934 | ||||
| 46807 | 2023 1872 | 2023-11-21 | Hong Kong 134 | Turkmenistan 240 | 2 | 2 | D | FIFA World Cup qualification | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.438294 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46807 | ||||
| 46495 | 2023 1872 | 2023-10-12 | Hong Kong 134 | Bhutan 221 | 4 | 0 | H | FIFA World Cup qualification | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.286507 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46495 | ||||
| 46421 | 2023 1856 | 2023-09-11 | Hong Kong 134 | Brunei 193 | 10 | 0 | H | Friendly | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.250458 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46421 | ||||
| 46140 | 2023 1856 | 2023-06-19 | Hong Kong 134 | Thailand 143 | 0 | 1 | A | Friendly | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.113837 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46140 | ||||
| 45858 | 2023 1856 | 2023-03-23 | Hong Kong 134 | Singapore 135 | 1 | 1 | D | Friendly | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.932518 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45858 | ||||
| 45529 | 2022 1832 | 2022-09-24 | Hong Kong 134 | Myanmar 125 | 0 | 0 | D | Friendly | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.772794 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45529 | ||||
| 45478 | 2022 1832 | 2022-09-21 | Hong Kong 134 | Myanmar 125 | 2 | 0 | H | Friendly | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.748060 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45478 | ||||
| 45289 | 2022 1842 | 2022-06-08 | Hong Kong 134 | Afghanistan 98 | 2 | 1 | H | AFC Asian Cup qualification | Kolkota | Kolkota | India | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.656031 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45289 | ||||
| 44086 | 2021 1813 | 2021-06-11 | Hong Kong 134 | Iraq 164 | 0 | 1 | A | FIFA World Cup qualification | Arad | Arad | Iran | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.987085 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44086 | ||||
| 43372 | 2019 1805 | 2019-12-18 | Hong Kong 134 | China 33 | 0 | 2 | A | EAFF Championship | Busan | Busan | South Korea | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.585615 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43372 | ||||
| 43339 | 2019 1793 | 2019-11-19 | Hong Kong 134 | Cambodia 142 | 2 | 0 | H | FIFA World Cup qualification | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.569570 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43339 | ||||
| 43211 | 2019 1793 | 2019-11-14 | Hong Kong 134 | Bahrain 183 | 0 | 0 | D | FIFA World Cup qualification | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.507282 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43211 | ||||
| 42969 | 2019 1793 | 2019-09-10 | Hong Kong 134 | Iran 99 | 0 | 2 | A | FIFA World Cup qualification | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.334832 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42969 | ||||
| 42585 | 2019 1782 | 2019-06-11 | Hong Kong 134 | Taiwan 123 | 0 | 2 | A | Friendly | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.138540 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42585 | ||||
| 42048 | 2018 1774 | 2018-11-13 | Hong Kong 134 | North Korea 149 | 0 | 0 | D | EAFF Championship | Taipei | Taipei | Taiwan | 1 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.870690 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42048 | ||||
| 41891 | 2018 1765 | 2018-10-11 | Hong Kong 134 | Thailand 143 | 0 | 1 | A | Friendly | Hong Kong | Hong Kong | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.707297 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41891 | ||||
| 41202 | 2017 1749 | 2017-11-14 | Hong Kong 134 | Lebanon 96 | 0 | 1 | A | AFC Asian Cup qualification | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.357095 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41202 | ||||
| 41136 | 2017 1743 | 2017-11-09 | Hong Kong 134 | Bahrain 183 | 0 | 2 | A | Friendly | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.323532 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41136 | ||||
| 41102 | 2017 1749 | 2017-10-10 | Hong Kong 134 | Malaysia 136 | 2 | 0 | H | AFC Asian Cup qualification | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.306240 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41102 | ||||
| 41020 | 2017 1743 | 2017-10-05 | Hong Kong 134 | Laos 167 | 4 | 0 | H | Friendly | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.264781 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41020 | ||||
| 40732 | 2017 1749 | 2017-06-13 | Hong Kong 134 | North Korea 149 | 1 | 1 | D | AFC Asian Cup qualification | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.065982 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40732 | ||||
| 40641 | 2017 1743 | 2017-06-07 | Hong Kong 134 | Jordan 175 | 0 | 0 | D | Friendly | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.019598 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40641 | ||||
| 40281 | 2016 1735 | 2016-11-12 | Hong Kong 134 | North Korea 149 | 0 | 1 | A | EAFF Championship | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.842953 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40281 | ||||
| 40241 | 2016 1735 | 2016-11-09 | Hong Kong 134 | Taiwan 123 | 4 | 2 | H | EAFF Championship | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.823530 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40241 | ||||
| 40229 | 2016 1735 | 2016-11-06 | Hong Kong 134 | Guam 204 | 3 | 2 | H | EAFF Championship | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.817680 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40229 | ||||
| 40195 | 2016 1719 | 2016-10-11 | Hong Kong 134 | Singapore 135 | 2 | 0 | H | Friendly | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.801174 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40195 | ||||
| 39994 | 2016 1719 | 2016-09-01 | Hong Kong 134 | Cambodia 142 | 4 | 2 | H | Friendly | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.649242 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39994 | ||||
| 39379 | 2015 1700 | 2015-11-17 | Hong Kong 134 | China 33 | 0 | 0 | D | FIFA World Cup qualification | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.320539 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39379 | ||||
| 39345 | 2015 1696 | 2015-11-14 | Hong Kong 134 | Macau 116 | 2 | 0 | H | Friendly | Siu Sai Wan | Siu Sai Wan | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.303944 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39345 | ||||
| 39276 | 2015 1696 | 2015-11-07 | Hong Kong 134 | Myanmar 125 | 5 | 0 | H | Friendly | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.270325 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39276 | ||||
| 39101 | 2015 1700 | 2015-09-08 | Hong Kong 134 | Qatar 190 | 2 | 3 | A | FIFA World Cup qualification | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.185326 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39101 | ||||
| 38842 | 2015 1700 | 2015-06-16 | Hong Kong 134 | Maldives 214 | 2 | 0 | H | FIFA World Cup qualification | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.005705 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38842 | ||||
| 38751 | 2015 1700 | 2015-06-11 | Hong Kong 134 | Bhutan 221 | 7 | 0 | H | FIFA World Cup qualification | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.961252 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38751 | ||||
| 38577 | 2015 1696 | 2015-03-28 | Hong Kong 134 | Guam 204 | 1 | 0 | H | Friendly | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.876349 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38577 | ||||
| 38205 | 2014 1675 | 2014-10-14 | Hong Kong 134 | Argentina 8 | 0 | 7 | A | Friendly | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.695742 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38205 | ||||
| 38123 | 2014 1675 | 2014-10-10 | Hong Kong 134 | Singapore 135 | 2 | 1 | H | Friendly | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.655822 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38123 | ||||
| 37489 | 2013 1656 | 2013-11-19 | Hong Kong 134 | Uzbekistan 242 | 0 | 2 | A | AFC Asian Cup qualification | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.297063 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37489 | ||||
| 37385 | 2013 1656 | 2013-10-15 | Hong Kong 134 | United Arab Emirates 196 | 0 | 4 | A | AFC Asian Cup qualification | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.246304 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37385 | ||||
| 37290 | 2013 1650 | 2013-09-10 | Hong Kong 134 | Singapore 135 | 1 | 0 | H | Friendly | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.199982 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37290 | ||||
| 36929 | 2013 1650 | 2013-06-04 | Hong Kong 134 | Philippines 32 | 0 | 1 | A | Friendly | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.942531 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36929 | ||||
| 36793 | 2013 1656 | 2013-03-22 | Hong Kong 134 | Vietnam 115 | 1 | 0 | H | AFC Asian Cup qualification | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.875805 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36793 | ||||
| 36548 | 2012 1638 | 2012-12-09 | Hong Kong 134 | North Korea 149 | 0 | 4 | A | EAFF Championship | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.756586 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36548 | ||||
| 36536 | 2012 1638 | 2012-12-07 | Hong Kong 134 | Taiwan 123 | 2 | 0 | H | EAFF Championship | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.750778 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36536 | ||||
| 36524 | 2012 1638 | 2012-12-03 | Hong Kong 134 | Australia 53 | 0 | 1 | A | EAFF Championship | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.744979 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36524 | ||||
| 36516 | 2012 1638 | 2012-12-01 | Hong Kong 134 | Guam 204 | 2 | 1 | H | EAFF Championship | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.741090 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36516 | ||||
| 36370 | 2012 1623 | 2012-10-16 | Hong Kong 134 | Malaysia 136 | 0 | 3 | A | Friendly | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.670143 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36370 | ||||
| 35954 | 2012 1623 | 2012-06-10 | Hong Kong 134 | Vietnam 115 | 1 | 2 | A | Friendly | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.414798 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35954 | ||||
| 35832 | 2012 1623 | 2012-06-01 | Hong Kong 134 | Singapore 135 | 1 | 0 | H | Friendly | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.355075 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35832 | ||||
| 35668 | 2012 1623 | 2012-02-29 | Hong Kong 134 | Taiwan 123 | 5 | 1 | H | Friendly | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.275321 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35668 | ||||
| 35244 | 2011 1619 | 2011-10-02 | Hong Kong 134 | Macau 116 | 5 | 1 | H | Dragon Cup | Kaohsiung | Kaohsiung | Taiwan | 1 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.069182 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35244 | ||||
| 35240 | 2011 1619 | 2011-09-30 | Hong Kong 134 | Philippines 32 | 3 | 3 | D | Dragon Cup | Kaohsiung | Kaohsiung | Taiwan | 1 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.067232 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35240 | ||||
| 34974 | 2011 1613 | 2011-07-28 | Hong Kong 134 | Saudi Arabia 179 | 0 | 5 | A | FIFA World Cup qualification | Siu Sai Wan | Siu Sai Wan | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.884000 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34974 | ||||
| 34746 | 2011 1599 | 2011-06-03 | Hong Kong 134 | Malaysia 136 | 1 | 1 | D | Friendly | Siu Sai Wan | Siu Sai Wan | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.772565 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34746 | ||||
| 34332 | 2010 1575 | 2010-11-17 | Hong Kong 134 | Paraguay 37 | 0 | 7 | A | Friendly | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.570755 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34332 | ||||
| 33699 | 2010 1576 | 2010-03-03 | Hong Kong 134 | Yemen 182 | 0 | 0 | D | AFC Asian Cup qualification | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.176714 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33699 | ||||
| 33661 | 2010 1579 | 2010-02-14 | Hong Kong 134 | China 33 | 0 | 2 | A | EAFF Championship | Tokyo | Tokyo | Japan | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.158150 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33661 | ||||
| 33521 | 2009 1558 | 2009-11-18 | Hong Kong 134 | Japan 36 | 0 | 4 | A | AFC Asian Cup qualification | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.090287 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33521 | ||||
| 33231 | 2009 1563 | 2009-08-27 | Hong Kong 134 | Guam 204 | 12 | 0 | H | EAFF Championship | Kaohsiung | Kaohsiung | Taiwan | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.948928 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33231 | ||||
| 33227 | 2009 1563 | 2009-08-25 | Hong Kong 134 | North Korea 149 | 0 | 0 | D | EAFF Championship | Kaohsiung | Kaohsiung | Taiwan | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.946982 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33227 | ||||
| 32713 | 2009 1558 | 2009-01-21 | Hong Kong 134 | Bahrain 183 | 1 | 3 | A | AFC Asian Cup qualification | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.638897 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32713 | ||||
| 32698 | 2009 1557 | 2009-01-14 | Hong Kong 134 | India 92 | 2 | 1 | H | Friendly | Victoria | Victoria | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.631391 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32698 | ||||
| 31424 | 2007 1524 | 2007-11-10 | Hong Kong 134 | Turkmenistan 240 | 0 | 0 | D | FIFA World Cup qualification | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.914259 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31424 | ||||
| 31405 | 2007 1524 | 2007-10-28 | Hong Kong 134 | Timor-Leste 267 | 8 | 1 | H | FIFA World Cup qualification | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.904714 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31405 | ||||
| 30988 | 2007 1512 | 2007-06-21 | Hong Kong 134 | Guam 204 | 15 | 1 | H | EAFF Championship | Macau | Macau | Macau | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.651153 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30988 | ||||
| 30981 | 2007 1512 | 2007-06-19 | Hong Kong 134 | Taiwan 123 | 1 | 1 | D | EAFF Championship | Macau | Macau | Macau | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.647619 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30981 | ||||
| 30937 | 2007 1502 | 2007-06-10 | Hong Kong 134 | Macau 116 | 2 | 1 | H | Friendly | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.625245 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30937 | ||||
| 30457 | 2006 1482 | 2006-11-15 | Hong Kong 134 | Bangladesh 200 | 2 | 0 | H | AFC Asian Cup qualification | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.389229 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30457 | ||||
| 30263 | 2006 1482 | 2006-09-06 | Hong Kong 134 | Uzbekistan 242 | 0 | 0 | D | AFC Asian Cup qualification | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.294843 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30263 | ||||
| 30134 | 2006 1479 | 2006-08-12 | Hong Kong 134 | Singapore 135 | 1 | 2 | A | Friendly | Victoria | Victoria | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.232198 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30134 | ||||
| 29815 | 2006 1482 | 2006-02-22 | Hong Kong 134 | Qatar 190 | 0 | 3 | A | AFC Asian Cup qualification | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.023920 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29815 | ||||
| 29807 | 2006 1479 | 2006-02-18 | Hong Kong 134 | India 92 | 2 | 2 | D | Friendly | Victoria | Victoria | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.020033 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29807 | ||||
| 29803 | 2006 1479 | 2006-02-15 | Hong Kong 134 | Singapore 135 | 1 | 1 | D | Friendly | Victoria | Victoria | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.018091 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29803 | ||||
| 29783 | 2006 1481 | 2006-02-01 | Hong Kong 134 | Croatia 95 | 0 | 4 | A | Lunar New Year Cup | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.007883 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29783 | ||||
| 29173 | 2005 1459 | 2005-05-29 | Hong Kong 134 | Macau 116 | 8 | 1 | H | Friendly | Victoria | Victoria | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.711093 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29173 | ||||
| 29050 | 2005 1467 | 2005-03-13 | Hong Kong 134 | North Korea 149 | 0 | 2 | A | EAFF Championship | Taipei | Taipei | Taiwan | 1 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.651058 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29050 | ||||
| 29039 | 2005 1467 | 2005-03-05 | Hong Kong 134 | Mongolia 100 | 6 | 0 | H | EAFF Championship | Taipei | Taipei | Taiwan | 1 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.645730 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29039 | ||||
| 28988 | 2005 1463 | 2005-02-09 | Hong Kong 134 | Brazil 34 | 1 | 7 | A | Lunar New Year Cup | So Kon Po | So Kon Po | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.537590 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28988 | ||||
| 28843 | 2004 1438 | 2004-12-02 | Hong Kong 134 | Myanmar 125 | 2 | 2 | D | Friendly | Singapore | Singapore | Singapore | 1 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.467381 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28843 | ||||
| 28703 | 2004 1443 | 2004-10-13 | Hong Kong 134 | Malaysia 136 | 2 | 0 | H | FIFA World Cup qualification | Kowloon | Kowloon | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.399486 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28703 | ||||
| 28590 | 2004 1443 | 2004-09-08 | Hong Kong 134 | Kuwait 174 | 0 | 2 | A | FIFA World Cup qualification | Siu Sai Wan | Siu Sai Wan | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.344567 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28590 | ||||
| 28041 | 2004 1443 | 2004-03-31 | Hong Kong 134 | China 33 | 0 | 1 | A | FIFA World Cup qualification | Siu Sai Wan | Siu Sai Wan | Hong Kong | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.078339 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28041 | ||||
| 27807 | 2003 1417 | 2003-12-04 | Hong Kong 134 | South Korea 114 | 1 | 3 | A | EAFF Championship | Tokyo | Tokyo | Japan | 1 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.912870 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27807 |
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);