F1 GrandPrix Dataset

raceid RaceId	year Year	round Round	circuitid CircuitId	name Name	date Date	time Time	url Url	fp1_date Fp1 Date	fp1_time Fp1 Time	fp2_date Fp2 Date	fp2_time Fp2 Time	fp3_date Fp3 Date	fp3_time Fp3 Time	quali_date Quali Date	quali_time Quali Time	sprint_date Sprint Date	sprint_time Sprint Time
1	2009	1	1	Australian Grand Prix	Sun Mar 29 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	06:00:00	http://en.wikipedia.org/wiki/2009_Australian_Grand_Prix	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
2	2009	2	2	Malaysian Grand Prix	Sun Apr 05 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	09:00:00	http://en.wikipedia.org/wiki/2009_Malaysian_Grand_Prix	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
3	2009	3	17	Chinese Grand Prix	Sun Apr 19 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	07:00:00	http://en.wikipedia.org/wiki/2009_Chinese_Grand_Prix	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4	2009	4	3	Bahrain Grand Prix	Sun Apr 26 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12:00:00	http://en.wikipedia.org/wiki/2009_Bahrain_Grand_Prix	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
5	2009	5	4	Spanish Grand Prix	Sun May 10 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12:00:00	http://en.wikipedia.org/wiki/2009_Spanish_Grand_Prix	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
6	2009	6	6	Monaco Grand Prix	Sun May 24 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12:00:00	http://en.wikipedia.org/wiki/2009_Monaco_Grand_Prix	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
7	2009	7	5	Turkish Grand Prix	Sun Jun 07 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12:00:00	http://en.wikipedia.org/wiki/2009_Turkish_Grand_Prix	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
8	2009	8	9	British Grand Prix	Sun Jun 21 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12:00:00	http://en.wikipedia.org/wiki/2009_British_Grand_Prix	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
9	2009	9	20	German Grand Prix	Sun Jul 12 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12:00:00	http://en.wikipedia.org/wiki/2009_German_Grand_Prix	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
10	2009	10	11	Hungarian Grand Prix	Sun Jul 26 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12:00:00	http://en.wikipedia.org/wiki/2009_Hungarian_Grand_Prix	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N


CREATE TABLE races (
  "raceid" BIGINT,
  "year" BIGINT,
  "round" BIGINT,
  "circuitid" BIGINT,
  "name" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "url" VARCHAR,
  "fp1_date" VARCHAR,
  "fp1_time" VARCHAR,
  "fp2_date" VARCHAR,
  "fp2_time" VARCHAR,
  "fp3_date" VARCHAR,
  "fp3_time" VARCHAR,
  "quali_date" VARCHAR,
  "quali_time" VARCHAR,
  "sprint_date" VARCHAR,
  "sprint_time" VARCHAR
);