home / my_database

scheduled_games

6 rows where away_team_id = 323

✎ View and edit SQL

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

CSV options:

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