Context

I like to compensate my frustration with sports analyzing sports data so I put together every data I could from the first season of this Netflix series and here we are.

Tables

Classifiers

@kaggle.kandebonfim_ultimate_beastmaster.classifiers

19.77 KB
670 rows
13 columns


CREATE TABLE classifiers (
  "name" VARCHAR,
  "points" BIGINT,
  "time" VARCHAR,
  "position" BIGINT,
  "level" BIGINT,
  "season" BIGINT,
  "episode" BIGINT,
  "result" VARCHAR,
  "injury" BOOLEAN,
  "completed" BOOLEAN,
  "classified" BOOLEAN,
  "won" BOOLEAN,
  "type" VARCHAR
);

Competitors

@kaggle.kandebonfim_ultimate_beastmaster.competitors

12.88 KB
270 rows
7 columns


CREATE TABLE competitors (
  "name" VARCHAR,
  "age" BIGINT,
  "profession" VARCHAR,
  "team" VARCHAR,
  "result" VARCHAR,
  "season" BIGINT,
  "episode" BIGINT
);

Episodes

@kaggle.kandebonfim_ultimate_beastmaster.episodes

4.11 KB
29 rows
4 columns


CREATE TABLE episodes (
  "name" VARCHAR,
  "episode" BIGINT,
  "season" BIGINT,
  "identifier" VARCHAR
);

Finals

@kaggle.kandebonfim_ultimate_beastmaster.finals

19.77 KB
670 rows
13 columns


CREATE TABLE finals (
  "name" VARCHAR,
  "points" BIGINT,
  "time" VARCHAR,
  "position" BIGINT,
  "level" BIGINT,
  "season" BIGINT,
  "episode" BIGINT,
  "result" VARCHAR,
  "injury" BOOLEAN,
  "completed" BOOLEAN,
  "classified" BOOLEAN,
  "won" BOOLEAN,
  "type" VARCHAR
);

Performances

@kaggle.kandebonfim_ultimate_beastmaster.performances

19.77 KB
670 rows
13 columns


CREATE TABLE performances (
  "name" VARCHAR,
  "points" BIGINT,
  "time" VARCHAR,
  "position" BIGINT,
  "level" BIGINT,
  "season" BIGINT,
  "episode" BIGINT,
  "result" VARCHAR,
  "injury" BOOLEAN,
  "completed" BOOLEAN,
  "classified" BOOLEAN,
  "won" BOOLEAN,
  "type" VARCHAR
);

Semifinals

@kaggle.kandebonfim_ultimate_beastmaster.semifinals

19.77 KB
670 rows
13 columns


CREATE TABLE semifinals (
  "name" VARCHAR,
  "points" BIGINT,
  "time" VARCHAR,
  "position" BIGINT,
  "level" BIGINT,
  "season" BIGINT,
  "episode" BIGINT,
  "result" VARCHAR,
  "injury" BOOLEAN,
  "completed" BOOLEAN,
  "classified" BOOLEAN,
  "won" BOOLEAN,
  "type" VARCHAR
);