home / football

match

60 rows where away_team_id = 111 sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: home_team_id, home_score, away_score, result, round_stage, country, is_neutral, created_at, date (date), created_at (date), updated_at (date)

match_id season_id date ▲ kickoff home_team_id away_team_id home_score away_score result round_stage matchday venue city country referee attendance is_neutral is_postponed is_cancelled created_at updated_at created_by_run_id updated_by_run_id source_id source_raw_key
49023 2025 1925 2025-11-26   Bahrain 183 Djibouti 111 1 0 H Arab Cup qualification   Al Rayyan Al Rayyan Qatar     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.696159 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49023
48618 2025 1907 2025-09-08   Guinea-Bissau 137 Djibouti 111 2 0 H FIFA World Cup qualification   Bissau Bissau Guinea-Bissau     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.444697 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48618
48218 2025 1907 2025-03-24   Ethiopia 112 Djibouti 111 6 1 H FIFA World Cup qualification   El Jadida El Jadida Morocco     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.249907 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48218
48173 2025 1907 2025-03-21   Burkina Faso 159 Djibouti 111 4 1 H FIFA World Cup qualification   El Jadida El Jadida Morocco     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.227834 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48173
47204 2024 1886 2024-06-05   Sierra Leone 119 Djibouti 111 2 1 H FIFA World Cup qualification   El Jadida El Jadida Morocco     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.684997 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47204
47168 2024 1880 2024-03-26   Liberia 169 Djibouti 111 0 0 D African Cup of Nations qualification   Monrovia Monrovia Liberia     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.667537 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47168
46888 2024 1877 2024-01-09   Equatorial Guinea 202 Djibouti 111 1 1 D Friendly   Malabo Malabo Equatorial Guinea     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.477678 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46888
46685 2023 1872 2023-11-16   Egypt 42 Djibouti 111 6 0 H FIFA World Cup qualification   Cairo Cairo Egypt     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.378799 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46685
46055 2023 1862 2023-06-14   Mauritius 108 Djibouti 111 1 3 A Mauritius Four Nations Cup   Saint Pierre Saint Pierre Mauritius     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:10.072553 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46055
45057 2022 1835 2022-03-27   South Sudan 295 Djibouti 111 1 0 H African Cup of Nations qualification   Entebbe Entebbe Uganda     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.542827 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45057
44719 2021 1813 2021-11-15   Niger 171 Djibouti 111 7 2 H FIFA World Cup qualification   Niamey Niamey Niger     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.295445 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44719
44575 2021 1813 2021-10-11   Burkina Faso 159 Djibouti 111 2 0 H FIFA World Cup qualification   Marrakech Marrakech Morocco     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.225238 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44575
44315 2021 1813 2021-09-02   Algeria 173 Djibouti 111 8 0 H FIFA World Cup qualification   Blida Blida Algeria     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.098886 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44315
44183 2021 1820 2021-06-23   Lebanon 96 Djibouti 111 1 0 H Arab Cup qualification   Doha Doha Qatar     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.034763 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44183
43085 2019 1787 2019-10-13   Gambia 133 Djibouti 111 1 1 D African Cup of Nations qualification   Bakau Bakau Gambia     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.446004 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43085
42987 2019 1793 2019-09-10   Eswatini 188 Djibouti 111 0 0 D FIFA World Cup qualification   Manzini Manzini Eswatini     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.343992 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42987
40568 2017 1746 2017-03-28   South Sudan 295 Djibouti 111 6 0 H African Cup of Nations qualification   Juba Juba South Sudan     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.982485 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40568
40445 2017 1743 2017-03-13   Burundi 139 Djibouti 111 1 0 H Friendly   Bujumbura Bujumbura Burundi     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.922636 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40445
40443 2017 1743 2017-03-11   Burundi 139 Djibouti 111 7 0 H Friendly   Bujumbura Bujumbura Burundi     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.921664 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40443
40044 2016 1723 2016-09-04   Togo 148 Djibouti 111 5 0 H African Cup of Nations qualification   Lomé Lomé Togo     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.727581 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40044
39616 2016 1723 2016-03-29   Liberia 169 Djibouti 111 5 0 H African Cup of Nations qualification   Monrovia Monrovia Liberia     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.436236 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39616
39419 2015 1716 2015-11-25   Malawi 154 Djibouti 111 3 0 H CECAFA Cup   Bahir Dar Bahir Dar Ethiopia     1 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.339959 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39419
39413 2015 1716 2015-11-23   South Sudan 295 Djibouti 111 2 0 H CECAFA Cup   Bahir Dar Bahir Dar Ethiopia     1 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.337042 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39413
39270 2015 1700 2015-10-17   Eswatini 188 Djibouti 111 2 1 H FIFA World Cup qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.267414 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39270
38781 2015 1709 2015-06-12   Tunisia 152 Djibouti 111 8 1 H African Cup of Nations qualification   Tunis Tunis Tunisia     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.975809 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38781
35532 2011 1620 2011-12-02   Rwanda 207 Djibouti 111 5 2 H CECAFA Cup   Dar es Salaam Dar es Salaam Tanzania     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.209247 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35532
35523 2011 1620 2011-11-29   Tanzania 101 Djibouti 111 3 0 H CECAFA Cup   Dar es Salaam Dar es Salaam Tanzania     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.204854 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35523
35517 2011 1620 2011-11-27   Zimbabwe 102 Djibouti 111 2 0 H CECAFA Cup   Dar es Salaam Dar es Salaam Tanzania     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.201845 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35517
35483 2011 1613 2011-11-15   Namibia 231 Djibouti 111 4 0 H FIFA World Cup qualification   Windhoek Windhoek Namibia     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.185366 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35483
33548 2009 1555 2009-12-02   Kenya 68 Djibouti 111 2 0 H CECAFA Cup   Nairobi Nairobi Kenya     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.103413 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33548
33544 2009 1555 2009-11-30   Ethiopia 112 Djibouti 111 5 0 H CECAFA Cup   Nairobi Nairobi Kenya     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.101460 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33544
32678 2009 1555 2009-01-06   Kenya 68 Djibouti 111 5 1 H CECAFA Cup   Jinja Jinja Uganda     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.621288 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32678
32662 2008 1554 2008-12-31   Zambia 103 Djibouti 111 3 0 H CECAFA Cup   Jinja Jinja Uganda     1 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.613255 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32662
32468 2008 1532 2008-10-12   Egypt 42 Djibouti 111 4 0 H FIFA World Cup qualification   Cairo Cairo Egypt     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.515422 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32468
32108 2008 1532 2008-06-22   DR Congo 113 Djibouti 111 5 1 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.336150 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32108
31894 2008 1532 2008-05-31   Malawi 154 Djibouti 111 8 1 H FIFA World Cup qualification   Blantyre Blantyre Malawi     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.177895 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31894
31530 2007 1527 2007-12-09   Uganda 69 Djibouti 111 7 0 H CECAFA Cup   Dar es Salaam Dar es Salaam Tanzania     1 0 0 2026-06-07 06:58:51 2026-06-07 21:04:01.967675 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31530
30556 2006 1500 2006-12-20   Yemen 182 Djibouti 111 4 1 H Arab Cup qualification   Sana'a Sana'a Yemen     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.437392 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30556
30537 2006 1499 2006-12-01   Tanzania 101 Djibouti 111 3 0 H CECAFA Cup   Addis Ababa Addis Ababa Ethiopia     1 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.428100 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30537
30529 2006 1499 2006-11-28   Ethiopia 112 Djibouti 111 4 0 H CECAFA Cup   Addis Ababa Addis Ababa Ethiopia     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.424209 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30529
26104 2001 1384 2001-12-13   Tanzania 101 Djibouti 111 4 1 H CECAFA Cup   Kigali Kigali Rwanda     1 0 0 2026-06-07 06:58:47 2026-06-07 21:03:59.025174 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26104
26098 2001 1384 2001-12-11   Burundi 139 Djibouti 111 3 1 H CECAFA Cup   Kigali Kigali Rwanda     1 0 0 2026-06-07 06:58:47 2026-06-07 21:03:59.022151 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26098
26096 2001 1384 2001-12-09   Uganda 69 Djibouti 111 10 1 H CECAFA Cup   Kigali Kigali Rwanda     1 0 0 2026-06-07 06:58:47 2026-06-07 21:03:59.021169 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26096
25088 2000 1358 2000-11-27   Uganda 69 Djibouti 111 7 0 H CECAFA Cup   Kampala Kampala Uganda     0 0 0 2026-06-07 06:58:47 2026-06-07 21:03:58.450470 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25088
25085 2000 1358 2000-11-25   Ethiopia 112 Djibouti 111 4 2 H CECAFA Cup   Kampala Kampala Uganda     1 0 0 2026-06-07 06:58:47 2026-06-07 21:03:58.449020 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25085
24731 2000 1353 2000-07-15   Burundi 139 Djibouti 111 1 0 H African Cup of Nations qualification   Bujumbura Bujumbura Burundi     0 0 0 2026-06-07 06:58:46 2026-06-07 21:03:58.221203 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24731
24432 2000 1340 2000-04-23   DR Congo 113 Djibouti 111 9 1 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:46 2026-06-07 21:03:58.070181 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24432
23747 1999 1323 1999-07-26   Tanzania 101 Djibouti 111 2 1 H CECAFA Cup   Kigali Kigali Rwanda     1 0 0 2026-06-07 06:58:46 2026-06-07 21:03:57.650584 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23747
23741 1999 1323 1999-07-24   Rwanda 207 Djibouti 111 4 1 H CECAFA Cup   Kigali Kigali Rwanda     0 0 0 2026-06-07 06:58:46 2026-06-07 21:03:57.647677 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23741
22964 1998 1293 1998-08-15   Kenya 68 Djibouti 111 9 1 H African Cup of Nations qualification   Nairobi Nairobi Kenya     0 0 0 2026-06-07 06:58:45 2026-06-07 21:03:57.214771 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22964
22936 1998 1293 1998-07-31   Kenya 68 Djibouti 111 3 0 H African Cup of Nations qualification   Nairobi Nairobi Kenya     0 0 0 2026-06-07 06:58:45 2026-06-07 21:03:57.200871 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22936
20073 1994 1190 1994-12-03   Tanzania 101 Djibouti 111 3 0 H CECAFA Cup   Nairobi Nairobi Kenya     1 0 0 2026-06-07 06:58:43 2026-06-07 21:03:55.645164 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20073
20071 1994 1190 1994-12-01   Somalia 178 Djibouti 111 2 1 H CECAFA Cup   Nairobi Nairobi Kenya     1 0 0 2026-06-07 06:58:43 2026-06-07 21:03:55.644197 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20071
20062 1994 1190 1994-11-28   Kenya 68 Djibouti 111 4 1 H CECAFA Cup   Nairobi Nairobi Kenya     0 0 0 2026-06-07 06:58:43 2026-06-07 21:03:55.639811 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20062
14147 1984 930 1984-06-03   Ethiopia 112 Djibouti 111 2 0 H Friendly   Addis Ababa Addis Ababa Ethiopia     0 0 0 2026-06-07 06:58:39 2026-06-07 21:03:52.384198 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:14147
13578 1983 907 1983-03-29   Ethiopia 112 Djibouti 111 4 2 H Friendly   Addis Ababa Addis Ababa Ethiopia     0 0 0 2026-06-07 06:58:39 2026-06-07 21:03:52.051240 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:13578
13576 1983 907 1983-03-27   Ethiopia 112 Djibouti 111 8 1 H Friendly   Addis Ababa Addis Ababa Ethiopia     0 0 0 2026-06-07 06:58:39 2026-06-07 21:03:52.050238 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:13576
5029 1960 476 1960-04-14   Cameroon 140 Djibouti 111 9 2 H African Friendship Games   Tananarive Tananarive Madagascar     1 0 0 2026-06-07 06:58:33 2026-06-07 21:03:47.340301 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:5028
3911 1954 401 1954-05-01   Ethiopia 112 Djibouti 111 10 2 H Friendly   Addis Ababa Addis Ababa Ethiopia     0 0 0 2026-06-07 06:58:33 2026-06-07 21:03:46.656097 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:3910
3230 1949 359 1949-05-01   Ethiopia 112 Djibouti 111 6 0 H Friendly   Addis Ababa Addis Ababa Ethiopia     0 0 0 2026-06-07 06:58:32 2026-06-07 21:03:46.323434 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:3229

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 31.28ms