home / football

match

142 rows where home_team_id = 81 sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

match_id season_id date ▲ kickoff home_team_id away_team_id home_score away_score result round_stage matchday venue city country referee attendance is_neutral is_postponed is_cancelled created_at updated_at created_by_run_id updated_by_run_id source_id source_raw_key
48493 2025 1914 2025-06-24   Guadeloupe 81 Guatemala 48 2 3 A Gold Cup   Houston Houston United States     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.383696 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48493
48163 2025 1910 2025-03-21   Guadeloupe 81 Nicaragua 76 1 0 H Gold Cup qualification   Le Gosier Le Gosier Guadeloupe     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.222963 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48163
48005 2024 1883 2024-11-19   Guadeloupe 81 Cayman Islands 226 1 0 H CONCACAF Nations League   Le Gosier Le Gosier Guadeloupe     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.145987 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48005
47824 2024 1883 2024-10-15   Guadeloupe 81 Martinique 78 0 0 D CONCACAF Nations League   Le Gosier Le Gosier Guadeloupe     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:11.014611 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47824
47728 2024 1883 2024-10-11   Guadeloupe 81 Martinique 78 0 1 A CONCACAF Nations League   Le Gosier Le Gosier Guadeloupe     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.967742 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47728
47600 2024 1883 2024-09-09   Guadeloupe 81 Suriname 44 1 0 H CONCACAF Nations League   Le Gosier Le Gosier Guadeloupe     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.905285 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47600
46746 2023 1860 2023-11-19   Guadeloupe 81 Saint Kitts and Nevis 90 5 0 H CONCACAF Nations League   Sainte-Anne Sainte-Anne Guadeloupe     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.408410 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46746
46565 2023 1860 2023-10-15   Guadeloupe 81 Saint Lucia 85 2 0 H CONCACAF Nations League   Sainte-Anne Sainte-Anne Guadeloupe     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.320530 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46565
46399 2023 1860 2023-09-10   Guadeloupe 81 Sint Maarten 230 4 0 H CONCACAF Nations League   Sainte-Anne Sainte-Anne Guadeloupe     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.239793 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46399
46229 2023 1867 2023-07-04   Guadeloupe 81 Guatemala 48 2 3 A Gold Cup   Harrison Harrison United States     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:10.157116 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46229
46157 2023 1864 2023-06-20   Guadeloupe 81 Guyana 19 2 0 H Gold Cup qualification   Fort Lauderdale Fort Lauderdale United States     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:10.122083 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46157
45880 2023 1860 2023-03-23   Guadeloupe 81 Antigua & Barbuda 199 0 1 A CONCACAF Nations League   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.943252 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45880
45378 2022 1841 2022-06-12   Guadeloupe 81 Barbados 75 2 1 H CONCACAF Nations League   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.699263 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45378
45168 2022 1841 2022-06-02   Guadeloupe 81 Cuba 77 2 1 H CONCACAF Nations League   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.596903 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45168
44963 2022 1832 2022-03-23   Guadeloupe 81 Cape Verde 157 0 2 A Friendly   Orléans Orléans France     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.413977 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44963
44262 2021 1823 2021-07-16   Guadeloupe 81 Jamaica 67 1 2 A Gold Cup   Orlando Orlando United States     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.073206 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44262
44216 2021 1821 2021-07-03   Guadeloupe 81 Bahamas 192 2 0 H Gold Cup qualification   Fort Lauderdale Fort Lauderdale United States     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.050908 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44216
43283 2019 1802 2019-11-17   Guadeloupe 81 Turks and Caicos Islands 255 10 0 H CONCACAF Nations League   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.542330 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43283
42900 2019 1802 2019-09-07   Guadeloupe 81 Sint Maarten 230 5 1 H CONCACAF Nations League   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.299669 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42900
42360 2019 1785 2019-03-23   Guadeloupe 81 Martinique 78 0 1 A CONCACAF Nations League qualification   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.023847 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42360
42022 2018 1777 2018-10-16   Guadeloupe 81 Aruba 62 0 0 D CONCACAF Nations League qualification   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:07.857968 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42022
41599 2018 1765 2018-06-07   Guadeloupe 81 French Guiana 84 0 2 A Friendly   Fort-de-France Fort-de-France Martinique     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.559165 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41599
41350 2018 1765 2018-03-23   Guadeloupe 81 Trinidad & Tobago 20 0 1 A Friendly   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.432509 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41350
40582 2017 1743 2017-05-17   Guadeloupe 81 Dominica 79 2 2 D Friendly   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.989419 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40582
39785 2016 1722 2016-06-04   Guadeloupe 81 Dominica 79 2 1 H CFU Caribbean Cup qualification   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.546114 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39785
39486 2016 1722 2016-03-23   Guadeloupe 81 Suriname 44 0 0 D CFU Caribbean Cup qualification   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.372573 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39486
39472 2016 1719 2016-02-06   Guadeloupe 81 Martinique 78 1 1 D Friendly   Vieux-Habitants Vieux-Habitants Guadeloupe     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.365807 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39472
38169 2014 1683 2014-10-12   Guadeloupe 81 Curaçao 63 0 1 A CFU Caribbean Cup qualification   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.678250 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38169
37656 2014 1675 2014-04-17   Guadeloupe 81 French Guiana 84 3 2 H Friendly   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.378405 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37656
36413 2012 1640 2012-10-27   Guadeloupe 81 Martinique 78 3 3 D CFU Caribbean Cup qualification   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.690935 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36413
36410 2012 1640 2012-10-25   Guadeloupe 81 Puerto Rico 97 4 1 H CFU Caribbean Cup qualification   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.689485 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36410
36406 2012 1640 2012-10-23   Guadeloupe 81 Dominican Republic 117 0 2 A CFU Caribbean Cup qualification   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.687544 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36406
36274 2012 1642 2012-09-29   Guadeloupe 81 Mayotte 265 1 0 H Coupe de l'Outre-Mer   Saint-Gratien Saint-Gratien France     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.623550 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36274
36253 2012 1642 2012-09-24   Guadeloupe 81 French Guiana 84 4 2 H Coupe de l'Outre-Mer   Saint-Ouen Saint-Ouen France     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.613397 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36253
36246 2012 1642 2012-09-22   Guadeloupe 81 Saint Pierre and Miquelon 287 13 0 H Coupe de l'Outre-Mer   Versailles Versailles France     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.610006 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36246
35753 2012 1623 2012-05-04   Guadeloupe 81 Guyana 19 1 2 A Friendly   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.316680 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35753
35742 2012 1623 2012-04-07   Guadeloupe 81 Martinique 78 0 1 A Friendly   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.311345 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35742
34413 2010 1596 2010-12-05   Guadeloupe 81 Jamaica 67 1 1 D CFU Caribbean Cup   Fort-de-France Fort-de-France Martinique     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.610211 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34413
34395 2010 1596 2010-12-01   Guadeloupe 81 Antigua & Barbuda 199 1 0 H CFU Caribbean Cup   Rivière-Pilote Rivière-Pilote Martinique     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.601473 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34395
34386 2010 1596 2010-11-29   Guadeloupe 81 Jamaica 67 0 2 A CFU Caribbean Cup   Rivière-Pilote Rivière-Pilote Martinique     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.597025 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34386
34280 2010 1590 2010-10-24   Guadeloupe 81 Puerto Rico 97 3 2 H CFU Caribbean Cup qualification   St. George's St. George's Grenada     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.545399 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34280
34139 2010 1588 2010-09-29   Guadeloupe 81 Martinique 78 2 0 H Coupe de l'Outre-Mer   Val-de-Marne Val-de-Marne France     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.476515 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34139
34132 2010 1588 2010-09-26   Guadeloupe 81 Tahiti 132 1 1 D Coupe de l'Outre-Mer   Essonne Essonne France     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.473100 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34132
34120 2010 1588 2010-09-23   Guadeloupe 81 New Caledonia 126 1 1 D Coupe de l'Outre-Mer   Val-de-Marne Val-de-Marne France     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.467158 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34120
33682 2010 1575 2010-03-02   Guadeloupe 81 Saint Kitts and Nevis 90 2 1 H Friendly   Vieux-Habitants Vieux-Habitants Guadeloupe     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.168415 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33682
33162 2009 1570 2009-07-19   Guadeloupe 81 Costa Rica 46 1 5 A Gold Cup   Arlington Arlington United States     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.915298 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33162
33147 2009 1570 2009-07-09   Guadeloupe 81 Nicaragua 76 2 0 H Gold Cup   Houston Houston United States     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.907970 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33147
32616 2008 1552 2008-12-04   Guadeloupe 81 Cuba 77 1 2 A CFU Caribbean Cup   Montego Bay Montego Bay Jamaica     1 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.590079 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32616
32496 2008 1545 2008-10-15   Guadeloupe 81 Martinique 78 3 1 H CFU Caribbean Cup qualification   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.529551 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32496
32473 2008 1545 2008-10-13   Guadeloupe 81 Grenada 91 2 1 H CFU Caribbean Cup qualification   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.517931 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32473
32430 2008 1545 2008-10-11   Guadeloupe 81 Cayman Islands 226 7 1 H CFU Caribbean Cup qualification   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.496350 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32430
32407 2008 1548 2008-10-03   Guadeloupe 81 French Guiana 84 4 0 H Coupe de l'Outre-Mer   La Courneuve La Courneuve France     1 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.484777 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32407
32393 2008 1548 2008-09-24   Guadeloupe 81 Martinique 78 0 1 A Coupe de l'Outre-Mer   La Courneuve La Courneuve France     1 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.477728 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32393
30914 2007 1515 2007-06-06   Guadeloupe 81 Haiti 66 1 1 D Gold Cup   Miami Miami United States     1 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.613555 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30914
30815 2007 1502 2007-05-20   Guadeloupe 81 Dominica 79 1 1 D Friendly   Basse-Terre Basse-Terre Guadeloupe     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.563763 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30815
30814 2007 1502 2007-05-17   Guadeloupe 81 Dominica 79 2 0 H Friendly   Morne-à-l'Eau Morne-à-l'Eau Guadeloupe     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.563276 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30814
30722 2007 1502 2007-03-24   Guadeloupe 81 Trinidad & Tobago 20 2 2 D Friendly   Le Gosier Le Gosier Guadeloupe     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.518006 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30722
30612 2007 1504 2007-01-20   Guadeloupe 81 Haiti 66 1 3 A CFU Caribbean Cup   Port of Spain Port of Spain Trinidad and Tobago     1 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.464556 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30612
30599 2007 1504 2007-01-16   Guadeloupe 81 Guyana 19 3 4 A CFU Caribbean Cup   San Fernando San Fernando Trinidad and Tobago     1 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.458255 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30599
30310 2006 1493 2006-09-24   Guadeloupe 81 Martinique 78 4 0 H CFU Caribbean Cup qualification   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.317765 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30310
30305 2006 1493 2006-09-22   Guadeloupe 81 Dominica 79 1 0 H CFU Caribbean Cup qualification   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.315348 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30305
30302 2006 1493 2006-09-20   Guadeloupe 81 Saint Martin 235 1 0 H CFU Caribbean Cup qualification   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.313891 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30302
29939 2006 1479 2006-05-20   Guadeloupe 81 Saint Lucia 85 2 1 H Friendly   Les Abymes Les Abymes Guadeloupe     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.084184 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29939
28758 2004 1453 2004-11-12   Guadeloupe 81 Dominica 79 7 0 H CFU Caribbean Cup qualification   Rivière-Pilote Rivière-Pilote Martinique     1 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.426217 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28758
28753 2004 1453 2004-11-10   Guadeloupe 81 French Guiana 84 0 1 A CFU Caribbean Cup qualification   Fort-de-France Fort-de-France Martinique     1 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.423785 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28753
27876 2004 1438 2004-01-18   Guadeloupe 81 Saint Lucia 85 2 0 H Friendly   Basse-Terre Basse-Terre Guadeloupe     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.946311 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27876
27212 2003 1411 2003-06-03   Guadeloupe 81 French Guiana 84 1 0 H Friendly   Saint-Brieuc Saint-Brieuc France     1 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.623661 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27212
27105 2003 1422 2003-03-30   Guadeloupe 81 Antigua & Barbuda 199 2 0 H Gold Cup qualification   San Fernando San Fernando Trinidad and Tobago     1 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.571439 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27105
27050 2003 1422 2003-03-26   Guadeloupe 81 Cuba 77 2 3 A Gold Cup qualification   Port of Spain Port of Spain Trinidad and Tobago     1 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.544631 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27050
27020 2003 1411 2003-03-15   Guadeloupe 81 French Guiana 84 2 2 D Friendly   Fort-de-France Fort-de-France Martinique     1 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.530017 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27020
26517 2002 1402 2002-07-07   Guadeloupe 81 Puerto Rico 97 4 0 H Gold Cup qualification   Baie-Mahault Baie-Mahault Guadeloupe     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.231391 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26517
25428 2001 1366 2001-04-12   Guadeloupe 81 United States Virgin Islands 253 11 0 H CFU Caribbean Cup qualification   Port-au-Prince Port-au-Prince Haiti     1 0 0 2026-06-07 06:58:47 2026-06-07 21:03:58.615699 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25428
25423 2001 1366 2001-04-10   Guadeloupe 81 Saint Lucia 85 2 3 A CFU Caribbean Cup qualification   Port-au-Prince Port-au-Prince Haiti     1 0 0 2026-06-07 06:58:47 2026-06-07 21:03:58.613284 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25423
23400 1999 1306 1999-03-14   Guadeloupe 81 Barbados 75 1 0 H CFU Caribbean Cup qualification   Pointe-à-Pitre Pointe-à-Pitre Guadeloupe     0 0 0 2026-06-07 06:58:45 2026-06-07 21:03:57.481673 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23400
23396 1999 1306 1999-03-12   Guadeloupe 81 Antigua & Barbuda 199 2 1 H CFU Caribbean Cup qualification   Pointe-à-Pitre Pointe-à-Pitre Guadeloupe     0 0 0 2026-06-07 06:58:45 2026-06-07 21:03:57.479735 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23396
23387 1999 1306 1999-03-10   Guadeloupe 81 Dominica 79 1 0 H CFU Caribbean Cup qualification   Pointe-à-Pitre Pointe-à-Pitre Guadeloupe     0 0 0 2026-06-07 06:58:45 2026-06-07 21:03:57.475379 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23387
22703 1998 1281 1998-04-03   Guadeloupe 81 British Virgin Islands 228 3 0 H CFU Caribbean Cup qualification   Basseterre Basseterre Saint Kitts and Nevis     1 0 0 2026-06-07 06:58:45 2026-06-07 21:03:57.083492 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22703
20313 1995 1200 1995-05-13   Guadeloupe 81 Martinique 78 2 1 H CFU Caribbean Cup qualification   Cayenne Cayenne French Guiana     1 0 0 2026-06-07 06:58:43 2026-06-07 21:03:55.761763 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20313
20308 1995 1200 1995-05-09   Guadeloupe 81 Suriname 44 1 2 A CFU Caribbean Cup qualification   Cayenne Cayenne French Guiana     1 0 0 2026-06-07 06:58:43 2026-06-07 21:03:55.759363 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20308
19655 1994 1178 1994-04-17   Guadeloupe 81 Suriname 44 2 0 H CFU Caribbean Cup   Port of Spain Port of Spain Trinidad and Tobago     1 0 0 2026-06-07 06:58:43 2026-06-07 21:03:55.387326 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:19655
19580 1994 1171 1994-03-04   Guadeloupe 81 Anguilla 227 9 0 H CFU Caribbean Cup qualification   Kingstown Kingstown Saint Vincent and the Grenadines     1 0 0 2026-06-07 06:58:43 2026-06-07 21:03:55.350484 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:19580
19035 1993 1144 1993-05-20   Guadeloupe 81 Réunion 109 0 3 A Friendly   Créteil Créteil France     1 0 0 2026-06-07 06:58:43 2026-06-07 21:03:55.085454 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:19035
18908 1993 1153 1993-04-14   Guadeloupe 81 Martinique 78 1 4 A CFU Caribbean Cup qualification   Pointe-à-Pitre Pointe-à-Pitre Guadeloupe     0 0 0 2026-06-07 06:58:43 2026-06-07 21:03:54.968652 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:18908
18318 1992 1132 1992-06-20   Guadeloupe 81 Jamaica 67 0 1 A CFU Caribbean Cup   San Fernando San Fernando Trinidad and Tobago     1 0 0 2026-06-07 06:58:42 2026-06-07 21:03:54.680895 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:18318
17750 1991 1105 1991-05-17   Guadeloupe 81 French Guiana 84 1 0 H CFU Caribbean Cup qualification   Fort-de-France Fort-de-France Martinique     1 0 0 2026-06-07 06:58:42 2026-06-07 21:03:54.321546 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:17750
17306 1990 1082 1990-05-30   Guadeloupe 81 Jamaica 67 0 0 D CFU Caribbean Cup qualification   Pointe-à-Pitre Pointe-à-Pitre Guadeloupe     0 0 0 2026-06-07 06:58:41 2026-06-07 21:03:54.104064 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:17306
17253 1990 1075 1990-05-01   Guadeloupe 81 Martinique 78 1 0 H Friendly   Paris Paris France     1 0 0 2026-06-07 06:58:41 2026-06-07 21:03:54.077357 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:17253
16851 1989 1068 1989-07-07   Guadeloupe 81 Trinidad & Tobago 20 2 0 H CFU Caribbean Cup   Bridgetown Bridgetown Barbados     1 0 0 2026-06-07 06:58:41 2026-06-07 21:03:53.825017 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16851
16715 1989 1062 1989-05-21   Guadeloupe 81 Dominica 79 0 0 D CFU Caribbean Cup qualification   Basse-Terre Basse-Terre Guadeloupe     0 0 0 2026-06-07 06:58:41 2026-06-07 21:03:53.758095 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16715
16593 1989 1053 1989-03-17   Guadeloupe 81 Paraguay 37 0 2 A Friendly   Basse-Terre Basse-Terre Guadeloupe     0 0 0 2026-06-07 06:58:41 2026-06-07 21:03:53.698665 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16593
16220 1988 1039 1988-07-05   Guadeloupe 81 Trinidad & Tobago 20 0 3 A CFU Caribbean Cup   Fort-de-France Fort-de-France Martinique     1 0 0 2026-06-07 06:58:41 2026-06-07 21:03:53.516298 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16220
16133 1988 1021 1988-05-11   Guadeloupe 81 Togo 148 2 1 H Friendly   Paris Paris France     1 0 0 2026-06-07 06:58:41 2026-06-07 21:03:53.473710 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16133
16099 1988 1027 1988-04-19   Guadeloupe 81 Suriname 44 1 1 D CFU Caribbean Cup qualification   Basse-Terre Basse-Terre Guadeloupe     0 0 0 2026-06-07 06:58:41 2026-06-07 21:03:53.456975 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16099
16033 1988 1027 1988-03-11   Guadeloupe 81 Suriname 44 0 2 A CFU Caribbean Cup qualification   Basse-Terre Basse-Terre Guadeloupe     0 0 0 2026-06-07 06:58:41 2026-06-07 21:03:53.424570 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16033
15704 1987 998 1987-05-30   Guadeloupe 81 Réunion 109 3 0 H Friendly   Gagny Gagny France     1 0 0 2026-06-07 06:58:40 2026-06-07 21:03:53.190713 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:15704
15701 1987 998 1987-05-28   Guadeloupe 81 French Guiana 84 4 1 H Friendly   Gagny Gagny France     1 0 0 2026-06-07 06:58:40 2026-06-07 21:03:53.189259 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:15701
15204 1986 975 1986-03-03   Guadeloupe 81 Norway 24 1 2 A Friendly   Basse-Terre Basse-Terre Guadeloupe     0 0 0 2026-06-07 06:58:40 2026-06-07 21:03:52.946969 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:15204
14886 1985 964 1985-06-30   Guadeloupe 81 Suriname 44 2 2 D CFU Caribbean Cup   Bridgetown Bridgetown Barbados     1 0 0 2026-06-07 06:58:40 2026-06-07 21:03:52.744548 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:14886
14877 1985 964 1985-06-25   Guadeloupe 81 Martinique 78 1 2 A CFU Caribbean Cup   Bridgetown Bridgetown Barbados     1 0 0 2026-06-07 06:58:40 2026-06-07 21:03:52.740179 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:14877
14703 1985 957 1985-04-03   Guadeloupe 81 Trinidad & Tobago 20 1 1 D CFU Caribbean Cup qualification   Basse-Terre Basse-Terre Guadeloupe     0 0 0 2026-06-07 06:58:40 2026-06-07 21:03:52.655304 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:14703

Next page

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 39.827ms