F1H2O Championship Dataset

Formula 1 Powerboat World Championship

@kaggle.igalbronshtein_f1h2o_championship_dataset

Table List

6 tables(108.23 KB)

Drivers

Lap

Pole

Results

Standings

Teams

Standings

@kaggle.igalbronshtein_f1h2o_championship_dataset.standings

23.57 KB
685 rows
8 columns

year Year	pos Pos	nat Nat	licence Licence	boat Boat	driver Driver	p_list P List	p_total P Total
1997	1	us	us	18	Scott Gillman	['RET', '20', '20', '20', '20', '15', '12', '15', '20']	142
1997	2	fi	fi	10	Pertti Leppala	['12', '15', '12', '15', '9', '12', '15', '9', '9']	108
1997	3	it	it	1	Guido Cappellini	['15', 'DSQ', '15', 'RET', '15', '20', '20', '12', '0']	97
1997	4	gb	gb	7	Jonathan Jones	['20', 'RET', 'RET', 'RET', 'RET', 'RET', '5', '20', 'RET']	45
1997	5	jp	jp	2	Yutaka Sugihara	['5', '-', 'RET', '12', '4', '-', '7', '3', '7']	38
1997	6	se	se	5	Göran Karlöf	['RET', '9', 'RET', 'RET', '12', '9', 'RET', '7', 'RET']	37
1997	7	it	it	15	Francesco Cantando	['RET', '5', 'RET', '3', '3', 'RET', '9', 'RET', '15']	35
1997	8	fr	fr	19	Philippe Dessertenne	['9', '4', '5', '7', '0', '3', '3', '1', 'RET']	32
1997	9	it	it	8	Massimo Roggiero	['RET', '12', 'RET', '1', 'RET', 'RET', '2', '2', '12']	29
1997	10	de	de	3	Michael Werner	['RET', '3', '9', '9', '5', 'RET', '0', 'RET', '0']	26


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