team

11 rows where division_id = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: year_founded, franchise_id

id ▼ name year_founded division_id franchise_id
4 Bakersfield Condors 2015 Pacific 4  
21 Ontario Reign 2015 Pacific 4  
27 San Diego Gulls 2015 Pacific 4  
28 San Jose Barracuda 2015 Pacific 4  
35 Tucson Roadrunners 2016 Pacific 4  
39 Coachella Valley Firebirds 2022 Pacific 4 1 1
40 Abbotsford Canucks 2021 Pacific 4  
42 Calgary Wranglers 2022 Pacific 4 2 2
43 Colorado Eagles 2003 Pacific 4  
44 Henderson Silver Knights 2020 Pacific 4  
46 Stockton Heat 2015 Pacific 4 2 2

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