franchise_history

9 rows where franchise_id = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: active, nickname

history_id ▼ franchise_id team_id team_code active name city nickname start_year end_year
32 6 6   MON 0 Montreal Voyageurs Montreal Voyageurs 1969 1971
33 6 6   NS 0 Nova Scotia Voyageurs Nova Scotia Voyageurs 1971 1984
34 6 6   SHE 0 Sherbrooke Canadiens Sherbrooke Canadiens 1984 1990
35 6 6   FRE 0 Fredericton Canadiens Fredericton Canadiens 1990 1999
36 6 6   QUE 0 Quebec Citadelles Quebec Citadelles 1999 2002
37 6 6   TOR 0 Toronto Roadrunners Toronto Roadrunners 2003 2004
38 6 6   EDM 0 Edmonton Roadrunners Edmonton Roadrunners 2004 2005
39 6 6 Oklahoma City Barons 383 OKC 0 Oklahoma City Barons Oklahoma City Barons 2010 2015
40 6 6 Bakersfield Condors 402 BAK 1 Bakersfield Condors Bakersfield Condors 2015  

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