franchise_history

8 rows where franchise_id = 12

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_code, active, name, city, nickname

history_id ▼ franchise_id team_id team_code active name city nickname start_year end_year
55 12 12   PRO 0 Providence Reds Providence Reds 1936 1977
56 12 12   BRO 0 Broome Dusters Broome Dusters 1977 1980
57 12 12   BIN 0 Binghamton Whalers Binghamton Whalers 1980 1990
58 12 12   BIN 0 Binghamton Rangers Binghamton Rangers 1990 1997
59 12 12 Hartford Wolf Pack 307 HFD 0 Hartford Wolf Pack Hartford Wolf Pack 1997 2010
60 12 12   HWPC 0 Hartford Wolf Pack/Connecticut Whale Hartford Wolf Pack/Connecticut Whale 2010 2011
61 12 12   CON 0 Connecticut Whale Connecticut Whale 2011 2013
62 12 12 Hartford Wolf Pack 307 HFD 1 Hartford Wolf Pack Hartford Wolf Pack 2013  

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