team

9 rows where division_id = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: year_founded

id ▼ name year_founded division_id franchise_id
8 Chicago Wolves 2001 Central 3  
11 Grand Rapids Griffins 2001 Central 3  
15 Houston Aeros 2001 Central 3  
16 Iowa Wild 2013 Central 3  
19 Manitoba Moose 2001 Central 3  
20 Milwaukee Admirals 2001 Central 3  
25 Rockford IceHogs 2007 Central 3  
26 San Antonio Rampage 2002 Central 3  
33 Texas Stars 2009 Central 3  

Advanced export

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

CSV options: 

CREATE TABLE "team" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(32) NULL, "year_founded" integer NULL, "division_id" bigint NULL REFERENCES "division" ("id") DEFERRABLE INITIALLY DEFERRED, "franchise_id" bigint NULL REFERENCES "franchise" ("id") DEFERRABLE INITIALLY DEFERRED);
CREATE INDEX "team_division_id_d045beb7" ON "team" ("division_id");
CREATE INDEX "team_franchise_id_c7da83a8" ON "team" ("franchise_id");