match
155 rows where away_team_id = 246 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: home_score, away_score, result, round_stage, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49290 | 2026 1929 | 2026-06-01 | Turkey 61 | North Macedonia 246 | 4 | 0 | H | Friendly | Istanbul | Istanbul | Turkey | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.831616 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49290 | ||||
| 49266 | 2026 1929 | 2026-05-29 | Bosnia and Herzegovina 248 | North Macedonia 246 | 0 | 0 | D | Friendly | Sarajevo | Sarajevo | Bosnia and Herzegovina | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.819450 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49266 | ||||
| 49239 | 2026 1929 | 2026-03-31 | Republic of Ireland 65 | North Macedonia 246 | 0 | 0 | D | Friendly | Dublin | Dublin | Republic of Ireland | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.805769 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49239 | ||||
| 49136 | 2026 1931 | 2026-03-26 | Denmark 25 | North Macedonia 246 | 4 | 0 | H | FIFA World Cup qualification | Copenhagen | Copenhagen | Denmark | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.753579 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49136 | ||||
| 49003 | 2025 1907 | 2025-11-18 | Wales 3 | North Macedonia 246 | 7 | 1 | H | FIFA World Cup qualification | Cardiff | Cardiff | Wales | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.685788 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49003 | ||||
| 48756 | 2025 1907 | 2025-10-10 | Belgium 12 | North Macedonia 246 | 0 | 0 | D | FIFA World Cup qualification | Gent | Gent | Belgium | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.512161 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48756 | ||||
| 48530 | 2025 1906 | 2025-09-04 | Saudi Arabia 179 | North Macedonia 246 | 2 | 1 | H | Friendly | Prague | Prague | Czech Republic | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.401709 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48530 | ||||
| 48404 | 2025 1907 | 2025-06-09 | Kazakhstan 212 | North Macedonia 246 | 0 | 1 | A | FIFA World Cup qualification | Astana | Astana | Kazakhstan | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.340394 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48404 | ||||
| 48196 | 2025 1907 | 2025-03-22 | Liechtenstein 220 | North Macedonia 246 | 0 | 3 | A | FIFA World Cup qualification | Vaduz | Vaduz | Liechtenstein | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.239117 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48196 | ||||
| 47775 | 2024 1884 | 2024-10-13 | Armenia 209 | North Macedonia 246 | 0 | 2 | A | UEFA Nations League | Yerevan | Yerevan | Armenia | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.990691 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47775 | ||||
| 47692 | 2024 1884 | 2024-10-10 | Latvia 54 | North Macedonia 246 | 0 | 3 | A | UEFA Nations League | Riga | Riga | Latvia | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.950217 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47692 | ||||
| 47573 | 2024 1884 | 2024-09-07 | Faroe Islands 197 | North Macedonia 246 | 1 | 1 | D | UEFA Nations League | Toftir | Toftir | Faroe Islands | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.892036 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47573 | ||||
| 47308 | 2024 1877 | 2024-06-10 | Czech Republic 247 | North Macedonia 246 | 2 | 1 | H | Friendly | Hradec Králové | Hradec Králové | Czech Republic | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.735536 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47308 | ||||
| 47186 | 2024 1877 | 2024-06-03 | Croatia 95 | North Macedonia 246 | 3 | 0 | H | Friendly | Rijeka | Rijeka | Croatia | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.676294 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47186 | ||||
| 47115 | 2024 1877 | 2024-03-25 | Montenegro 106 | North Macedonia 246 | 1 | 0 | H | Friendly | Antalya | Antalya | Turkey | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.641680 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47115 | ||||
| 46722 | 2023 1859 | 2023-11-17 | Italy 26 | North Macedonia 246 | 5 | 2 | H | UEFA Euro qualification | Rome | Rome | Italy | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.396725 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46722 | ||||
| 46553 | 2023 1859 | 2023-10-14 | Ukraine 74 | North Macedonia 246 | 2 | 0 | H | UEFA Euro qualification | Prague | Prague | Czech Republic | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.314730 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46553 | ||||
| 46468 | 2023 1859 | 2023-09-12 | Malta 151 | North Macedonia 246 | 0 | 2 | A | UEFA Euro qualification | Ta' Qali | Ta' Qali | Malta | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.273364 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46468 | ||||
| 46148 | 2023 1859 | 2023-06-19 | England 2 | North Macedonia 246 | 7 | 0 | H | UEFA Euro qualification | Manchester | Manchester | England | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.117717 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46148 | ||||
| 45617 | 2022 1832 | 2022-10-22 | Saudi Arabia 179 | North Macedonia 246 | 1 | 0 | H | Friendly | Abu Dhabi | Abu Dhabi | United Arab Emirates | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.815631 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45617 | ||||
| 45522 | 2022 1836 | 2022-09-23 | Georgia 210 | North Macedonia 246 | 2 | 0 | H | UEFA Nations League | Tbilisi | Tbilisi | Georgia | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.769387 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45522 | ||||
| 45243 | 2022 1836 | 2022-06-05 | Gibraltar 244 | North Macedonia 246 | 0 | 2 | A | UEFA Nations League | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.633567 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45243 | ||||
| 45180 | 2022 1836 | 2022-06-02 | Bulgaria 64 | North Macedonia 246 | 1 | 1 | D | UEFA Nations League | Razgrad | Razgrad | Bulgaria | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.602769 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45180 | ||||
| 45082 | 2022 1834 | 2022-03-29 | Portugal 50 | North Macedonia 246 | 2 | 0 | H | FIFA World Cup qualification | Porto | Porto | Portugal | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.555045 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45082 | ||||
| 44989 | 2022 1834 | 2022-03-24 | Italy 26 | North Macedonia 246 | 0 | 1 | A | FIFA World Cup qualification | Palermo | Palermo | Italy | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.426635 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44989 | ||||
| 44656 | 2021 1813 | 2021-11-11 | Armenia 209 | North Macedonia 246 | 0 | 5 | A | FIFA World Cup qualification | Yerevan | Yerevan | Armenia | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.264979 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44656 | ||||
| 44511 | 2021 1813 | 2021-10-08 | Liechtenstein 220 | North Macedonia 246 | 0 | 4 | A | FIFA World Cup qualification | Vaduz | Vaduz | Liechtenstein | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.194079 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44511 | ||||
| 44388 | 2021 1813 | 2021-09-05 | Iceland 104 | North Macedonia 246 | 2 | 2 | D | FIFA World Cup qualification | Reykjavík | Reykjavík | Iceland | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.134353 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44388 | ||||
| 44170 | 2021 1818 | 2021-06-21 | Netherlands 18 | North Macedonia 246 | 3 | 0 | H | UEFA Euro | Amsterdam | Amsterdam | Netherlands | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.028407 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44170 | ||||
| 44149 | 2021 1818 | 2021-06-17 | Ukraine 74 | North Macedonia 246 | 2 | 1 | H | UEFA Euro | Bucharest | Bucharest | Romania | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.018121 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44149 | ||||
| 44112 | 2021 1818 | 2021-06-13 | Austria 9 | North Macedonia 246 | 3 | 1 | H | UEFA Euro | Bucharest | Bucharest | Romania | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.999791 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44112 | ||||
| 43916 | 2021 1813 | 2021-03-31 | Germany 22 | North Macedonia 246 | 1 | 2 | A | FIFA World Cup qualification | Duisburg | Duisburg | Germany | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.850509 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43916 | ||||
| 43789 | 2021 1813 | 2021-03-25 | Romania 38 | North Macedonia 246 | 3 | 2 | H | FIFA World Cup qualification | Bucharest | Bucharest | Romania | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.788735 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43789 | ||||
| 43714 | 2020 1808 | 2020-11-18 | Armenia 209 | North Macedonia 246 | 1 | 0 | H | UEFA Nations League | Nicosia | Nicosia | Cyprus | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.752418 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43714 | ||||
| 43589 | 2020 1810 | 2020-11-12 | Georgia 210 | North Macedonia 246 | 0 | 1 | A | UEFA Euro qualification | Tbilisi | Tbilisi | Georgia | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.691153 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43589 | ||||
| 43507 | 2020 1808 | 2020-10-11 | Estonia 43 | North Macedonia 246 | 3 | 3 | D | UEFA Nations League | Tallinn | Tallinn | Estonia | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.651289 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43507 | ||||
| 43434 | 2020 1808 | 2020-09-08 | Georgia 210 | North Macedonia 246 | 1 | 1 | D | UEFA Nations League | Tbilisi | Tbilisi | Georgia | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.615692 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43434 | ||||
| 43250 | 2019 1784 | 2019-11-16 | Austria 9 | North Macedonia 246 | 2 | 1 | H | UEFA Euro qualification | Vienna | Vienna | Austria | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.526292 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43250 | ||||
| 43080 | 2019 1784 | 2019-10-13 | Poland 49 | North Macedonia 246 | 2 | 0 | H | UEFA Euro qualification | Warsaw | Warsaw | Poland | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.443588 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43080 | ||||
| 42931 | 2019 1784 | 2019-09-09 | Latvia 54 | North Macedonia 246 | 0 | 2 | A | UEFA Euro qualification | Riga | Riga | Latvia | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.315507 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42931 | ||||
| 42835 | 2019 1784 | 2019-09-05 | Israel 82 | North Macedonia 246 | 1 | 1 | D | UEFA Euro qualification | Beer Sheva | Beer Sheva | Israel | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.266507 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42835 | ||||
| 42374 | 2019 1784 | 2019-03-24 | Slovenia 238 | North Macedonia 246 | 1 | 1 | D | UEFA Euro qualification | Ljubljana | Ljubljana | Slovenia | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.030978 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42374 | ||||
| 42074 | 2018 1776 | 2018-11-16 | Liechtenstein 220 | North Macedonia 246 | 0 | 2 | A | UEFA Nations League | Vaduz | Vaduz | Liechtenstein | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.883336 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42074 | ||||
| 41989 | 2018 1776 | 2018-10-16 | Armenia 209 | North Macedonia 246 | 4 | 0 | H | UEFA Nations League | Yerevan | Yerevan | Armenia | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.757367 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41989 | ||||
| 41739 | 2018 1776 | 2018-09-06 | Gibraltar 244 | North Macedonia 246 | 0 | 2 | A | UEFA Nations League | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.630238 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41739 | ||||
| 41407 | 2018 1765 | 2018-03-27 | Azerbaijan 211 | North Macedonia 246 | 1 | 1 | D | Friendly | Antalya | Antalya | Turkey | 1 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.461462 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41407 | ||||
| 41345 | 2018 1765 | 2018-03-23 | Finland 29 | North Macedonia 246 | 0 | 0 | D | Friendly | Belek | Belek | Turkey | 1 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.429960 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41345 | ||||
| 41037 | 2017 1747 | 2017-10-06 | Italy 26 | North Macedonia 246 | 1 | 1 | D | FIFA World Cup qualification | Turin | Turin | Italy | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.273387 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41037 | ||||
| 40937 | 2017 1747 | 2017-09-02 | Israel 82 | North Macedonia 246 | 0 | 1 | A | FIFA World Cup qualification | Haifa | Haifa | Israel | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.170097 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40937 | ||||
| 40487 | 2017 1747 | 2017-03-24 | Liechtenstein 220 | North Macedonia 246 | 0 | 3 | A | FIFA World Cup qualification | Vaduz | Vaduz | Liechtenstein | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:06.943064 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40487 | ||||
| 40290 | 2016 1724 | 2016-11-12 | Spain 41 | North Macedonia 246 | 4 | 0 | H | FIFA World Cup qualification | Granada | Granada | Spain | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.847296 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40290 | ||||
| 40048 | 2016 1724 | 2016-09-05 | Albania 105 | North Macedonia 246 | 2 | 1 | H | FIFA World Cup qualification | Shkodër | Shkodër | Albania | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.729522 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40048 | ||||
| 39688 | 2016 1719 | 2016-05-29 | Azerbaijan 211 | North Macedonia 246 | 1 | 3 | A | Friendly | Bad Erlach | Bad Erlach | Austria | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.498383 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39688 | ||||
| 39492 | 2016 1719 | 2016-03-23 | Slovenia 238 | North Macedonia 246 | 1 | 0 | H | Friendly | Koper | Koper | Slovenia | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.375485 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39492 | ||||
| 39218 | 2015 1702 | 2015-10-12 | Belarus 73 | North Macedonia 246 | 0 | 0 | D | UEFA Euro qualification | Barysaw | Barysaw | Belarus | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.242152 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39218 | ||||
| 39046 | 2015 1702 | 2015-09-05 | Luxembourg 30 | North Macedonia 246 | 1 | 0 | H | UEFA Euro qualification | Luxembourg | Luxembourg | Luxembourg | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.158574 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39046 | ||||
| 38821 | 2015 1702 | 2015-06-14 | Slovakia 93 | North Macedonia 246 | 2 | 1 | H | UEFA Euro qualification | Žilina | Žilina | Slovakia | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:05.995429 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38821 | ||||
| 38182 | 2014 1690 | 2014-10-12 | Ukraine 74 | North Macedonia 246 | 1 | 0 | H | UEFA Euro qualification | Lviv | Lviv | Ukraine | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.684560 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38182 | ||||
| 38061 | 2014 1690 | 2014-09-08 | Spain 41 | North Macedonia 246 | 5 | 1 | H | UEFA Euro qualification | Valencia | Valencia | Spain | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.625725 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38061 | ||||
| 37893 | 2014 1675 | 2014-06-22 | China 33 | North Macedonia 246 | 0 | 0 | D | Friendly | Jinan | Jinan | China | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.494259 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37893 | ||||
| 37880 | 2014 1675 | 2014-06-18 | China 33 | North Macedonia 246 | 2 | 0 | H | Friendly | Shenyang | Shenyang | China | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.487947 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37880 | ||||
| 37410 | 2013 1655 | 2013-10-15 | Serbia 122 | North Macedonia 246 | 5 | 1 | H | FIFA World Cup qualification | Jagodina | Jagodina | Serbia | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.258559 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37410 | ||||
| 37361 | 2013 1655 | 2013-10-11 | Wales 3 | North Macedonia 246 | 1 | 0 | H | FIFA World Cup qualification | Cardiff | Cardiff | Wales | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.234601 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37361 | ||||
| 37009 | 2013 1650 | 2013-06-11 | Norway 24 | North Macedonia 246 | 2 | 0 | H | Friendly | Oslo | Oslo | Norway | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:05.062771 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37009 | ||||
| 36926 | 2013 1650 | 2013-06-03 | Sweden 23 | North Macedonia 246 | 1 | 0 | H | Friendly | Malmö | Malmö | Sweden | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.941070 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36926 | ||||
| 36851 | 2013 1655 | 2013-03-26 | Belgium 12 | North Macedonia 246 | 1 | 0 | H | FIFA World Cup qualification | Brussels | Brussels | Belgium | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.904115 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36851 | ||||
| 36229 | 2012 1627 | 2012-09-11 | Scotland 1 | North Macedonia 246 | 1 | 1 | D | FIFA World Cup qualification | Glasgow | Glasgow | Scotland | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.601752 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36229 | ||||
| 36136 | 2012 1627 | 2012-09-07 | Croatia 95 | North Macedonia 246 | 1 | 0 | H | FIFA World Cup qualification | Zagreb | Zagreb | Croatia | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.556583 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36136 | ||||
| 35812 | 2012 1623 | 2012-05-29 | Angola 205 | North Macedonia 246 | 0 | 0 | D | Friendly | Cascais | Cascais | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.345316 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35812 | ||||
| 35797 | 2012 1623 | 2012-05-26 | Portugal 50 | North Macedonia 246 | 0 | 0 | D | Friendly | Leiria | Leiria | Portugal | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.338045 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35797 | ||||
| 35679 | 2012 1623 | 2012-02-29 | Luxembourg 30 | North Macedonia 246 | 2 | 1 | H | Friendly | Luxembourg | Luxembourg | Luxembourg | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.280744 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35679 | ||||
| 35254 | 2011 1607 | 2011-10-07 | Armenia 209 | North Macedonia 246 | 4 | 1 | H | UEFA Euro qualification | Yerevan | Yerevan | Armenia | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.074011 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35254 | ||||
| 35127 | 2011 1607 | 2011-09-02 | Russia 28 | North Macedonia 246 | 1 | 0 | H | UEFA Euro qualification | Moscow | Moscow | Russia | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.012055 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35127 | ||||
| 35001 | 2011 1599 | 2011-08-10 | Azerbaijan 211 | North Macedonia 246 | 0 | 1 | A | Friendly | Baku | Baku | Azerbaijan | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.950572 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35001 | ||||
| 34630 | 2011 1607 | 2011-03-26 | Republic of Ireland 65 | North Macedonia 246 | 2 | 1 | H | UEFA Euro qualification | Dublin | Dublin | Republic of Ireland | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.715970 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34630 | ||||
| 34436 | 2010 1575 | 2010-12-22 | China 33 | North Macedonia 246 | 1 | 0 | H | Friendly | Guangzhou | Guangzhou | China | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.621424 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34436 | ||||
| 34314 | 2010 1575 | 2010-11-17 | Albania 105 | North Macedonia 246 | 0 | 0 | D | Friendly | Korçë | Korçë | Albania | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.561935 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34314 | ||||
| 34156 | 2010 1587 | 2010-10-08 | Andorra 250 | North Macedonia 246 | 0 | 2 | A | UEFA Euro qualification | Sant Julià de Lòria | Sant Julià de Lòria | Andorra | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.484756 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34156 | ||||
| 34029 | 2010 1587 | 2010-09-03 | Slovakia 93 | North Macedonia 246 | 1 | 0 | H | UEFA Euro qualification | Bratislava | Bratislava | Slovakia | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.422649 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34029 | ||||
| 33970 | 2010 1575 | 2010-08-11 | Malta 151 | North Macedonia 246 | 1 | 1 | D | Friendly | Attard | Attard | Malta | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.309662 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33970 | ||||
| 33833 | 2010 1575 | 2010-06-02 | Romania 38 | North Macedonia 246 | 0 | 1 | A | Friendly | Villach | Villach | Austria | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.242211 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33833 | ||||
| 33797 | 2010 1575 | 2010-05-29 | Azerbaijan 211 | North Macedonia 246 | 1 | 3 | A | Friendly | Bischofshofen | Bischofshofen | Austria | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.224279 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33797 | ||||
| 33523 | 2009 1557 | 2009-11-18 | Iran 99 | North Macedonia 246 | 1 | 1 | D | Friendly | Tehran | Tehran | Iran | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.091265 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33523 | ||||
| 33315 | 2009 1562 | 2009-09-09 | Norway 24 | North Macedonia 246 | 2 | 1 | H | FIFA World Cup qualification | Oslo | Oslo | Norway | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.989981 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33315 | ||||
| 33273 | 2009 1562 | 2009-09-05 | Scotland 1 | North Macedonia 246 | 2 | 0 | H | FIFA World Cup qualification | Glasgow | Glasgow | Scotland | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.969335 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33273 | ||||
| 32903 | 2009 1562 | 2009-04-01 | Netherlands 18 | North Macedonia 246 | 4 | 0 | H | FIFA World Cup qualification | Amsterdam | Amsterdam | Netherlands | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.734637 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32903 | ||||
| 32587 | 2008 1529 | 2008-11-19 | Montenegro 106 | North Macedonia 246 | 2 | 1 | H | Friendly | Podgorica | Podgorica | Montenegro | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.575429 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32587 | ||||
| 32497 | 2008 1532 | 2008-10-15 | Iceland 104 | North Macedonia 246 | 1 | 0 | H | FIFA World Cup qualification | Reykjavík | Reykjavík | Iceland | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.530048 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32497 | ||||
| 32234 | 2008 1529 | 2008-08-20 | Luxembourg 30 | North Macedonia 246 | 1 | 4 | A | Friendly | Luxembourg | Luxembourg | Luxembourg | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.397788 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32234 | ||||
| 31737 | 2008 1529 | 2008-03-26 | Bosnia and Herzegovina 248 | North Macedonia 246 | 2 | 2 | D | Friendly | Zenica | Zenica | Bosnia and Herzegovina | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.072679 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31737 | ||||
| 31497 | 2007 1508 | 2007-11-21 | Israel 82 | North Macedonia 246 | 1 | 0 | H | UEFA Euro qualification | Ramat Gan | Ramat Gan | Israel | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.951060 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31497 | ||||
| 31236 | 2007 1508 | 2007-09-08 | Russia 28 | North Macedonia 246 | 3 | 0 | H | UEFA Euro qualification | Moscow | Moscow | Russia | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.819622 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31236 | ||||
| 30714 | 2007 1508 | 2007-03-24 | Croatia 95 | North Macedonia 246 | 2 | 1 | H | UEFA Euro qualification | Zagreb | Zagreb | Croatia | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.514115 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30714 | ||||
| 30648 | 2007 1502 | 2007-02-07 | Albania 105 | North Macedonia 246 | 0 | 1 | A | Friendly | Shkodër | Shkodër | Albania | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.481989 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30648 | ||||
| 30381 | 2006 1491 | 2006-10-11 | Andorra 250 | North Macedonia 246 | 0 | 3 | A | UEFA Euro qualification | Sant Julià de Lòria | Sant Julià de Lòria | Andorra | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.352354 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30381 | ||||
| 30340 | 2006 1491 | 2006-10-07 | England 2 | North Macedonia 246 | 0 | 0 | D | UEFA Euro qualification | Manchester | Manchester | England | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.332383 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30340 | ||||
| 30156 | 2006 1491 | 2006-08-16 | Estonia 43 | North Macedonia 246 | 0 | 1 | A | UEFA Euro qualification | Tallinn | Tallinn | Estonia | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.242856 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30156 | ||||
| 30031 | 2006 1479 | 2006-06-04 | Turkey 61 | North Macedonia 246 | 0 | 1 | A | Friendly | Krefeld | Krefeld | Germany | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.182564 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30031 | ||||
| 29621 | 2005 1459 | 2005-11-12 | Liechtenstein 220 | North Macedonia 246 | 1 | 2 | A | Friendly | Vaduz | Vaduz | Liechtenstein | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:00.928865 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29621 | ||||
| 29589 | 2005 1462 | 2005-10-12 | Netherlands 18 | North Macedonia 246 | 0 | 0 | D | FIFA World Cup qualification | Amsterdam | Amsterdam | Netherlands | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.913291 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29589 |
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);