scheduled_games
6 rows where away_team_id = 323
This data as json, CSV (advanced)
Suggested facets: game_date (date)
| game_id ▼ | home_team_id | away_team_id | game_date |
|---|---|---|---|
| 1028838 | Cleveland Monsters 373 | Rochester Americans 323 | 2026-04-06 |
| 1028846 | Syracuse Crunch 324 | Rochester Americans 323 | 2026-04-08 |
| 1028860 | Springfield Thunderbirds 411 | Rochester Americans 323 | 2026-04-10 |
| 1028872 | Providence Bruins 309 | Rochester Americans 323 | 2026-04-11 |
| 1028919 | Wilkes-Barre/Scranton Penguins 316 | Rochester Americans 323 | 2026-04-18 |
| 1028924 | Hershey Bears 319 | Rochester Americans 323 | 2026-04-19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE scheduled_games (
game_id INTEGER PRIMARY KEY,
home_team_id INTEGER NOT NULL,
away_team_id INTEGER NOT NULL,
game_date DATE NOT NULL,
FOREIGN KEY (home_team_id) REFERENCES team(team_id),
FOREIGN KEY (away_team_id) REFERENCES team(team_id)
);