match
410 rows where away_team_id = 64 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: home_score, away_score, result, round_stage, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49327 | 2026 1929 | 2026-06-05 | Moldova 146 | Bulgaria 64 | 2 | 2 | D | Friendly | Chișinău | Chișinău | Moldova | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.850386 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49327 | ||||
| 49206 | 2026 1930 | 2026-03-30 | Indonesia 83 | Bulgaria 64 | 0 | 1 | A | FIFA Series | Jakarta | Jakarta | Indonesia | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.789020 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49206 | ||||
| 49166 | 2026 1930 | 2026-03-27 | Solomon Islands 177 | Bulgaria 64 | 2 | 10 | A | FIFA Series | Jakarta | Jakarta | Indonesia | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.768817 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49166 | ||||
| 48925 | 2025 1907 | 2025-11-15 | Turkey 61 | Bulgaria 64 | 2 | 0 | H | FIFA World Cup qualification | Bursa | Bursa | Turkey | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.594085 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48925 | ||||
| 48832 | 2025 1907 | 2025-10-14 | Spain 41 | Bulgaria 64 | 4 | 0 | H | FIFA World Cup qualification | Valladolid | Valladolid | Spain | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.549032 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48832 | ||||
| 48604 | 2025 1907 | 2025-09-07 | Georgia 210 | Bulgaria 64 | 3 | 0 | H | FIFA World Cup qualification | Tbilisi | Tbilisi | Georgia | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.437866 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48604 | ||||
| 48425 | 2025 1906 | 2025-06-10 | Greece 39 | Bulgaria 64 | 4 | 0 | H | Friendly | Heraklion | Heraklion | Greece | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.350602 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48425 | ||||
| 48212 | 2025 1909 | 2025-03-23 | Republic of Ireland 65 | Bulgaria 64 | 2 | 1 | H | UEFA Nations League | Dublin | Dublin | Republic of Ireland | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.246946 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48212 | ||||
| 47907 | 2024 1884 | 2024-11-15 | Luxembourg 30 | Bulgaria 64 | 0 | 1 | A | UEFA Nations League | Luxembourg | Luxembourg | Luxembourg | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:11.054924 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47907 | ||||
| 47837 | 2024 1884 | 2024-10-15 | Northern Ireland 4 | Bulgaria 64 | 5 | 0 | H | UEFA Nations League | Belfast | Belfast | Northern Ireland | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:11.020940 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47837 | ||||
| 47512 | 2024 1884 | 2024-09-05 | Belarus 73 | Bulgaria 64 | 0 | 0 | D | UEFA Nations League | Zalaegerszeg | Zalaegerszeg | Hungary | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.862162 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47512 | ||||
| 47279 | 2024 1877 | 2024-06-08 | Slovenia 238 | Bulgaria 64 | 1 | 1 | D | Friendly | Ljubljana | Ljubljana | Slovenia | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.721420 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47279 | ||||
| 47194 | 2024 1877 | 2024-06-04 | Romania 38 | Bulgaria 64 | 0 | 0 | D | Friendly | Bucharest | Bucharest | Romania | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.680165 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47194 | ||||
| 47106 | 2024 1882 | 2024-03-25 | Azerbaijan 211 | Bulgaria 64 | 1 | 1 | D | FIFA Series | Baku | Baku | Azerbaijan | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.637278 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47106 | ||||
| 46759 | 2023 1859 | 2023-11-19 | Serbia 122 | Bulgaria 64 | 2 | 2 | D | UEFA Euro qualification | Leskovac | Leskovac | Serbia | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.414769 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46759 | ||||
| 46617 | 2023 1856 | 2023-10-17 | Albania 105 | Bulgaria 64 | 2 | 0 | H | Friendly | Tirana | Tirana | Albania | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.345771 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46617 | ||||
| 46409 | 2023 1859 | 2023-09-10 | Montenegro 106 | Bulgaria 64 | 2 | 1 | H | UEFA Euro qualification | Podgorica | Podgorica | Montenegro | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.244649 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46409 | ||||
| 46106 | 2023 1859 | 2023-06-17 | Lithuania 60 | Bulgaria 64 | 1 | 1 | D | UEFA Euro qualification | Kaunas | Kaunas | Lithuania | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.097273 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46106 | ||||
| 45976 | 2023 1859 | 2023-03-27 | Hungary 10 | Bulgaria 64 | 3 | 0 | H | UEFA Euro qualification | Budapest | Budapest | Hungary | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.989760 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45976 | ||||
| 45703 | 2022 1832 | 2022-11-20 | Luxembourg 30 | Bulgaria 64 | 0 | 0 | D | Friendly | Luxembourg | Luxembourg | Luxembourg | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.857430 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45703 | ||||
| 45641 | 2022 1832 | 2022-11-16 | Cyprus 118 | Bulgaria 64 | 0 | 2 | A | Friendly | Larnaca | Larnaca | Cyprus | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.827282 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45641 | ||||
| 45572 | 2022 1836 | 2022-09-26 | North Macedonia 246 | Bulgaria 64 | 0 | 1 | A | UEFA Nations League | Skopje | Skopje | North Macedonia | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.793666 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45572 | ||||
| 45389 | 2022 1836 | 2022-06-12 | Georgia 210 | Bulgaria 64 | 0 | 0 | D | UEFA Nations League | Tbilisi | Tbilisi | Georgia | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.704606 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45389 | ||||
| 45327 | 2022 1836 | 2022-06-09 | Gibraltar 244 | Bulgaria 64 | 1 | 1 | D | UEFA Nations League | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.674544 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45327 | ||||
| 45092 | 2022 1832 | 2022-03-29 | Croatia 95 | Bulgaria 64 | 2 | 1 | H | Friendly | Al Rayyan | Al Rayyan | Qatar | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.559890 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45092 | ||||
| 45040 | 2022 1832 | 2022-03-26 | Qatar 190 | Bulgaria 64 | 2 | 1 | H | Friendly | Al Rayyan | Al Rayyan | Qatar | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.534485 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45040 | ||||
| 44724 | 2021 1813 | 2021-11-15 | Switzerland 14 | Bulgaria 64 | 4 | 0 | H | FIFA World Cup qualification | Lucerne | Lucerne | Switzerland | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.297851 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44724 | ||||
| 44633 | 2021 1812 | 2021-11-11 | Ukraine 74 | Bulgaria 64 | 1 | 1 | D | Friendly | Odessa | Odessa | Ukraine | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.253455 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44633 | ||||
| 44522 | 2021 1813 | 2021-10-09 | Lithuania 60 | Bulgaria 64 | 3 | 1 | H | FIFA World Cup qualification | Vilnius | Vilnius | Lithuania | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.199516 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44522 | ||||
| 44329 | 2021 1813 | 2021-09-02 | Italy 26 | Bulgaria 64 | 1 | 1 | D | FIFA World Cup qualification | Florence | Florence | Italy | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.105696 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44329 | ||||
| 44049 | 2021 1812 | 2021-06-08 | France 13 | Bulgaria 64 | 3 | 0 | H | Friendly | Paris | Paris | France | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.969094 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44049 | ||||
| 44002 | 2021 1812 | 2021-06-05 | Russia 28 | Bulgaria 64 | 1 | 0 | H | Friendly | Moscow | Moscow | Russia | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.946286 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44002 | ||||
| 43942 | 2021 1812 | 2021-06-01 | Slovakia 93 | Bulgaria 64 | 1 | 1 | D | Friendly | Ried im Innkreis | Ried im Innkreis | Austria | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.863104 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43942 | ||||
| 43905 | 2021 1813 | 2021-03-31 | Northern Ireland 4 | Bulgaria 64 | 0 | 0 | D | FIFA World Cup qualification | Belfast | Belfast | Northern Ireland | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.845177 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43905 | ||||
| 43712 | 2020 1808 | 2020-11-18 | Republic of Ireland 65 | Bulgaria 64 | 0 | 0 | D | UEFA Nations League | Dublin | Dublin | Republic of Ireland | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.751449 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43712 | ||||
| 43505 | 2020 1808 | 2020-10-11 | Finland 29 | Bulgaria 64 | 2 | 0 | H | UEFA Nations League | Helsinki | Helsinki | Finland | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.650319 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43505 | ||||
| 43413 | 2020 1808 | 2020-09-06 | Wales 3 | Bulgaria 64 | 1 | 0 | H | UEFA Nations League | Cardiff | Cardiff | Wales | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.605435 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43413 | ||||
| 43045 | 2019 1784 | 2019-10-11 | Montenegro 106 | Bulgaria 64 | 0 | 0 | D | UEFA Euro qualification | Podgorica | Podgorica | Montenegro | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.426553 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43045 | ||||
| 42948 | 2019 1782 | 2019-09-10 | Republic of Ireland 65 | Bulgaria 64 | 3 | 1 | H | Friendly | Dublin | Dublin | Republic of Ireland | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.324125 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42948 | ||||
| 42890 | 2019 1784 | 2019-09-07 | England 2 | Bulgaria 64 | 4 | 0 | H | UEFA Euro qualification | London | London | England | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.294601 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42890 | ||||
| 42499 | 2019 1784 | 2019-06-07 | Czech Republic 247 | Bulgaria 64 | 2 | 1 | H | UEFA Euro qualification | Prague | Prague | Czech Republic | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.094690 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42499 | ||||
| 42397 | 2019 1784 | 2019-03-25 | Kosovo 274 | Bulgaria 64 | 1 | 1 | D | UEFA Euro qualification | Pristina | Pristina | Kosovo | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.042727 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42397 | ||||
| 42072 | 2018 1776 | 2018-11-16 | Cyprus 118 | Bulgaria 64 | 1 | 1 | D | UEFA Nations League | Nicosia | Nicosia | Cyprus | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.882369 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42072 | ||||
| 41985 | 2018 1776 | 2018-10-16 | Norway 24 | Bulgaria 64 | 1 | 0 | H | UEFA Nations League | Oslo | Oslo | Norway | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.755350 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41985 | ||||
| 41735 | 2018 1776 | 2018-09-06 | Slovenia 238 | Bulgaria 64 | 1 | 2 | A | UEFA Nations League | Ljubljana | Ljubljana | Slovenia | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.628226 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41735 | ||||
| 41108 | 2017 1747 | 2017-10-10 | Luxembourg 30 | Bulgaria 64 | 1 | 1 | D | FIFA World Cup qualification | Luxembourg | Luxembourg | Luxembourg | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.309288 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41108 | ||||
| 40954 | 2017 1747 | 2017-09-03 | Netherlands 18 | Bulgaria 64 | 3 | 1 | H | FIFA World Cup qualification | Amsterdam | Amsterdam | Netherlands | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.179042 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40954 | ||||
| 40660 | 2017 1747 | 2017-06-09 | Belarus 73 | Bulgaria 64 | 2 | 1 | H | FIFA World Cup qualification | Barysaw | Barysaw | Belarus | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.029355 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40660 | ||||
| 40186 | 2016 1724 | 2016-10-10 | Sweden 23 | Bulgaria 64 | 3 | 0 | H | FIFA World Cup qualification | Solna | Solna | Sweden | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.796790 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40186 | ||||
| 40127 | 2016 1724 | 2016-10-07 | France 13 | Bulgaria 64 | 4 | 1 | H | FIFA World Cup qualification | Saint-Denis | Saint-Denis | France | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.767991 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40127 | ||||
| 39759 | 2016 1730 | 2016-06-03 | Japan 36 | Bulgaria 64 | 7 | 2 | H | Kirin Cup | Toyota | Toyota | Japan | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.533294 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39759 | ||||
| 39618 | 2016 1719 | 2016-03-29 | North Macedonia 246 | Bulgaria 64 | 0 | 2 | A | Friendly | Skopje | Skopje | North Macedonia | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.437218 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39618 | ||||
| 39546 | 2016 1719 | 2016-03-25 | Portugal 50 | Bulgaria 64 | 0 | 1 | A | Friendly | Leiria | Leiria | Portugal | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.401803 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39546 | ||||
| 39193 | 2015 1702 | 2015-10-10 | Croatia 95 | Bulgaria 64 | 3 | 0 | H | UEFA Euro qualification | Zagreb | Zagreb | Croatia | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.229981 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39193 | ||||
| 39066 | 2015 1702 | 2015-09-06 | Italy 26 | Bulgaria 64 | 1 | 0 | H | UEFA Euro qualification | Palermo | Palermo | Italy | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.168282 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39066 | ||||
| 38774 | 2015 1702 | 2015-06-12 | Malta 151 | Bulgaria 64 | 0 | 1 | A | UEFA Euro qualification | Attard | Attard | Malta | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.972421 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38774 | ||||
| 38732 | 2015 1696 | 2015-06-08 | Turkey 61 | Bulgaria 64 | 4 | 0 | H | Friendly | Istanbul | Istanbul | Turkey | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.952033 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38732 | ||||
| 38192 | 2014 1690 | 2014-10-13 | Norway 24 | Bulgaria 64 | 2 | 1 | H | UEFA Euro qualification | Oslo | Oslo | Norway | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.689428 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38192 | ||||
| 38066 | 2014 1690 | 2014-09-09 | Azerbaijan 211 | Bulgaria 64 | 1 | 2 | A | UEFA Euro qualification | Baku | Baku | Azerbaijan | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.628145 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38066 | ||||
| 37330 | 2013 1655 | 2013-10-11 | Armenia 209 | Bulgaria 64 | 2 | 1 | H | FIFA World Cup qualification | Yerevan | Yerevan | Armenia | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.219529 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37330 | ||||
| 37301 | 2013 1655 | 2013-09-10 | Malta 151 | Bulgaria 64 | 1 | 2 | A | FIFA World Cup qualification | Attard | Attard | Malta | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.205336 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37301 | ||||
| 37222 | 2013 1655 | 2013-09-06 | Italy 26 | Bulgaria 64 | 1 | 0 | H | FIFA World Cup qualification | Palermo | Palermo | Italy | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:05.166755 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37222 | ||||
| 37165 | 2013 1650 | 2013-08-14 | North Macedonia 246 | Bulgaria 64 | 2 | 0 | H | Friendly | Skopje | Skopje | North Macedonia | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:05.138987 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37165 | ||||
| 36932 | 2013 1650 | 2013-06-04 | Kazakhstan 212 | Bulgaria 64 | 1 | 2 | A | Friendly | Almaty | Almaty | Kazakhstan | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.943984 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36932 | ||||
| 36911 | 2013 1660 | 2013-05-30 | Japan 36 | Bulgaria 64 | 0 | 2 | A | Kirin Challenge Cup | Toyota | Toyota | Japan | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.933782 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36911 | ||||
| 36855 | 2013 1655 | 2013-03-26 | Denmark 25 | Bulgaria 64 | 1 | 1 | D | FIFA World Cup qualification | Copenhagen | Copenhagen | Denmark | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.906076 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36855 | ||||
| 36365 | 2012 1627 | 2012-10-16 | Czech Republic 247 | Bulgaria 64 | 0 | 0 | D | FIFA World Cup qualification | Prague | Prague | Czech Republic | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.667719 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36365 | ||||
| 35794 | 2012 1623 | 2012-05-26 | Netherlands 18 | Bulgaria 64 | 1 | 2 | A | Friendly | Amsterdam | Amsterdam | Netherlands | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.336584 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35794 | ||||
| 35669 | 2012 1623 | 2012-02-29 | Hungary 10 | Bulgaria 64 | 1 | 1 | D | Friendly | Győr | Győr | Hungary | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.275805 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35669 | ||||
| 35291 | 2011 1599 | 2011-10-07 | Ukraine 74 | Bulgaria 64 | 3 | 0 | H | Friendly | Kyiv | Kyiv | Ukraine | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.091954 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35291 | ||||
| 35223 | 2011 1607 | 2011-09-06 | Switzerland 14 | Bulgaria 64 | 3 | 1 | H | UEFA Euro qualification | Basel | Basel | Switzerland | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.058948 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35223 | ||||
| 35002 | 2011 1599 | 2011-08-10 | Belarus 73 | Bulgaria 64 | 1 | 0 | H | Friendly | Minsk | Minsk | Belarus | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.951060 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35002 | ||||
| 34765 | 2011 1607 | 2011-06-04 | Montenegro 106 | Bulgaria 64 | 1 | 1 | D | UEFA Euro qualification | Podgorica | Podgorica | Montenegro | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.781791 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34765 | ||||
| 34733 | 2011 1599 | 2011-05-31 | Corsica 186 | Bulgaria 64 | 1 | 0 | H | Friendly | Ajaccio | Ajaccio | France | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.766247 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34733 | ||||
| 34667 | 2011 1599 | 2011-03-29 | Cyprus 118 | Bulgaria 64 | 0 | 1 | A | Friendly | Larnaca | Larnaca | Cyprus | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.734050 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34667 | ||||
| 34187 | 2010 1587 | 2010-10-08 | Wales 3 | Bulgaria 64 | 0 | 1 | A | UEFA Euro qualification | Cardiff | Cardiff | Wales | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.499962 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34187 | ||||
| 34009 | 2010 1587 | 2010-09-03 | England 2 | Bulgaria 64 | 4 | 0 | H | UEFA Euro qualification | London | London | England | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.412826 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34009 | ||||
| 33981 | 2010 1575 | 2010-08-11 | Russia 28 | Bulgaria 64 | 1 | 0 | H | Friendly | Saint Petersburg | Saint Petersburg | Russia | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.315053 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33981 | ||||
| 33777 | 2010 1575 | 2010-05-24 | South Africa 21 | Bulgaria 64 | 1 | 1 | D | Friendly | Johannesburg | Johannesburg | South Africa | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.214596 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33777 | ||||
| 33762 | 2010 1575 | 2010-05-19 | Belgium 12 | Bulgaria 64 | 2 | 1 | H | Friendly | Brussels | Brussels | Belgium | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.207320 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33762 | ||||
| 33716 | 2010 1575 | 2010-03-03 | Poland 49 | Bulgaria 64 | 2 | 0 | H | Friendly | Warsaw | Warsaw | Poland | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.184918 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33716 | ||||
| 33527 | 2009 1557 | 2009-11-18 | Malta 151 | Bulgaria 64 | 1 | 4 | A | Friendly | Paola | Paola | Malta | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.093208 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33527 | ||||
| 33349 | 2009 1562 | 2009-10-10 | Cyprus 118 | Bulgaria 64 | 4 | 1 | H | FIFA World Cup qualification | Larnaca | Larnaca | Cyprus | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.006525 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33349 | ||||
| 33305 | 2009 1562 | 2009-09-09 | Italy 26 | Bulgaria 64 | 2 | 0 | H | FIFA World Cup qualification | Turin | Turin | Italy | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.985061 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33305 | ||||
| 32836 | 2009 1562 | 2009-03-28 | Republic of Ireland 65 | Bulgaria 64 | 1 | 1 | D | FIFA World Cup qualification | Dublin | Dublin | Republic of Ireland | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.700935 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32836 | ||||
| 32792 | 2009 1557 | 2009-02-11 | Switzerland 14 | Bulgaria 64 | 1 | 1 | D | Friendly | Geneva | Geneva | Switzerland | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.678780 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32792 | ||||
| 32597 | 2008 1529 | 2008-11-19 | Serbia 122 | Bulgaria 64 | 6 | 1 | H | Friendly | Belgrade | Belgrade | Serbia | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.580466 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32597 | ||||
| 32492 | 2008 1532 | 2008-10-15 | Georgia 210 | Bulgaria 64 | 0 | 0 | D | FIFA World Cup qualification | Tbilisi | Tbilisi | Georgia | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.527545 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32492 | ||||
| 32308 | 2008 1532 | 2008-09-06 | Montenegro 106 | Bulgaria 64 | 2 | 2 | D | FIFA World Cup qualification | Podgorica | Podgorica | Montenegro | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.434787 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32308 | ||||
| 32213 | 2008 1529 | 2008-08-20 | Bosnia and Herzegovina 248 | Bulgaria 64 | 1 | 2 | A | Friendly | Zenica | Zenica | Bosnia and Herzegovina | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.387487 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32213 | ||||
| 31676 | 2008 1529 | 2008-02-06 | Northern Ireland 4 | Bulgaria 64 | 0 | 1 | A | Friendly | Belfast | Belfast | Northern Ireland | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.041820 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31676 | ||||
| 31511 | 2007 1508 | 2007-11-21 | Slovenia 238 | Bulgaria 64 | 0 | 2 | A | UEFA Euro qualification | Celje | Celje | Slovenia | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.958102 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31511 | ||||
| 31356 | 2007 1508 | 2007-10-17 | Albania 105 | Bulgaria 64 | 1 | 1 | D | UEFA Euro qualification | Tirana | Tirana | Albania | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.880016 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31356 | ||||
| 31232 | 2007 1508 | 2007-09-08 | Netherlands 18 | Bulgaria 64 | 2 | 0 | H | UEFA Euro qualification | Amsterdam | Amsterdam | Netherlands | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.817605 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31232 | ||||
| 30847 | 2007 1508 | 2007-06-02 | Belarus 73 | Bulgaria 64 | 0 | 2 | A | UEFA Euro qualification | Minsk | Minsk | Belarus | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.579511 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30847 | ||||
| 30655 | 2007 1507 | 2007-02-07 | Cyprus 118 | Bulgaria 64 | 0 | 3 | A | Cyprus International Tournament | Nicosia | Nicosia | Cyprus | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.485383 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30655 | ||||
| 30643 | 2007 1507 | 2007-02-06 | Latvia 54 | Bulgaria 64 | 0 | 2 | A | Cyprus International Tournament | Larnaca | Larnaca | Cyprus | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.479568 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30643 | ||||
| 30474 | 2006 1479 | 2006-11-15 | Slovakia 93 | Bulgaria 64 | 3 | 1 | H | Friendly | Žilina | Žilina | Slovakia | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.397473 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30474 | ||||
| 30399 | 2006 1491 | 2006-10-11 | Luxembourg 30 | Bulgaria 64 | 0 | 1 | A | UEFA Euro qualification | Luxembourg | Luxembourg | Luxembourg | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.361072 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30399 | ||||
| 30221 | 2006 1491 | 2006-09-02 | Romania 38 | Bulgaria 64 | 2 | 2 | D | UEFA Euro qualification | Constanţa | Constanţa | Romania | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.274367 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30221 |
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);