match
42 rows where away_team_id = 235 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: season_id, home_team_id, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49199 | 2026 1932 | 2026-03-29 | Bonaire 288 | Saint Martin 235 | 0 | 3 | A | CONCACAF Series | Rincon | Rincon | Bonaire | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.785500 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49199 | ||||
| 48860 | 2025 1922 | 2025-11-12 | Dominica 79 | Saint Martin 235 | 1 | 2 | A | CONCACAF Series | Basseterre | Basseterre | Saint Kitts and Nevis | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.562587 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48860 | ||||
| 48680 | 2025 1906 | 2025-10-05 | Saint Kitts and Nevis 90 | Saint Martin 235 | 2 | 1 | H | Friendly | Basseterre | Basseterre | Saint Kitts and Nevis | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.475200 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48680 | ||||
| 48679 | 2025 1906 | 2025-10-04 | Saint Kitts and Nevis 90 | Saint Martin 235 | 5 | 0 | H | Friendly | Basseterre | Basseterre | Saint Kitts and Nevis | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.474710 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48679 | ||||
| 47973 | 2024 1883 | 2024-11-18 | Grenada 91 | Saint Martin 235 | 0 | 3 | A | CONCACAF Nations League | Gros Islet | Gros Islet | Saint Lucia | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.086886 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47973 | ||||
| 47910 | 2024 1883 | 2024-11-15 | Curaçao 63 | Saint Martin 235 | 5 | 0 | H | CONCACAF Nations League | Willemstad | Willemstad | Curaçao | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:11.056377 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47910 | ||||
| 47789 | 2024 1883 | 2024-10-14 | Saint Lucia 85 | Saint Martin 235 | 0 | 4 | A | CONCACAF Nations League | Gros Islet | Gros Islet | Saint Lucia | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.997507 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47789 | ||||
| 47732 | 2024 1883 | 2024-10-11 | Saint Lucia 85 | Saint Martin 235 | 2 | 1 | H | CONCACAF Nations League | Gros Islet | Gros Islet | Saint Lucia | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.969682 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47732 | ||||
| 47603 | 2024 1883 | 2024-09-09 | Curaçao 63 | Saint Martin 235 | 4 | 0 | H | CONCACAF Nations League | Saint George's | Saint George's | Grenada | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.906752 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47603 | ||||
| 47541 | 2024 1883 | 2024-09-06 | Grenada 91 | Saint Martin 235 | 2 | 0 | H | CONCACAF Nations League | St George's | St George's | Grenada | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.876423 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47541 | ||||
| 46790 | 2023 1860 | 2023-11-21 | Bonaire 288 | Saint Martin 235 | 0 | 4 | A | CONCACAF Nations League | Rincon | Rincon | Bonaire | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.430003 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46790 | ||||
| 46322 | 2023 1860 | 2023-09-07 | Anguilla 227 | Saint Martin 235 | 0 | 6 | A | CONCACAF Nations League | The Valley | The Valley | Anguilla | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.202303 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46322 | ||||
| 45379 | 2022 1841 | 2022-06-12 | Saint Kitts and Nevis 90 | Saint Martin 235 | 1 | 1 | D | CONCACAF Nations League | Basseterre | Basseterre | Saint Kitts and Nevis | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.699746 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45379 | ||||
| 45257 | 2022 1841 | 2022-06-06 | Aruba 62 | Saint Martin 235 | 3 | 0 | H | CONCACAF Nations League | Willemstad | Willemstad | Curaçao | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.640446 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45257 | ||||
| 43327 | 2019 1802 | 2019-11-19 | United States Virgin Islands 253 | Saint Martin 235 | 1 | 2 | A | CONCACAF Nations League | Upper Bethlehem | Upper Bethlehem | United States Virgin Islands | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.563749 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43327 | ||||
| 43142 | 2019 1802 | 2019-10-15 | Cayman Islands 226 | Saint Martin 235 | 1 | 0 | H | CONCACAF Nations League | George Town | George Town | Cayman Islands | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.473696 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43142 | ||||
| 42845 | 2019 1802 | 2019-09-05 | Barbados 75 | Saint Martin 235 | 4 | 0 | H | CONCACAF Nations League | Bridgetown | Bridgetown | Barbados | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.271580 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42845 | ||||
| 42356 | 2019 1785 | 2019-03-23 | Sint Maarten 230 | Saint Martin 235 | 4 | 3 | H | CONCACAF Nations League qualification | The Valley | The Valley | Anguilla | 1 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.021821 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42356 | ||||
| 42292 | 2019 1782 | 2019-03-17 | Saint Barthélemy 286 | Saint Martin 235 | 4 | 3 | H | Friendly | Saint-Jean | Saint-Jean | Saint Barthélemy | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.989618 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42292 | ||||
| 42091 | 2018 1777 | 2018-11-16 | Grenada 91 | Saint Martin 235 | 5 | 2 | H | CONCACAF Nations League qualification | St. George's | St. George's | Grenada | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.891556 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42091 | ||||
| 41715 | 2018 1765 | 2018-08-25 | Anguilla 227 | Saint Martin 235 | 1 | 2 | A | Friendly | The Valley | The Valley | Anguilla | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.618021 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41715 | ||||
| 41459 | 2018 1765 | 2018-04-29 | Saint Barthélemy 286 | Saint Martin 235 | 3 | 2 | H | Friendly | Saint-Jean | Saint-Jean | Saint Barthélemy | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.487911 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41459 | ||||
| 37965 | 2014 1675 | 2014-08-16 | British Virgin Islands 228 | Saint Martin 235 | 2 | 4 | A | Friendly | Road Town | Road Town | British Virgin Islands | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.529225 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37965 | ||||
| 36183 | 2012 1640 | 2012-09-09 | Puerto Rico 97 | Saint Martin 235 | 9 | 0 | H | CFU Caribbean Cup qualification | Port-au-Prince | Port-au-Prince | Haiti | 1 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.579405 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36183 | ||||
| 36145 | 2012 1640 | 2012-09-07 | Haiti 66 | Saint Martin 235 | 7 | 0 | H | CFU Caribbean Cup qualification | Port-au-Prince | Port-au-Prince | Haiti | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.560998 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36145 | ||||
| 34151 | 2010 1590 | 2010-10-06 | Anguilla 227 | Saint Martin 235 | 2 | 1 | H | CFU Caribbean Cup qualification | Bayamón | Bayamón | Puerto Rico | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.482323 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34151 | ||||
| 34150 | 2010 1590 | 2010-10-04 | Puerto Rico 97 | Saint Martin 235 | 2 | 0 | H | CFU Caribbean Cup qualification | Bayamón | Bayamón | Puerto Rico | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.481836 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34150 | ||||
| 33941 | 2010 1575 | 2010-08-08 | Anguilla 227 | Saint Martin 235 | 1 | 3 | A | Friendly | The Valley | The Valley | Anguilla | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.295561 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33941 | ||||
| 32273 | 2008 1545 | 2008-08-31 | Antigua & Barbuda 199 | Saint Martin 235 | 3 | 2 | H | CFU Caribbean Cup qualification | George Town | George Town | Cayman Islands | 1 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.417068 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32273 | ||||
| 32264 | 2008 1545 | 2008-08-27 | Cayman Islands 226 | Saint Martin 235 | 3 | 0 | H | CFU Caribbean Cup qualification | George Town | George Town | Cayman Islands | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.412534 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32264 | ||||
| 30309 | 2006 1493 | 2006-09-24 | Dominica 79 | Saint Martin 235 | 0 | 0 | D | CFU Caribbean Cup qualification | Les Abymes | Les Abymes | Guadeloupe | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.317285 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30309 | ||||
| 30306 | 2006 1493 | 2006-09-22 | Martinique 78 | Saint Martin 235 | 1 | 0 | H | CFU Caribbean Cup qualification | Les Abymes | Les Abymes | Guadeloupe | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.315834 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30306 | ||||
| 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 | ||||
| 29828 | 2006 1479 | 2006-02-25 | Saint Kitts and Nevis 90 | Saint Martin 235 | 6 | 1 | H | Friendly | Basseterre | Basseterre | Saint Kitts and Nevis | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.030247 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29828 | ||||
| 28835 | 2004 1453 | 2004-11-28 | United States Virgin Islands 253 | Saint Martin 235 | 0 | 0 | D | CFU Caribbean Cup qualification | Kingston | Kingston | Jamaica | 1 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.463513 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28835 | ||||
| 28822 | 2004 1453 | 2004-11-24 | Jamaica 67 | Saint Martin 235 | 12 | 0 | H | CFU Caribbean Cup qualification | Kingston | Kingston | Jamaica | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.457164 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28822 | ||||
| 26514 | 2002 1402 | 2002-07-06 | Grenada 91 | Saint Martin 235 | 8 | 3 | H | Gold Cup qualification | St. George's | St. George's | Grenada | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.229926 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26514 | ||||
| 25413 | 2001 1366 | 2001-04-08 | Dominica 79 | Saint Martin 235 | 2 | 3 | A | CFU Caribbean Cup qualification | Georgetown | Georgetown | Guyana | 1 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.608468 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25413 | ||||
| 25401 | 2001 1366 | 2001-04-06 | Cuba 77 | Saint Martin 235 | 1 | 0 | H | CFU Caribbean Cup qualification | Uitvlugt | Uitvlugt | Guyana | 1 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.602659 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25401 | ||||
| 25396 | 2001 1366 | 2001-04-04 | Guyana 19 | Saint Martin 235 | 2 | 0 | H | CFU Caribbean Cup qualification | Georgetown | Georgetown | Guyana | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.600220 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25396 | ||||
| 21912 | 1997 1245 | 1997-04-28 | Bermuda 180 | Saint Martin 235 | 2 | 1 | H | Friendly | Hamilton | Hamilton | Bermuda | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:56.629232 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:21912 | ||||
| 17281 | 1990 1082 | 1990-05-20 | Jamaica 67 | Saint Martin 235 | 1 | 0 | H | CFU Caribbean Cup qualification | Kingston | Kingston | Jamaica | 0 | 0 | 0 | 2026-06-07 06:58:41 | 2026-06-07 21:03:54.091535 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:17281 |
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);