match
88 rows where home_team_id = 244 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: home_score, away_score, result, round_stage, venue, city, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49299 | 2026 1929 | 2026-06-03 | Gibraltar 244 | British Virgin Islands 228 | 4 | 0 | H | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.836172 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49299 | ||||
| 48909 | 2025 1907 | 2025-11-14 | Gibraltar 244 | Montenegro 106 | 1 | 2 | A | FIFA World Cup qualification | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.586345 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48909 | ||||
| 48695 | 2025 1906 | 2025-10-08 | Gibraltar 244 | New Caledonia 126 | 0 | 2 | A | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.482480 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48695 | ||||
| 48634 | 2025 1907 | 2025-09-08 | Gibraltar 244 | Faroe Islands 197 | 0 | 1 | A | FIFA World Cup qualification | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.452472 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48634 | ||||
| 48526 | 2025 1906 | 2025-09-04 | Gibraltar 244 | Albania 105 | 0 | 1 | A | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.399703 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48526 | ||||
| 48363 | 2025 1907 | 2025-06-06 | Gibraltar 244 | Croatia 95 | 0 | 7 | A | FIFA World Cup qualification | Faro-Loulé | Faro-Loulé | Portugal | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.320471 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48363 | ||||
| 48290 | 2025 1907 | 2025-03-25 | Gibraltar 244 | Czech Republic 247 | 0 | 4 | A | FIFA World Cup qualification | Faro-Loulé | Faro-Loulé | Portugal | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.284986 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48290 | ||||
| 48009 | 2024 1877 | 2024-11-19 | Gibraltar 244 | Moldova 146 | 1 | 1 | D | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.147964 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48009 | ||||
| 47694 | 2024 1884 | 2024-10-10 | Gibraltar 244 | San Marino 236 | 1 | 0 | H | UEFA Nations League | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.951191 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47694 | ||||
| 47590 | 2024 1884 | 2024-09-08 | Gibraltar 244 | Liechtenstein 220 | 2 | 2 | D | UEFA Nations League | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.900390 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47590 | ||||
| 47478 | 2024 1877 | 2024-09-04 | Gibraltar 244 | Andorra 250 | 1 | 0 | H | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.845516 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47478 | ||||
| 47215 | 2024 1877 | 2024-06-06 | Gibraltar 244 | Wales 3 | 0 | 0 | D | Friendly | Faro-Loulé | Faro-Loulé | Portugal | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.690338 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47215 | ||||
| 47189 | 2024 1877 | 2024-06-03 | Gibraltar 244 | Scotland 1 | 0 | 2 | A | Friendly | Faro-Loulé | Faro-Loulé | Portugal | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.677744 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47189 | ||||
| 47022 | 2024 1884 | 2024-03-21 | Gibraltar 244 | Lithuania 60 | 0 | 1 | A | UEFA Nations League | Faro-Loulé | Faro-Loulé | Portugal | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.596615 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47022 | ||||
| 46834 | 2023 1859 | 2023-11-21 | Gibraltar 244 | Netherlands 18 | 0 | 6 | A | UEFA Euro qualification | Faro-Loulé | Faro-Loulé | Portugal | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.451500 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46834 | ||||
| 46588 | 2023 1859 | 2023-10-16 | Gibraltar 244 | Republic of Ireland 65 | 0 | 4 | A | UEFA Euro qualification | Faro-Loulé | Faro-Loulé | Portugal | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.331666 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46588 | ||||
| 46082 | 2023 1859 | 2023-06-16 | Gibraltar 244 | France 13 | 0 | 3 | A | UEFA Euro qualification | Faro-Loulé | Faro-Loulé | Portugal | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.085668 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46082 | ||||
| 45905 | 2023 1859 | 2023-03-24 | Gibraltar 244 | Greece 39 | 0 | 3 | A | UEFA Euro qualification | Faro-Loulé | Faro-Loulé | Portugal | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.955330 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45905 | ||||
| 45687 | 2022 1832 | 2022-11-19 | Gibraltar 244 | Andorra 250 | 1 | 0 | H | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.849675 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45687 | ||||
| 45644 | 2022 1832 | 2022-11-16 | Gibraltar 244 | Liechtenstein 220 | 2 | 0 | H | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.828740 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45644 | ||||
| 45571 | 2022 1836 | 2022-09-26 | Gibraltar 244 | Georgia 210 | 1 | 2 | A | UEFA Nations League | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.793184 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45571 | ||||
| 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 | ||||
| 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 | ||||
| 45036 | 2022 1832 | 2022-03-26 | Gibraltar 244 | Faroe Islands 197 | 0 | 0 | D | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.532538 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45036 | ||||
| 44961 | 2022 1832 | 2022-03-23 | Gibraltar 244 | Grenada 91 | 0 | 0 | D | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.413008 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44961 | ||||
| 44762 | 2021 1813 | 2021-11-16 | Gibraltar 244 | Latvia 54 | 1 | 3 | A | FIFA World Cup qualification | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.316292 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44762 | ||||
| 44503 | 2021 1813 | 2021-10-08 | Gibraltar 244 | Montenegro 106 | 0 | 3 | A | FIFA World Cup qualification | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.190157 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44503 | ||||
| 44367 | 2021 1813 | 2021-09-04 | Gibraltar 244 | Turkey 61 | 0 | 3 | A | FIFA World Cup qualification | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.124185 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44367 | ||||
| 43884 | 2021 1813 | 2021-03-30 | Gibraltar 244 | Netherlands 18 | 0 | 7 | A | FIFA World Cup qualification | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.834927 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43884 | ||||
| 43754 | 2021 1813 | 2021-03-24 | Gibraltar 244 | Norway 24 | 0 | 3 | A | FIFA World Cup qualification | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.771792 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43754 | ||||
| 43680 | 2020 1808 | 2020-11-17 | Gibraltar 244 | Liechtenstein 220 | 1 | 1 | D | UEFA Nations League | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.735903 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43680 | ||||
| 43408 | 2020 1808 | 2020-09-05 | Gibraltar 244 | San Marino 236 | 1 | 0 | H | UEFA Nations League | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.603001 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43408 | ||||
| 43293 | 2019 1784 | 2019-11-18 | Gibraltar 244 | Switzerland 14 | 1 | 6 | A | UEFA Euro qualification | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.547258 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43293 | ||||
| 43119 | 2019 1784 | 2019-10-15 | Gibraltar 244 | Georgia 210 | 2 | 3 | A | UEFA Euro qualification | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.462444 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43119 | ||||
| 42831 | 2019 1784 | 2019-09-05 | Gibraltar 244 | Denmark 25 | 0 | 6 | A | UEFA Euro qualification | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.264469 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42831 | ||||
| 42408 | 2019 1782 | 2019-03-26 | Gibraltar 244 | Estonia 43 | 0 | 1 | A | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.048345 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42408 | ||||
| 42342 | 2019 1784 | 2019-03-23 | Gibraltar 244 | Republic of Ireland 65 | 0 | 1 | A | UEFA Euro qualification | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.014726 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42342 | ||||
| 42073 | 2018 1776 | 2018-11-16 | Gibraltar 244 | Armenia 209 | 2 | 6 | A | UEFA Nations League | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.882848 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42073 | ||||
| 41990 | 2018 1776 | 2018-10-16 | Gibraltar 244 | Liechtenstein 220 | 2 | 1 | H | UEFA Nations League | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.757871 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41990 | ||||
| 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 | ||||
| 41389 | 2018 1765 | 2018-03-25 | Gibraltar 244 | Latvia 54 | 1 | 0 | H | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.452332 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41389 | ||||
| 41056 | 2017 1747 | 2017-10-07 | Gibraltar 244 | Estonia 43 | 0 | 6 | A | FIFA World Cup qualification | Faro | Faro | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.282943 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41056 | ||||
| 40950 | 2017 1747 | 2017-09-03 | Gibraltar 244 | Bosnia and Herzegovina 248 | 0 | 4 | A | FIFA World Cup qualification | Faro | Faro | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.177092 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40950 | ||||
| 40664 | 2017 1747 | 2017-06-09 | Gibraltar 244 | Cyprus 118 | 1 | 2 | A | FIFA World Cup qualification | Faro | Faro | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.031400 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40664 | ||||
| 40182 | 2016 1724 | 2016-10-10 | Gibraltar 244 | Belgium 12 | 0 | 6 | A | FIFA World Cup qualification | Faro | Faro | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.794780 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40182 | ||||
| 40071 | 2016 1724 | 2016-09-06 | Gibraltar 244 | Greece 39 | 1 | 4 | A | FIFA World Cup qualification | Faro | Faro | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.740765 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40071 | ||||
| 39606 | 2016 1719 | 2016-03-29 | Gibraltar 244 | Latvia 54 | 0 | 5 | A | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.431376 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39606 | ||||
| 39485 | 2016 1719 | 2016-03-23 | Gibraltar 244 | Liechtenstein 220 | 0 | 0 | D | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.372085 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39485 | ||||
| 39210 | 2015 1702 | 2015-10-11 | Gibraltar 244 | Scotland 1 | 0 | 6 | A | UEFA Euro qualification | Faro | Faro | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.238205 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39210 | ||||
| 39022 | 2015 1702 | 2015-09-04 | Gibraltar 244 | Republic of Ireland 65 | 0 | 4 | A | UEFA Euro qualification | Faro | Faro | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.146951 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39022 | ||||
| 38913 | 2015 1711 | 2015-07-02 | Gibraltar 244 | Åland Islands 234 | 0 | 0 | D | Island Games | St. Brelade | St. Brelade | Jersey | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.040353 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38913 | ||||
| 38904 | 2015 1711 | 2015-06-30 | Gibraltar 244 | Guernsey 15 | 0 | 4 | A | Island Games | St Helier | St Helier | Jersey | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.035990 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38904 | ||||
| 38897 | 2015 1711 | 2015-06-29 | Gibraltar 244 | Ynys Môn 232 | 1 | 1 | D | Island Games | St Helier | St Helier | Jersey | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.032599 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38897 | ||||
| 38885 | 2015 1711 | 2015-06-28 | Gibraltar 244 | Gotland 257 | 2 | 1 | H | Island Games | St. Peter | St. Peter | Jersey | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.026721 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38885 | ||||
| 38792 | 2015 1702 | 2015-06-13 | Gibraltar 244 | Germany 22 | 0 | 7 | A | UEFA Euro qualification | Faro | Faro | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.981168 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38792 | ||||
| 38203 | 2014 1690 | 2014-10-14 | Gibraltar 244 | Georgia 210 | 0 | 3 | A | UEFA Euro qualification | Faro | Faro | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.694768 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38203 | ||||
| 38043 | 2014 1690 | 2014-09-07 | Gibraltar 244 | Poland 49 | 0 | 7 | A | UEFA Euro qualification | Faro | Faro | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.617047 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38043 | ||||
| 37814 | 2014 1675 | 2014-06-04 | Gibraltar 244 | Malta 151 | 1 | 0 | H | Friendly | Faro | Faro | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.455879 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37814 | ||||
| 37602 | 2014 1675 | 2014-03-05 | Gibraltar 244 | Estonia 43 | 0 | 2 | A | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.352141 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37602 | ||||
| 37581 | 2014 1675 | 2014-03-01 | Gibraltar 244 | Faroe Islands 197 | 1 | 4 | A | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.341881 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37581 | ||||
| 37487 | 2013 1650 | 2013-11-19 | Gibraltar 244 | Slovakia 93 | 0 | 0 | D | Friendly | Faro | Faro | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.296086 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37487 | ||||
| 34862 | 2011 1614 | 2011-06-27 | Gibraltar 244 | Ynys Môn 232 | 6 | 3 | H | Island Games | Brading | Brading | England | 1 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.828972 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34862 | ||||
| 34577 | 2011 1599 | 2011-03-11 | Gibraltar 244 | Faroe Islands 197 | 3 | 0 | H | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.690127 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34577 | ||||
| 33131 | 2009 1569 | 2009-07-03 | Gibraltar 244 | Isle of Wight 239 | 3 | 0 | H | Island Games | Jomala | Jomala | Sweden | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.900212 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33131 | ||||
| 33118 | 2009 1569 | 2009-06-30 | Gibraltar 244 | Ynys Môn 232 | 1 | 3 | A | Island Games | Hammarland | Hammarland | Sweden | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.893908 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33118 | ||||
| 33101 | 2009 1569 | 2009-06-28 | Gibraltar 244 | Guernsey 15 | 0 | 0 | D | Island Games | Eckerö | Eckerö | Sweden | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.885686 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33101 | ||||
| 31049 | 2007 1518 | 2007-07-04 | Gibraltar 244 | Bermuda 180 | 2 | 0 | H | Island Games | Rhodes | Rhodes | Greece | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.728461 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31049 | ||||
| 31037 | 2007 1518 | 2007-07-02 | Gibraltar 244 | Menorca 280 | 2 | 1 | H | Island Games | Rhodes | Rhodes | Greece | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.722642 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31037 | ||||
| 29996 | 2006 1489 | 2006-05-31 | Gibraltar 244 | Tibet 262 | 5 | 0 | H | FIFI Wild Cup | Hamburg | Hamburg | Germany | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.111852 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29996 | ||||
| 29164 | 2005 1459 | 2005-05-27 | Gibraltar 244 | AS Monaco 387 | 4 | 0 | H | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.706707 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29164 | ||||
| 27376 | 2003 1426 | 2003-07-04 | Gibraltar 244 | Ynys Môn 232 | 0 | 2 | A | Island Games | Saint Sampson | Saint Sampson | Guernsey | 1 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.703378 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27376 | ||||
| 27347 | 2003 1426 | 2003-06-30 | Gibraltar 244 | Greenland 219 | 2 | 0 | H | Island Games | Saint Martin | Saint Martin | Guernsey | 1 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.689346 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27347 | ||||
| 27336 | 2003 1426 | 2003-06-29 | Gibraltar 244 | Sark 268 | 19 | 0 | H | Island Games | Saint Martin | Saint Martin | Guernsey | 1 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.683954 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27336 | ||||
| 26275 | 2002 1386 | 2002-02-18 | Gibraltar 244 | AS Monaco 387 | 2 | 2 | D | Friendly | Nice | Nice | France | 1 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:59.111699 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26275 | ||||
| 25785 | 2001 1379 | 2001-07-13 | Gibraltar 244 | Rhodes 259 | 2 | 0 | H | Island Games | Douglas | Douglas | Isle of Man | 1 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.789188 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25785 | ||||
| 25776 | 2001 1379 | 2001-07-12 | Gibraltar 244 | Shetland 233 | 2 | 0 | H | Island Games | Peel | Peel | Isle of Man | 1 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.784810 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25776 | ||||
| 24617 | 2000 1331 | 2000-06-11 | Gibraltar 244 | AS Monaco 387 | 5 | 0 | H | Friendly | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.163667 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24617 | ||||
| 23700 | 1999 1319 | 1999-07-02 | Gibraltar 244 | Frøya 251 | 5 | 1 | H | Island Games | Visby | Visby | Sweden | 1 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:57.627690 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23700 | ||||
| 23677 | 1999 1319 | 1999-06-29 | Gibraltar 244 | Jersey 17 | 1 | 5 | A | Island Games | Fardhem | Fardhem | Sweden | 1 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:57.616483 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23677 | ||||
| 22148 | 1997 1264 | 1997-07-02 | Gibraltar 244 | Greenland 219 | 5 | 1 | H | Island Games | St. Lawrence | St. Lawrence | Jersey | 1 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:56.809998 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22148 | ||||
| 22138 | 1997 1264 | 1997-06-29 | Gibraltar 244 | Guernsey 15 | 1 | 2 | A | Island Games | Grouville | Grouville | Jersey | 1 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:56.805156 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22138 | ||||
| 20486 | 1995 1208 | 1995-07-22 | Gibraltar 244 | Isle of Wight 239 | 0 | 1 | A | Island Games | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:55.846015 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20486 | ||||
| 20482 | 1995 1208 | 1995-07-21 | Gibraltar 244 | Jersey 17 | 1 | 0 | H | Island Games | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:55.844069 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20482 | ||||
| 20474 | 1995 1208 | 1995-07-20 | Gibraltar 244 | Jersey 17 | 1 | 0 | H | Island Games | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:55.840174 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20474 | ||||
| 20465 | 1995 1208 | 1995-07-18 | Gibraltar 244 | Ynys Môn 232 | 2 | 0 | H | Island Games | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:55.835786 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20465 | ||||
| 20461 | 1995 1208 | 1995-07-17 | Gibraltar 244 | Isle of Man 245 | 2 | 1 | H | Island Games | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:55.833837 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20461 | ||||
| 20456 | 1995 1208 | 1995-07-16 | Gibraltar 244 | Greenland 219 | 0 | 1 | A | Island Games | Gibraltar | Gibraltar | Gibraltar | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:55.831394 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20456 | ||||
| 19211 | 1993 1164 | 1993-07-04 | Gibraltar 244 | Jersey 17 | 1 | 2 | A | Island Games | Isle of Wight | Isle of Wight | England | 1 | 0 | 0 | 2026-06-07 06:58:43 | 2026-06-07 21:03:55.170933 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:19211 |
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);