F1 Race By Race (1950-2017)

CREATE TABLE compiled_data (
  "resultid" BIGINT,
  "year" BIGINT,
  "round" BIGINT,
  "gp_name" VARCHAR,
  "circuit_name" VARCHAR,
  "circuit_location" VARCHAR,
  "circuit_country" VARCHAR,
  "circuit_latitude" DOUBLE,
  "circuit_longitude" DOUBLE,
  "circuit_altitude_low" DOUBLE,
  "circuit_altitude_high" DOUBLE,
  "gp_date" TIMESTAMP,
  "gp_start_time" VARCHAR,
  "driver" VARCHAR,
  "driver_nationality" VARCHAR,
  "driver_dob" TIMESTAMP,
  "constructor" VARCHAR,
  "constructor_nationality" VARCHAR,
  "q1_time" VARCHAR,
  "q2_time" VARCHAR,
  "q3_time" VARCHAR,
  "grid" BIGINT,
  "driver_pole" BOOLEAN,
  "positiontext" VARCHAR,
  "positionorder" BIGINT,
  "driver_win" BOOLEAN,
  "points" DOUBLE,
  "laps" BIGINT,
  "time" VARCHAR,
  "fastestlaptime" VARCHAR,
  "fastestlapspeed" DOUBLE,
  "fastestlap" DOUBLE,
  "rank" DOUBLE,
  "status" VARCHAR,
  "no_of_pit_stops" DOUBLE,
  "cumulative_points" DOUBLE,
  "constructor_points" DOUBLE,
  "cumulative_constructor_points" DOUBLE,
  "constructor_rank" DOUBLE
);