franchise_history

4 rows where franchise_id = 35

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: active

history_id ▼ franchise_id team_id team_code active name city nickname start_year end_year
144 35 35   FRE 0 Fredericton Express Fredericton Express 1981 1988
145 35 35   HAL 0 Halifax Citadels Halifax Citadels 1988 1993
146 35 35   COR 0 Cornwall Aces Cornwall Aces 1993 1996
147 35 35 Wilkes-Barre/Scranton Penguins 316 WBS 1 Wilkes-Barre/Scranton Penguins Wilkes-Barre/Scranton Penguins 1999  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE franchise_history (
            history_id INTEGER PRIMARY KEY AUTOINCREMENT,
            franchise_id INTEGER NOT NULL REFERENCES franchise(franchise_id),
            team_id INTEGER REFERENCES team(team_id),
            team_code TEXT NOT NULL,
            active BOOLEAN NOT NULL,
            name TEXT NOT NULL,
            city TEXT NOT NULL,
            nickname TEXT NOT NULL,
            start_year INTEGER NOT NULL,
            end_year INTEGER
        );