scheduled_games

4 rows where home_team_id = 402

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: away_team_id, game_date (date)

game_id ▼ home_team_id away_team_id game_date
1028843 Bakersfield Condors 402 Tucson Roadrunners 412 2026-04-08
1028850 Bakersfield Condors 402 San Diego Gulls 404 2026-04-10
1028862 Bakersfield Condors 402 San Diego Gulls 404 2026-04-11
1028893 Bakersfield Condors 402 San Jose Barracuda 405 2026-04-17

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)
);