F1H2O Championship Dataset

CREATE TABLE drivers (
  "year" BIGINT,
  "team" VARCHAR,
  "country" VARCHAR,
  "manager" VARCHAR,
  "debut" VARCHAR,
  "drivers" VARCHAR,
  "links" VARCHAR
);

CREATE TABLE lap (
  "year" BIGINT,
  "pos" BIGINT,
  "nat" VARCHAR,
  "licence" VARCHAR,
  "boat" BIGINT,
  "driver" VARCHAR,
  "points" BIGINT
);

CREATE TABLE pole (
  "year" BIGINT,
  "pos" BIGINT,
  "nat" VARCHAR,
  "licence" VARCHAR,
  "boat" BIGINT,
  "driver" VARCHAR,
  "points" BIGINT
);

CREATE TABLE results (
  "year" BIGINT,
  "pos" BIGINT,
  "nat" VARCHAR,
  "licence" VARCHAR,
  "boat" BIGINT,
  "driver" VARCHAR,
  "laps" DOUBLE,
  "gap" VARCHAR,
  "points" DOUBLE,
  "competition" VARCHAR,
  "c_location" VARCHAR,
  "c_date" VARCHAR
);

CREATE TABLE standings (
  "year" BIGINT,
  "pos" BIGINT,
  "nat" VARCHAR,
  "licence" VARCHAR,
  "boat" DOUBLE,
  "driver" VARCHAR,
  "p_list" VARCHAR,
  "p_total" BIGINT
);

CREATE TABLE teams (
  "year" BIGINT,
  "pos" BIGINT,
  "country" VARCHAR,
  "team" VARCHAR,
  "points" BIGINT
);