franchise_history

9 rows where franchise_id = 1

✎ 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
1 1 1   MAI 0 Maine Mariners Maine Mariners 1977 1987
2 1 1   UTI 0 Utica Devils Utica Devils 1987 1993
3 1 1   SJ 0 Saint John Flames Saint John Flames 1993 2003
4 1 1 Omaha Ak-Sar-Ben Knights 337 OMA 0 Omaha Ak-Sar-Ben Knights Omaha Ak-Sar-Ben Knights 2005 2007
5 1 1 Quad City Flames 371 QC 0 Quad City Flames Quad City Flames 2007 2009
6 1 1 Abbotsford Heat 379 ABB 0 Abbotsford Heat Abbotsford Heat 2009 2014
7 1 1 Adirondack Flames 400 ADK 0 Adirondack Flames Adirondack Flames 2014 2015
8 1 1 Stockton Heat 406 STK 0 Stockton Heat Stockton Heat 2015 2022
9 1 1 Calgary Wranglers 444 CGY 1 Calgary Wranglers Calgary Wranglers 2022  

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